JR53138: UPGRADEPROCESSDATA FAILS WITH BADSQLGRAMMAREXCEPTION / SQLSYNTAXERROREXCEPTION

8.0.1.3-WS-BPM-IFJR53138
Version 8.5 Refresh Pack 7 for the IBM Business Process Manager products

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