IBM Support

JR56464: TRANSACTION LOG OVERFLOWS WHILE UPGRADING THE DATABASE DURING MIGRATION TO IBM BPM V8.5.6

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When you migrate to IBM Business Process Manager (BPM) V8.5.6,
    you see an error like the following error:
    
    8/Jul/2016 20:44:29 FINE: com.lombardisoftware.tools.dbupgrade.
    UpgradeDatabase.upgradeStandardDatabase - StatementCallback;
    uncategorized SQLException for SQL [update lsw_bpd_instance set
    lsw_bpd_instance.project_id=(select s.project_id from
    lsw_snapshot s
    where s.snapshot_id=lsw_bpd_instance.snapshot_id)]; SQL state
    [57011];
    error code [-964]; DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011,
    SQLERRMC=null, DRIVER=4.18.60; nested exception is
    com.ibm.db2.jcc.am.
    SqlException: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011,
    SQLERRMC=null, DRIVER=4.18.60
    org.springframework.jdbc.UncategorizedSQLException:
    StatementCallback;
    uncategorized SQLException for SQL [update lsw_bpd_instance set
    lsw_bpd_instance.project_id=(select s.project_id from
    lsw_snapshot s
    where s.snapshot_id=lsw_bpd_instance.snapshot_id)]; SQL state
    [57011];
    error code [-964]; DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011,
    SQLERRMC=null, DRIVER=4.18.60; nested exception is
    com.ibm.db2.jcc.am.
    SqlException: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011,
    SQLERRMC=null, DRIVER=4.18.60
    

Local fix

Problem summary

  • This issue occurs when the LSW_BPD_INSTANCE database table
    contains a huge number of records.
    
    PRODUCTS AFFECTED
    IBM BPM Advanced
    IBM BPM Standard
    IBM BPM Express
    

Problem conclusion

  • A fix is available for IBM BPM V8.5.6.2 that introduces partial
    commits to the database upgrade step and, therefore, reduces the
    transaction log output.
    
    A fix will be included in IBM BPM V8.5.7 cumulative fix 2016.09
    
    On Fix Central (http://www.ibm.com/support/fixcentral), search
    for JR56464:
    
     1. Select IBM Business Process Manager with your edition from
    the product selector, the installed version to the fix pack
    level, and your platform, and then click Continue.
     2. Select APAR or SPR, enter JR56464, and click Continue.
    
    When you download fix packages, ensure that you also download
    the readme file for each fix. Review each readme file for
    additional installation instructions and information about the
    fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR56464

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    856

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-08-10

  • Closed date

    2016-09-21

  • Last modified date

    2016-09-21

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

  • Fixed component ID

    5725C9500

Applicable component levels

  • R856 PSY

       UP

  • R857 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:
21 September 2016