Unable to drop Oracle schema 10.7 SP1

Document ID : KB000106287
Last Modified Date : 17/07/2018
Show Technical Document Details
Issue:
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
 
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.