search cancel

Identity Governance Does not start


Article ID: 112395


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal


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"


Identity Governance 14.1


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


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