BookmarkSubscribeRSS Feed
shoin
Lapis Lazuli | Level 10

(WIN x64 env SAS, 9.4TS1M6)

 

ERROR: CLI describe error: [SAS][ODBC SQL Server Wire Protocol driver][SQL Server Parallel Data Warehouse]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 3 (""): Data type 0xE7 has an invalid data length or metadata length.

 

I am not able to find much SAS related note(s) and Google spits out these links:

this https://support.microsoft.com/en-us/help/971051/fix-error-message-when-you-run-a-sql-server-2008-bas... Which gives an explanation.

https://support.microsoft.com/en-us/help/970519/you-receive-a-the-incoming-tabular-data-stream-tds-r...

 

I was not successful in finding anything in the Hot Fix lists either.  

 

Any insight?  (BTW, this issue from a SAS env 9.3 does not surface).  Currently using SET IMPLICIT_TRANSACTIONS {ON|OFF}; mitigates the error reported above.

 

Any insight is welcome.

1 REPLY 1
RichardDeVen
Barite | Level 11

What is your connection string ?

Are your SQL Server and OS updates current or hotfixed ?

 

The second MS document, dated Apr 17, 2018, states

This error will not happen if you specify any value that is outside the range of 4001 to 8000 for Sqlparameter.size.

and

Status: Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section. This is scheduled to be addressed in the next major release of .NET Framework

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1048 views
  • 0 likes
  • 2 in conversation