ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
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
Cause
This is can be caused by an erroneous index on the Wgn3Event table.
Environment
CA Data Protection 15.2 running on Oracle Db
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)