Azure SQL time Data Type Throws Error on Linked Server Query - by Kalman Toth

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 780161 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 2/27/2013 2:36:40 PM
Access Restriction Public

Description

Here is the error with time data type:

SELECT * FROM [GAMMA_AZURE].AdventureWorks2012.HumanResources.Shift;
/*
Msg 7347, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' for linked server 'GAMMA_AZURE' returned data that does not match 
expected data length for column '[GAMMA_AZURE].[AdventureWorks2012].[HumanResources].[Shift].StartTime'. 
The (maximum) expected data length is 16, while the returned data length is 12.
*/

SELECT * FROM OPENQUERY([GAMMA_AZURE], 'SELECT * FROM AdventureWorks2012.HumanResources.Shift');
/*
Msg 7347, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' for linked server 'GAMMA_AZURE' returned data that does not match 
expected data length for column '[MSDASQL].StartTime'. The (maximum) expected data length is 16, 
while the returned data length is 12.
*/
Sign in to post a comment.
Posted by Microsoft on 4/22/2013 at 2:26 PM
Hello,
We cannot repro the issue with the latest SQL Server 2012 build. I tried on version 11.0.3339.0. Please provide complete steps/details if you would like us to investigate further.

--
Umachandar, SQL Programmability Team
Posted by ArthurZ on 2/28/2013 at 7:44 AM
The bug appears to be in the SQL Server 2012 metadata discovery stored procedure sys.sp_describe_first_result_set.
There is a MSDN Forum item with some more details on this topic: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/487841e4-0107-4209-b6d9-e9af12af3f58