Hi!
ZCM 10.2.2 on SLES 11 box.
Well, last evening I got ZCM server goes down. I mean, it did answer ping, but http monitor was down and today all ZCM services seems to be down also.
Only thing related to this in timely fashion was in ZCC log, please see below. When I restarted all ZCM service ... it come back, seems to.
Also, when I'd log via NX to server I saw in screen to BUG-boxes (well, never seen before). I'm not sure this is related to this issue in any way, but here it is (I couldn't find time the occurred):
--
A Fatal Error Occurred
The application Plasma Workspace (plasma) crashed and caused the signal 11 (SIGSEGV)
The application Konqueror (konqueror) crashed and caused the signal 11 (SIGSEGV)
--
Any ideas about this? I mean, mostly interested this in ZCC log below! This kind of server-down issues may cause many trouble as (I tried) no service available and no log in etc. on ws's! Too bad!
More thanks, Alar.

--- From ZCC log on server ---
25 Jan 2010 21:18:43 ============== Exception (begin) ===========================
25 Jan 2010 21:18:43 Exception occured
com.novell.zenworks.datamodel.exceptions.Connectio nException: org.hibernate.exception.GenericJDBCException: Cannot open connection
at com.novell.zenworks.datamodel.database.AbstractDat abaseTypeHelper.throwStandardDataModelException(Ab stractDatabaseTypeHelper.java:417)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.handleException(Abstrac tHibernateSessionImpl.java:177)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.simpleQuery(AbstractHib ernateSessionImpl.java:530)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateBasicSession.simpleQuery(HibernateBasicSess ion.java:1077)
at com.novell.zenworks.datamodel.utils.AdminImplUtil. getObjects(AdminImplUtil.java:251)
at com.novell.zenworks.datamodel.utils.AdminImplUtil. getObjects(AdminImplUtil.java:243)
at com.novell.zenworks.datamodel.services.quicktasks. QuickTasksAdminImpl.getAdminQuickTasks(QuickTasksA dminImpl.java:268)
at com.novell.zenworks.admin.pages.home.QuickTasksPlu gin.buildQuickTasks(QuickTasksPlugin.java:115)
at com.novell.zenworks.admin.pages.home.QuickTasksPlu gin.createChildControls(QuickTasksPlugin.java:102)
at com.novell.web.controls.WebControl.ensureChildCont rols(WebControl.java:1738)
at com.novell.zenworks.fw.web.layout.BasePlugin.onLoa d(BasePlugin.java:113)
at com.novell.zenworks.admin.pages.home.QuickTasksPlu gin.onLoad(QuickTasksPlugin.java:87)
at com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2423)
at com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at com.novell.web.controls.Page.internalProcessReques t(Page.java:573)
at com.novell.web.controls.Page.processRequest(Page.j ava:528)
at com.novell.web.internal.controls.PageTag.doEndTag( PageTag.java:86)
at org.apache.jsp.jsp.core.controls.AjaxPage_jsp._jsp x_meth_web_page_0(AjaxPage_jsp.java:85)
at org.apache.jsp.jsp.core.controls.AjaxPage_jsp._jsp Service(AjaxPage_jsp.java:56)
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 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:403)
at org.apache.catalina.core.ApplicationDispatcher.for ward(ApplicationDispatcher.java:301)
at com.novell.web.controls.AjaxPostBackHandler.servic e(AjaxPostBackHandler.java:39)
at com.novell.web.AjaxServlet.serviceImpl(AjaxServlet .java:95)
at com.novell.web.AjaxServlet.service(AjaxServlet.jav a:70)
at com.novell.zenworks.fw.web.internal.ZENworksAjaxSe rvlet.service(ZENworksAjaxServlet.java:47)
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:433)
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 com.novell.zenworks.tomcat.ZENRequestValve.invoke( ZENRequestValve.java:1122)
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: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledN onSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:420)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:118)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1294)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateSessionImpl.newTransaction(HibernateSession Impl.java:30)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.beginTransaction(Abstra ctHibernateSessionImpl.java:84)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.simpleQuery(AbstractHib ernateSessionImpl.java:496)
... 66 more
Caused by: java.sql.SQLException: Invalid ODBC handle
at ianywhere.ml.jdbcodbc.IConnection.getAutoCommit(Na tive Method)
at com.mchange.v2.c3p0.impl.NewProxyConnection.getAut oCommit(NewProxyConnection.java:985)
at org.hibernate.connection.C3P0ConnectionProvider.ge tConnection(C3P0ConnectionProvider.java:37)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:417)
... 73 more
25 Jan 2010 21:18:43

Exception Info:
25 Jan 2010 21:18:43 Class....... com.novell.zenworks.datamodel.exceptions.Connectio nException
25 Jan 2010 21:18:43 Message..... org.hibernate.exception.GenericJDBCException: Cannot open connection
25 Jan 2010 21:18:43 Logged at... QuickTasksPlugin....119
25 Jan 2010 21:18:43 ============== Exception (end) =============================