Teradata Connector - Request Size exceeds maximum

fridge · Post by **fridge** » Mon Jan 18, 2010 6:14 am

Hi - anyone seen this before - using the TDconnector stage on a job to do an insert into table - only about 20 or so fields

And get the following error - however looking at the documentation it suggest that the limit is about 1mb for the sql statement and nowhere near that

Just wondered if a bug - and has anyone else seen it

Teradata_Connector_6,0: [IIS-CONN-TERA-005004] RDBMS code 350: CLI2: REQOVFLOW(350): Request size exceeds maximum. SQL statement: USING (LOCA_ID BIGINT, BLDG_ADR_DES_1 CHAR(33), BLDG_ADR_DES_2 CHAR(33), BLDG_ADR_DES_3 CHAR(33), BLDG_ADR_DES_4 CHAR(33), BLDG_ADR_DES_5 CHAR(33), BLDG_ADR_DES_6 CHAR(33), BLDG_ADR_DES_7 CHAR(33), BLDG_ADR_DES_8 CHAR(33), BLDG_ADR_DES_9 CHAR(33), BLDG_ADR_DES_10 CHAR(33), BLDG_ADR_DES_1A VARCHAR(67), BLDG_ADR_DES_2A VARCHAR(67), BLDG_ADR_DES_3A VARCHAR(67), BLDG_ADR_DES_4A VARCHAR(67), BLDG_ADR_DES_5A VARCHAR(67), BLDG_ADR_DES_6A VARCHAR(67), BLDG_ADR_DES_7A VARCHAR(67), BLDG_ADR_DES_8A VARCHAR(67), BLDG_ADR_DES_9A VARCHAR(67), BLDG_ADR_DES_10A VARCHAR(67), BLDG_ADR_TYCD CHAR(8), REC_TS TIMESTAMP(6), POST_IN CHAR(4), POST_OUT CHAR(4)) INSERT INTO DWH_BLDG_ADR_DFT838_FX(LOCA_ID,BLDG_ADR_DES_1,BLDG_ADR_DES_2,BLDG_ADR_DES_3,BLDG_ADR_DES_4,BLDG_ADR_DES_5,BLDG_ADR_DES_6,BLDG_ADR_DES_7,BLDG_ADR_DES_8,BLDG_ADR_DES_9,BLDG_ADR_DES_10,BLDG_ADR_DES_1A,BLDG_ADR_DES_2A,BLDG_ADR_DES_3A,BLDG_ADR_DES_4A,BLDG_ADR_DES_5A,BLDG_ADR_DES_6A,BLDG_ADR_DES_7A,BLDG_ADR_DES_8A,BLDG_ADR_DES_9A,BLDG_ADR_DES_10A,BLDG_ADR_TYCD,REC_TS,POST_IN,POST_OUT) VALUES(:LOCA_ID,:BLDG_ADR_DES_1,:BLDG_ADR_DES_2,:BLDG_ADR_DES_3,:BLDG_ADR_DES_4,:BLDG_ADR_DES_5,:BLDG_ADR_DES_6,:BLDG_ADR_DES_7,:BLDG_ADR_DES_8,:BLDG_ADR_DES_9,:BLDG_ADR_DES_10,:BLDG_ADR_DES_1A,:BLDG_ADR_DES_2A,:BLDG_ADR_DES_3A,:BLDG_ADR_DES_4A,:BLDG_ADR_DES_5A,:BLDG_ADR_DES_6A,:BLDG_ADR_DES_7A,:BLDG_ADR_DES_8A,:BLDG_ADR_DES_9A,:BLDG_ADR_DES_10A,:BLDG_ADR_TYCD,CAST(:REC_TS AS TIMESTAMP(6)),:POST_IN,:POST_OUT) (CC_TeraDBStatement::dbsExecute, file CC_TeraDBStatement.cpp, line 1,278)

hamzaqk · Post by **hamzaqk** » Thu Jan 21, 2010 4:31 am

Insert from a file into TD ? using TPT ? Load ? with a Custom Query ?

fridge · Post by **fridge** » Thu Jan 21, 2010 5:38 am

sorry should have said

insert from a Dataset using Teradata connector in immediate mode (delegates to Teradata Call Level Interface API)

chanaka · Post by **chanaka** » Fri Jan 14, 2011 4:20 pm

Hi Fridge and all,

Were you able to resolve this issue. I also observed the same issue in my environment after changing a lookup stage to a join. In my case it involves areound 400 columns and probably there is a limitation in the SQL statement size.

Cheers!

Chanaka