CA Identity ManagerCA Identity GovernanceCA 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"
Cause
The cause is the setting to true the property setting of reportdb.enabled.
Environment
Identity Governance 14.1
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';