系统十几分钟不运行，就自动提示调用失败。

无可奈何花落去

系统是5.2.7 升级到3.3的。
之前系统运行是没问题的，今天就发现时间一长不动页面，就会报这个错误，但是不影响使用，点击确定按钮就消失了，
在数据库中执行报错的语句并不报错，也在平台搜了一下解决方案，有一个解决方案是在server.xml中添加： 报错图片是：
validationQuery="select  sysdate  from  dual;"  我添加了之后 问题还存在依然会报错。
这个是什么原因导致的？
控制台报错为：
  <action direct-execute="false" process="/dialog/popupRemind/process/timeRemind/timeRemindProcess" activity="timeRemindActivity" action-flag="__action_0__" executor="" execute-context="" name="countNowTaskAction">undefined</action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select d.fSJS,d.fSJLX from DI_DCTX d
--> sql: SELECT  d.FSJS AS fSJS, d.FSJLX AS fSJLX FROM DI_DCTX d
--> binds: []
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at PopupRemind.getTimeAndType(PopupRemind.java:22)
        at PopupRemind.countNowTask(PopupRemind.java:113)
        ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  d.FSJS AS fSJS, d.FSJLX AS fSJLX FROM DI_DCTX d, binds: []出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 32 more
Caused by: java.sql.SQLException: I/O Error: Read timed out
        at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1049)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:406)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 33 more
Caused by: java.net.SocketTimeoutException: Read timed out
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.read(SocketInputStream.java:152)
        at java.net.SocketInputStream.read(SocketInputStream.java:122)
        at java.io.DataInputStream.readFully(DataInputStream.java:195)
        at java.io.DataInputStream.readFully(DataInputStream.java:169)
        at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:826)
        at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:707)
        at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
        at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
        at net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:88)
        at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3870)
        at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1042)
        ... 37 more

jishuang

Caused by: java.sql.SQLException: I/O Error: Read timed out
        at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1049)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:406)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 33 more
Caused by: java.net.SocketTimeoutException: Read timed out
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.read(SocketInputStream.java:152)


数据库的问题，数据库连接超时了，可以到网上查找错误原因

无可奈何花落去

jishuang 发表于 2017-4-14 14:21
Caused by: java.sql.SQLException: I/O Error: Read timed out
        at net.sourceforge.jtds.jdbc.Tds ...

版主，我没有太懂还是新手，是应该改代码，还是改sqlserver的设置？能提供一下具体的解决方案么？系统之前好好的为什么会突然出现这个问题呢？

执行错误的代码块在下面这个位置：
/BIZ/dialog/popupRemind/logic/code/dsrc/PopupRemind.java

我真的不太懂为什么我的系统一段时间不用就会执行到这里，然后今天就报错了。。。

jishuang

这个错误是数据库抛出来的，到网上才查找可能的原因啊

无可奈何花落去

jishuang 发表于 2017-4-14 14:47
这个错误是数据库抛出来的，到网上才查找可能的原因啊

好，谢谢，那有可能是切换了使用别人的数据库导致的。