IBM Support

JR53138: UPGRADEPROCESSDATA FAILS WITH BADSQLGRAMMAREXCEPTION / SQLSYNTAXERROREXCEPTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When upgrading from BPM v8.0.1.2 to v8.0.13, the
    upgradeProcessData command fails if you are using DB2 v9.5.0.7
    or a later fixpack.
    
    com.lombardisoftware.tools.dbupgrade.ant.UpgradeDBHelperTask -
    PreparedStatementCallback; bad SQL grammar [select propvalue
    from
    lsw_system_schema where upper(propname)=upper(?)]; nested
    exception is
    com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
    SQLCODE=-418,
    SQLSTATE=42610, SQLERRMC=null, DRIVER=3.61.65
    org.springframework.jdbc.BadSqlGrammarException:
    PreparedStatementCallback; bad SQL grammar [select propvalue
    from
    lsw_system_schema where upper(propname)=upper(?)]; nested
    exception is
    com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
    SQLCODE=-418,
    SQLSTATE=42610, SQLERRMC=null, DRIVER=3.61.65
     at
    org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.
    translat
    e(SQLStateSQLExceptionTranslator.java:111)
     at
    org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTransla
    tor.tran
    slate(SQLErrorCodeSQLExceptionTranslator.java:322)
     at
    org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.
    java:607
    )
     ...
    
    Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL
    Error:
    SQLCODE=-418, SQLSTATE=42610, SQLERRMC=null, DRIVER=3.61.65
     at com.ibm.db2.jcc.am.ed.a(ed.java:676)
     at com.ibm.db2.jcc.am.ed.a(ed.java:60)
     ...
    

Local fix

  • N/A
    

Problem summary

  • When you run the DBUpgrade command, the upgrade fails and you
    receive an exception similar to the following exception when you
    use IBM DB2 V9.5:
    
     SEVERE:com.lombardisoftware.tools.dbupgrade.ant.UpgradeDBHelper
    Task - Exception while preparing for database upgrade
        SEVERE:
    com.lombardisoftware.tools.dbupgrade.ant.UpgradeDBHelperTask -
    Check the log files for details
     SEVERE:
    com.lombardisoftware.tools.dbupgrade.ant.UpgradeDBHelperTask -
    PreparedStatementCallback; bad SQL grammar [select propvalue
    from lsw_system_schema where upper(propname)=upper(?)];
      nested exception is
    com.ibm.db2.jcc.am.SqlSyntaxErrorException:  DB2 SQL Error:
    SQLCODE=-418, SQLSTATE=42610, SQLERRMC=null, DRIVER=3.61.65
    

Problem conclusion

  • A fix is available for IBM BPM V8.0.1.3 that ensures running the
    DBUpgrade command is successful even when you have DB2 V9.5.
    
    On Fix Central (http://www.ibm.com/support/fixcentral), search
    for JR53138:
    
    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 JR53138, 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

    JR53138

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-04-22

  • Closed date

    2015-07-23

  • Last modified date

    2015-07-23

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

  • Fixed component ID

    5725C9400

Applicable component levels

  • R801 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
23 July 2015