ZDC reports mismatch in the table constraints or views for ZENworks 2020 Update 1 (20.1)

  • 7024741
  • 20-Jul-2020
  • 21-Jul-2020

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.