服务器迁移云平台后报错

yiya42538757

原平台没有问题，迁移云平台后出现报错。

各系统运行过程中，经常会出现报错，关闭后再次运行又没有问题，有时重新运行一次即可，有时需2-3次。

错误出现时机不定，即便同一功能同一任务打开的时候也是有时出现有时不出现。
报错例子如下：
        ... 25 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  TT_WSXXFBSQB.VERSION AS version, TT_WSXXFBSQB.FSQDW AS fSQDW, TT_WSXXFBSQB.FFBSQBT AS fFBSQBT, TT_WSXXFBSQB.FSQSJ AS fSQSJ, TT_WSXXFBSQB.FXXZYXMJNRJJ AS fXXZYXMJNRJJ, TT_WSXXFBSQB.FFBLM AS fFBLM, TT_WSXXFBSQB.FXXZZRY AS fXXZZRY, TT_WSXXFBSQB.FSQBMLDSHYJ AS fSQBMLDSHYJ, TT_WSXXFBSQB.FSQBMLDSHSJ AS fSQBMLDSHSJ, TT_WSXXFBSQB.FSQBMLDSHXM AS fSQBMLDSHXM, TT_WSXXFBSQB.FXCBSHYJ AS fXCBSHYJ, TT_WSXXFBSQB.FXCBSHSJ AS fXCBSHSJ, TT_WSXXFBSQB.FXCBMLDXM AS fXCBMLDXM, TT_WSXXFBSQB.FXXZXLDSHYJ AS fXXZXLDSHYJ, TT_WSXXFBSQB.FXXZXLDSHSJ AS fXXZXLDSHSJ, TT_WSXXFBSQB.FXXZXLDXM AS fXXZXLDXM, TT_WSXXFBSQB.FXXWHJGXSJ AS fXXWHJGXSJ, TT_WSXXFBSQB.FXXWHRYXM AS fXXWHRYXM, TT_WSXXFBSQB.FFJ AS fFJ, TT_WSXXFBSQB.fID AS TT_WSXXFBSQB FROM TT_WSXXFBSQB TT_WSXXFBSQB  WHERE TT_WSXXFBSQB.fID = ?, binds: [C10F2F2AD37F4AF5880964988C88C4BE]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 30 more
Caused by: java.sql.SQLException: Io 异常: Connection reset by peer: socket write error
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:812)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
        at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 31 more


请问以上报错是哪方面原因引起的？

yiya42538757

这是下面详细内容：


编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT TT_WSXXFBSQB.* FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE ((TT_WSXXFBSQB='CB3561C808A34D03BE891735B254D0BA')) LIMIT 0, 20
--> sql: SELECT TT_WSXXFBSQB.VERSION AS version, TT_WSXXFBSQB.FSQDW AS fSQDW, TT_WSXXFBSQB.FFBSQBT AS fFBSQBT, TT_WSXXFBSQB.FSQSJ AS fSQSJ, TT_WSXXFBSQB.FXXZYXMJNRJJ AS fXXZYXMJNRJJ, TT_WSXXFBSQB.FFBLM AS fFBLM, TT_WSXXFBSQB.FXXZZRY AS fXXZZRY, TT_WSXXFBSQB.FSQBMLDSHYJ AS fSQBMLDSHYJ, TT_WSXXFBSQB.FSQBMLDSHSJ AS fSQBMLDSHSJ, TT_WSXXFBSQB.FSQBMLDSHXM AS fSQBMLDSHXM, TT_WSXXFBSQB.FXCBSHYJ AS fXCBSHYJ, TT_WSXXFBSQB.FXCBSHSJ AS fXCBSHSJ, TT_WSXXFBSQB.FXCBMLDXM AS fXCBMLDXM, TT_WSXXFBSQB.FXXZXLDSHYJ AS fXXZXLDSHYJ, TT_WSXXFBSQB.FXXZXLDSHSJ AS fXXZXLDSHSJ, TT_WSXXFBSQB.FXXZXLDXM AS fXXZXLDXM, TT_WSXXFBSQB.FXXWHJGXSJ AS fXXWHJGXSJ, TT_WSXXFBSQB.FXXWHRYXM AS fXXWHRYXM, TT_WSXXFBSQB.FFJ AS fFJ, TT_WSXXFBSQB.fID AS TT_WSXXFBSQB FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE TT_WSXXFBSQB.fID = ?
--> binds: [CB3561C808A34D03BE891735B254D0BA]
编码: JUSTEP150039; 提示: 执行sql: SELECT TT_WSXXFBSQB.VERSION AS version, TT_WSXXFBSQB.FSQDW AS fSQDW, TT_WSXXFBSQB.FFBSQBT AS fFBSQBT, TT_WSXXFBSQB.FSQSJ AS fSQSJ, TT_WSXXFBSQB.FXXZYXMJNRJJ AS fXXZYXMJNRJJ, TT_WSXXFBSQB.FFBLM AS fFBLM, TT_WSXXFBSQB.FXXZZRY AS fXXZZRY, TT_WSXXFBSQB.FSQBMLDSHYJ AS fSQBMLDSHYJ, TT_WSXXFBSQB.FSQBMLDSHSJ AS fSQBMLDSHSJ, TT_WSXXFBSQB.FSQBMLDSHXM AS fSQBMLDSHXM, TT_WSXXFBSQB.FXCBSHYJ AS fXCBSHYJ, TT_WSXXFBSQB.FXCBSHSJ AS fXCBSHSJ, TT_WSXXFBSQB.FXCBMLDXM AS fXCBMLDXM, TT_WSXXFBSQB.FXXZXLDSHYJ AS fXXZXLDSHYJ, TT_WSXXFBSQB.FXXZXLDSHSJ AS fXXZXLDSHSJ, TT_WSXXFBSQB.FXXZXLDXM AS fXXZXLDXM, TT_WSXXFBSQB.FXXWHJGXSJ AS fXXWHJGXSJ, TT_WSXXFBSQB.FXXWHRYXM AS fXXWHRYXM, TT_WSXXFBSQB.FFJ AS fFJ, TT_WSXXFBSQB.fID AS TT_WSXXFBSQB FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE TT_WSXXFBSQB.fID = ?, binds: [CB3561C808A34D03BE891735B254D0BA]出错
Io 异常: Connection reset by peer: socket write error

java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor275.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
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.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:662)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT TT_WSXXFBSQB.* FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE ((TT_WSXXFBSQB='CB3561C808A34D03BE891735B254D0BA')) LIMIT 0, 20
--> sql: SELECT TT_WSXXFBSQB.VERSION AS version, TT_WSXXFBSQB.FSQDW AS fSQDW, TT_WSXXFBSQB.FFBSQBT AS fFBSQBT, TT_WSXXFBSQB.FSQSJ AS fSQSJ, TT_WSXXFBSQB.FXXZYXMJNRJJ AS fXXZYXMJNRJJ, TT_WSXXFBSQB.FFBLM AS fFBLM, TT_WSXXFBSQB.FXXZZRY AS fXXZZRY, TT_WSXXFBSQB.FSQBMLDSHYJ AS fSQBMLDSHYJ, TT_WSXXFBSQB.FSQBMLDSHSJ AS fSQBMLDSHSJ, TT_WSXXFBSQB.FSQBMLDSHXM AS fSQBMLDSHXM, TT_WSXXFBSQB.FXCBSHYJ AS fXCBSHYJ, TT_WSXXFBSQB.FXCBSHSJ AS fXCBSHSJ, TT_WSXXFBSQB.FXCBMLDXM AS fXCBMLDXM, TT_WSXXFBSQB.FXXZXLDSHYJ AS fXXZXLDSHYJ, TT_WSXXFBSQB.FXXZXLDSHSJ AS fXXZXLDSHSJ, TT_WSXXFBSQB.FXXZXLDXM AS fXXZXLDXM, TT_WSXXFBSQB.FXXWHJGXSJ AS fXXWHJGXSJ, TT_WSXXFBSQB.FXXWHRYXM AS fXXWHRYXM, TT_WSXXFBSQB.FFJ AS fFJ, TT_WSXXFBSQB.fID AS TT_WSXXFBSQB FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE TT_WSXXFBSQB.fID = ?
--> binds: [CB3561C808A34D03BE891735B254D0BA]
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.BizData.query(Unknown Source)
at BizProcedure.query(BizProcedure.java:137)
... 25 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT TT_WSXXFBSQB.VERSION AS version, TT_WSXXFBSQB.FSQDW AS fSQDW, TT_WSXXFBSQB.FFBSQBT AS fFBSQBT, TT_WSXXFBSQB.FSQSJ AS fSQSJ, TT_WSXXFBSQB.FXXZYXMJNRJJ AS fXXZYXMJNRJJ, TT_WSXXFBSQB.FFBLM AS fFBLM, TT_WSXXFBSQB.FXXZZRY AS fXXZZRY, TT_WSXXFBSQB.FSQBMLDSHYJ AS fSQBMLDSHYJ, TT_WSXXFBSQB.FSQBMLDSHSJ AS fSQBMLDSHSJ, TT_WSXXFBSQB.FSQBMLDSHXM AS fSQBMLDSHXM, TT_WSXXFBSQB.FXCBSHYJ AS fXCBSHYJ, TT_WSXXFBSQB.FXCBSHSJ AS fXCBSHSJ, TT_WSXXFBSQB.FXCBMLDXM AS fXCBMLDXM, TT_WSXXFBSQB.FXXZXLDSHYJ AS fXXZXLDSHYJ, TT_WSXXFBSQB.FXXZXLDSHSJ AS fXXZXLDSHSJ, TT_WSXXFBSQB.FXXZXLDXM AS fXXZXLDXM, TT_WSXXFBSQB.FXXWHJGXSJ AS fXXWHJGXSJ, TT_WSXXFBSQB.FXXWHRYXM AS fXXWHRYXM, TT_WSXXFBSQB.FFJ AS fFJ, TT_WSXXFBSQB.fID AS TT_WSXXFBSQB FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE TT_WSXXFBSQB.fID = ?, binds: [CB3561C808A34D03BE891735B254D0BA]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 30 more
Caused by: java.sql.SQLException: Io 异常: Connection reset by peer: socket write error
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:812)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 31 more

yiya42538757

yiya42538757 发表于 2018-10-23 10:40
这是下面详细内容：

url:/UI/system/service/common/bizAction.j
param:020Error: {"message":"执行KSQL出错, KSQL: SELECT TT_WSXXFBSQB.* FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE ((TT_WSXXFBSQB='CB3561C808A34D03BE891735B254D0BA')) LIMIT 0, 20\n --> sql: SELECT TT_WSXXFBSQB.VERSION AS version, TT_WSXXFBSQB.FSQDW AS fSQDW, TT_WSXXFBSQB.FFBSQBT AS fFBSQBT, TT_WSXXFBSQB.FSQSJ AS fSQSJ, TT_WSXXFBSQB.FXXZYXMJNRJJ AS fXXZYXMJNRJJ, TT_WSXXFBSQB.FFBLM AS fFBLM, TT_WSXXFBSQB.FXXZZRY AS fXXZZRY, TT_WSXXFBSQB.FSQBMLDSHYJ AS fSQBMLDSHYJ, TT_WSXXFBSQB.FSQBMLDSHSJ AS fSQBMLDSHSJ, TT_WSXXFBSQB.FSQBMLDSHXM AS fSQBMLDSHXM, TT_WSXXFBSQB.FXCBSHYJ AS fXCBSHYJ, TT_WSXXFBSQB.FXCBSHSJ AS fXCBSHSJ, TT_WSXXFBSQB.FXCBMLDXM AS fXCBMLDXM, TT_WSXXFBSQB.FXXZXLDSHYJ AS fXXZXLDSHYJ, TT_WSXXFBSQB.FXXZXLDSHSJ AS fXXZXLDSHSJ, TT_WSXXFBSQB.FXXZXLDXM AS fXXZXLDXM, TT_WSXXFBSQB.FXXWHJGXSJ AS fXXWHJGXSJ, TT_WSXXFBSQB.FXXWHRYXM AS fXXWHRYXM, TT_WSXXFBSQB.FFJ AS fFJ, TT_WSXXFBSQB.fID AS TT_WSXXFBSQB FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE TT_WSXXFBSQB.fID = ?\n --> binds: [CB3561C808A34D03BE891735B254D0BA],刷新数据失败！ ","reason":null,"code":"JUSTEP150210","stack":"java.lang.reflect.InvocationTargetException\n\tat sun.reflect.GeneratedMethodAccessor275.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n\tat java.lang.reflect.Method.invoke(Method.java:597)\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\n\tat java.lang.Thread.run(Thread.java:662)\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT TT_WSXXFBSQB.* FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE ((TT_WSXXFBSQB='CB3561C808A34D03BE891735B254D0BA')) LIMIT 0, 20\n --> sql: SELECT TT_WSXXFBSQB.VERSION AS version, TT_WSXXFBSQB.FSQDW AS fSQDW, TT_WSXXFBSQB.FFBSQBT AS fFBSQBT, TT_WSXXFBSQB.FSQSJ AS fSQSJ, TT_WSXXFBSQB.FXXZYXMJNRJJ AS fXXZYXMJNRJJ, TT_WSXXFBSQB.FFBLM AS fFBLM, TT_WSXXFBSQB.FXXZZRY AS fXXZZRY, TT_WSXXFBSQB.FSQBMLDSHYJ AS fSQBMLDSHYJ, TT_WSXXFBSQB.FSQBMLDSHSJ AS fSQBMLDSHSJ, TT_WSXXFBSQB.FSQBMLDSHXM AS fSQBMLDSHXM, TT_WSXXFBSQB.FXCBSHYJ AS fXCBSHYJ, TT_WSXXFBSQB.FXCBSHSJ AS fXCBSHSJ, TT_WSXXFBSQB.FXCBMLDXM AS fXCBMLDXM, TT_WSXXFBSQB.FXXZXLDSHYJ AS fXXZXLDSHYJ, TT_WSXXFBSQB.FXXZXLDSHSJ AS fXXZXLDSHSJ, TT_WSXXFBSQB.FXXZXLDXM AS fXXZXLDXM, TT_WSXXFBSQB.FXXWHJGXSJ AS fXXWHJGXSJ, TT_WSXXFBSQB.FXXWHRYXM AS fXXWHRYXM, TT_WSXXFBSQB.FFJ AS fFJ, TT_WSXXFBSQB.fID AS TT_WSXXFBSQB FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE TT_WSXXFBSQB.fID = ?\n --> binds: [CB3561C808A34D03BE891735B254D0BA]\n\tat com.justep.exception.BusinessException.create(Unknown Source)\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\n\tat com.justep.system.data.BizData.query(Unknown Source)\n\tat BizProcedure.query(BizProcedure.java:137)\n\t... 25 more\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT TT_WSXXFBSQB.VERSION AS version, TT_WSXXFBSQB.FSQDW AS fSQDW, TT_WSXXFBSQB.FFBSQBT AS fFBSQBT, TT_WSXXFBSQB.FSQSJ AS fSQSJ, TT_WSXXFBSQB.FXXZYXMJNRJJ AS fXXZYXMJNRJJ, TT_WSXXFBSQB.FFBLM AS fFBLM, TT_WSXXFBSQB.FXXZZRY AS fXXZZRY, TT_WSXXFBSQB.FSQBMLDSHYJ AS fSQBMLDSHYJ, TT_WSXXFBSQB.FSQBMLDSHSJ AS fSQBMLDSHSJ, TT_WSXXFBSQB.FSQBMLDSHXM AS fSQBMLDSHXM, TT_WSXXFBSQB.FXCBSHYJ AS fXCBSHYJ, TT_WSXXFBSQB.FXCBSHSJ AS fXCBSHSJ, TT_WSXXFBSQB.FXCBMLDXM AS fXCBMLDXM, TT_WSXXFBSQB.FXXZXLDSHYJ AS fXXZXLDSHYJ, TT_WSXXFBSQB.FXXZXLDSHSJ AS fXXZXLDSHSJ, TT_WSXXFBSQB.FXXZXLDXM AS fXXZXLDXM, TT_WSXXFBSQB.FXXWHJGXSJ AS fXXWHJGXSJ, TT_WSXXFBSQB.FXXWHRYXM AS fXXWHRYXM, TT_WSXXFBSQB.FFJ AS fFJ, TT_WSXXFBSQB.fID AS TT_WSXXFBSQB FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE TT_WSXXFBSQB.fID = ?, binds: [CB3561C808A34D03BE891735B254D0BA]出错\n\tat com.justep.exception.BusinessException.create(Unknown Source)\n\tat com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)\n\t... 30 more\nCaused by: java.sql.SQLException: Io 异常: Connection reset by peer: socket write error\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)\n\tat oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:812)\n\tat oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)\n\tat oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)\n\tat oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)\n\t... 31 more\n","messages":["编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT TT_WSXXFBSQB.* FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE ((TT_WSXXFBSQB='CB3561C808A34D03BE891735B254D0BA')) LIMIT 0, 20\r\n --> sql: SELECT TT_WSXXFBSQB.VERSION AS version, TT_WSXXFBSQB.FSQDW AS fSQDW, TT_WSXXFBSQB.FFBSQBT AS fFBSQBT, TT_WSXXFBSQB.FSQSJ AS fSQSJ, TT_WSXXFBSQB.FXXZYXMJNRJJ AS fXXZYXMJNRJJ, TT_WSXXFBSQB.FFBLM AS fFBLM, TT_WSXXFBSQB.FXXZZRY AS fXXZZRY, TT_WSXXFBSQB.FSQBMLDSHYJ AS fSQBMLDSHYJ, TT_WSXXFBSQB.FSQBMLDSHSJ AS fSQBMLDSHSJ, TT_WSXXFBSQB.FSQBMLDSHXM AS fSQBMLDSHXM, TT_WSXXFBSQB.FXCBSHYJ AS fXCBSHYJ, TT_WSXXFBSQB.FXCBSHSJ AS fXCBSHSJ, TT_WSXXFBSQB.FXCBMLDXM AS fXCBMLDXM, TT_WSXXFBSQB.FXXZXLDSHYJ AS fXXZXLDSHYJ, TT_WSXXFBSQB.FXXZXLDSHSJ AS fXXZXLDSHSJ, TT_WSXXFBSQB.FXXZXLDXM AS fXXZXLDXM, TT_WSXXFBSQB.FXXWHJGXSJ AS fXXWHJGXSJ, TT_WSXXFBSQB.FXXWHRYXM AS fXXWHRYXM, TT_WSXXFBSQB.FFJ AS fFJ, TT_WSXXFBSQB.fID AS TT_WSXXFBSQB FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE TT_WSXXFBSQB.fID = ?\r\n --> binds: [CB3561C808A34D03BE891735B254D0BA]","编码: JUSTEP150039; 提示: 执行sql: SELECT TT_WSXXFBSQB.VERSION AS version, TT_WSXXFBSQB.FSQDW AS fSQDW, TT_WSXXFBSQB.FFBSQBT AS fFBSQBT, TT_WSXXFBSQB.FSQSJ AS fSQSJ, TT_WSXXFBSQB.FXXZYXMJNRJJ AS fXXZYXMJNRJJ, TT_WSXXFBSQB.FFBLM AS fFBLM, TT_WSXXFBSQB.FXXZZRY AS fXXZZRY, TT_WSXXFBSQB.FSQBMLDSHYJ AS fSQBMLDSHYJ, TT_WSXXFBSQB.FSQBMLDSHSJ AS fSQBMLDSHSJ, TT_WSXXFBSQB.FSQBMLDSHXM AS fSQBMLDSHXM, TT_WSXXFBSQB.FXCBSHYJ AS fXCBSHYJ, TT_WSXXFBSQB.FXCBSHSJ AS fXCBSHSJ, TT_WSXXFBSQB.FXCBMLDXM AS fXCBMLDXM, TT_WSXXFBSQB.FXXZXLDSHYJ AS fXXZXLDSHYJ, TT_WSXXFBSQB.FXXZXLDSHSJ AS fXXZXLDSHSJ, TT_WSXXFBSQB.FXXZXLDXM AS fXXZXLDXM, TT_WSXXFBSQB.FXXWHJGXSJ AS fXXWHJGXSJ, TT_WSXXFBSQB.FXXWHRYXM AS fXXWHRYXM, TT_WSXXFBSQB.FFJ AS fFJ, TT_WSXXFBSQB.fID AS TT_WSXXFBSQB FROM TT_WSXXFBSQB TT_WSXXFBSQB WHERE TT_WSXXFBSQB.fID = ?, binds: [CB3561C808A34D03BE891735B254D0BA]出错","Io 异常: Connection reset by peer: socket write error"],"url":"/UI/system/service/common/bizAction.j","param":"020"}
at Object.errorMessage (http://10.22.121.226:8088/x5/$v2671/base/base.js?language=zh_CN:1:39761)
at Object.justep.Request.sendBizRequest2.callback (http://10.22.121.226:8088/x5/$v2671/component/data/data.js?language=zh_CN:1:54083)
at cbf (http://10.22.121.226:8088/x5/$v2671/base/base.js?language=zh_CN:1:34515)
at Object.sendRequest2 (http://10.22.121.226:8088/x5/$v2671/base/base.js?language=zh_CN:1:34759)
at Object.sendBizRequest2 (http://10.22.121.226:8088/x5/$v2671/base/base.js?language=zh_CN:1:70407)
at ._doRefreshData (http://10.22.121.226:8088/x5/$v2671/component/data/data.js?language=zh_CN:1:53459)
at .doRefreshData (http://10.22.121.226:8088/x5/$v2671/component/data/data.js?language=zh_CN:1:8813)
at .refreshData (http://10.22.121.226:8088/x5/$v2671/component/data/data.js?language=zh_CN:1:30551)
at .loadData (http://10.22.121.226:8088/x5/$v2671/component/data/data.js?language=zh_CN:1:35874)
at HTMLSpanElement. (http://10.22.121.226:8088/x5/$v2671/component/data/data.js?language=zh_CN:1:34027)

jishuang

这个提示的数据库连不上了，出错的时候确认数据库的连接是否正确

yiya42538757

jishuang 发表于 2018-10-23 11:48
这个提示的数据库连不上了，出错的时候确认数据库的连接是否正确

是连接正确的，比如我再刷新一下就正常了，是连接池的问题么？

jishuang

确认是不是http://docs.wex5.com/bex5-deploy-question-list-4011/中的问题

yiya42538757

jishuang 发表于 2018-10-23 15:03
确认是不是http://docs.wex5.com/bex5-deploy-question-list-4011/中的问题

我们是5.2.7企业版 ，按照里面要求在context修改，打开后没有数据源信息，请问是这样添加么？

jishuang

发帖时请备注具体用的版本，如果不做标记都是按最新版本回复的

5.2.7版本数据源的配置是在tomcat\conf\server.xml中的

yiya42538757

jishuang 发表于 2019-1-15 10:28
发帖时请备注具体用的版本，如果不做标记都是按最新版本回复的

5.2.7版本数据源的配置是在tomcat\conf\ser ...

修改完了，还是出现这种情况

jishuang

java.sql.SQLException: Io 异常: Connection reset by peer: socket write oracle.jdbc.driver.Database Error.throwSqlException(DatabaseError.java:112)

这个是数据库标准报错到网上查找相关的错误原因，确认驱动包等是否都正确