APAR status
Closed as program error.
Error description
After instInstalling patch JR55512, a parallel job such that Sequential File --> Transformer --> Teradata Connector failed with next error. Item #: 15 Event ID: 14 Timestamp: 2017-07-26 09:33:26 Type: Info User Name: WIN|dsadm Message Id: IIS-CONN-DAAPI-00099 Message: Teradata_Connector_2,0: col1:2 col2:<LOB> Item #: 16 Event ID: 15 Timestamp: 2017-07-26 09:33:26 Type: Fatal User Name: WIN|dsadm Message Id: IIS-CONN-TERA-05004 Message: Teradata_Connector_2,0: RDBMS code 350: CLI2: REQOVFLOW(350): Request size exceeds maximum. SQL statement: USING (col1 VARCHAR(20), col2 CLOB AS DEFERRED) INSERT INTO dw.clob_table (col1,col2) VALUES(:col1,:col2) (CC_TeraDBStatement::dbsExecute, file CC_TeraDBStatement.cpp, line 1,334) Item #: 17 Event ID: 16 Timestamp: 2017-07-26 09:33:26 Type: Info User Name: WIN|dsadm Message Id: IIS-CONN-TERA-05004 Message: Teradata_Connector_2,0: RDBMS code 8019: The parcel stream is invalid. SQL statement: ABORT Teradata Connector --> Transformer --> Teradata Connector job failed with next error. Item #: 10135 Event ID: 10134 Timestamp: 2017-07-28 10:29:39 Type: Fatal User Name: WIN|dsadm Message Id: IIS-CONN-TERA-05002 Message: TDCC_target,0: Memory allocation failed (CC_TeraConnection::fetchNextRow, file CC_TeraConnection.cpp, line 3,535)
Local fix
n/a
Problem summary
Teradata connector was unable to load clob data. With this fix we are now able to load the clob data.
Problem conclusion
TDCC is now able to load the clob data.
Temporary fix
Comments
APAR Information
APAR number
JR58328
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
B31
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-08-22
Closed date
2017-11-07
Last modified date
2017-11-07
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
RB30 PSY
UP
RB31 PSY
UP
RB50 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
07 November 2017