Novell Home

My Favorites

Close

Please to see your favorites.

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

This document (7012449) is provided subject to the disclaimer at the end of this document.

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 TID 7012027 "ZENworks Configuration Management 11.2.4 - update information and list of fixes" which can be found at http://www.novell.com/support/search.do?usemicrosite=true&searchString=7012027

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7012449
  • Creation Date:21-MAY-13
  • Modified Date:28-OCT-13
    • NovellZENworks Configuration Management
      ZENworks Patch Management

Did this document solve your problem? Provide Feedback