远程设计连接发生未知错误
服务器tomcat重启之后出现这个问题,前端数据决策系统虽然能打开,但是报表预览会报错,远程设计器无法连接。
错误堆栈如下:
com.fr.workspace.engine.exception.RemoteDesignUnknownException: java.lang.RuntimeException: com.fr.third.org.hibernate.exception.GenericJDBCException: could not execute query
at com.fr.workspace.engine.convert.UnknownErrorConverter.convert(UnknownErrorConverter.java)
at com.fr.workspace.engine.convert.UnknownErrorConverter.convert(UnknownErrorConverter.java)
at com.fr.workspace.engine.convert.ExceptionConverter.convert(ExceptionConverter.java)
at com.fr.env.handler.impl.UnexpectedHandler.handle(Unknown Source)
at com.fr.env.handler.impl.UnexpectedHandler.handle(Unknown Source)
at com.fr.env.handler.WorkspaceExceptionHandler.handle(Unknown Source)
at com.fr.env.handler.WorkspaceExceptionHandler.handleInSwitch(Unknown Source)
at com.fr.design.EnvChangeEntrance.switch2Env(Unknown Source)
at com.fr.design.EnvChangeEntrance.envListOkAction(Unknown Source)
at com.fr.design.EnvChangeEntrance.access$200(Unknown Source)
at com.fr.design.EnvChangeEntrance$4.doOk(Unknown Source)
at com.fr.design.dialog.UIDialog.doOK(Unknown Source)
at com.fr.design.dialog.UIDialog$3.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6539)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6304)
at java.awt.Container.processEvent(Container.java:2239)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2297)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
at java.awt.Container.dispatchEventImpl(Container.java:2283)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
at java.awt.EventQueue$4.run(EventQueue.java:733)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:190)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:235)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:233)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:233)
at java.awt.Dialog.show(Dialog.java:1084)
at java.awt.Component.show(Component.java:1671)
at java.awt.Component.setVisible(Component.java:1623)
at java.awt.Window.setVisible(Window.java:1014)
at java.awt.Dialog.setVisible(Dialog.java:1005)
at com.fr.design.EnvChangeEntrance.chooseEnv(Unknown Source)
at com.fr.design.actions.file.SwitchExistEnv$GetExistEnvAction.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:842)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:886)
at java.awt.Component.processMouseEvent(Component.java:6539)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6304)
at java.awt.Container.processEvent(Container.java:2239)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2297)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
at java.awt.Container.dispatchEventImpl(Container.java:2283)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
at java.awt.EventQueue$4.run(EventQueue.java:733)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: java.lang.RuntimeException: com.fr.third.org.hibernate.exception.GenericJDBCException: could not execute query
at com.fr.config.dao.impl.HibernateXmlEnityDao$3.doInServer(HibernateXmlEnityDao.java)
at com.fr.config.dao.impl.HibernateXmlEnityDao$3.doInServer(HibernateXmlEnityDao.java)
at com.fr.config.dao.HibernateTemplate.doQuery(HibernateTemplate.java)
at com.fr.config.dao.impl.HibernateXmlEnityDao.find(HibernateXmlEnityDao.java)
at com.fr.config.dao.impl.BatchSubmitXmlEntityDao.find(BatchSubmitXmlEntityDao.java)
at com.fr.config.server.transport.XmlEntityType.fetch(XmlEntityType.java)
at com.fr.config.server.ServerDataFetcher.getConfig(ServerDataFetcher.java)
at sun.reflect.GeneratedMethodAccessor391.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.fr.workspace.engine.rpc.WorkspaceServerInvoker.handleMessage(WorkspaceServerInvoker.java)
at com.fr.workspace.WorkContext.handleMessage(WorkContext.java)
at com.fr.decision.webservice.v10.remote.RemoteDesignService.onMessage(Unknown Source)
at com.fr.decision.extension.report.api.remote.RemoteDesignResource.onMessage(Unknown Source)
at sun.reflect.GeneratedMethodAccessor388.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at com.fr.third.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854)
at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765)
at com.fr.third.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at com.fr.third.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
at com.fr.third.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
at com.fr.third.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at com.fr.third.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:515)
at com.fr.third.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:583)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:212)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
at com.fr.decision.webservice.BackupActivator$1.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
at com.fr.decision.webservice.filter.TenantFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
at com.fr.decision.base.DecisionServletInitializer$6.doFilterInternal(Unknown Source)
at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
at com.fr.decision.base.DecisionServletInitializer$4.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
at com.fr.third.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:679)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:617)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:934)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1698)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.fr.third.org.hibernate.exception.GenericJDBCException: could not execute query
at com.fr.third.org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at com.fr.third.org.hibernate.loader.Loader.doList(Loader.java:2625)
at com.fr.third.org.hibernate.loader.Loader.doList(Loader.java:2605)
at com.fr.third.org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2434)
at com.fr.third.org.hibernate.loader.Loader.list(Loader.java:2429)
at com.fr.third.org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
at com.fr.third.org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
at com.fr.third.org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
at com.fr.third.org.hibernate.internal.SessionImpl.list(SessionImpl.java:1338)
at com.fr.third.org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
... 69 more
Caused by: java.sql.SQLException: Error
at com.fr.third.alibaba.druid.pool.DruidDataSource.handleConnectionException(DruidDataSource.java:1391)
at com.fr.third.alibaba.druid.pool.DruidPooledConnection.handleException(DruidPooledConnection.java:132)
at com.fr.third.alibaba.druid.pool.DruidPooledStatement.checkException(DruidPooledStatement.java:65)
at com.fr.third.alibaba.druid.pool.DruidPooledResultSet.checkException(DruidPooledResultSet.java:55)
at com.fr.third.alibaba.druid.pool.DruidPooledResultSet.getBytes(DruidPooledResultSet.java:341)
at com.fr.third.org.hibernate.type.descriptor.sql.VarbinaryTypeDescriptor$2.doExtract(VarbinaryTypeDescriptor.java:60)
at com.fr.third.org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:47)
at com.fr.third.org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:235)
at com.fr.third.org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:231)
at com.fr.third.org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:222)
at com.fr.third.org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:296)
at com.fr.third.org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2838)
at com.fr.third.org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1735)
at com.fr.third.org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1661)
at com.fr.third.org.hibernate.loader.Loader.getRow(Loader.java:1550)
at com.fr.third.org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:733)
at com.fr.third.org.hibernate.loader.Loader.processResultSet(Loader.java:978)
at com.fr.third.org.hibernate.loader.Loader.doQuery(Loader.java:936)
at com.fr.third.org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:342)
at com.fr.third.org.hibernate.loader.Loader.doList(Loader.java:2622)
... 77 more
Caused by: com.fr.third.org.hsqldb.HsqlException: file input/output error
at com.fr.third.org.hsqldb.error.Error.error(Error.java:291)
at com.fr.third.org.hsqldb.types.BlobDataID.getBytes(BlobDataID.java:95)
at com.fr.third.org.hsqldb.jdbc.JDBCResultSet.getBytes(JDBCResultSet.java:797)
at com.fr.third.org.hsqldb.jdbc.JDBCResultSet.getBytes(JDBCResultSet.java:1259)
at com.fr.third.alibaba.druid.pool.DruidPooledResultSet.getBytes(DruidPooledResultSet.java:339)
... 92 more