Error E0050 - The infrastructure has been suspended. (Invalid database configuration information.)
book
Article ID: 111782
calendar_today
Updated On:
Products
CA Security Command CenterCA Data Protection (DataMinder)CA User Activity Reporting
Issue/Introduction
The CA Data Protection Infrastructure Service starts but suspends with an error in the Activity Log.
E0050 The infrastructure has been suspended. (Invalid database configuration information.)
This also coincides with the following STDerr.logs
Aug 20, 2018 09:35:09 AM System Disabling Infrastructure due to exception - java.sql.SQLException: [CA DataMinder][Oracle JDBC Driver][Oracle]ORA-01502: index 'WGNOWNER_OWNER.UK_WGN3EVENT_SEQIDM' or partition of such index is in unusable state ORA-06512: at "WGNOWNER.WGN3EVENTINSERT", line 53 ORA-06512: at line 1 Aug 20, 2018 09:35:09 AM System Internal Error: [CA DataMinder][Oracle JDBC Driver][Oracle]ORA-01502: index 'WGNOWNER_OWNER.UK_WGN3EVENT_SEQIDM' or partition of such index is in unusable state ORA-06512: at "WGNOWNER.WGN3EVENTINSERT", line 53 ORA-06512: at line 1 Aug 20, 2018 09:35:09 AM System java.sql.SQLException: [CA DataMinder][Oracle JDBC Driver][Oracle]ORA-01502: index 'WGNOWNER_OWNER.UK_WGN3EVENT_SEQIDM' or partition of such index is in unusable state ORA-06512: at "WGNOWNER.WGN3EVENTINSERT", line 53 ORA-06512: at line 1
Environment
CA Data Protection 15.2 running on Oracle Db
Cause
This is can be caused by an erroneous index on the Wgn3Event table.
Resolution
Rebuilding indexes ie (ALTER INDEX REBUILD ONLINE) on resolves the problem.
Additional Information
All database maintenance should be undertaken by an experienced Data Base Administrator (DBA)