Problem:
Cannot start Jboss Services.
From server.log file appears the following
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
Win2008 R2
Cause :
1. The problem was caused after deployed a new JAR files. With DBA tools was identified which tables are being trying to create at the jboss startup stage.
2. The Persistence Database is created when you start the application Server (jboss)
the problem seems to be due an object currently present with the same
name that is being trying to create the Task Persistence DB.
Resolution/Workaround:
1. Please identify which table name is trying create and failing , using DBA tools you can identify which tables are being trying to create at the jboss startup stage.
2. delete the problematic tables from the Database, on this case of use the
tables were the following :
TMP_BULKLOADER12_5
ARCHIVE_TMP_BULKLOADER12_5
Note : those tables will be created based on the JAR file during the Jboss service startup.