|
版本: |
其它(帖子中说明) |
小版本号: |
|
|
|
数据库: |
MySQL |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 7 |
浏览器: |
Chrome |
|
|
平台Bex5版本: 5.3.8.6314
这是正是服务器,本地开发环境没遇到过,现场多次反映此问题,上次以为是连接超时,在Tomcat中加了 validationQuery="select current_date" ,现在又报错了。
现场反映是偶尔报,关闭后打开功能又没问题了,而且一直在操作系统,不存在连接超时情况,请问是什么问题?
2021-04-01 08:14:28 开始-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2021-04-01 08:14:28 结束-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2021-04-01 08:14:28 开始-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2021-04-01 08:14:29 结束-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2021-04-01 08:14:30 开始-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:14:30 结束-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:14:30 开始-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:14:30 结束-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:14:54 开始-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2021-04-01 08:14:54 结束-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2021-04-01 08:14:54 开始-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2021-04-01 08:14:54 结束-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2021-04-01 08:14:54 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:14:55 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:14:55 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:14:55 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:14:55 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:14:56 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:14:56 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:14:56 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:15:29 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:15:32 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:15:32 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:15:32 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:16:17 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
2021-04-01 08:16:19 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
2021-04-01 08:16:19 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
2021-04-01 08:16:19 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
定时执行更新生产数据
select id,workShopCode,cobject,`data`,cdate,ctime,DATE_ADD(cdate,INTERVAL 1 DAY) as AcDate,DATE_SUB(cdate,INTERVAL 1 DAY) as ScDate from transdata where newflag1 =1 and cobject in ('FIT_401','FIT_402','FIT_406','FIT_409A','FIT_409B')
2021-04-01 08:16:40 excute stream action, params:{"process":"/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/generalMaterialsWarehousingProcess","activity":"mainActivity","translateParameter":{"rowsConfig":{"sequence":"fSCCS,ERP_MaterialClass,fPath,fWZBH,fSFYHP,fCJR,fMXSM,fSLC,fSFNYP,version,fFJDBM,fXHGG,fWZEJFL,fWZLX,fDW,fSZSB,fCJSJ,fWJ,fSPSL,fWZMC,fFJDMC,fYJFL,fSL,fBZ","concept":"ERP_MaterialClass"},"dataType":"row-list","includeState":true,"transformIdcolumn":true,"useNamespace":true,"cellnameByRelation":false},"executor":"","executeContext":"","actionFlag":"__action_0__","action":"queryERP_MaterialClassAction","contentType":"json","parameters":{"filter":"(fWZLX = '工区物资') AND ((upper(ERP_MaterialClass.fWZBH) LIKE '%硫%') OR (upper(ERP_MaterialClass.fWZMC) LIKE '%硫%') OR (upper(ERP_MaterialClass.fXHGG) LIKE '%硫%') OR (upper(ERP_MaterialClass.fDW) LIKE '%硫%') OR (upper(ERP_MaterialClass.fFJDMC) LIKE '%硫%'))","variables":{},"offset":0,"columns":"fSCCS,ERP_MaterialClass,fPath,fWZBH,fSFYHP,fCJR,fMXSM,fSLC,fSFNYP,version,fFJDBM,fXHGG,fWZEJFL,fWZLX,fDW,fSZSB,fCJSJ,fWJ,fSPSL,fWZMC,fFJDMC,fYJFL,fSL,fBZ","limit":20},"accept":"application/json"}
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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 ERP_MaterialClass.* FROM ERP_MaterialClass ERP_MaterialClass WHERE ((fWZLX = '工区物资') AND ((upper(ERP_MaterialClass.fWZBH) LIKE '%硫%') OR (upper(ERP_MaterialClass.fWZMC) LIKE '%硫%') OR (upper(ERP_MaterialClass.fXHGG) LIKE '%硫%') OR (upper(ERP_MaterialClass.fDW) LIKE '%硫%') OR (upper(ERP_MaterialClass.fFJDMC) LIKE '%硫%'))) LIMIT 0, 20
--> sql: SELECT ERP_MaterialClass.FSCCS AS fSCCS, ERP_MaterialClass.fID AS ERP_MaterialClass, ERP_MaterialClass.FPATH AS fPath, ERP_MaterialClass.FWZBH AS fWZBH, ERP_MaterialClass.FSFYHP AS fSFYHP, ERP_MaterialClass.FCJR AS fCJR, ERP_MaterialClass.FMXSM AS fMXSM, ERP_MaterialClass.FSLC AS fSLC, ERP_MaterialClass.FSFNYP AS fSFNYP, ERP_MaterialClass.VERSION AS version, ERP_MaterialClass.FFJDBM AS fFJDBM, ERP_MaterialClass.FXHGG AS fXHGG, ERP_MaterialClass.FWZEJFL AS fWZEJFL, ERP_MaterialClass.FWZLX AS fWZLX, ERP_MaterialClass.FDW AS fDW, ERP_MaterialClass.FSZSB AS fSZSB, ERP_MaterialClass.FCJSJ AS fCJSJ, ERP_MaterialClass.FWJ AS fWJ, ERP_MaterialClass.FSPSL AS fSPSL, ERP_MaterialClass.FWZMC AS fWZMC, ERP_MaterialClass.FFJDMC AS fFJDMC, ERP_MaterialClass.FYJFL AS fYJFL, ERP_MaterialClass.FSL AS fSL, ERP_MaterialClass.FBZ AS fBZ FROM ERP_MATERIALCLASS ERP_MaterialClass WHERE (fWZLX = ?) AND ( (UPPER(ERP_MaterialClass.FWZBH) LIKE ?) OR (UPPER(ERP_MaterialClass.FWZMC) LIKE ?) OR (UPPER(ERP_MaterialClass.FXHGG) LIKE ?) OR (UPPER(ERP_MaterialClass.FDW) LIKE ?) OR (UPPER(ERP_MaterialClass.FFJDMC) LIKE ?) )
--> 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.BizData.query(Unknown Source)
at BizProcedure.query(BizProcedure.java:12)
... 30 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT ERP_MaterialClass.FSCCS AS fSCCS, ERP_MaterialClass.fID AS ERP_MaterialClass, ERP_MaterialClass.FPATH AS fPath, ERP_MaterialClass.FWZBH AS fWZBH, ERP_MaterialClass.FSFYHP AS fSFYHP, ERP_MaterialClass.FCJR AS fCJR, ERP_MaterialClass.FMXSM AS fMXSM, ERP_MaterialClass.FSLC AS fSLC, ERP_MaterialClass.FSFNYP AS fSFNYP, ERP_MaterialClass.VERSION AS version, ERP_MaterialClass.FFJDBM AS fFJDBM, ERP_MaterialClass.FXHGG AS fXHGG, ERP_MaterialClass.FWZEJFL AS fWZEJFL, ERP_MaterialClass.FWZLX AS fWZLX, ERP_MaterialClass.FDW AS fDW, ERP_MaterialClass.FSZSB AS fSZSB, ERP_MaterialClass.FCJSJ AS fCJSJ, ERP_MaterialClass.FWJ AS fWJ, ERP_MaterialClass.FSPSL AS fSPSL, ERP_MaterialClass.FWZMC AS fWZMC, ERP_MaterialClass.FFJDMC AS fFJDMC, ERP_MaterialClass.FYJFL AS fYJFL, ERP_MaterialClass.FSL AS fSL, ERP_MaterialClass.FBZ AS fBZ FROM ERP_MATERIALCLASS ERP_MaterialClass WHERE (fWZLX = ?) AND ( (UPPER(ERP_MaterialClass.FWZBH) LIKE ?) OR (UPPER(ERP_MaterialClass.FWZMC) LIKE ?) OR (UPPER(ERP_MaterialClass.FXHGG) LIKE ?) OR (UPPER(ERP_MaterialClass.FDW) LIKE ?) OR (UPPER(ERP_MaterialClass.FFJDMC) LIKE ?) ) , binds: [工区物资, %硫%, %硫%, %硫%, %硫%, %硫%]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 35 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 36,160,987 milliseconds ago. The last packet sent successfully to the server was 36,160,987 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1038)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3621)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 36 more
Caused by: java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3603)
... 43 more
2021-04-01 08:16:57 excute stream action, params:{"process":"/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/generalMaterialsWarehousingProcess","activity":"mainActivity","translateParameter":{"rowsConfig":{"sequence":"fSCCS,ERP_MaterialClass,fPath,fWZBH,fSFYHP,fCJR,fMXSM,fSLC,fSFNYP,version,fFJDBM,fXHGG,fWZEJFL,fWZLX,fDW,fSZSB,fCJSJ,fWJ,fSPSL,fWZMC,fFJDMC,fYJFL,fSL,fBZ","concept":"ERP_MaterialClass"},"dataType":"row-list","includeState":true,"transformIdcolumn":true,"useNamespace":true,"cellnameByRelation":false},"executor":"","executeContext":"","actionFlag":"__action_0__","action":"queryERP_MaterialClassAction","contentType":"json","parameters":{"filter":"(fWZLX = '工区物资') AND ((upper(ERP_MaterialClass.fWZBH) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fWZMC) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fXHGG) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fDW) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fFJDMC) LIKE '%硫酸%'))","variables":{},"offset":0,"columns":"fSCCS,ERP_MaterialClass,fPath,fWZBH,fSFYHP,fCJR,fMXSM,fSLC,fSFNYP,version,fFJDBM,fXHGG,fWZEJFL,fWZLX,fDW,fSZSB,fCJSJ,fWJ,fSPSL,fWZMC,fFJDMC,fYJFL,fSL,fBZ","limit":20},"accept":"application/json"}
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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 ERP_MaterialClass.* FROM ERP_MaterialClass ERP_MaterialClass WHERE ((fWZLX = '工区物资') AND ((upper(ERP_MaterialClass.fWZBH) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fWZMC) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fXHGG) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fDW) LIKE '%硫酸%') OR (upper(ERP_MaterialClass.fFJDMC) LIKE '%硫酸%'))) LIMIT 0, 20
--> sql: SELECT ERP_MaterialClass.FSCCS AS fSCCS, ERP_MaterialClass.fID AS ERP_MaterialClass, ERP_MaterialClass.FPATH AS fPath, ERP_MaterialClass.FWZBH AS fWZBH, ERP_MaterialClass.FSFYHP AS fSFYHP, ERP_MaterialClass.FCJR AS fCJR, ERP_MaterialClass.FMXSM AS fMXSM, ERP_MaterialClass.FSLC AS fSLC, ERP_MaterialClass.FSFNYP AS fSFNYP, ERP_MaterialClass.VERSION AS version, ERP_MaterialClass.FFJDBM AS fFJDBM, ERP_MaterialClass.FXHGG AS fXHGG, ERP_MaterialClass.FWZEJFL AS fWZEJFL, ERP_MaterialClass.FWZLX AS fWZLX, ERP_MaterialClass.FDW AS fDW, ERP_MaterialClass.FSZSB AS fSZSB, ERP_MaterialClass.FCJSJ AS fCJSJ, ERP_MaterialClass.FWJ AS fWJ, ERP_MaterialClass.FSPSL AS fSPSL, ERP_MaterialClass.FWZMC AS fWZMC, ERP_MaterialClass.FFJDMC AS fFJDMC, ERP_MaterialClass.FYJFL AS fYJFL, ERP_MaterialClass.FSL AS fSL, ERP_MaterialClass.FBZ AS fBZ FROM ERP_MATERIALCLASS ERP_MaterialClass WHERE (fWZLX = ?) AND ( (UPPER(ERP_MaterialClass.FWZBH) LIKE ?) OR (UPPER(ERP_MaterialClass.FWZMC) LIKE ?) OR (UPPER(ERP_MaterialClass.FXHGG) LIKE ?) OR (UPPER(ERP_MaterialClass.FDW) LIKE ?) OR (UPPER(ERP_MaterialClass.FFJDMC) LIKE ?) )
--> 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.BizData.query(Unknown Source)
at BizProcedure.query(BizProcedure.java:12)
... 30 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT ERP_MaterialClass.FSCCS AS fSCCS, ERP_MaterialClass.fID AS ERP_MaterialClass, ERP_MaterialClass.FPATH AS fPath, ERP_MaterialClass.FWZBH AS fWZBH, ERP_MaterialClass.FSFYHP AS fSFYHP, ERP_MaterialClass.FCJR AS fCJR, ERP_MaterialClass.FMXSM AS fMXSM, ERP_MaterialClass.FSLC AS fSLC, ERP_MaterialClass.FSFNYP AS fSFNYP, ERP_MaterialClass.VERSION AS version, ERP_MaterialClass.FFJDBM AS fFJDBM, ERP_MaterialClass.FXHGG AS fXHGG, ERP_MaterialClass.FWZEJFL AS fWZEJFL, ERP_MaterialClass.FWZLX AS fWZLX, ERP_MaterialClass.FDW AS fDW, ERP_MaterialClass.FSZSB AS fSZSB, ERP_MaterialClass.FCJSJ AS fCJSJ, ERP_MaterialClass.FWJ AS fWJ, ERP_MaterialClass.FSPSL AS fSPSL, ERP_MaterialClass.FWZMC AS fWZMC, ERP_MaterialClass.FFJDMC AS fFJDMC, ERP_MaterialClass.FYJFL AS fYJFL, ERP_MaterialClass.FSL AS fSL, ERP_MaterialClass.FBZ AS fBZ FROM ERP_MATERIALCLASS ERP_MaterialClass WHERE (fWZLX = ?) AND ( (UPPER(ERP_MaterialClass.FWZBH) LIKE ?) OR (UPPER(ERP_MaterialClass.FWZMC) LIKE ?) OR (UPPER(ERP_MaterialClass.FXHGG) LIKE ?) OR (UPPER(ERP_MaterialClass.FDW) LIKE ?) OR (UPPER(ERP_MaterialClass.FFJDMC) LIKE ?) ) , binds: [工区物资, %硫酸%, %硫酸%, %硫酸%, %硫酸%, %硫酸%]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 35 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 36,224,001 milliseconds ago. The last packet sent successfully to the server was 36,224,001 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1038)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3621)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 36 more
Caused by: java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3603)
... 43 more
2021-04-01
INSERT INTO erp_warehousewarningpush(fid,version,fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fSZKFID,fSL,fYJSL)select UUID() fid,(0)version, ('2021-04-01')fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fKFXXID,fSL,fYJSL from ERP_MaterialDetail where fSL <= fYJSL
更新实时数据--------------------------------------------------------------------
2021-04-01 08:18:48 开始-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2021-04-01 08:18:48 结束-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2021-04-01 08:18:49 开始-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2021-04-01 08:18:49 结束-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2021-04-01 08:18:50 开始-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:18:50 结束-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:18:50 开始-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:18:50 结束-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:18:53 开始-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2021-04-01 08:18:53 结束-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2021-04-01 08:18:53 开始-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2021-04-01 08:18:53 结束-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2021-04-01 08:19:04 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:19:06 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:19:06 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:19:06 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:19:19 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
2021-04-01 08:19:20 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
2021-04-01 08:19:20 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
2021-04-01 08:19:20 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/SelectActivity.w
定时执行更新生产数据
select id,workShopCode,cobject,`data`,cdate,ctime,DATE_ADD(cdate,INTERVAL 1 DAY) as AcDate,DATE_SUB(cdate,INTERVAL 1 DAY) as ScDate from transdata where newflag1 =1 and cobject in ('FIT_401','FIT_402','FIT_406','FIT_409A','FIT_409B')
2021-04-01
INSERT INTO erp_warehousewarningpush(fid,version,fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fSZKFID,fSL,fYJSL)select UUID() fid,(0)version, ('2021-04-01')fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fKFXXID,fSL,fYJSL from ERP_MaterialDetail where fSL <= fYJSL
更新实时数据--------------------------------------------------------------------
2021-04-01 08:23:16 开始-WINDOW生成中间文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:23:16 结束-WINDOW生成中间文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:23:16 开始-中间文件生成缓存文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:23:17 结束-中间文件生成缓存文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:25:20 开始-WINDOW生成中间文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:25:20 结束-WINDOW生成中间文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:25:20 开始-中间文件生成缓存文件: /UI2/system/service/process/dialog/processDialog.w
2021-04-01 08:25:20 结束-中间文件生成缓存文件: /UI2/system/service/process/dialog/processDialog.w
定时执行更新生产数据
select id,workShopCode,cobject,`data`,cdate,ctime,DATE_ADD(cdate,INTERVAL 1 DAY) as AcDate,DATE_SUB(cdate,INTERVAL 1 DAY) as ScDate from transdata where newflag1 =1 and cobject in ('FIT_401','FIT_402','FIT_406','FIT_409A','FIT_409B')
2021-04-01
INSERT INTO erp_warehousewarningpush(fid,version,fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fSZKFID,fSL,fYJSL)select UUID() fid,(0)version, ('2021-04-01')fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fKFXXID,fSL,fYJSL from ERP_MaterialDetail where fSL <= fYJSL
2021-04-01 08:27:49 执行sql: insert into SA_Log (sCreatorPosName, sActivity, sAction, sCreatorFID, sProcess, sCreatorPersonName, sCreateTime, sParameters, sActionName, sIP, sDeviceType, sProcessName, sStatusName, sDescription, sCreatorFName, sCreatorPersonID, sCreatorOgnName, sOperatingSystem, version, SID, sResult, sCreatorPosID, sActivityName, sCreatorDeptID, sTypeName, sCreatorDeptName, sCreatorOgnID, $clientName) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, $clientValue), binds: [, mainActivity, logoutAction, /ORG01.ogn/PSN01@ORG01.psm, /SA/OPM/system/systemProcess, system, 2021-04-01 08:27:49.465, 参数名称: sessionID
参数值: {"value":"2AEA1BB54814ADB479932D68DE2005A1"}
, 退出, 192.168.4.200, 未知, 系统调用, 失败, null, /起步软件/system, PSN01, 起步软件, 未知, 0, 199793049F924FB6B1DD9B4EA7DA63D8, , , 系统, , 操作日志, , ORG01]失败
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 52,275,539 milliseconds ago. The last packet sent successfully to the server was 52,275,539 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1038)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3621)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)
at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4882)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328)
at com.justep.system.data.Transaction.begin(Unknown Source)
at com.justep.system.log.LogUtils.execSqlUpdate(Unknown Source)
at com.justep.system.log.LogUtils.log(Unknown Source)
at com.justep.system.log.LogUtils.log(Unknown Source)
at com.justep.system.interceptor.LogBefore.actionLog(Unknown Source)
at com.justep.system.interceptor.LogBefore.doActionLog(Unknown Source)
at com.justep.system.interceptor.LogBefore.execute(Unknown Source)
at com.justep.system.action.EngineInterceptor.excute(Unknown Source)
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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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: java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3603)
... 40 more
更新实时数据--------------------------------------------------------------------
2021-04-01 08:29:18 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/mainActivity.w
2021-04-01 08:29:22 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/mainActivity.w
2021-04-01 08:29:22 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/mainActivity.w
2021-04-01 08:29:22 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/mainActivity.w
2021-04-01 08:30:59 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/SelectActivity.w
2021-04-01 08:31:00 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/SelectActivity.w
2021-04-01 08:31:00 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/SelectActivity.w
2021-04-01 08:31:00 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/OutgoingManagement/SelectActivity.w
定时执行更新生产数据
select id,workShopCode,cobject,`data`,cdate,ctime,DATE_ADD(cdate,INTERVAL 1 DAY) as AcDate,DATE_SUB(cdate,INTERVAL 1 DAY) as ScDate from transdata where newflag1 =1 and cobject in ('FIT_401','FIT_402','FIT_406','FIT_409A','FIT_409B')
2021-04-01
INSERT INTO erp_warehousewarningpush(fid,version,fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fSZKFID,fSL,fYJSL)select UUID() fid,(0)version, ('2021-04-01')fTSSJ,fWZBH,fWZMC,fWZLX,fXHGG,fDW,fSZKF,fKFXXID,fSL,fYJSL from ERP_MaterialDetail where fSL <= fYJSL
更新实时数据--------------------------------------------------------------------
定时执行更新生产数据
select id,workShopCode,cobject,`data`,cdate,ctime,DATE_ADD(cdate,INTERVAL 1 DAY) as AcDate,DATE_SUB(cdate,INTERVAL 1 DAY) as ScDate from transdata where newflag1 =1 and cobject in ('FIT_401','FIT_402','FIT_406','FIT_409A','FIT_409B')
2021-04-01 08:36:48 开始-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2021-04-01 08:36:48 结束-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2021-04-01 08:36:48 开始-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2021-04-01 08:36:48 结束-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2021-04-01 08:36:49 Not registed session:989DFC625E298217F9110F03A815AC07, jsessionid:JSESSIONID=79528813B3AFBE010D2494536D13422C, action: <?xml version="1.0" encoding="UTF-8"?>
<actions><action process="/SA/OPM/system/systemProcess" activity="mainActivity" name="getSysParamsAction" execute-context="" content-type="application/xml"><parameters/></action></actions>
2021-04-01 08:36:49 开始-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:36:49 结束-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:36:49 开始-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:36:49 结束-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2021-04-01 08:36:52 开始-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2021-04-01 08:36:52 结束-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2021-04-01 08:36:52 开始-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2021-04-01 08:36:52 结束-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2021-04-01 08:36:52 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:36:53 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:36:53 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:36:53 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2021-04-01 08:36:53 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:36:54 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:36:54 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:36:54 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2021-04-01 08:36:54 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/queryActivity.w
2021-04-01 08:36:54 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/queryActivity.w
2021-04-01 08:36:54 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/queryActivity.w
2021-04-01 08:36:54 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/queryActivity.w
2021-04-01 08:36:57 开始-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:36:58 结束-WINDOW生成中间文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:36:58 开始-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
2021-04-01 08:36:58 结束-中间文件生成缓存文件: /UI2/ERP/WareHouseManagement/process/GeneralMaterialsWarehousing/mainActivity.w
|
|