Environment
ZENworks Configuration Management 2020 Update 1 (20.1)
PostgreSQL database
Situation
Running ZENworks Diagnostic Center (ZDC) version after upgrading to ZENworks 2020 Update 1 (20.1) on PostgreSQL
Any of the following Errors is seen in the 20.1 ZDC report.
Mismatch in table 'nc_networkdeviceadfs'structure.
Object type: [Constraint], Object name: [fk_nc_netw_networkdeviceadfoid]
Expected: [Name: fk_nc_netw_networkdeviceadfoid, Type: FOREIGN KEY, Table: nc_networkdeviceadfs, ColumnOrder {Position: 1 [ColumnName: networkdeviceadfoid, DeleteCascade: true]}]
Found: [Name: fk_nc_netw_networkdeviceadfoid, Type: FOREIGN KEY, Table: nc_networkdeviceadfs, ColumnOrder {Position: 1 [ColumnName: networkdeviceadfoid, DeleteCascade: false]}]
Mismatch in table 'storagedevicepolicy'structure.
Object type: [Constraint], Object name: [fk_stordev_accesstype06]
Expected: [Name: fk_stordev_accesstype06, Type: FOREIGN KEY, Table: storagedevicepolicy, ColumnOrder {Position: 1 [ColumnName: portableaccessid, DeleteCascade: true]}]
Found: [Name: fk_stordev_accesstype06, Type: FOREIGN KEY, Table: storagedevicepolicy, ColumnOrder {Position: 1 [ColumnName: portableaccessid, DeleteCascade: false]}]
Mismatch in table 'zesm_certinformation'structure.
Object type: [Column], Object name: [password]
Expected: [Name: password, Size: 2147483647, Type: VARCHAR, Nullable: true]
Found: [Name: password, Size: 255, Type: VARCHAR, Nullable: true]
Mismatch in View 'zrs_assignablecons'structure.
Expected: [Name: zrs_assignablecons, Definition hash(Case-insensitive): 65d8ece5]
Found: [Name: zrs_assignablecons, Definition hash(Case-insensitive): 887dee37]
Resolution
Contact Micro Focus ZENworks support for a database script
(PostgreSQL) that will resolve this issue.