Direct link to fix
APAR status
Closed as program error.
Error description
When you run the BPMUpdateSystemApp command while upgrading IBM Business Process Manager (BPM), the command doesn't import the SAP Guided Workflow toolkit if the process app is archived. An exception similar to following exception is logged in BPMUpdateSystemApp log file under the Dmgr profile: [2/23/17 8:46:12:678 CST] 00000001 ImportHelper I CWLLG0379I: Importing snapshot 8.5.7.0 from process application SAP Guided Workflow (deprecated)(SGW) :STARTING ... [2/23/17 8:46:19:335 CST] 00000001 TWXImportExpo I CWLLG0162I: Import Failed [2/23/17 8:46:19:335 CST] 00000001 ImportFileHel I File D:\ibm\WebSphere\AppServer\BPM\Lombardi\imports\ssi4bpm-guided-w orkflow. twx failed..... [2/23/17 8:46:19:335 CST] 00000001 ImportFileHel I PreparedStatementCallback; SQL [ INSERT INTO LSW_PO_REFERENCE ( REFERENCE_ID, BRANCH_ID, START_SEQ_NUM, DEP_PATH_ID, TARGET_TYPE, TARGET_ID, TARGET_SUMMARY_DATA, END_SEQ_NUM) VALUES (?,?,?,?,?,?,?,?) ]; ORA-00001: unique constraint (BPMPROCESSPC.LSWC_PO_REFERENCE) violated ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (BPMPROCESSPC.LSWC_PO_REFERENCE) violated
Local fix
1. Update Dmgr_porfile/properties/service/productDir/BPM/twximport.propert ies file by removing 'ssi4bpm-guided-workflow.twx' from the list. 2. Restart the server. 3. Go to the Process Center console and unarchive the SAP Guided Workflow toolkit 4. Manually run the BPMUpdateSystemApp command to update the SAP Guided Workflow by using the ssi4bpm-guided-workflow.twx file located in the <WAS Install Root>\BPM\Lombardi\imports directory. For more information, see "BPMUpdateSystemApp command" (https://www.ibm.com/support/knowledgecenter/en/SSFPJS_8.6.0/com .ibm.wbpm.ref.doc/topics/rref_bpmupdatesystemapp.html).
Problem summary
This issue occurs when the SAP Guided Workflow toolkit is archived. BPMUpdateSystemApp can't find it. PRODUCTS AFFECTED IBM BPM IBM BPM Express
Problem conclusion
A fix that includes archived snapshots when the BPMUpdateSystemApp command runs will be included in a future release of IBM BPM.
Temporary fix
Comments
APAR Information
APAR number
JR57944
Reported component name
BPM STANDARD
Reported component ID
5725C9500
Reported release
860
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-05-24
Closed date
2017-11-22
Last modified date
2017-11-22
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
Fixed component ID
5737A5700
Applicable component levels
R860 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFPJS","label":"IBM Business Process Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.6.0.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
14 September 2022