Request size exceeds maximum Error

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
srini.dw
Premium Member
Premium Member
Posts: 186
Joined: Fri Aug 18, 2006 1:59 am
Location: Chennai

Request size exceeds maximum Error

Post by srini.dw »

Hi,

My design

ODBC Connector -> Copy Stage -> TD Connector Stage.

Source SQL Server
Target Teradata

The job is getting aborted with the below reason.

TDC_MSPMP100,0: [IIS-CONN-TERA-005004] RDBMS code 350: CLI2: REQOVFLOW(350): Request size exceeds maximum.

The issue here is in the target iam having 732 columns.

If i remove the TD Connector Stage and put a dataset, iam able to get the data.

Please let me know what are the possible solutions or any ideas.

Your attention to this issue is much appreciated.

Thank you.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

It's probably an ODBC limitation. Search DSXchange for MAXFETCHCOLS
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
ETLJOB
Participant
Posts: 87
Joined: Thu May 01, 2008 1:15 pm
Location: INDIA

Post by ETLJOB »

An interesting old thread on TDC - Request size exceeds maximum(350) error code.

viewtopic.php?t=124675
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”