IBM Support

JR57944: BPMUPDATESYSTEMAPP COMMAND DOESN'T IMPORT SAP GUIDED WORKFLOW TOOLKIT

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.

 

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