configimport fails with '[ERROR] [main][ root] [ConfigImport] - Oracle Schema should be empty before importing.'

Products

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

Issue/Introduction

 Symptoms:

 Exported an Oracle APM/CEM Database configuration and dropped the database using dbdrop.sh (.bat) script.

 When trying to import the Database configuration using the same Oracle userid receives this error:

 [ERROR] [main][ root] [ConfigImport] - Oracle Schema should be empty before importing.

 

 Resolution:

 The ConfigImport checks that the Oracle user does not own any objects by executing this SQL:

 SELECT  count(Object_type) from user_objects order by  object_type;

 The dbdrop.sh (.bat) script will only drop APM related objects so any other objects that still exist in the schema will cause ConfigImport to fail.

 Request the DBA to verify the presence of the other schema objects and remove them to resolve the problem.

 

 

Environment

Release: CEMUGD00200-9.7-Introscope to CA Application-Performance Management-Upgrade Main
Component: