Jboss Does Not Startup Due to ORA-00955: name is already used by an existing object.

Article Id: 37595

Status: Published

Updated On: 05-10-2018 09:09

Legacy Id: TEC1036739

Products:

CA Identity Manager , CA Identity Governance , CA Identity Portal , CA Risk Analytics , CA Secure Cloud SaaS - Arcot A-OK (WebFort) , CA Secure Cloud SaaS - Advanced Authentication , CA Secure Cloud SaaS - Identity Management , CA Secure Cloud SaaS - Single Sign On

Issue/Introduction:

Problem:

Jboss Server does not start up due to ORA-00955: name is already used by an existing object

The server.log file shows the following message:

INFO [ims.Main] (ServerService Thread Pool -- 115) * Startup Step 1 : Attempting to start ServiceLocator.

ERROR [ims.tmt.CreateDatabaseSchema] (ServerService Thread Pool -- 115)

Error in creating Task Persistence database schema.: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

Environment:

CA Identity Manager 12.6.06.0.214

JBoss EAP 6.3.0.GA

jdk1.7.0_71

Oracle Database

Cause:

Persistence Database tables are created when you start the application Server (jboss)

The problem was caused after deploying new JAR files to do some tests.

Resolution:

1. Identify which table is trying to create during Jboss starting up.

For example: the tables appear similar to the following text:

TMP_BULKLOADER12_5

ARCHIVE_TMP_BULKLOADER12_5

2. Delete those tables names from the database.

3. The same tables will be created based on the JAR file during the Jboss service startup.

Additional Information :

For MSSQL, Determine Which Queries Are Holding Locks

https://technet.microsoft.com/en-us/library/bb677357(v=sql.110).aspx

For Oracle , How to see lock on table and query?

https://community.oracle.com/thread/1034701?tstart=0

For further details, please refer to your MSSQL or your Oracle Database Documentation.

Environment:

Release: CAIDMB99000-12.6.6-Identity Manager-B to B
Component:

Resolution:

Please Update This Required Field