CA Identity Manager: Jboss is throwing a DB error immediately after installation
Article ID: 113637
CA Identity ManagerCA Identity GovernanceCA Identity Portal
After installing a copy of Identity Manager, Jboss fails to boot up with the following or a similar error message:
Error in creating Auditing database schema.: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'IM_Audit_Start_Date' in the database.
Release: Component: IDMGR
There was a problem in building the tables that Identity Manager uses.
The solution to this is to drop the tables that Identity Manager created in your database and let Jboss recreate them during the next start up. If this installation was performed over an old Identity Manager database, the old DB should be backed up and then dropped.