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
CA Identity Manager 12.6.06.0.214
JBoss EAP 6.3.0.GA
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.
1. Identify which table is trying to create during Jboss starting up.
For example: the tables appear similar to the following text:
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
For Oracle , How to see lock on table and query?
For further details, please refer to your MSSQL or your Oracle Database Documentation.