search cancel

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


Article ID: 35693


Updated On:


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



 Exported an Oracle APM/CEM Database configuration and dropped the database using (.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.



 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 (.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.




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