IBM Support

JR34041: ORACLE CONNECTOR LOGS TOO MANY WARNINGS WHEN LOADING DATA

Subscribe

You can track all active APARs for this component.

 

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 number

    JR34041

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-08-18

  • Closed date

    2009-09-28

  • Last modified date

    2009-12-15

  • 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

[{"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":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 December 2009