Unable to drop Oracle schema 10.7 SP1

Products

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

Issue/Introduction

After a clean APM 10.7 installation, we tried cleaning up the Oracle schema. 

./dbdrop.sh -databaseName xxxx -databaseType Oracle -host x.y.z.t -port xxxx -user xxxx -password xxxx -releaseVersion 10.7.0.0 -scriptsDir /introscope/product-10.7/install/oracle/database-scripts/ 

[INFO] [main] [root] [DropSchema] - DBDetails: hostName: x.y.z.t port: xxx databaseName: xxxx user: xxx 
[INFO] [main] [root] [DropSchema] - DBType: Oracle 
[INFO] [main] [root] [DropSchema] - Release Version: 10.7.0.0 
[INFO] [main] [root] [DropSchema] - Scripts location: /introscope/product-10.7/install/oracle/database-scripts/ 
[ERROR] [main] [root] [DropSchema] - No Major release version found from the given releaseVersion - 10.7.0.0 

Scripts are in the folder /introscope/product-10.7/install/oracle/database-scripts/ 

APM schema version in Oracle 

SQL> select ts_db_versions from ts_domains; 

TS_DB_VERSIONS 
-------------------------------------------------------------------------------- 
10.7.0.0 

The same command with an APM 10.5.2 works
 

Environment

Release: MSPAPJ99000-10.7.0-Application Performance Mgmt-Java and .NET Agent-MSP
Component:

Cause

When dropping the schema, the APM10.7 version was not seen in the list. This caused it to error out stating that there was no major release version found.

 

Resolution

This is fixed in  APM 10.7.0 SP2.