JR63489: IBM CONTENT NAVIGATOR TABLES AREN'T CREATED WHEN YOU UPGRADE

workflow.2102.delta.repository
8.6.20020002-WS-BPM-IFJR63489

APAR status

• Closed as program error.

Error description

• When you try to upgrade from IBM Business Process Manager (BPM)
  8.5.x to IBM Business Automation Workflow 20.0.0.2, the IBM
  Content Navigator tables aren't created and you see an exception
   similar to the following exception in the Application Server
  logs:
  
  [3/23/21 23:00:02:694 CDT] 00000159 SystemOut   O [03/23/21
  23:00:02:694 CDT] 00000159 SystemOut O CIWEB Error: [ ]
  null.processCleanup() event =
  org.apache.commons.configuration.event.ConfigurationErrorEvent[s
  ource=com.ibm.ecm.configuration.DatabaseConfiguration@5971d288]
  [3/23/21 23:00:02:694 CDT] 00000159 SystemOut   O [03/23/21
  23:00:02:694 CDT] 00000159 SystemOut O CIWEB Error: [ ]
  null.processCleanup() cause =
  com.ibm.db2.jcc.am.SqlSyntaxErrorException:
  "LOMBARDI.CONFIGURATION" is an undefined name.. SQLCODE=-204,
  SQLSTATE=42704, DRIVER=4.26.14
  [3/23/21 23:00:02:694 CDT] 00000159 SystemOut   O [03/23/21
  23:00:02:694 CDT] 00000159 SystemOut O CIWEB Error: [ ]
  null.processCleanup() There was a SQL configuration error.
  org.apache.commons.configuration.event.ConfigurationErrorEvent[s
  ource=com.ibm.ecm.configuration.DatabaseConfiguration@5971d288]
  [3/23/21 23:00:02:694 CDT] 00000159 SystemOut   O [03/23/21
  23:00:02:694 CDT] 00000159 SystemOut O CIWEB Error: [ ]
  com.ibm.ecm.configuration.DatabaseConfiguration.getProperty()
  key = application.navigator
  com.ibm.db2.jcc.am.SqlSyntaxErrorException:
  "LOMBARDI.CONFIGURATION" is an undefined name.. SQLCODE=-204,
  SQLSTATE=42704, DRIVER=4.26.14
  

Local fix

• 1. Run dmgr_profile/dbscripts/Upgrade/<cell name>.<de name>/<db
  type>/<db name>.<schema name>/createTable_ICN.sql.
  2. Restart the deployment environment.
  3. Ensure the database connection user is granted the required
  permissions. For more information, see "Database privileges"
  (https://www.ibm.com/support/knowledgecenter/SS8JB4_20.x/com.ibm
  .wbpm.imuc.doc/topics/rpln_db_privileges.html).
  

Problem summary

• No additional information is available.
  

Problem conclusion

• A fix is available or will be available that ensures the IBM
  Content Navigator tables are created after you upgrade.
  

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

  BUS AUTO WORKFL

• Fixed component ID

  5737H4100

Applicable component levels