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

Document ID : KB000111782
Last Modified Date : 21/08/2018
Show Technical Document Details
Issue:
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)