Upgrading from APM 10.1 to 10.5.1 fails.

Article Id: 7479

Status: Published

Updated On: 14-02-2018 08:18

Legacy Id: TEC1258782

Products:

CA Application Performance Management Agent (APM / Wily / Introscope) INTROSCOPE

Issue/Introduction:

The APM database fails to upgrade from APM 10.1 to 10.5.1.

Introscope_10.5.1.8_InstallLog.log shows following ERROR.
Upgrade Database Schema Failed
                          Status: ERROR
                          Additional Notes: ERROR - . Check /opt/CA/Introscope/install/schematools.log for more details

schematools.log shows following ERROR.
[ERROR] [main] [root] [Upgrade10_1_0_0] - Unexpected exception while upgrading
java.sql.SQLException: ORA-12899: value too large for column "APMTEST"."APPMAP_ATTRIBS"."VALUE" (actual: 1485, maximum: 1024)

Cause:

The failure is caused by the column length of a table in APM 10.1 Database.

Environment:

APM is installed with Oracle Database.

Resolution:

As a workaround prior to the upgrade, increase the column length manually:

alter table APMTEST.APPMAP_ATTRIBS modify (VALUE VARCHAR2(2048));

This command will then confirm the change:

desc APMTEST.APPMAP_ATTRIBS

Run the install again to upgrade the APM Database.