ZDC reports missing constraint FK_ZQUICKTASKASSIGNMENT_AUXID

  • 7012900
  • 18-Jul-2013
  • 18-Jul-2013


Novell ZENworks Configuration Management 11.2.2


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



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.

This is a false positive and can be ignored.


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