ORA-00955: name is already used by an existing object

Products

• CA Privileged Access Manager - Server Control (PAMSC)
• CA Privileged Identity Management Endpoint (PIM)

Issue/Introduction

Issue:

Every time we restart JBOSS  the following error is shown in the server.log file:

ERROR [ims.tmt.CreateDatabaseSchema] Error in creating Report Snapshot database schema.
java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
        ...

 

Environment: 

CA ENTM 12.91 with ORACLE 12c on Linux Rhel 6.7.

Cause:

The error is because the table already exists in the database. When we install the product, all the tables will be created in the database. Post installation when jboss starts it will again check for some of the tables and try to create it again. the error is because of that.

Workaround:

We can ignore this error. There is no impact of it on the product.

Additional Information: 

Prepare the Central Database for Enterprise Management

Environment

Release: ACP1M005900-12.9-Privileged Identity Manager
Component:

Resolution

.