Failed to launch the list of all patches when trying to view all the patches applicable to a Dynamic Workstation Workgroup

  • Document ID:7014235
  • Creation Date:05-Dec-2013
  • Modified Date:20-Dec-2013
    • Micro Focus Products:
      ZENworks Configuration Management

Environment

Novell ZENworks Configuration Management 11.2.3
Oracle Database

Situation

When clicking on the Patches Section of a Dynamic Workstation group, the list of patches displayed on this list will not be complete and this will prevent the user from adding the not listed patches to the Mandatory baselines.
 
The following error log will be displayed in the zcc.log file:
 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

Resolution

A fix for this issue is intended to be included in a future update to the product: however, in the interim, Novell has made a Patch available for testing, as part of a Monthly patch update: it can be obtained at https://download.novell.com/Download?buildid=Rbs5fYlojj0~ as "ZCM 11.2.4 Monthly Update 1 - see TID 7014163". This update should only be applied if the symptoms above are being experienced, and are causing problems.

Please report any problems encountered when using this Patch, by using the feedback link on this TID.

Additional Information

See full stack trace below:
 
Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of
expressions in a list is 1000
 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
    at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
    at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
    at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
    at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
    at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
    at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
    at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
    at org.hibernate.loader.Loader.doQuery(Loader.java:662)
    at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
    at org.hibernate.loader.Loader.doList(Loader.java:2145)
    ... 59 more
15 Aug 2013 14:54:34
 
Exception Info:
15 Aug 2013 14:54:34     Class.......
org.hibernate.exception.SQLGrammarException
15 Aug 2013 14:54:34     Message..... could not execute query
15 Aug 2013 14:54:34     Logged at... ViewDeviceGroupVul..932
15 Aug 2013 14:54:34 ============== Exception (end)
=============================
15 Aug 2013 14:54:34 ViewDeviceGroupVul..934 :Test 14
15 Aug 2013 14:54:34 ViewDeviceGroupVul..938 :Test 15
15 Aug 2013 14:54:34 ViewDeviceGroupVul..992 :Hibernate Search Result is Null..
Resetting the view with no data
15 Aug 2013 14:54:34 ViewDeviceGroupVul..940 :Test 16
To Duplicate:
  1. Click on Devices section on the main menu
  2. Click on Workstations link
  3. Click on a Dynamic Workstation Group that contains a number of devices over 1000, such as Windows 7 Workstations
  4. Click on the Patches tab to display the list of Patches applicable to this Workstation Group.