Error in creating Task Persistence database schema

book

Article ID: 36988

calendar_today

Updated On:

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: 

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.

 

Environment

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