Content satellite fails to clean up content

  • 7014580
  • 18-Feb-2014
  • 22-May-2015

Environment

Novell ZENworks Configuration Management 11.2

Situation

Satellite superfluous content is not cleaned up.

ERROR (satellite zmd-messages.log):

result=(Code, Message): 
(1, (org.hibernate.exception.DataException: could not execute update query))]
[] [] 

ERROR (satellite's first configuration primary logs):

[DEBUG] [12/17/13 3:33:00 PM] [] [Content Web Service] [610] [][updateCDPSyncState: Error updating sync state for device.] [] []
[DEBUG] [12/17/13 3:33:00 PM] [] [Content Web Service] [610] [] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.hql.ast. QuerySyntaxException: unexpected end of subtree [[update com.novell.zenworks.datamodel.objects.content.ContentSyncState c set c.SyncState=:syncState where c.ContentUID in () and c.ServerUID=:serverUID]]
...
Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [[update com.novell.zenworks.datamodel.objects.content.ContentSyncState c set c.SyncState=:syncState where c.ContentUID in () and c.ServerUID=:serverUID]] at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)

Resolution

This is fixed in version 11.3.1 - see KB 7015288 "ZENworks Configuration Management 11.3.1 - update information and list of fixes" which can be found at https:// www.novell.com/support/search.do?usemicrosite=true&searchString=7015288