All Forums Tools
ramya123 13 posts Joined 11/11
02 Apr 2012
Request size exceeds maximum.

Hi,

We are using Datastage as ETL tool and Teradata as Database. In one job we are using Teradata connector stage as Target.
If we select Parallel synchronization as "Yes" job is getting aborted with the below error. If "No" jobs is getting finished.

Error Message :

RDBMS code 350: CLI2: REQOVFLOW(350): Request size exceeds maximum

Could any one let me know what was the issue.

Regards,

Ramya

 

 

 

29 Jun 2012

We're getting the same error. I'm still digging, if I come up with a solution I'll post here.

--dave

Dave Hays
Senior Analyst
Enterprise Information Management
Caterpillar, Inc.

Adeel Chaudhry 773 posts Joined 04/08
02 Jul 2012

Usually, this error comes up when the size of SQL issued to Teradata is greater than the allowed length (1 MB).

 

Can you check if the generated SQL is large enough to cause this error? If yes, you can breakup sql and create its view to avoid this error.

 

HTH!

-- If you are stuck at something .... consider it an opportunity to think anew.

feinholz 1234 posts Joined 05/08
02 Jul 2012

I have seen this error when incompatible versions of different TTU software components are installed, especially CLI.

Please install (or-reinstall) the latest and greatest patches of CLI.

 

--SteveF

abhijitvyas 51 posts Joined 08/06
02 Jul 2012

 

When submitted directly to the parser, the maximum SQL request size is 1mb(sysmaxreqsize).However, when submitted inside a stored procedure, each request is limited to a maximum size of 64kb (max_req_size).

10 Jul 2012

We made the error go away by tweaking the array size in DataStage:

Our Buffersize in Teradata is 1Mbyte.

We divided 1Mbyte by the maximum row size in the data we were loading.

We used that result for the arraysize in datastage.

 

-- I apologize I don't seem to have kept track of the source for that, but I recall I picked that recommendation up somewhere in the forums,  and it appears to have cleared up the problem.

Dave Hays
Senior Analyst
Enterprise Information Management
Caterpillar, Inc.

nhari 8 posts Joined 01/11
15 Sep 2012

 

Hi,

 

I am also facing the same issue as 

 

RDBMS code 350: CLI2: REQOVFLOW(350): Request size exceeds maximum with datastage and teradata in immediate mode. Teradata 13.10 and DS 8.x

 

My Request Text size is a few KBs . I tried to reduce the array size in TD connector. It was set to default of 2000 which I changed to 200. All doesnt seem to work.

 

What would be the impact if we change the default settings in DBSControl for parameter (I don't rem the variable name but it set as default 50%)?

 

Thanks in Advance,

 

Nirmal

Jigar 70 posts Joined 09/11
11 Dec 2012

Any resolution on this ? Facing the same issue :(

mohamed.maged 2 posts Joined 07/11
15 Dec 2012

i think the answer may be in the below link
 
http://www.dsxchange.com/viewtopic.php?t=124675
 

mohamed.maged 2 posts Joined 07/11
15 Dec 2012

also this will be helpfull
http://www-01.ibm.com/support/docview.wss?uid=swg21600151

ameyagaikwad 1 post Joined 05/13
29 May 2013

I had the same issue while inserting 16K Records.
The fix: I broke the 16K into into 2 sets of 8K each and it worked. Apparantly some size limitat ions.

You must sign in to leave a comment.