JR60242: THE "BPMCONFIG -MIGRATE" COMMAND EXPORTS THE WRONG SCHEMA NAME OF THE CELL AND SHARED DATABASE FOR IBM BPM V8.0

workflow.18002.delta.repository

APAR status

• Closed as fixed if next.

Error description

• While you migrate from IBM Business Process Manager (BPM) V8.0.x
  to IBM BPM V8.6, the deployment environment (DE) configuration
  is exported from the source environment by using "BPMConfig
  -migrate" command. But in the exported DE properties file, the
  schema name of the cell database and shared database are not
  correct. The properties file has the user name as the schema
  name for the DB2 environment.
  
  
  As a result, you will see the following exception  when you try
  to upgrade the database using DBUpgrade command at the target
  environment.
  
  DBUpgrade_Tue-Oct-30-18.46.44-CDT-2018_0.log
  ----------------------------------
  Oct 30, 2018 6:47:23 PM] 00000001 INFO:
  com.lombardisoftware.tools.dbupgrade.steps.TestDatabases.execute
  - Successfully connected to Cell scope database.
  [Oct 30, 2018 6:47:23 PM] 00000001 FINE:
  com.lombardisoftware.tools.dbupgrade.steps.SchemaUtils.tableExis
  ts - Check if table CUSTPROPERTIES with schema <USERNAME>
  existed.
  [Oct 30, 2018 6:47:23 PM] 00000001 SEVERE:
  com.lombardisoftware.tools.dbupgrade.steps.TestDatabases.printEx
  pectedDatabaseInfo - In the Cell scoped
  database(CMNDBU.<userName>), there is no expected table with
  name CUSTPROPERTIES.
  [Oct 30, 2018 6:47:23 PM] 00000001 SEVERE:
  com.lombardisoftware.tools.dbupgrade.UpgradeDatabase.main -
  Exception while verifying your database configuration
  [Oct 30, 2018 6:47:23 PM] 00000001 SEVERE:
  com.lombardisoftware.tools.dbupgrade.UpgradeDatabase.main -
  Check the log files for details
  [Oct 30, 2018 6:47:23 PM] 00000001 FINE:
  com.lombardisoftware.tools.dbupgrade.UpgradeDatabase.main - The
  configured Cell scope database does not appear to be a valid
  database.
  java.lang.RuntimeException: The configured Cell scope database
  does not appear to be a valid database.
  at
  com.lombardisoftware.tools.dbupgrade.steps.TestDatabases.execute
  (TestDatabases.java:90)
  at
  com.lombardisoftware.tools.dbupgrade.UpgradeDatabase.main(Upgrad
  eDatabase.java:137)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at
  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
  Impl.java:90)
  at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:55)
  at java.lang.reflect.Method.invoke(Method.java:508)
  at
  org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:2
  17)
  at
  org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.ja
  va:152)
  at org.apache.tools.ant.taskdefs.Java.run(Java.java:764)
  at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:218)
  

Local fix

• Before you create the target environment, check the exported DE
  properties file to make sure the schema names of the cell
  database and shared database match your database schema name.
  

Problem summary

• No additional information is available.
  

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