Identity Governance not starting - ORA-00942: table or view does not exist"

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

When trying to start the Identity Governance web application, the application does not start and errors appear in the log.
Among them :
"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.1

Cause

The cause is the setting to true the property setting of reportdb.enabled.

Resolution

Setting the property of reportdb.enabled back to 'false' resolves issue.
However, since this cannot be done through the web UI as it cannot come up, this modification should be made using the database.
You can open the eurekify_sdb database, sage_properties. Update the row where the NAME is reportdb.enabled. SET the VALUE column to be 'false'.

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

By default this name and value pair will not exist in your database. The above commands only work if you have already edited the value from a default and chose it as a database property.

If this is the case here is an example of how to add it to an oracle database:

insert into EUREKIFY_SDB.sage_preferences (LOGINID, PREFGROUP, NAME, VALUE) Values ('eurekify.properties', 'eurekify.properties.dynamic', 'reportdb.enabled', 'false');

 

Please understand that EUREKIFY_SDB.sage_preferences this statement, EUREKIFY_SDB refers to your Oracle schema name and may need to be changed in your environment.