JR33908: A WARNING MESSSAGE IS LOGGED TOO MANY TIMES BY ERROR ON ORACLE.

APAR status

• Closed as program error.

Error description

• On a job, Seq. file ---> Transformer ---> ORAOCIBL, a warning
  messsage is logged too many times if there is any problem on
  Oracle side.
  
        NRI_WZAA01_O..Transformer1: Row 1936 cannot be loaded. See
  next Oracle error message for details.
  
  When using the Oracle Bulk Loader, the tablespace runs out of
  space, this happens.
  Instead of failing after one warning, the job continues to run
  generating many log messages and filling up the log file.
  
  Even though 300 record in Text file, several ten-thousand
  messages are logged.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Oracle OCI Bulk Load Plugin
  ****************************************************************
  PROBLEM DESCRIPTION:
  logged too many times if there is any   problem on Oracle
  side.
  ****************************************************************
  RECOMMENDATION:
  Fixed in patch patch_JR33908_server_redhat_8100.tar
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• Fixed in patch patch_JR33908_server_redhat_8100.tar
  

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