Error: "java.lang.NullPointerException" accessing Patch Management page in ZCC

  • 7012449
  • 21-May-2013
  • 28-Oct-2013

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

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


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