search cancel

Error in creating Task Persistence database schema


Article ID: 36988


Updated On:


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



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



CA Identity Manager

JBoss EAP 6.3.0.GA


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.




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 :



Note : those tables will be created based on the JAR file during the Jboss service startup.



Release: CAIDMB99000-12.6.7-Identity Manager-B to B