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

  • Document ID:7015663
  • Creation Date:16-Sep-2014
  • Modified Date:16-Sep-2014
    • Micro Focus Products:
      ZENworks Configuration Management

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