Error E0050 - The infrastructure has been suspended. (Invalid database configuration information.)

Products

• CA Security Command Center
• CA 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)