ZCM automated Dynamic Group recalculation failing

  • 7011783
  • 13-Feb-2013
  • 31-Oct-2013

Environment

Novell ZENworks Configuration Management 11.2

Situation

The automated nightly process that recalculates Dynamic Groups is failing to complete.
The following error is seen in the loader-messages.log:

[DEBUG] [09/01/13 06:02:28] [] [Loader.Query Group Refresh Handler] [300] []
[Failed to refresh the query groups] [] []
[DEBUG] [09/01/13 06:02:28] [] [Loader.Query Group Refresh Handler] [300] []
[com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
org.hibernate.exception.DataException: could not execute query
...

Resolution

This is fixed in version 11.2.4 - see KB 7012027 "ZENworks Configuration Management 11.2.4 - update information and list of fixes" which can be found at:
https://support.microfocus.com/kb/doc.php?id=7012027

Workaround: if it is not possible to upgrade to ZCM11.2.4 at this time, in the interim, Novell has made a Patch available for testing, as part of a Monthly patch update: it can be obtained at https://download.novell.com/Download?buildid=s5zcEae9xcI~ as "ZCM 11.2.3a Monthly Update 1 - see TID 7012025". This update should only be applied if the symptoms above are being experienced, and are causing problems.

Please report any problems encountered when using this Patch, by using the feedback link on this TID.