ODBC:Warning: Data type 0xE7 has an invalid data length

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dwh_user
Premium Member
Premium Member
Posts: 14
Joined: Thu Oct 18, 2018 8:08 pm
Location: Sydney

ODBC:Warning: Data type 0xE7 has an invalid data length

Post by dwh_user »

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Open a support case.
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply