JR54253: IMPORTING OR INSTALLING IBM BPM SNAPSHOTS FAILS

Version 8.5 Refresh Pack 7 for the IBM Business Process Manager products

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 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