IBM Support

Error DB2 SQL Error: SQLCODE=-624, SQLSTATE=42889 when running Migrator for PEM Install

Troubleshooting


Problem

When attempting a fresh deployment of Partner Engagement Manager with a DB2 database, this error message is generated during the Migrator step:
liquibase.integration ERROR  DB2 SQL Error: SQLCODE=-624, SQLSTATE=42889, SQLERRMC=SVPEMDEVDBU.VCH_ACTIVITY_TAG;PRIMARY, DRIVER=4.33.31 [Failed SQL: (-624) ALTER TABLE "SVPEMDEVDBU".VCH_ACTIVITY_TAG ADD CONSTRAINT ACTIVITY_TAG_PK PRIMARY KEY (ACTIVITY_TAG_KEY)]
liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: Unexpected error running Liquibase: Migration failed for change set changelog/changelog-19.0-testmode.xml::2907201613169::IBM:

Cause

The customer was using the different names for the DB_SCHEMA and DB_USER for both Master and TestMode:

testmode_db_port="XXXXX"
testmode_db_host="xxx.xxx.xxx.com"
testmode_db_name="PEMDEV"
testmode_db_schema="pemtest"
testmode_db_user="TestModePEM_usr"
testmode_db_password="YYYYYYYYYYY"
testmode_db_driver="com.ibm.db2.jcc.DB2Driver"

db_port="XXXXX"
db_host="xxx.xxx.xxx.com"
db_name="PEMDEV"
db_schema="pemmaster"
db_user="MasterPEM_usr"
db_password="b8KmXLI6J9TAucW5T7bC"
db_driver="com.ibm.db2.jcc.DB2Driver"

Resolving The Problem

Per the Documentation Page for DB2 configuration:

https://www.ibm.com/docs/en/spems/6.2.3?topic=schema-db2-database-configuration
Note: PEM only supports configurations using the default schema associated with the respective database users.
The customer needs to create the DB_SCHEMA and DB_USER for both the Master and TestMode with the same name prior to running the Migrator.

testmode_db_port="XXXXX"
testmode_db_host="xxx.xxx.xxx.com"
testmode_db_name="PEMDEV"
testmode_db_schema="pemtest"
testmode_db_user="pemtest"
testmode_db_password="YYYYYYYYYYY"
testmode_db_driver="com.ibm.db2.jcc.DB2Driver"

db_port="XXXXX"
db_host="xxx.xxx.xxx.com"
db_name="PEMDEV"
db_schema="pemmaster"
db_user="pemmaster"
db_password="b8KmXLI6J9TAucW5T7bC"
db_driver="com.ibm.db2.jcc.DB2Driver"

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFG8Z","label":"IBM Sterling Partner Engagement Manager Software"},"ARM Category":[{"code":"a8m0z000000boKAAAY","label":"Deployment"}],"ARM Case Number":"TS015877215","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
11 April 2024

UID

ibm17148071

Page Feedback