Satellite content cleanup fails with SQL exception due to excessive parameters

  • 7021192
  • 09-Aug-2017
  • 05-Apr-2018

Environment

ZENworks Configuration Management 2017 Update 1

Situation


ERROR (MSSQL)

[Content Datamodel] [] [setContentSyncStateBatch complete, time: 9ms, serverUID: 73082b51edf52548932f5e8057220987, contentIDs: (f909952307a6afc6b00a81953cdf8ed7), syncState: UNAVAILABLE, thread: 112] [] [] [] [ZENServer]
[Content Web Service] [] [updateCDPSyncState: Error updating sync state for device.73082b51edf52548932f5e8057220987] [] [] [] [ZENServer]
[Content Web Service] [] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.SQLGrammarExcept

Caused by: org.hibernate.exception.SQLGrammarException: The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.

ERROR (Oracle)

[Content Web Service] [] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.SQLGrammarException: ORA-01795: maximum number of expressions in a list is 1000

Resolution

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

Workaround: if it is not possible to upgrade to ZCM 2017 Update 2 at this time, in the interim, Novell has made a Patch available for testing.  Contact Micro Focus Customer Care ZENworks support to request the patch.   

Status

Reported to Engineering

Feedback service temporarily unavailable. For content questions or problems, please contact Support.