IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR54063

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-08-13

  • Closed date

    2015-09-15

  • Last modified date

    2015-09-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

    BPM STANDARD

  • Fixed component ID

    5725C9500

Applicable component levels

  • R801 PSY

       UP

  • R850 PSY

       UP

  • R855 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
15 September 2015