MS SQL SERVER Issue

shoin — Thu, 12 Mar 2020 18:20:51 GMT

(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-based-application-tha Which gives an explanation.

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

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.

Re: MS SQL SERVER Issue

RichardDeVen — Fri, 13 Mar 2020 10:47:53 GMT

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

topic MS SQL SERVER Issue in New SAS User

MS SQL SERVER Issue

Re: MS SQL SERVER Issue