Identity Governance Does not start

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';