Environment
Novell ZENworks Configuration Management 11.4 Database
Novell ZENworks Configuration Management 11.4 ZDC
Oracle 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]
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.