系统常时间登录不用超时后再登陆以后报错

qweasdzxc

系统常时间登录不用超时后再登陆以后报错，重新登录又好了，什么原因？
浏览器报错： 接二楼

1. Error: __justepServerErrorStart__{"message":"刷新数据失败！ , \n执行KSQL出错, KSQL: SELECT SAM_COMMENTS.*,SAM_AssetDiscuss.fAssetName as fAssetName,SAM_ASSET.fVersionNumber as fVersionNumber  FROM SAM_COMMENTS SAM_COMMENTS  optional  join SAM_AssetDiscuss SAM_AssetDiscuss on SAM_COMMENTS.fParentId = SAM_AssetDiscuss optional  join SAM_ASSET SAM_ASSET on SAM_COMMENTS.fAssetId  =  SAM_ASSET WHERE ((SAM_COMMENTS.fPersonalScore > :score)) ORDER BY fDiscussDate DESC,fPersonalScore DESC LIMIT 0, 5\r\n --> sql: SELECT  SAM_COMMENTS.fID AS SAM_COMMENTS, SAM_COMMENTS.FASSETID AS fAssetId, SAM_AssetDiscuss.FASSETNAME AS fAssetName, SAM_COMMENTS.FCOMMENT AS fComment, SAM_COMMENTS.FDISCUSSDATE AS fDiscussDate, SAM_COMMENTS.FDISCUSSANT AS fDiscussant, SAM_COMMENTS.FDISCUSSANTID AS fDiscussantId, SAM_COMMENTS.FPARENTID AS fParentId, SAM_COMMENTS.FPERSONALSCORE AS fPersonalScore, SAM_ASSET.FVERSIONNUMBER AS fVersionNumber, SAM_COMMENTS.VERSION AS version FROM SAM_COMMENTS SAM_COMMENTS LEFT JOIN SAM_ASSETDISCUSS SAM_AssetDiscuss ON SAM_COMMENTS.FPARENTID = SAM_AssetDiscuss.fID LEFT JOIN SAM_ASSET SAM_ASSET ON SAM_COMMENTS.FASSETID = SAM_ASSET.fID  WHERE SAM_COMMENTS.FPERSONALSCORE >  ?   ORDER BY fDiscussDate DESC, fPersonalScore DESC\r\n --> binds: [3]","reason":"","code":"JUSTEP150210","stack":"java.lang.reflect.InvocationTargetException\r\n\tat sun.reflect.GeneratedMethodAccessor139.invoke(Unknown Source)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:497)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\r\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)\r\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)\r\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT SAM_COMMENTS.*,SAM_AssetDiscuss.fAssetName as fAssetName,SAM_ASSET.fVersionNumber as fVersionNumber  FROM SAM_COMMENTS SAM_COMMENTS  optional  join SAM_AssetDiscuss SAM_AssetDiscuss on SAM_COMMENTS.fParentId = SAM_AssetDiscuss optional  join SAM_ASSET SAM_ASSET on SAM_COMMENTS.fAssetId  =  SAM_ASSET WHERE ((SAM_COMMENTS.fPersonalScore > :score)) ORDER BY fDiscussDate DESC,fPersonalScore DESC LIMIT 0, 5\r\n --> sql: SELECT  SAM_COMMENTS.fID AS SAM_COMMENTS, SAM_COMMENTS.FASSETID AS fAssetId, SAM_AssetDiscuss.FASSETNAME AS fAssetName, SAM_COMMENTS.FCOMMENT AS fComment, SAM_COMMENTS.FDISCUSSDATE AS fDiscussDate, SAM_COMMENTS.FDISCUSSANT AS fDiscussant, SAM_COMMENTS.FDISCUSSANTID AS fDiscussantId, SAM_COMMENTS.FPARENTID AS fParentId, SAM_COMMENTS.FPERSONALSCORE AS fPersonalScore, SAM_ASSET.FVERSIONNUMBER AS fVersionNumber, SAM_COMMENTS.VERSION AS version FROM SAM_COMMENTS SAM_COMMENTS LEFT JOIN SAM_ASSETDISCUSS SAM_AssetDiscuss ON SAM_COMMENTS.FPARENTID = SAM_AssetDiscuss.fID LEFT JOIN SAM_ASSET SAM_ASSET ON SAM_COMMENTS.FASSETID = SAM_ASSET.fID  WHERE SAM_COMMENTS.FPERSONALSCORE >  ?   ORDER BY fDiscussDate DESC, fPersonalScore DESC\r\n --> binds: [3]\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\r\n\tat com.justep.system.data.BizData.query(Unknown Source)\r\n\tat BizProcedure.query(BizProcedure.java:12)\r\n\t... 26 more\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  SAM_COMMENTS.fID AS SAM_COMMENTS, SAM_COMMENTS.FASSETID AS fAssetId, SAM_AssetDiscuss.FASSETNAME AS fAssetName, SAM_COMMENTS.FCOMMENT AS fComment, SAM_COMMENTS.FDISCUSSDATE AS fDiscussDate, SAM_COMMENTS.FDISCUSSANT AS fDiscussant, SAM_COMMENTS.FDISCUSSANTID AS fDiscussantId, SAM_COMMENTS.FPARENTID AS fParentId, SAM_COMMENTS.FPERSONALSCORE AS fPersonalScore, SAM_ASSET.FVERSIONNUMBER AS fVersionNumber, SAM_COMMENTS.VERSION AS version FROM SAM_COMMENTS SAM_COMMENTS LEFT JOIN SAM_ASSETDISCUSS SAM_AssetDiscuss ON SAM_COMMENTS.FPARENTID = SAM_AssetDiscuss.fID LEFT JOIN SAM_ASSET SAM_ASSET ON SAM_COMMENTS.FASSETID = SAM_ASSET.fID  WHERE SAM_COMMENTS.FPERSONALSCORE >  ?   ORDER BY fDiscussDate DESC, fPersonalScore DESC, binds: [3]出错\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)\r\n\t... 31 more\r\nCaused by: java.sql.SQLException: Io 异常: Connection reset by peer: socket write error\r\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)\r\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)\r\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)\r\n\tat oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:812)\r\n\tat oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)\r\n\tat oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)\r\n\tat oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)\r\n\t... 32 more\r\n","messages":["编码: JUSTEP150210;
   

复制代码

qweasdzxc

1.      提示: 执行KSQL出错, KSQL: SELECT SAM_COMMENTS.*,SAM_AssetDiscuss.fAssetName as fAssetName,SAM_ASSET.fVersionNumber as fVersionNumber FROM SAM_COMMENTS SAM_COMMENTS optional join SAM_AssetDiscuss SAM_AssetDiscuss on SAM_COMMENTS.fParentId = SAM_AssetDiscuss optional join SAM_ASSET SAM_ASSET on SAM_COMMENTS.fAssetId = SAM_ASSET WHERE ((SAM_COMMENTS.fPersonalScore > :score)) ORDER BY fDiscussDate DESC,fPersonalScore DESC LIMIT 0, 5\r\n --> sql: SELECT SAM_COMMENTS.fID AS SAM_COMMENTS, SAM_COMMENTS.FASSETID AS fAssetId, SAM_AssetDiscuss.FASSETNAME AS fAssetName, SAM_COMMENTS.FCOMMENT AS fComment, SAM_COMMENTS.FDISCUSSDATE AS fDiscussDate, SAM_COMMENTS.FDISCUSSANT AS fDiscussant, SAM_COMMENTS.FDISCUSSANTID AS fDiscussantId, SAM_COMMENTS.FPARENTID AS fParentId, SAM_COMMENTS.FPERSONALSCORE AS fPersonalScore, SAM_ASSET.FVERSIONNUMBER AS fVersionNumber, SAM_COMMENTS.VERSION AS version FROM SAM_COMMENTS SAM_COMMENTS LEFT JOIN SAM_ASSETDISCUSS SAM_AssetDiscuss ON SAM_COMMENTS.FPARENTID = SAM_AssetDiscuss.fID LEFT JOIN SAM_ASSET SAM_ASSET ON SAM_COMMENTS.FASSETID = SAM_ASSET.fID WHERE SAM_COMMENTS.FPERSONALSCORE > ? ORDER BY fDiscussDate DESC, fPersonalScore DESC\r\n --> binds: [3]","编码: JUSTEP150039; 提示: 执行sql: SELECT SAM_COMMENTS.fID AS SAM_COMMENTS, SAM_COMMENTS.FASSETID AS fAssetId, SAM_AssetDiscuss.FASSETNAME AS fAssetName, SAM_COMMENTS.FCOMMENT AS fComment, SAM_COMMENTS.FDISCUSSDATE AS fDiscussDate, SAM_COMMENTS.FDISCUSSANT AS fDiscussant, SAM_COMMENTS.FDISCUSSANTID AS fDiscussantId, SAM_COMMENTS.FPARENTID AS fParentId, SAM_COMMENTS.FPERSONALSCORE AS fPersonalScore, SAM_ASSET.FVERSIONNUMBER AS fVersionNumber, SAM_COMMENTS.VERSION AS version FROM SAM_COMMENTS SAM_COMMENTS LEFT JOIN SAM_ASSETDISCUSS SAM_AssetDiscuss ON SAM_COMMENTS.FPARENTID = SAM_AssetDiscuss.fID LEFT JOIN SAM_ASSET SAM_ASSET ON SAM_COMMENTS.FASSETID = SAM_ASSET.fID WHERE SAM_COMMENTS.FPERSONALSCORE > ? ORDER BY fDiscussDate DESC, fPersonalScore DESC, binds: [3]出错","Io 异常: Connection reset by peer: socket write error"],"url":"http://localhost:8080/BusinessServer/business-action","param":{"contentType":"json","accept":"application/json","process":"/SAM/assetManage/process/common/commonProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"","executeContext":"","action":"querySAM_COMMENTSAction","parameters":{"variables":{"score":"3"},"filter":"(SAM_COMMENTS.fPersonalScore > :score)","offset":-1,"limit":5,"columns":"SAM_COMMENTS,fAssetId,fAssetName,fComment,fDiscussDate,fDiscussant,fDiscussantId,fParentId,fPersonalScore,fVersionNumber,version","orderBy":"fDiscussDate DESC,fPersonalScore DESC"},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"includeState":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"SAM_COMMENTS","sequence":"SAM_COMMENTS,fAssetId,fAssetName,fComment,fDiscussDate,fDiscussant,fDiscussantId,fParentId,fPersonalScore,fVersionNumber,version"}}}}__justepServerErrorEnd__
   
2.     at Object.create (core.min.js:65)
   
3.     at Object.Request.errorMessage (biz.common.min.js:12)
   
4.     at Object.callback (biz.common.min.js:12)
   
5.     at Object.h (biz.common.min.js:12)
   
6.     at f (core.min.js:65)
   
7.     at Object.add (core.min.js:65)
   
8.     at _sendRequest (biz.common.min.js:12)
   
9.     at Object.Request.sendRequest (biz.common.min.js:12)
   
10.     at Object.$var._sendBizRequest (eval at __actionFinish (biz.common.min.js:12), <anonymous>:1:577)
    
11.     at Object.Request.sendBizRequest (biz.common.min.js:12)
    

复制代码

平台报错： 接三楼
2017-04-05 20:05:00 Not registed session:3980475419CFAC05BAC064A118CCAE7F, jsessionid:JSESSIONID=290BD7E78725C0C791889A889919660C, action: <?xml version="1.0" encoding="UTF-8"?>
<actions><action process="/SAM/assetManage/process/asset_search/asset_searchProcess" activity="mainActivity" name="getSysParamsAction" execute-context="" content-type="application/xml"><parameters/></action></actions>
2017-04-05 20:05:00 Not registed session:594FCC16FF9DD7278F30345342E44525, jsessionid:JSESSIONID=290BD7E78725C0C791889A889919660C; request-use-base64=false; bsessionid=290BD7E78725C0C791889A889919660C, action: {"accept":"application/json","action":"getWordAction","actionFlag":"__action_0__","activity":"","contentType":"json","executeContext":"","executor":"","parameters":{"facet":"","isRelation":"0","pageCount":10,"personId":"","searchPage":1,"searchWord":"","term":""},"process":""}
2017-04-05 20:05:02 Not registed session:594FCC16FF9DD7278F30345342E44525, jsessionid:JSESSIONID=594FCC16FF9DD7278F30345342E44525; request-use-base64=false; bsessionid=290BD7E78725C0C791889A889919660C, action: {"accept":"application/json","action":"queryWaitTask2Action","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"SA_Task,sActivity,sCreateTime,sCreatorFName,sData1,sData2,sData3,sData4,sEURL,sExecutorFID,sExecutorFName,sExecutorNames,sKindID,sName,sProcess,sStatusID","limit":5,"offset":-1,"orderBy":"sCreateTime DESC","variables":{}},"process":"/SA/task/taskView/taskViewProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"SA_Task","sequence":"SA_Task,sActivity,sCreateTime,sCreatorFName,sData1,sData2,sData3,sData4,sEURL,sExecutorFID,sExecutorFName,sExecutorNames,sKindID,sName,sProcess,sStatusID"},"transformIdcolumn":true,"useNamespace":true}}
2017-04-05 20:05:02 Not registed session:594FCC16FF9DD7278F30345342E44525, jsessionid:JSESSIONID=594FCC16FF9DD7278F30345342E44525; request-use-base64=false; bsessionid=290BD7E78725C0C791889A889919660C, action: {"accept":"application/json","action":"querySAM_FavoriteAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"SAM_Favorite,fAssetId,fAssetName,fCreateDate,fCreateTime,fCreatorId,fSort,fUrl,fVersionNumber,version","filter":"(SAM_Favorite.fCreatorId = 'PSN01')","limit":5,"offset":-1,"orderBy":"fCreateTime DESC","variables":{}},"process":"/SAM/assetManage/process/common/commonProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"SAM_Favorite","sequence":"SAM_Favorite,fAssetId,fAssetName,fCreateDate,fCreateTime,fCreatorId,fSort,fUrl,fVersionNumber,version"},"transformIdcolumn":true,"useNamespace":true}}
2017-04-05 20:05:02 Not registed session346F02B8A22C334C19DAB95BA629A02, jsessionid:JSESSIONID=290BD7E78725C0C791889A889919660C, action: logout
--------登陆------------------2

qweasdzxc

qweasdzxc 发表于 2017-4-5 20:15
平台报错： 接三楼
2017-04-05 20:05:00 Not registed session:3980475419CFAC05BAC064A118CCAE7F, jsessio ...

2017-04-05 20:05:03 执行sql: insert into SA_Log  (sProcessName, sStatusName, sActivity, sAction, sOperatingSystem, version, SID, sProcess, sCreatorPersonName, sCreateTime, sActivityName, sActionName, sParameters, sIP, sTypeName, sDeviceType, $clientName ) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, $clientValue ), binds: [系统调用, 失败, mainActivity, loginAction, WINDOWS, 0, 04712A5FEAF04D19A6E0AB6B75B6E0DA, /SA/OPM/system/systemProcess, system, 2017-04-05 20:05:03.318, 系统, 登录, ******, 0:0:0:0:0:0:0:1, 操作日志, Computer]失败
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.executeForRows(T4CPreparedStatement.java:974)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at com.justep.system.interceptor.LogBefore.execSqlUpdate(Unknown Source)
    at com.justep.system.interceptor.LogBefore.loginLog(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.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)
--------登陆方式三
2017-04-05 20:05:03 excute stream action, params:{"accept":"application/json","action":"querySAM_COMMENTSAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"SAM_COMMENTS,fAssetId,fAssetName,fComment,fDiscussDate,fDiscussant,fDiscussantId,fParentId,fPersonalScore,fVersionNumber,version","filter":"(SAM_COMMENTS.fPersonalScore > :score)","limit":5,"offset":-1,"orderBy":"fDiscussDate DESC,fPersonalScore DESC","variables":{"score":"3"}},"process":"/SAM/assetManage/process/common/commonProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"SAM_COMMENTS","sequence":"SAM_COMMENTS,fAssetId,fAssetName,fComment,fDiscussDate,fDiscussant,fDiscussantId,fParentId,fPersonalScore,fVersionNumber,version"},"transformIdcolumn":true,"useNamespace":true}}
java.lang.reflect.InvocationTargetException
    at sun.reflect.GeneratedMethodAccessor139.invoke(Unknown Source)
    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 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 SAM_COMMENTS.*,SAM_AssetDiscuss.fAssetName as fAssetName,SAM_ASSET.fVersionNumber as fVersionNumber  FROM SAM_COMMENTS SAM_COMMENTS  optional  join SAM_AssetDiscuss SAM_AssetDiscuss on SAM_COMMENTS.fParentId = SAM_AssetDiscuss optional  join SAM_ASSET SAM_ASSET on SAM_COMMENTS.fAssetId  =  SAM_ASSET WHERE ((SAM_COMMENTS.fPersonalScore > :score)) ORDER BY fDiscussDate DESC,fPersonalScore DESC LIMIT 0, 5
--> sql: SELECT  SAM_COMMENTS.fID AS SAM_COMMENTS, SAM_COMMENTS.FASSETID AS fAssetId, SAM_AssetDiscuss.FASSETNAME AS fAssetName, SAM_COMMENTS.FCOMMENT AS fComment, SAM_COMMENTS.FDISCUSSDATE AS fDiscussDate, SAM_COMMENTS.FDISCUSSANT AS fDiscussant, SAM_COMMENTS.FDISCUSSANTID AS fDiscussantId, SAM_COMMENTS.FPARENTID AS fParentId, SAM_COMMENTS.FPERSONALSCORE AS fPersonalScore, SAM_ASSET.FVERSIONNUMBER AS fVersionNumber, SAM_COMMENTS.VERSION AS version FROM SAM_COMMENTS SAM_COMMENTS LEFT JOIN SAM_ASSETDISCUSS SAM_AssetDiscuss ON SAM_COMMENTS.FPARENTID = SAM_AssetDiscuss.fID LEFT JOIN SAM_ASSET SAM_ASSET ON SAM_COMMENTS.FASSETID = SAM_ASSET.fID  WHERE SAM_COMMENTS.FPERSONALSCORE >  ?   ORDER BY fDiscussDate DESC, fPersonalScore DESC
--> binds: [3]
    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)
    ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  SAM_COMMENTS.fID AS SAM_COMMENTS, SAM_COMMENTS.FASSETID AS fAssetId, SAM_AssetDiscuss.FASSETNAME AS fAssetName, SAM_COMMENTS.FCOMMENT AS fComment, SAM_COMMENTS.FDISCUSSDATE AS fDiscussDate, SAM_COMMENTS.FDISCUSSANT AS fDiscussant, SAM_COMMENTS.FDISCUSSANTID AS fDiscussantId, SAM_COMMENTS.FPARENTID AS fParentId, SAM_COMMENTS.FPERSONALSCORE AS fPersonalScore, SAM_ASSET.FVERSIONNUMBER AS fVersionNumber, SAM_COMMENTS.VERSION AS version FROM SAM_COMMENTS SAM_COMMENTS LEFT JOIN SAM_ASSETDISCUSS SAM_AssetDiscuss ON SAM_COMMENTS.FPARENTID = SAM_AssetDiscuss.fID LEFT JOIN SAM_ASSET SAM_ASSET ON SAM_COMMENTS.FASSETID = SAM_ASSET.fID  WHERE SAM_COMMENTS.FPERSONALSCORE >  ?   ORDER BY fDiscussDate DESC, fPersonalScore DESC, binds: [3]出错
    at com.justep.exception.BusinessException.create(Unknown Source)
    at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
    ... 31 more

qweasdzxc

qweasdzxc 发表于 2017-4-5 20:15
2017-04-05 20:05:03 执行sql: insert into SA_Log  (sProcessName, sStatusName, sActivity, sAction, s ...

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)
    ... 32 more

jishuang

http://docs.wex5.com/bex5-deploy-question-list-4011/