Troubleshooting
Problem
Server startup or various DB upgrade tasks are prevented because the workflow databases have an improper schema version. The error generally means that the database schema is inconsistent with what the product expects. If not for the validation warning, there could be many product issues caused by the inconsistency.
The behavior can impact any product database that uses a similar schema checking style originally used by the Business Process Manager product's BPM and PDW databases. For the Business Automation Workflow product, the BPM and PDW database also can have this issue. For Cloud Pak for Business Automation, the Business Automation Workflow database, Business Automation Studio database, and Workflow Process Service database can have this issue.
Other product databases might have similar problems if schema changes are inconsistent with what is expected. Although the errors might be different so it is good to understand the concepts when you are having schema issues.
Symptom
The following are exceptions can be seen:
- When you run the bootstrapProcessServerDatabase operation, the following error can be seen in the log file.
BootstrapProc E com.ibm.bpm.bootstrap.BootstrapProcessServerDataHelper validateDatabaseSchemaVersion The database [jdbc:db2://myDBhost.com:50000/BPMDB] schema version [1.3.0] is not consistent with the expected database schema version [1.4.0] required by IBM Business Automation Workflow profile version [8.6.2.20002], ensure the database is updated successfully before starting the server. - At startup for a traditional installation, you can see an error similar to this one when the version is inconsistent.
CWMCB0050E: The schema version 1.4.0 of the database jdbc/TeamWorksDB does not match IBM Business Automation Workflow product version 1.6.0. Run the DBUpgrade command-line utility before starting the server. - At startup for a container installation, you might see this message in the db-compatibility-checking init container for your failing component.
Not Compatible: Actual Schema Version [1.4.0] vs Expected Schema Version [1.6.0]. The Actual Schema Version record we got in DB is not compatible with the Expected Schema Version.
-
For a new installation, you might see this error when the schema information is missing.
CWMCB0049E: The schema version could not be retrieved from the table LSW_SYSTEM_SCHEMA in the database jdbc/TeamWorksDB using the query 'SELECT PROPVALUE FROM LSW_SYSTEM_SCHEMA WHERE upper(PROPNAME) = upper('DatabaseSchemaVersion')'.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"ARM Category":[{"code":"a8m50000000CcaUAAS","label":"Upgrade and Migration-\u003EDBUpgrade"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS2JQC","label":"IBM Cloud Pak for Automation"},"ARM Category":[{"code":"a8m0z0000001iTWAAY","label":"Business Automation Workflow-\u003EBAW Install\\Upgrade\\Setup"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFPJS","label":"IBM Business Process Manager"},"ARM Category":[{"code":"a8m50000000CcaUAAS","label":"Upgrade and Migration-\u003EDBUpgrade"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
14 September 2022
UID
ibm16510314