Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Won't Fix Help for as Won't Fix


2
0
Sign in
to vote
Type: Bug
ID: 780161
Opened: 2/27/2013 2:36:40 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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.
*/
Details
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
Sign in to post a workaround.