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