DSXchange

Hi Experts,

Parallel job with source as ODBC connector is generating the below warning when run with/with out any data in source table.

"SQLSTATE = HY000: Native Error Code = 8,016: Msg = [IBM (DataDirect OEM)][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"

The source table is in PDW (APS) and has 105 fields of which most of them are Varchar fields with lengths varying from 100 to 2000 characters, except for 2 fields which are date format and an other field is Timestamp. The job has a source ODBC connector and metadata is defined in the columns tab. Encountered this warning while reading the data.

As part of debugging, warning got eliminated in below 2 different scenarios.
1. Enabling RCP in the connector with out defining any metadata
2. Reading a subset of 70-80 varchar columns from source table with metadata defined in columns tab of ODBC connector.

Appreciate any help or suggestions.

Many Thanks

Open a support case.

That and check to make sure you're have all of the latest patches for your release. I say that because errors of that nature are rarely something either caused by or fixable by the user and require a vendor patch/fix to resolve.