Java exception in ZCC when clicking on Vulnerabilities tab

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

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

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)