页面经常在数据加载的时候报错，如下图

mazhao02

运气好了，刷新几次就能好，运气不好了，一直报错！

jishuang

看tomcat控制台完整的错误信息

mazhao02

Caused by: com.justep.model.exception.ModelException: 查询数据库记录数时出错！
->SQL :SELECT count(*) FROM MTL_MOVE_ORDERS MTL_MOVE_ORDERS LEFT JOIN SYS_DICTIONARY SYS_DICTIONARY ON  (MTL_MOVE_ORDERS.STATUS_ID = SYS_DICTIONARY.DVALUE) AND (SYS_DICTIONARY.PARENT_ID = ?)  LEFT JOIN MTL_TRANSACTION MTL_TRANSACTION ON MTL_MOVE_ORDERS.TRANSACTION_ID = MTL_TRANSACTION.TRANSACTION_ID LEFT JOIN SYS_DICTIONARY SYS_DICTIONARY_1 ON  (MTL_MOVE_ORDERS.MOVE_ORDER_TYPE_CODE = SYS_DICTIONARY_1.DVALUE) AND (SYS_DICTIONARY_1.PARENT_ID = ?)  LEFT JOIN SA_OPPerson SA_OPPerson ON MTL_MOVE_ORDERS.CREATED_BY = SA_OPPerson.sID LEFT JOIN WMS_STORE_HOUSE WMS_STORE_HOUSE ON MTL_MOVE_ORDERS.STORE_HOUSE_CODE = WMS_STORE_HOUSE.STORE_HOUSE_CODE LEFT JOIN SYS_DICTIONARY SYS_DICTIONARY_2 ON  (MTL_TRANSACTION.TRANSACTION_TYPE_CODE = SYS_DICTIONARY_2.DVALUE) AND (SYS_DICTIONARY_2.PARENT_ID = ?)   WHERE  (? = ?) AND (STORE_HOUSE_DEPT_ID = ?) AND ( STATUS_ID IN (?, ?) )
->binds:[95DA830DF08D4A6595A98BBAA5F063DB, 399725F473014000A56D3D6654C459B4, 180A9B4DBCF848F2A33646AAFEDE2AA4, 1, 1, 117049F8179E4ED8886A76B763917120, 1, 0]
        at com.justep.system.data.impl.TableImpl.countInDB(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:12)
        ... 25 more
Caused by: java.sql.SQLException: 无法从套接字读取更多的数据
        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:208)
        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1118)
        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1070)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:478)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
        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)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 28 more
2018-01-03 13:21:20 invokeActions error！
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
        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:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor1135.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)
        ... 21 more

mazhao02

2018-02-03 19:35:43 invokeActions error！
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
        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:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        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)
        ... 21 more
Caused by: java.lang.RuntimeException: 创建发料单失败:执行sqlQueryAction时报错！SELECT A.*  FROM MTL_TRANSACTION_LINES A INNER JOIN MTL_TRANSACTION B    ON A.TRANSACTION_ID = B.TRANSACTION_ID WHERE B.WAVE_CODE = ?
        at WIP.createTransByWaveCodeJob(WIP.java:3756)
        ... 26 more
2018-02-03 19:35:57 invokeActions error！
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
        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:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)

jishuang

这个是数据库的问题

http://blog.csdn.net/xiaopeng187/article/details/25797885

http://blog.csdn.net/liduote/article/details/70227040

http://linwei-211.iteye.com/blog/1205992

mazhao02

我个人觉得是连接池的问题，x5没有处理网络造成的异常连接，导致用户正常操作的时候获取的无用连接

jishuang

平台底层就是jdbc的方式去链接数据库的，就跟标准的web应用一样，不会去处理数据库网络异常的问题
可以到网上查找一下数据库是否有这样的设置

malixin

mazhao02 发表于 2018-2-5 09:41
Caused by: com.justep.model.exception.ModelException: 查询数据库记录数时出错！
->SQL :SELECT count( ...

同样遇到该问题，action是系统默认的query，直接在数据库执行查询是可以，但是在ui界面就不行。

jishuang

java写一个jdbc去测试看看