Can't Start IdentityGovernance Service

book

Article ID: 111002

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal

Issue/Introduction

When starting the Identity Governance it is failing. The failing message lists a table which does not exust:
"SELECT ssid, Name, CreateDate, Owner, Description, Type, ExtractionComplete, ExtractionFailed FROM RCM_Snapshots ]; nested exception is java.sql.SQLException:
...
table or view does not exist "

Cause

This is caused by a property wrongly set.
The property of 'reportdb.enabled' need to be set to 'false'.


 

Environment

Identity Governance 14.0 and up

Resolution

Since modifying the property is not possible through the web UI(the server is not starting), it will have to be modified directly in the database.
Engage your DBA in order to modify the SAGE_PREFERENCES table and change the VALUE column to 'false' where the NAME column equals 'reportdb.enabled'.