Satellite cleanup error Caused by: java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers

  • 7015663
  • 16-Sep-2014
  • 16-Sep-2014

Environment

Novell ZENworks Configuration Management 11.3

Situation

Large content cleanup job for satellite servers when MS SQL database is used.  Content is not cleaned up.

ERROR:

Caused by: java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.

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