3.0 Troubleshooting ZENworks Diagnostics Center

The following sections provide solutions to the problems you might encounter while working with Micro Focus ZENworks Diagnostics Center:

ZENworks Diagnostics Center Report displays Inconsistencies for Patch Management

Source: ZENworks 2020 Update 3
Explanation: While running ZENworks Diagnostics on the database, the following inconsistencies will be displayed in the ZDC report: 
ERROR Missing object in table 'patchsignature' 
Object type: [Index] , Object name: [uniq_patchsignature_type] 
Detail: [Name: uniq_patchsignature_type, Table: patchsignature, ColumnMap: {type=1}, isConstraint: false] 
IndexERROR Missing object in table 'patchsignature' 
Object type: [Constraint] , Object name: [uniq_patchsignature_type] 
Detail: [Name: uniq_patchsignature_type, Type: UNIQUE, Table: patchsignature, ColumnOrder {Position: 1 [ColumnName: type, DeleteCascade: false]}] 
ConstraintERROR Missing object in table 'patchsuperseded' 
Object type: [Index] , Object name: [uniq_patchsuperseded] 
Detail: [Name: uniq_patchsuperseded, Table: patchsuperseded, ColumnMap: {newpatchid=1, oldpatchid=2}, isConstraint: false] 
IndexERROR Missing object in table 'patchsuperseded' 
Object type: [Constraint] , Object name: [fk_patchsuperseded_newpatchid] 
Detail: [Name: fk_patchsuperseded_newpatchid, Type: FOREIGN KEY, Table: patchsuperseded, ColumnOrder {Position: 1 [ColumnName: newpatchid, DeleteCascade: true]}] 
ConstraintERROR Missing object in table 'patchsuperseded' 
Object type: [Constraint] , Object name: [fk_patchsuperseded_oldpatchid] 
Detail: [Name: fk_patchsuperseded_oldpatchid, Type: FOREIGN KEY, Table: patchsuperseded, ColumnOrder {Position: 1 [ColumnName: oldpatchid, DeleteCascade: true]}]
ConstraintERROR Missing object in table 'patchsuperseded' 
Object type: [Constraint] , Object name: [uniq_patchsuperseded] 
Detail: [Name: uniq_patchsuperseded, Type: UNIQUE, Table: patchsuperseded, ColumnOrder {Position: 1 [ColumnName: newpatchid, DeleteCascade: false]} {Position: 2 [ColumnName: oldpatchid, DeleteCascade: false]}]
ConstraintERROR Missing object in table 'patchdevicestatus' 
Object type: [Index] , Object name: [uniq_patchdevicestatus] 
Detail: [Name: uniq_patchdevicestatus, Table: patchdevicestatus, ColumnMap: {deviceid=1, signature_id=2}, isConstraint: false]
IndexERROR Missing object in table 'patchdevicestatus' 
Object type: [Constraint] , Object name: [uniq_patchdevicestatus] 
Detail: [Name: uniq_patchdevicestatus, Type: UNIQUE, Table: patchdevicestatus, ColumnOrder {Position: 1 [ColumnName: deviceid, DeleteCascade: false]} {Position: 2 [ColumnName: signature_id, DeleteCascade: false]}]
Action: These inconsistencies can be ignored. If you are using ZENworks Patch Management with legacy feed even after updating to ZENworks 2020 Update 3, then you will observe these inconsistencies. In ZENworks 2020 Update 3, after migrating to the Advanced Patch feed, all inconsistencies would be automatically addressed.