Identity Governance Startup Failure: Resolving 'ORA-00942: table or view does not exist' for RCM_Snapshots

Products

• CA Identity Governance
• CA Identity Suite

Issue/Introduction

The Identity Governance web application fails to start, and the following error sequence appears in the server logs:

Error creating bean with name 'extractionManager' defined in class path resource [META-INF/reportDbContext.xml]: Invocation of init method failed
nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ SELECT ssid, Name, CreateDate, Owner, Description, Type, ExtractionComplete, ExtractionFailed FROM RCM_Snapshots ]
nested exception is java.sql.SQLException: ORA-00942: table or view does not exist

Environment

Identity Governance 14.x

Cause

The application is attempting to access reporting tables (RCM_Snapshots) because the reportdb.enabled property is set to true in the database preferences, even though the reporting schema may not be fully configured or present.

Resolution

Since the web UI is inaccessible, this property must be modified directly in the database. Follow these steps to set the value to false:

1. Log into your Oracle database instance as a user with sufficient privileges to modify the Identity Governance schema.

2. Determine if the property already exists in the SAGE_PREFERENCES table.

3. If the property exists, run the following update command:

   UPDATE EUREKIFY_SDB.sage_preferences SET VALUE = 'false' WHERE NAME = 'reportdb.enabled';

4. If the property does not exist (default behavior), you must insert it to explicitly disable the feature:

   INSERT INTO EUREKIFY_SDB.sage_preferences (LOGINID, PREFGROUP, NAME, VALUE) VALUES ('eurekify.properties', 'eurekify.properties.dynamic', 'reportdb.enabled', 'false');

5. Commit the changes to the database.

6. Restart the Identity Governance service.

Note: In the commands above, EUREKIFY_SDB refers to the default Oracle schema name. Replace this with the specific schema name used in your environment if different.