Import fails with error ORA-20167 Reserved object can not be updated

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

When trying to perform an import, the following error or similar may be seen:

ERROR at line 1:
ORA-20167:  Reserved object "Reports AHA-ABNORMAL_RUN_TIME can not be  updated"
ORA-06512: at "AUTOMIC.AWAPI2", line 487
ORA-06512: at "AUTOMIC.AWAPI4", line 1534
ORA-06512: at "AUTOMIC.AWAPI4", line 584
ORA-06512: at "AUTOMIC.AW_IMPORT", line 1903
ORA-06512: at "AUTOMIC.AW_IMPORT", line 4515
ORA-06512: at "AUTOMIC.AW_IMPORT", line 4602
ORA-06512: at line 5

IMPORT Failed

Environment

Release : 9.x

Cause

Applications Manager has a number of "reserved" objects that can not be updated.

Resolution

Reserved objects can not be updated. All Reports objects available out of the box are considered reserved objects.

To update an out of the box Report, a copy can be made and an update can be made to the copied Report.

The above error can be seen if an export is created which include out of the box Report objects.

When trying to import these Reports objects into another Applications Manager environment, the import tries to update the already available Report object but the ORA20167 error is thrown since the Report object is a reserved object.

The solution is to omit default Report objects from export/imports.