IBM Support

JR54253: IMPORTING OR INSTALLING IBM BPM SNAPSHOTS FAILS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Importing or installing IBM Business Process Manager (BPM)
    snapshots fails and you see this error in the log file:
    
    CWLLG3561E:
    Process application snapshot [snapshot name] was not installed
    because of the following error: PreparedStatementCallback;
    uncategorized SQLException for
    SQL [     INSERT INTO LSW_PO_VERSIONS (
                  PO_TYPE,
                  PO_ID,
                  PO_ROOT_ID,
                  PO_GUID,
                  PO_VERSION_ID,
                  VERSION_SUMMARY_ID,
                  PO_NAME,
                  LAST_MODIFIED_BY_USER_ID,
                  LAST_MODIFIED,
                  BRANCH_ID,
                  START_SEQ_NUM,
                  PO_DATA,
                  VALID_STATE,
                  VALIDATION_ERRS,
                  PO_ORIG_VERSION_ID,
                  ORIG_LAST_MODIFIED,
                  ORIG_LAST_MODIFIED_BY_USER,
                  END_SEQ_NUM)
                 VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
                ]; SQL state [72000]; error code [12899];
    ORA-12899: value too large for column
    "<db schema>"."LSW_PO_VERSIONS"."ORIG_LAST_MODIFIED_BY_USER"
    (actual: <actual size>,maximum: 50)
    ; nested exception is java.sql.SQLException: ORA-12899: value
    too large
    
    PRODUCTS AFFECTED
    IBM BPM Advanced
    IBM BPM Standard
    IBM BPM Express
    

Local fix

  • Change the ORIG_LAST_MODIFIED_BY_USER column size from 50 to 64
    in the LSW_PO_VERSIONS table.
    

Problem summary

  • You cannot import or install IBM BPM snapshots because the
    createTablecreateTable_ProcessServer.sql database script file
    has the wrong size for the ORIG_LAST_MODIFIED_BY_USER column in
    the LSW_PO_VERSIONS table. The ORIG_LAST_MODIFIED_BY_USER column
     size will be increased from 50 to 64 in the LSW_PO_VERSIONS
    table in a future release.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR54253

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    856

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-09-11

  • Closed date

    2015-11-30

  • Last modified date

    2015-11-30

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R856 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":"856","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
30 November 2015