JR54063: TRYING TO CLEANUP SNAPSHOTS FAILS BECAUSE ENTRIES FROM LSW_CLASS AREN'T DELETED, VIOLATING THE BPM_SHARED_OBJECT_FK CONSTRAINT

bpm.8560.cf1.delta.repository.2
bpm.8560.cf1.delta.repository.1
8.5.5.0-WS-BPM-IFJR54063
8.0.1.3-WS-BPM-IFJR54063
8.5.0.1-WS-BPM-IFJR54063
Version 8.5.0 Fix Pack 2 for the IBM Business Process Manager products
Version 8.5 Refresh Pack 7 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• When you try to clean up snapshots on IBM Process Center or
  delete a snapshot on IBM Process Server, the operation fails and
  you receive a database exception about the violation of the
  BPM_SHARED_OBJECT_FK constraint. For example, the
  BPMDeleteSnapshot command fails with this error when you run it
  on an IBM Business Process Manager (BPM) environment that has an
  Oracle database:
  
  wsadmin>AdminTask.BPMDeleteSnapshot('[-containerAcronym MYAPP
  -containerSnapshotAcronyms [V1 V2]]')
  
  WASX7015E: Exception running command:
  "AdminTask.BPMDeleteSnapshot('[-containerAcronym MYAPP
  -containerSnapshotAcronyms [V1 V2]]')"; exception information:
  
  java.lang.Exception: java.lang.Exception: StatementCallback; SQL
  [DELETE FROM LSW_CLASS WHERE VERSION_ID NOT IN (SELECT
  PO_VERSION_ID FROM LSW_PO_VERSIONS WHERE PO_TYPE = 12)];
  ORA-02292: integrity constraint (BPM.BPM_SHARED_OBJECT_FK)
  violated - child record found
  
  The error looks similar for other database systems.
  

Local fix

Problem summary

• A foreign key between the BPM_SHARED_OBJECT and LSW_CLASS tables
  prevents the LSW_CLASS entries from being cleaned up because the
  column in BPM_SHARED_OBJECT is filled incorrectly.
  

Problem conclusion

• A fix is available for IBM BPM that repairs the entries in the
  BPM_SHARED_OBJECT table before cleaning up the entries in the
  LSW_CLASS table.
  
  On Fix Central (http://www.ibm.com/support/fixcentral), search
  for JR54063:
  
  1. Select IBM Business Process Manager with your edition from
    the product selector, the installed version to the fix pack
    level, and your platform, and then click Continue.
  
  2. Select APAR or SPR, enter JR54063, and click Continue.
  
  When you download fix packages, ensure that you also download
  the readme file for each fix. Review each readme file for
  additional installation instructions and information about the
  fix.
  

Temporary fix

• Not applicable
  

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

  BPM STANDARD

• Fixed component ID

  5725C9500

Applicable component levels

• R801 PSY

     UP

• R850 PSY

     UP

• R855 PSY

     UP