Upgrading from APM 10.1 to 10.5.1 fails.

Products

• APP PERF MANAGEMENT
• CA Application Performance Management Agent (APM / Wily / Introscope)
• CUSTOMER EXPERIENCE MANAGER
• 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.