Environment is 10.3, running two primaries on Win2003 Server and
database on an MS SQL 2005 cluster. Updated to 10.3 a couple weeks back
and everything was looking good. ZCC was faster than ever and agents
seem more reliable too.

However, within the last few days the ZCC has slowed to a crawl and is
almost unusable. Restarting all the services gets things moving again
briefly, but that doesn't last long. I'm in need of some database
maintenance which will happen this weekend, but the fact that restarting
the primary helps makes me wonder if it's the DB at all.

I keep seeing the following error in the ZCC.LOG. This same error was
reported by rdseepaul with 10.1.3 (here: http://bit.ly/d1g9Zo) but it
seems no one ever gave him or her an answer. Anyone have any ideas for me?

> 21 Apr 2010 17:06:31 ============== Exception (begin) ===========================
> 21 Apr 2010 17:06:31 Exception occured
> com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: com.novell.zenworks.datamodel.exceptions.DataModel UsageException: You are not logged in.
> at com.novell.zenworks.datamodel.services.DirectServi ceStoreImpl.getService(DirectServiceStoreImpl.java :325)
> at com.novell.zenworks.core.web.util.UserUtil.getUser AdminService(UserUtil.java:65)
> at com.novell.zenworks.core.web.internal.pages.users. UserSourceList.bindStatusImage(UserSourceList.java :132)
> at sun.reflect.GeneratedMethodAccessor981.invoke(Unkn own Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:592)
> at com.novell.web.controls.WebControl.fireEvent(WebCo ntrol.java:1977)
> at com.novell.web.controls.WebControl.onDataBinding(W ebControl.java:2596)
> at com.novell.web.controls.DataGrid.createTableRows(D ataGrid.java:1445)
> at com.novell.web.controls.DataGrid.createChildContro lsImpl(DataGrid.java:671)
> at com.novell.web.controls.DataGrid.createChildContro ls(DataGrid.java:512)
> at com.novell.web.controls.WebControl.ensureChildCont rols(WebControl.java:1738)
> at com.novell.web.controls.WebControl.findControl(Web Control.java:1641)
> at com.novell.web.controls.WebControl.findControl(Web Control.java:1685)
> at com.novell.web.controls.WebControl.findControl(Web Control.java:1685)
> at com.novell.web.controls.WebControl.findControl(Web Control.java:1685)
> at com.novell.web.controls.WebControl.findControl(Web Control.java:1618)
> at com.novell.web.controls.Page.raisePostBackEvents(P age.java:832)
> at com.novell.web.controls.Page.internalProcessReques t(Page.java:584)
> at com.novell.web.controls.Page.processRequest(Page.j ava:528)
> at com.novell.zenworks.fw.web.internal.layout.Index.p rocessRequest(Index.java:518)
> at com.novell.web.internal.controls.PageTag.doEndTag( PageTag.java:86)
> at org.apache.jsp.jsp.index_jsp._jspService(index_jsp .java:178)
> 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:1196)
> 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.DataModel UsageException: You are not logged in.
> at com.novell.zenworks.datamodel.services.DirectServi ceStoreImpl.newService(DirectServiceStoreImpl.java :274)
> at com.novell.zenworks.datamodel.services.DirectServi ceStoreImpl.newService(DirectServiceStoreImpl.java :267)
> at com.novell.zenworks.datamodel.services.DirectServi ceStoreImpl.getService(DirectServiceStoreImpl.java :321)
> ... 56 more
> 21 Apr 2010 17:06:31
>
> Exception Info:
> 21 Apr 2010 17:06:31 Class....... com.novell.zenworks.datamodel.exceptions.InternalD ataModelException
> 21 Apr 2010 17:06:31 Message..... com.novell.zenworks.datamodel.exceptions.DataModel UsageException: You are not logged in.
> 21 Apr 2010 17:06:31 Logged at... UserUtil.............69
> 21 Apr 2010 17:06:31 ============== Exception (end) =============================