DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
dwh_user



Group memberships:
Premium Members

Joined: 18 Oct 2018
Posts: 13
Location: Sydney
Points: 163

Post Posted: Thu Oct 03, 2019 12:30 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Windows
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

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43045
Location: Denver, CO
Points: 222248

Post Posted: Thu Oct 03, 2019 6:36 am Reply with quote    Back to top    

Open a support case.

_________________
-craig

"May the bridges I burn light my way forward"
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43045
Location: Denver, CO
Points: 222248

Post Posted: Thu Oct 03, 2019 7:29 am Reply with quote    Back to top    

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

"May the bridges I burn light my way forward"
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours