起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 4225|回复: 3

[结贴] 任务中心错误:无法从套接字读取更多的数据

[复制链接]

184

主题

707

帖子

2333

积分

金牌会员

Rank: 6Rank: 6

积分
2333
QQ
发表于 2015-10-16 11:34:13 | 显示全部楼层 |阅读模式
版本: BeX5V3.1 小版本号:
数据库: Oracle 服务器操作系统: Windows 应用服务器: Tomcat
客户端操作系统: Windows 7 浏览器: Chrome
本帖最后由 silence 于 2015-10-16 14:13 编辑

在任务中心中查看待办任务和提交任务,页面弹出错误提示。后台日志如下:
2015-10-16 11:30:16 excute stream action, params:{"accept":"application/json","action":"queryTaskCenterAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"SA_Task,sAIActive,sAIID,sAIStatusID,sAIStatusName,sActive,sActivity,sActivityInTemplate,sActivityName,sActivityNames,sActualFinishTime,sActualStartTime,sCURL,sCatalogID,sCode,sContent,sCreateTime,sCreatorDeptID,sCreatorDeptName,sCreatorFID,sCreatorFName,sCreatorOgnID,sCreatorOgnName,sCreatorPersonID,sCreatorPersonName,sCreatorPosID,sCreatorPosName,sCustomerID,sCustomerName,sData1,sData2,sData3,sData4,sDistributeTime,sEBField51,sEBField52,sEBField53,sEBField54,sEDField21,sEDField22,sEDField23,sEDField24,sEIField41,sEIField42,sEIField43,sEIField44,sENField11,sENField12,sENField13,sENField14,sESField01,sESField02,sESField03,sESField04,sESField05,sESField06,sESField07,sESField08,sETField31,sETField32,sETField33,sETField34,sEURL,sEmergencyID,sEmergencyName,sExecuteMode,sExecuteMode2,sExecuteTime,sExecutorDeptID,sExecutorDeptName,sExecutorFID,sExecutorFName,sExecutorNames,sExecutorOgnID,sExecutorOgnName,sExecutorPersonID,sExecutorPersonName,sExecutorPosID,sExecutorPosName,sExpectFinishTime,sExpectStartTime,sFlowID,sFrontID,sHints,sImportanceID,sImportanceName,sKindID,sLastModifyTime,sLimitTime,sLock,sName,sParent,sPlanID,sPlanName,sPreemptMode,sProcess,sProcessName,sProcessTemplateID,sProcessTemplateID2,sProcessTemplateItemSequence,sProjectID,sProjectName,sRemark,sRemindMode,sResponsible,sSequence,sShortcut,sSourceID,sStatusID,sStatusName,sSummary,sTempPermissionID,sTypeID,sTypeName,sVariable,sWarningTime,sWithdraw,version","limit":20,"offset":0,"orderBy":"sCreateTime DESC","org":"CA937B2D192E497C81575DFD2F708666","status":"submited","variables":{}},"process":"/SA/task/taskCenter/taskCenterProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"SA_Task","sequence":"SA_Task,sAIActive,sAIID,sAIStatusID,sAIStatusName,sActive,sActivity,sActivityInTemplate,sActivityName,sActivityNames,sActualFinishTime,sActualStartTime,sCURL,sCatalogID,sCode,sContent,sCreateTime,sCreatorDeptID,sCreatorDeptName,sCreatorFID,sCreatorFName,sCreatorOgnID,sCreatorOgnName,sCreatorPersonID,sCreatorPersonName,sCreatorPosID,sCreatorPosName,sCustomerID,sCustomerName,sData1,sData2,sData3,sData4,sDistributeTime,sEBField51,sEBField52,sEBField53,sEBField54,sEDField21,sEDField22,sEDField23,sEDField24,sEIField41,sEIField42,sEIField43,sEIField44,sENField11,sENField12,sENField13,sENField14,sESField01,sESField02,sESField03,sESField04,sESField05,sESField06,sESField07,sESField08,sETField31,sETField32,sETField33,sETField34,sEURL,sEmergencyID,sEmergencyName,sExecuteMode,sExecuteMode2,sExecuteTime,sExecutorDeptID,sExecutorDeptName,sExecutorFID,sExecutorFName,sExecutorNames,sExecutorOgnID,sExecutorOgnName,sExecutorPersonID,sExecutorPersonName,sExecutorPosID,sExecutorPosName,sExpectFinishTime,sExpectStartTime,sFlowID,sFrontID,sHints,sImportanceID,sImportanceName,sKindID,sLastModifyTime,sLimitTime,sLock,sName,sParent,sPlanID,sPlanName,sPreemptMode,sProcess,sProcessName,sProcessTemplateID,sProcessTemplateID2,sProcessTemplateItemSequence,sProjectID,sProjectName,sRemark,sRemindMode,sResponsible,sSequence,sShortcut,sSourceID,sStatusID,sStatusName,sSummary,sTempPermissionID,sTypeID,sTypeName,sVariable,sWarningTime,sWithdraw,version"},"transformIdcolumn":true,"useNamespace":true}}
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor191.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: 编码: JUSTEP150197; 提示: 查询数据库记录数时出错, sql: SELECT count(*) FROM SA_Task SA_Task  WHERE  (SA_Task.SCREATORPERSONID =  ? ) AND (SA_Task.SEXECUTORFID LIKE ?) AND ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) , binds: [CA937B2D192E497C81575DFD2F708666, /%, tesReady, tesExecuting]
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableImpl.countInDB(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at TaskProcedure.taskQuery(TaskProcedure.java:35)
        ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT count(*) FROM SA_Task SA_Task  WHERE  (SA_Task.SCREATORPERSONID =  ? ) AND (SA_Task.SEXECUTORFID LIKE ?) AND ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) , binds: [CA937B2D192E497C81575DFD2F708666, /%, tesReady, tesExecuting]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 29 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)
        ... 30 more
2015-10-16 11:31:27 action:<?xml version="1.0" encoding="UTF-8"?>
<actions><action process="/longwayOA/financialModule/process/commonReimbursement/commonReimbursementProcess" activity="businessActivity2" name="getSysParamsAction" executor="" execute-context="" content-type="application/xml"><parameters/></action><action process="/longwayOA/financialModule/process/commonReimbursement/commonReimbursementProcess" activity="businessActivity2" name="queryTaskDataAction" executor="" execute-context="" content-type="application/xml"><parameters><parameter name="task"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">A2ADA5CEF7134EB5B902F788473A5AC5</xbiz:simple></parameter></parameters></action></actions>
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor192.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 task.sParent, task.sData1, task.sData2, task.sData3, task.sData4 from SA_Task task where task=:task
--> sql: SELECT  task.sParentID AS sParent, task.SDATA1 AS sData1, task.SDATA2 AS sData2, task.SDATA3 AS sData3, task.SDATA4 AS sData4 FROM SA_Task task  WHERE task.sID =  ?
--> binds: [A2ADA5CEF7134EB5B902F788473A5AC5]
        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 ProcessProcedure.getTaskData(ProcessProcedure.java:528)
        at ProcessProcedure.queryTaskData(ProcessProcedure.java:509)
        ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  task.sParentID AS sParent, task.SDATA1 AS sData1, task.SDATA2 AS sData2, task.SDATA3 AS sData3, task.SDATA4 AS sData4 FROM SA_Task task  WHERE task.sID =  ? , binds: [A2ADA5CEF7134EB5B902F788473A5AC5]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 32 more
Caused by: java.sql.SQLException: OALL8 处于不一致状态
        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.T4C8Oall.marshal(T4C8Oall.java:352)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:199)
        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)
        ... 33 more
2015-10-16 11:31:34 excute stream action, params:{"accept":"application/json","action":"querySubmitTask2Action","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"SA_Task,sActivity,sCURL,sCreateTime,sCreatorFName,sData1,sData2,sData3,sData4,sExecutorFID,sExecutorFName,sExecutorNames,sName,sProcess","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,sCURL,sCreateTime,sCreatorFName,sData1,sData2,sData3,sData4,sExecutorFID,sExecutorFName,sExecutorNames,sName,sProcess"},"transformIdcolumn":true,"useNamespace":true}}
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor182.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 SA_Task.*  FROM SA_Task SA_Task WHERE ((SA_Task.sStatusID='tesReady' or SA_Task.sStatusID='tesExecuting')  and SA_Task.sExecutorFID like '/%' and (SA_Task.sCreatorPersonID=:_cpid)) ORDER BY sCreateTime DESC LIMIT 0, 5
--> sql: SELECT  SA_Task.sID AS SA_Task, SA_Task.SACTIVITY AS sActivity, SA_Task.SCURL AS sCURL, SA_Task.SCREATETIME AS sCreateTime, SA_Task.SCREATORFNAME AS sCreatorFName, SA_Task.SDATA1 AS sData1, SA_Task.SDATA2 AS sData2, SA_Task.SDATA3 AS sData3, SA_Task.SDATA4 AS sData4, SA_Task.SEXECUTORFID AS sExecutorFID, SA_Task.SEXECUTORFNAME AS sExecutorFName, SA_Task.SEXECUTORNAMES AS sExecutorNames, SA_Task.SNAME AS sName, SA_Task.SPROCESS AS sProcess FROM SA_Task SA_Task  WHERE  ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND (SA_Task.SEXECUTORFID LIKE ?) AND (SA_Task.SCREATORPERSONID =  ? )   ORDER BY sCreateTime DESC
--> binds: [tesReady, tesExecuting, /%, 3FD16CB667724ADEB851539148E8BE76]
        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 TaskViewProcedure.querySubmitTask2(TaskViewProcedure.java:119)
        ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  SA_Task.sID AS SA_Task, SA_Task.SACTIVITY AS sActivity, SA_Task.SCURL AS sCURL, SA_Task.SCREATETIME AS sCreateTime, SA_Task.SCREATORFNAME AS sCreatorFName, SA_Task.SDATA1 AS sData1, SA_Task.SDATA2 AS sData2, SA_Task.SDATA3 AS sData3, SA_Task.SDATA4 AS sData4, SA_Task.SEXECUTORFID AS sExecutorFID, SA_Task.SEXECUTORFNAME AS sExecutorFName, SA_Task.SEXECUTORNAMES AS sExecutorNames, SA_Task.SNAME AS sName, SA_Task.SPROCESS AS sProcess FROM SA_Task SA_Task  WHERE  ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND (SA_Task.SEXECUTORFID LIKE ?) AND (SA_Task.SCREATORPERSONID =  ? )   ORDER BY sCreateTime DESC, binds: [tesReady, tesExecuting, /%, 3FD16CB667724ADEB851539148E8BE76]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 31 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)
        ... 32 more
2015-10-16 11:31:37 执行sql: insert into SA_Log  (sCreatorPersonID, sCreatorOgnName, sDeviceType, sCreatorFName, version, sProcess, sParameters, sCreatorDeptID, sDescription, sActivity, sCreatorPosID, sCreateTime, sProcessName, sCreatorOgnID, sCreatorFID, sOperatingSystem, sCreatorPosName, sActivityName, sCreatorDeptName, sStatusName, sCreatorPersonName, SID, sActionName, sTypeName, sResult, sIP, sAction, $clientName) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, $clientValue), binds: [1250BEAEEC3247929A2859CE27803639, 朗威电子, Computer, /朗威电子/市场营销中心/市场一部/销售一部/高级业务经理/张婷婷, 0, /SA/OPM/system/systemProcess, 参数名称: sessionID
参数值: {"value":"A9A863D84B847B2E920B0C66DACE3C14"}
, 280A6705F7AF475DAEAF4C7CC27A93B1, null, mainActivity, ADF9A3EEB15C41EAB383D95F15ADC897, 2015-10-16 11:31:37.692, 系统调用, ORG01, /ORG01.ogn/36BDE27292A14998968ABDCBA8DFE64F.dpt/E51581850A6C4E3EABECD91CFE909C58.dpt/280A6705F7AF475DAEAF4C7CC27A93B1.dpt/ADF9A3EEB15C41EAB383D95F15ADC897.pos/1250BEAEEC3247929A2859CE27803639@ADF9A3EEB15C41EAB383D95F15ADC897.psm, WINDOWS_VISTA, 高级业务经理, 系统, 销售一部, 失败, 张婷婷, 45C1D5BB35AC41E18B1A11CBE7B4A53A, 退出, 操作日志, , 124.202.191.168, logoutAction]失败
java.sql.SQLException: OALL8 处于不一致状态
        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.T4C8Oall.marshal(T4C8Oall.java:352)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:199)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:952)
        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.log.LogUtils.a(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.a(Unknown Source)
        at com.justep.system.interceptor.LogBefore.c(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 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)

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36069
发表于 2015-10-16 16:43:55 | 显示全部楼层
java.sql.SQLException: OALL8 处于不一致状态

java.sql.SQLException: 无法从套接字读取更多的数据都是数据库的标准错误可以到网上查找可能是什么原因导致的错误
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

184

主题

707

帖子

2333

积分

金牌会员

Rank: 6Rank: 6

积分
2333
QQ
 楼主| 发表于 2015-10-21 14:26:49 | 显示全部楼层
jishuang 发表于 2015-10-16 16:43
java.sql.SQLException: OALL8 处于不一致状态

java.sql.SQLException: 无法从套接字读取更多的数据都是数 ...

解决,谢谢!
回复 支持 反对

使用道具 举报

66

主题

152

帖子

463

积分

中级会员

Rank: 3Rank: 3

积分
463
QQ
发表于 2020-8-20 14:39:07 | 显示全部楼层

咋解决的,兄弟
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-11-25 17:21 , Processed in 0.097082 second(s), 25 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表