I posted about this error I had a while ago and finally decided to take
another shot at fixing it.

I get a error in ZCC when I go to Configuration page and the Configuration
tab. At the top of the screen I get Error: Query failed.:
com.novell.zenworks.datamodel.exceptions.ObjectNot FoundException:
/~credentials~
See the ZENworks Control Center log file (zcc.log) for the full stack
trace.

A fix was mentioned that the zZENObject table was missing a line. Can
someone tell me what is missing so I can add it.


Thanks,
Jim Koerner
ZCM 10.1.2 on Windows 2003 Server


Zcc.log shows the following

09 Jan 2009 15:49:28 MessageUtil..........85 :Error: Query failed.
09 Jan 2009 15:49:28 ============== Exception (begin)
===========================
09 Jan 2009 15:49:28 Exception occured
com.novell.zenworks.datamodel.exceptions.InternalD ataModelException:
com.novell.zenworks.datamodel.exceptions.ObjectNot FoundException:
/~credentials~
at
com.novell.zenworks.datamodel.services.BasicAdminI mpl.getRoot(BasicAdminImpl.java:64)
at
com.novell.zenworks.core.web.objects.DataModelView .getEffectiveRootFolderObject(DataModelView.java:2 90)
at
com.novell.zenworks.core.web.objects.DataModelView .createDataCollection(DataModelView.java:1483)
at
com.novell.zenworks.core.web.objects.DataModelView .performQuery(DataModelView.java:735)
at
com.novell.zenworks.fw.web.controls.DataGridView.p rerender(DataGridView.java:202)
at
com.novell.zenworks.core.web.objects.DataModelView .prerender(DataModelView.java:652)
at
com.novell.zenworks.common.web.internal.credential s.CredentialVaultSnapshot.prerender(CredentialVaul tSnapshot.java:422)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2626)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2637)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2637)
at
com.novell.zenworks.fw.web.internal.layout.Snapsho tTemplate.preRenderRecursiveInternal(SnapshotTempl ate.java:460)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2637)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2637)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2637)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2637)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2637)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2637)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2637)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2637)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2637)
at
com.novell.web.controls.WebControl.preRenderRecurs iveInternal(WebControl.java:2637)
at com.novell.web.controls.Page.internalProcessReques t(Page.java:598)
at com.novell.web.controls.Page.processRequest(Page.j ava:527)
at
com.novell.zenworks.fw.web.internal.layout.Index.p rocessRequest(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:176)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:328)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:315)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at
org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.ApplicationDispatcher.inv oke(ApplicationDispatcher.java:691)
at
org.apache.catalina.core.ApplicationDispatcher.pro cessRequest(ApplicationDispatcher.java:469)
at
org.apache.catalina.core.ApplicationDispatcher.doF orward(ApplicationDispatcher.java:364)
at
org.apache.catalina.core.ApplicationDispatcher.for ward(ApplicationDispatcher.java:301)
at com.novell.web.NJWCServlet.serviceImpl(NJWCServlet .java:97)
at
com.novell.zenworks.fw.web.internal.ZENworksServle t.service(ZENworksServlet.java:84)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at
org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at
com.patchlink.sapphire.web.pages.vulnerability.ses sion.HibernateSessionFilter.doFilter(HibernateSess ionFilter.java:75)
at
org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:174)
at
org.apache.catalina.authenticator.AuthenticatorBas e.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.invok e(StandardEngineValve.java:108)
at
com.novell.zenworks.tomcat.ZENRequestValve.invoke( ZENRequestValve.java:1122)
at
org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:870)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.novell.zenworks.datamodel.exceptions.ObjectNot FoundException:
/~credentials~
at
com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession.getBasicInformation(Hiberna teAbstractSession.java:863)
at
com.novell.zenworks.datamodel.session.hibernate.Hi bernateBasicSession.get(HibernateBasicSession.java :440)
at
com.novell.zenworks.datamodel.session.hibernate.Hi bernateBasicSession.get(HibernateBasicSession.java :392)
at
com.novell.zenworks.datamodel.services.BasicAdminI mpl.get(BasicAdminImpl.java:126)
at
com.novell.zenworks.datamodel.services.BasicAdminI mpl.getRoot(BasicAdminImpl.java:55)
... 59 more
09 Jan 2009 15:49:28

Exception Info:
09 Jan 2009 15:49:28 Class.......
com.novell.zenworks.datamodel.exceptions.InternalD ataModelException
09 Jan 2009 15:49:28 Message.....
com.novell.zenworks.datamodel.exceptions.ObjectNot FoundException:
/~credentials~
09 Jan 2009 15:49:28 Logged at... Messages............313
09 Jan 2009 15:49:28 ============== Exception (end)
=============================