After Upgrade CAPC Does Not Not Update The Release Details
search cancel

After Upgrade CAPC Does Not Not Update The Release Details


Article ID: 193807


Updated On:


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


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.


NetOps Performance Management


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 run
SEVERE: Error with upgrade/ An exception occurred on step 0 (upgrade/ of loading /ca/PerformanceCenter/Tools/bin/../../SQL/upgrade/
java.sql.SQLException: Error executing command: CALL fix_up_table_dst_interface_lifecyclestate() on line 305 in script /ca/PerformanceCenter/Tools/bin/../../SQL/upgrade/  Column 'ItemID' cannot be null


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.