Cannot get past dcm4chee login

[yukimi daifuku]

Dear dcm4che community. I need help please. dcm4chee has been working well for years for me but all of a sudden I cannot get past the login screen. it crashes with the following error. I tried restarting Apache, MySQL, updated Java, etc. and I have no other clue. Here is the message.

HTTP Status 500 -

type

Exception report

message

description

The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: EJBException:; nested exception is: javax.ejb.EJBException: java.sql.SQLException: give up executing SQL statement after all retries: SELECT org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

javax.servlet.ServletException: EJBException:; nested exception is: javax.ejb.EJBException: java.sql.SQLException: give up executing SQL statement after all retries: SELECT org.infohazard.maverick.ctl.Throwaway2.go(Throwaway2.java:51) org.infohazard.maverick.flow.ThrowawayControllerAdapter.go(ThrowawayControllerAdapter.java:54) org.infohazard.maverick.flow.CommandBase.go(CommandBase.java:66) org.infohazard.maverick.Dispatcher.service(Dispatcher.java:345) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:688) org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:658) org.apache.jsp.default_jsp._jspService(default_jsp.java:45) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

java.rmi.ServerException: EJBException:; nested exception is: javax.ejb.EJBException: java.sql.SQLException: give up executing SQL statement after all retries: SELECT org.jboss.ejb.plugins.LogInterceptor.handleException(LogInterceptor.java:365) org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:209) org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136) org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648) org.jboss.ejb.Container.invoke(Container.java:954) sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) org.jboss.mx.server.Invocation.invoke(Invocation.java:86) org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169) org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118) org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209) org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195) org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61) org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70) org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112) org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100) com.sun.proxy.$Proxy156.countStudies(Unknown Source) org.dcm4chex.archive.web.maverick.FolderSubmitCtrl.query(FolderSubmitCtrl.java:207) org.dcm4chex.archive.web.maverick.FolderSubmitCtrl.perform(FolderSubmitCtrl.java:150) org.dcm4chex.archive.web.maverick.Dcm4cheeFormController.go(Dcm4cheeFormController.java:118) org.infohazard.maverick.ctl.Throwaway2.go(Throwaway2.java:47) org.infohazard.maverick.flow.ThrowawayControllerAdapter.go(ThrowawayControllerAdapter.java:54) org.infohazard.maverick.flow.CommandBase.go(CommandBase.java:66) org.infohazard.maverick.Dispatcher.service(Dispatcher.java:345) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:688) org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:658) org.apache.jsp.default_jsp._jspService(default_jsp.java:45) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

root cause

root cause

1 sur 2

19/04/13 13:02Apache Tomcat/5.5.20 - Error report http://localhost:8080/dcm4chee-web/

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

Thank you in advance for any help on this.

Regards

Fabien

[yukimi daifuku]

Repaired all SQL tables. Connection successful.

Hope it helps someone.

Cheers

FB.