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