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
..."
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.
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.