ZDC reports missing constraint FK_ZQUICKTASKASSIGNMENT_AUXID

Document ID:7012900
Creation Date:18-Jul-2013
Modified Date:18-Jul-2013
- Micro Focus Products:
  ZENworks Asset Management
  ZENworks Configuration Management
  ZENworks Endpoint Security Management
  ZENworks Full Disk Encryption
  ZENworks Patch Management

Environment

Novell ZENworks Configuration Management 11.2.2

Situation

ZCM is installed on top of Oracle SQL database

ZENworks Diagnostic Center reports a missing constraint FK_ZQUICKTASKASSIGNMENT_AUXID

The ZDC logs file contains messages like:
"...
[ERROR] [DBObjectComparer] Constraint 'FK_ZQUICKTASKASSIGNMENT_AUXID' is missing!!!
...
[ERROR] [DBObjectComparer] Additional Constraint 'FK_ZQUICKTASK_AUXID' found!!!
[ERROR] [TableHelper] [!] 1 error(s) found while verifying Constraints of Table ZQUICKTASKASSIGNMENT
..."

Resolution

This is fixed in the ZENworks Diagnostic Center released for ZCM 11.2.3a, which can be found at https://download.novell.com/patch/finder/#familyId=18962&productId=49105&keywords=zdc

Please note to always use the ZDC version made available for the respective ZCM version.

Workaround:
This is a false positive and can be ignored.

Cause

This was caused by the baseline pattern used for database schema comparison.