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

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Risk Analytics
• CA Secure Cloud SaaS - Arcot A-OK (WebFort)
• CLOUDMINDER ADVANCED AUTHENTICATION
• 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