Diagnostics reports missing indexes in database

Document ID:7017953
Creation Date:15-Aug-2016
Modified Date:29-Aug-2016
- Micro Focus Products:
  ZENworks Configuration Management

Environment

Novell ZENworks Configuration Management 11.4 Database
Novell ZENworks Configuration Management 11.4 ZDC
Oracle database

Situation

Zenworks diagnostics center (ZDC) reports following missing indexes in the database

ERROR    Missing object in table 'ZCONTENT'
         Object type: [Index] , Object name: [IDX_ZCONTENT_K1_K4]
         Detail: [Name: IDX_ZCONTENT_K1_K4, Table: ZCONTENT]
ERROR    Missing object in table 'ZCONTENT'
         Object type: [Index] , Object name: [IDX_ZCONTENT_K1_K4]
         Detail: [Name: IDX_ZCONTENT_K1_K4, Table: ZCONTENT]
ERROR    Missing object in table 'ZZENOBJECT'
         Object type: [Index] , Object name: [IDX_ZZENOBJECT_K1_K6]
         Detail: [Name: IDX_ZZENOBJECT_K1_K6, Table: ZZENOBJECT]
ERROR    Missing object in table 'ZZENOBJECT'
         Object type: [Index] , Object name: [IDX_ZZENOBJECT_K1_K6]
         Detail: [Name: IDX_ZZENOBJECT_K1_K6, Table: ZZENOBJECT]

Resolution

These errors can be ignored.

Cause

These indexes are no longer used/needed.