JR34041: ORACLE CONNECTOR LOGS TOO MANY WARNINGS WHEN LOADING DATA

APAR status

• Closed as program error.

Error description

• The user has configured Oracle Connector stage to load data to
  the database in bulk-load mode. The user has also configured a
  reject link on the stage through which to send the records that
  could not be loaded. Many of the input records are rejected
  because they are in error. The connector logs warnings for each
  input record so the log grows in size very quickly.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Oracle Connector users who are writing data to the target table
  in bulk load mode and have reject link defined for the Oracle
  Connector stage.
  ****************************************************************
  PROBLEM DESCRIPTION:
  When loading data to an Oracle table in bulk load mode using
  Oracle Connector stage, and a reject link was defined for the
  stage, the connector would log warning messages for each bad
  record. In case of a large number of bad records, the job log
  would grow quickly in size and the large number of logged
  warnings would eventually cause the job to fail.
  ****************************************************************
  RECOMMENDATION:
  Install Connector Rollup Patch 2 (CCRP2).
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• The connector was fixed not to log warnings for each bad record
  individually but to provide a summary warning at the end
  indicating how many records were rejected. The user can then
  inspect the rejected data to determine for each rejected record
  the reason why it was rejected.
  

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

• R810 PSN

     UP