Java exception in ZCC when clicking on Vulnerabilities tab

  • 7001694
  • 21-Oct-2008
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1 ZENworks Control Center - ZCC

Situation

ERROR: "org.hibernate.exception.SQLGrammarException: could not execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)"

Clicking on the Vulnerabilities tab in ZCC

Resolution

This is fixed in version 10.1.1 - see KB 7001406 "ZENworks 10 Configuration Management 10.1.1" which can be found at https://www.novell.com/support

Additional Information

Extract from zcc.log
Error Details:

org.hibernate.exception.SQLGrammarException: could not execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
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.hql.QueryLoader.list(QueryLoader.java:392)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1109)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at
com.patchlink.sapphire.datamodel.PatchManagementAdminService.hqlSearchWithTotalRowCount(PatchManagementAdminService.java:180)
at
com.patchlink.sapphire.web.pages.vulnerability.ViewVulnerabilitiesSnapshot.performSearchForNameOrCVN(ViewVulnerabilitiesSnapshot.java:557)
at
com.patchlink.sapphire.web.pages.vulnerability.ViewVulnerabilitiesSnapshot.bindGrid(ViewVulnerabilitiesSnapshot.java:180)
at
com.novell.zenworks.fw.web.layout.BaseDataGridSnapshot.onLoad(BaseDataGridSnapshot.java:75)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2423)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2429)
at
com.novell.zenworks.fw.web.internal.layout.SnapshotTemplate.loadRecursive(SnapshotTemplate.java:446)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2429)
at com.novell.web.controls.Page.internalProcessRequest(Page.java:572)
at com.novell.web.controls.Page.processRequest(Page.java:527)
at
com.novell.zenworks.fw.web.internal.layout.Index.processRequest(Index.java:479)
at com.novell.web.internal.controls.PageTag.doEndTag(PageTag.java:86)
at org.apache.jsp.jsp.index_jsp._jspService(index_jsp.java:175)
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:1122)
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: java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]Column
'status' not found
at ianywhere.ml.jdbcodbc.IConnection.nativePrepareStatement(Native
Method)
at
ianywhere.ml.jdbcodbc.IConnection.prepareStatement(IConnection.java:324)
at
com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:415)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)