JR34094: ORACLE ERROR WHILE READING ROWS SHOULD ABORT THE JOB.

APAR status

• Closed as program error.

Error description

• Oracle stage gives the following message as a warning, but this
  should cause job to fail:
  
  ORA-01555: snapshot too old: rollback segment number nn with
  name "_ID"
  

Local fix

• This fix is included in 8.0.1 fixpack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Oracle EE stages
  ****************************************************************
  PROBLEM DESCRIPTION:
  Oracle EE stage is logging a warning message for a serious
  Oracle client error and not aborting the job.
  ****************************************************************
  RECOMMENDATION:
  Apply this patch to resolve the issue.
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• Oracle client error message reported now causes the job to
  abort.
  

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

• R801 PSY

     UP

• R810 PSY

     UP

• R753 PSY

     UP