Device status for targeted and pending blank for MS SQL database setups

Document ID:7006325
Creation Date:22-Jun-2010
Modified Date:30-Apr-2012
- Micro Focus Products:
  ZENworks Configuration Management

Environment

Novell ZENworks 10 Configuration Management with Support Pack 3 - 10.3

Situation

Bundle status page for device assigned bundles, pending and targeted drill down show empty list in ZCC. This seems specific to MS SQL used for database.

ERROR (from zcc.log. see details for full error):

org.hibernate.exception.GenericJDBCException: could not execute query

Resolution

This is fixed in version 10.3.2 - see KB 7007237 "ZENworks Configuration Management 10.3.2 - update information and list of fixes" which can be found at https://www.novell.com/support

Workaround: if it is not possible to upgrade to 10.3.2 at this time, in the interim, Novell has made a Patch available for testing, in the form of a Field Test File (FTF): it can be obtained at https://download.novell.com/Download?buildid=2Wgh0yxLITo~ as "ZCM 10.3.1 Combined patch for Zone performance degrades (see KB 7006967), Allow Windows 7 SP1 device to register (see KB 7007952), ZCC bundle status takes a long time to display (see KB 7006325)". This Patch should only be applied if the symptoms above are being experienced, and are causing problems.

This Patch has had limited testing, and should not be used in a production system without first being checked in a test environment. Some Patches have specific requirements for deployment, it is very important to follow any instructions in the readme at the download site. Please report any problems encountered when using this Patch, by using the feedback link on this TID.

A fix for this issue is included in ZENworks 11, see KB 7006995 "ZENworks 11 - information and updates" which can be found at https://www.novell.com/support

Additional Information

Exception Info:
22 Jun 2010 11:00:08     Class.......
com.novell.zenworks.datamodel.exceptions.InternalDataModelException
22 Jun 2010 11:00:08     Message.....
org.hibernate.exception.GenericJDBCException: could not execute query
22 Jun 2010 11:00:08     Logged at... DeploymentStatus....727
22 Jun 2010 11:00:08 ============== Exception (end)
=============================
22 Jun 2010 11:02:38 ============== Exception (begin)
===========================
22 Jun 2010 11:02:38 Exception occured
com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
org.hibernate.exception.GenericJDBCException: could not execute query
    at
com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:436)
    at
com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:421)
    at
com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:177)
    at
com.novell.zenworks.datamodel.session.hibernate.HibernateAssignmentSession$AssignmentResultHelper.getAssignedDevices(HibernateAssignmentSession.java:1125)
    at
com.novell.zenworks.datamodel.session.hibernate.HibernateAssignmentSession$AssignmentResultHelper.getAssignedDevicesObjectInfo(HibernateAssignmentSession.java:1174)
    at
com.novell.zenworks.datamodel.session.hibernate.HibernateAssignmentSession$AssignmentResultHelper.access$000(HibernateAssignmentSession.java:875)
    at
com.novell.zenworks.datamodel.session.hibernate.HibernateAssignmentSession.getAssignedDevicesObjectInfo(HibernateAssignmentSession.java:236)
    at
com.novell.zenworks.datamodel.services.assignments.AssignmentImpl.getAssignedDevicesObjectInfo(AssignmentImpl.java:187)
    at
com.novell.zenworks.admin.pages.common.DeploymentStatus.getNormalListData(DeploymentStatus.java:698)
    at
com.novell.zenworks.admin.pages.common.DeploymentStatus.prerender(DeploymentStatus.java:348)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2626)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2637)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2637)
    at
com.novell.zenworks.fw.web.internal.layout.SnapshotTemplate.preRenderRecursiveInternal(SnapshotTemplate.java:460)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2637)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2637)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2637)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2637)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2637)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2637)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2637)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2637)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2637)
    at
com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2637)
    at com.novell.web.controls.Page.internalProcessRequest(Page.java:599)
    at com.novell.web.controls.Page.processRequest(Page.java:528)
    at
com.novell.zenworks.fw.web.internal.layout.Index.processRequest(Index.java:518)
    at com.novell.web.internal.controls.PageTag.doEndTag(PageTag.java:86)
    at org.apache.jsp.jsp.index_jsp._jspService(index_jsp.java:178)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
    at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
    at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:364)
    at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
    at com.novell.web.NJWCServlet.serviceImpl(NJWCServlet.java:97)
    at
com.novell.zenworks.fw.web.internal.ZENworksServlet.service(ZENworksServlet.java:84)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at
com.patchlink.sapphire.web.pages.vulnerability.session.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:75)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
    at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
    at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
    at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at
com.novell.zenworks.tomcat.ZENRequestValve.invoke(ZENRequestValve.java:1196)
    at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
    at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
    at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
    at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.exception.GenericJDBCException: could not execute
query
    at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
    at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
    at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.loader.Loader.doList(Loader.java:2148)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
    at org.hibernate.loader.Loader.list(Loader.java:2024)
    at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:118)
    at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1659)
    at
org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
    at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)
    at
com.novell.zenworks.datamodel.session.hibernate.HibernateAssignmentSession$AssignmentResultHelper.getAssignedDevices(HibernateAssignmentSession.java:1118)
    ... 59 more
Caused by: java.sql.SQLException: Incorrect syntax near '@P0'.
    at
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
    at
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
    at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
    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)
    ... 66 more
Caused by: java.sql.SQLException: Incorrect syntax near '@P1'.
    at
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)
    ... 74 more
22 Jun 2010 11:02:38

Exception Info:
22 Jun 2010 11:02:38     Class.......
com.novell.zenworks.datamodel.exceptions.InternalDataModelException
22 Jun 2010 11:02:38     Message.....
org.hibernate.exception.GenericJDBCException: could not execute query
22 Jun 2010 11:02:38     Logged at... DeploymentStatus....727
22 Jun 2010 11:02:38 ============== Exception (end)
=============================