Error upgrading APM Postgres DB from APM 10.7>10.8

Products

• CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

 In the process of upgrading 10.7 to 10.8. The install complete for EM and WebView, but failed on DB upgrade.

 

This is the error that shows in the Introscope_10.8.0.27_InstallLog.log

 

Execute Script/Batch file:   Change permissions on lax files
                          Status: ERROR
                          Additional Notes: ERROR - Error while attempting to execute the installation script


Upgrade Database Schema Failed
                          Status: ERROR
                          Additional Notes: ERROR - . Check <APM_HOME>/install/schematools.log for more
 details


Custom Action:            com.wily.introscope.installer.plugin.LogErrorMessage
                          Status: SUCCESSFUL

 

There was no file created here though<APM_HOME>APM/Introscope10.7.0.45/install/schematools.log

 

I then attempted a manual DB upgrade using the command

./dbupgrade.sh -databaseName cemdb -databaseType Postgres -desiredVersion 10.8 -host localhost -is64bit true -user postgres -password <password> -port 5432 -postgresInstalldir <APM_HOME>/APM/PostgreSQL-9.6.2/ -scriptsDir /opt/ca/APM/Introscope10.7.0.45/install/database-scripts

 

This then showed the error:

[INFO] [main] [root] [UpgradeSchema] - DBType: Postgres
[INFO] [main] [root] [UpgradeSchema] - Desired Version: 10.8
[INFO] [main] [root] [UpgradeSchema] - Scripts location: <APM_HOME>/APM/Introscope10.7.0.45/instal
l/database-scripts/
[INFO] [main] [root] [UpgradeSchema] - Current release is: 10.7.0.0
[INFO] [main] [root] [UpgradeSchema] - SchemaUpgrade will execute upgrade
[INFO] [main] [root] [UpgradeSchema] - Undelying OS name is linux
[ERROR] [main] [root] [UpgradeSchema] -
com.wily.apm.dbtools.upgradeschema.ReleaseNotFoundException: Source or target release not found in Releases XML file
        at com.wily.apm.dbtools.upgradeschema.DBUpgradeReleaseHelper.loadReleases(DBUpgradeReleaseHelper.java:162)
        at com.wily.apm.dbtools.upgradeschema.DBUpgradeReleaseHelper.getUpgradePath(DBUpgradeReleaseHelper.java:46)
        at com.wily.apm.dbtools.upgradeschema.UpgradeSchema.initiateUpgradeProcess(UpgradeSchema.java:408)
        at com.wily.apm.dbtools.upgradeschema.UpgradeSchema.upgradeSchema(UpgradeSchema.java:296)
        at com.wily.apm.dbtools.upgradeschema.UpgradeSchema.main(UpgradeSchema.java:160)
[ERROR] [main] [root] [UpgradeSchema] - Error upgrading schema

 

Environment

APM 10.8 GA

Resolution

There are no changes to the APM DB (Oracle DB) schema between APM 10.7 and APM 10.8, there is no need to do a database update during upgrade, Instead do a custom install with EM.

Instead, set the ts_db_versions in ts_domains to 10.8.0 in the existing APM DB (Oracle DB).

Additional Information

APM Oracle DB Upgrade Not Needed

You may also see this error message in the EM loga and the ATC won't start.

 [ERROR] [main] [Manager.AppMap] DB version is 10.7.0.0, while your application has version 10.8. Denying to start ATC.