Environment
Novell ZENworks Configuration Management 11.2.2 Patch Management
Novell ZENworks Configuration Management 11.2.3a Patch Management
Novell ZENworks Patch Management 11.2.2
Novell ZENworks Patch Management 11.2.3a
Novell ZENworks Configuration Management 11.2.3a Patch Management
Novell ZENworks Patch Management 11.2.2
Novell ZENworks Patch Management 11.2.3a
Situation
Zone using Oracle database
accessing Patch Management page, get Error: "java.lang.NullPointerException"
zcc.log shows
17 May 2013 15:40:45 ============== Exception (begin) ===========================
17 May 2013 15:40:45 Exception occured
com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters: [] [select ErrorWarningStatus from ZENObject where UID=?]
at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:458)
at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:443)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:177)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleGetByQuery(AbstractHibernateSessionImpl.java:318)
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession.simpleGetByQuery(HibernateBasicSession.java:1073)
at com.novell.zenworks.datamodel.services.messaging.MessagingImpl.getStatus(MessagingImpl.java:1060)
at com.novell.zenworks.common.web.messages.EventLog.getTitleIcon(EventLog.java:600)
at com.novell.zenworks.fw.web.internal.layout.PluginTemplate.loadContent(PluginTemplate.java:320)
at com.novell.zenworks.fw.web.internal.layout.SnapshotTemplate.loadContent(SnapshotTemplate.java:84)
at com.novell.zenworks.fw.web.internal.layout.PluginTemplate.onLoad(PluginTemplate.java:130)
at com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2423)
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:712)
at com.novell.web.controls.Page.processRequest(Page.java:667)
at com.novell.zenworks.fw.web.internal.layout.Index.processRequest(Index.java:631)
at com.novell.web.internal.controls.PageTag.doEndTag(PageTag.java:86)
at org.apache.jsp.jsp.index_jsp._jspService(index_jsp.java:186)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:342)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
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:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.patchlink.sapphire.web.pages.vulnerability.session.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at com.novell.zenworks.tomcat.ZENRequestValve.invoke(ZENRequestValve.java:1293)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at 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: org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters: [] [select ErrorWarningStatus from ZENObject where UID=?]
at org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:319)
at org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:275)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:75)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:756)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleGetByQuery(AbstractHibernateSessionImpl.java:306)
... 55 more
accessing Patch Management page, get Error: "java.lang.NullPointerException"
zcc.log shows
17 May 2013 15:40:45 ============== Exception (begin) ===========================
17 May 2013 15:40:45 Exception occured
com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters: [] [select ErrorWarningStatus from ZENObject where UID=?]
at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:458)
at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:443)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:177)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleGetByQuery(AbstractHibernateSessionImpl.java:318)
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession.simpleGetByQuery(HibernateBasicSession.java:1073)
at com.novell.zenworks.datamodel.services.messaging.MessagingImpl.getStatus(MessagingImpl.java:1060)
at com.novell.zenworks.common.web.messages.EventLog.getTitleIcon(EventLog.java:600)
at com.novell.zenworks.fw.web.internal.layout.PluginTemplate.loadContent(PluginTemplate.java:320)
at com.novell.zenworks.fw.web.internal.layout.SnapshotTemplate.loadContent(SnapshotTemplate.java:84)
at com.novell.zenworks.fw.web.internal.layout.PluginTemplate.onLoad(PluginTemplate.java:130)
at com.novell.web.controls.WebControl.loadRecursive(WebControl.java:2423)
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:712)
at com.novell.web.controls.Page.processRequest(Page.java:667)
at com.novell.zenworks.fw.web.internal.layout.Index.processRequest(Index.java:631)
at com.novell.web.internal.controls.PageTag.doEndTag(PageTag.java:86)
at org.apache.jsp.jsp.index_jsp._jspService(index_jsp.java:186)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:342)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
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:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.patchlink.sapphire.web.pages.vulnerability.session.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at com.novell.zenworks.tomcat.ZENRequestValve.invoke(ZENRequestValve.java:1293)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at 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: org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters: [] [select ErrorWarningStatus from ZENObject where UID=?]
at org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:319)
at org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:275)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:75)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:756)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleGetByQuery(AbstractHibernateSessionImpl.java:306)
... 55 more
Resolution
This is fixed in version 11.2.4 - see KB 7012027 "ZENworks Configuration Management 11.2.4 - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7012027