IBM Support

JR62079: DELETING A SNAPSHOT FAILS IF INSTANCES ARE STILL RUNNING FOR A SYSTEM TOOLKIT AFTER YOU RUN THE BPMUPDATESYSTEMAPP COMMAND

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

Direct link to fix

 

APAR status

  • Closed as program error.

Error description

  • After you run the BPMUpdateSystemApp command on some system
    toolkits, or after you upgrade to a newer version of IBM
    Business Automation Workflow, you might see an error similar to
    this error when you try to delete snapshots:
    
    DB2 SQL Error: SQLCODE=-532, SQLSTATE=23504,
    SQLERRMC=DB2BPM.LSW_BPD_INSTANCE.LSWC_BPD_INST_FK1,
    DRIVER=4.21.29; nested exception is
    com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2
    SQL Error: SQLCODE=-532, SQLSTATE=23504,
    SQLERRMC=DB2BPM.LSW_BPD_INSTANCE.LSWC_BPD_INST_FK1,
    DRIVER=4.21.29
                     java.lang.Exception: StatementCallback; SQL [
           DELETE FROM LSW_BPD
           WHERE VERSION_ID NOT IN
           (SELECT PO_VERSION_ID
           FROM LSW_PO_VERSIONS
           WHERE PO_TYPE = 25)
          ]; DB2 SQL Error: SQLCODE=-532, SQLSTATE=23504,
    SQLERRMC=DB2BPM.LSW_BPD_INSTANCE.LSWC_BPD_INST_FK1,
    DRIVER=4.21.29; nested exception is
    com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2
    SQL Error: SQLCODE=-532, SQLSTATE=23504,
    SQLERRMC=DB2BPM.LSW_BPD_INSTANCE.LSWC_BPD_INST_FK1,
    DRIVER=4.21.29
    at com.lombardisoftware.client.delegate.Busine
    
    PRODUCTS AFFECTED
    Business Automation Workflow
    

Local fix

Problem summary

  • No additional information is available.
    

Problem conclusion

  • A fix is available or will be available that prevents this
    failure when you try to delete snapshots.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR62079

  • Reported component name

    BUS AUTO WORKFL

  • Reported component ID

    5737H4100

  • Reported release

    J00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-03-02

  • Closed date

    2021-02-23

  • Last modified date

    2021-02-23

  • 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

    BUS AUTO WORKFL

  • Fixed component ID

    5737H4100

Applicable component levels

[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"19.0.0.1"}]

Document Information

Modified date:
21 June 2021