JR28935: ORA-02291: INTEGRITY CONSTRAINT - THESE SHOULD BE ADDED TO THE LIST OF SQLCODES IN

APAR status

• Closed as program error.

Error description

• Oracle Enterprise treats some constraint violations as fatal
  errors - Most integrity constraint errors are labelled as
  sqlcode -1. There are a few that fall outside
  this range:
  ORA-02290: check constraint (string.string)
  violated
  Cause: The values being inserted do not
  satisfy the named check constraint.
  Action: do not insert values that violate the
  constraint.
  
  ORA-02291: integrity constraint (string.string)
  violated - parent key not found
  Cause: A foreign key value has no matching
  primary key value.
  Action: Delete the foreign key or add a matching
  primary key.
  ORA-02292: integrity constraint (string.string)
  violated - child record found
  Cause: attempted to delete a parent key value
  that had a foreign key dependency.
  Action: delete dependencies first then parent or
  disable constraint.
  
  These should be added to the list of sqlcodes in
  oraUpsert.C that get sent to a reject link rather
  than cause the code to fatal error.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  all platforms running 7.5.1
  ****************************************************************
  PROBLEM DESCRIPTION:
  Orignial patch supplied in Aprial has got problem 'can not get
  block count'
  ****************************************************************
  RECOMMENDATION:
  use latest code patch.
  ****************************************************************
  

Problem conclusion

• We are not able to reproduce these. However a new patch from
  latest code resolved the problem at customer site.
  

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

• R751 PSN

     UP