Teradata Connector - Request Size exceeds maximum
Posted: 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)
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)