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

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


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

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 ('', '', '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.