JR58328: TERADATA CONNECTOR CANNOT LOAD CLOB DATA

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 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