After Upgrade CAPC Does Not Not Update The Release Details

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Upgrading CAPC server to latest release appears to be successful, i.e. no errors on screen during upgrade process.  Open CAPC web interface and notice it does not update the CAPC release in Help | About CA Performance Center
The previous version of CAPM is displayed as the current version, for example CAPC r3.7.0, instead of CAPC r3.7.12.

Environment

NetOps Performance Management

Cause

From the dbmigrate.log.yyyy-mm-dd_hh-mm we can see the following entries during the CAPC upgrade:

Jun 10, 2020 7:47:11 PM com.ca.im.installanywhere.util.DbMigrate run
SEVERE: Error with upgrade/3.7.0.0/_upgrade.3.7.0.0.xml: An exception occurred on step 0 (upgrade/3.7.0.0/fixup_database_fields.sql) of loading /ca/PerformanceCenter/Tools/bin/../../SQL/upgrade/3.7.0.0/_upgrade.3.7.0.0.xml
java.sql.SQLException: Error executing command: CALL fix_up_table_dst_interface_lifecyclestate() on line 305 in script /ca/PerformanceCenter/Tools/bin/../../SQL/upgrade/3.7.0.0/fixup_database_fields.sql  Column 'ItemID' cannot be null
 at com.ca.im.installanywhere.util.DbExecuteScript.executeScript(DbExecuteScript.java:123)
 at com.ca.im.installanywhere.util.DbMigrate.runScript(DbMigrate.java:588)
 at com.ca.im.installanywhere.util.DbMigrate.loadScripts(DbMigrate.java:412)
 at com.ca.im.installanywhere.util.DbMigrate.run(DbMigrate.java:208)
 at com.ca.im.installanywhere.util.DbMigrateApp.runDBMigrate(DbMigrateApp.java:323)
 at com.ca.im.installanywhere.util.DbMigrateApp.run(DbMigrateApp.java:289)
 at com.ca.im.installanywhere.util.DbMigrateApp.main(DbMigrateApp.java:41)

Resolution

Run the following MySQL query on the CAPC server:

mysql> SELECT ItemID, SourceID, LocalID FROM dst_interface WHERE LifeCycleState='BINARY';

Empty set (0.00 sec)

If the value returned is "Empty set" only, like in the example above, then re-run the CAPC install again, no need to rollback/uninstall.  Do NOT run the MySQL statement if a value is anything else.  Instead, open a support case with Broadcom Support.  Include the MySQL command and it's results in the support case.