Upgrading from APM 10.1 to 10.5.1 fails.

Document ID : KB000007479
Last Modified Date : 14/02/2018
Show Technical Document Details

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)

APM is installed with Oracle Database.

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


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:



Run the install again to upgrade the APM Database.