Troubleshooting
Problem
The issue occurs with DataStage jobs with Teradata Connector stage when the combined length of the various columns is greater than the specified "Max buffer size" value. It is specific to Teradata Connector stage where "Access Method" is "Bulk".
Symptom
Error message similar to:
Item #: 18
Event ID: 135
Timestamp: 2010-10-21 11:35:55
Type: Fatal
User Name: dsadmin
Message Id: IIS-CONN-NGBR-00002
Message: TRG_L_00_01_ORDER,0: [IIS-CONN-TERA-005004] RDBMS code 260: PXTBS_FinalizeTableSchemaDefinition: Invalid input row length, size = -1577368712 SQL statement: INSERT INTO table1(col1, col2 .... ) (CC_TeraParallelTransporter::initiate, file CC_TeraParallelTransporter.cpp, line 1,248)
[IIS-CONN-TERA-005001] Internal error (CC_TeraParallelTransporter::getEvent, file CC_TeraParallelTransporter.cpp, line 1,005)
[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;8.5;11.5;11.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
25 April 2025
UID
swg21461578