快捷切换组织时报错,求教?
错误信息:Sql execute exception : select top 5 a.FID,FName_l2,fnumber from t_org_baseunit a join t_pm_orgrange b on a.fid=b.forgid join t_bas_switchorgrecord c on a.fid=c.forgid and b.fuserid=c.fuserid where b.ftype=10 and b.fuserid= ? and a.FIsUnion = 0 and a.FIsAssistantOrg=0 order by c.FLastUserTime desc,a.flongnumber asc
Caused exception message is: 无法从套接字读取更多的数据
错误详细堆栈信息:com.kingdee.bos.BOSException: Sql execute exception : select top 5 a.FID,FName_l2,fnumber from t_org_baseunit a join t_pm_orgrange b on a.fid=b.forgid join t_bas_switchorgrecord c on a.fid=c.forgid and b.fuserid=c.fuserid where b.ftype=10 and b.fuserid= ? and a.FIsUnion = 0 and a.FIsAssistantOrg=0 order by c.FLastUserTime desc,a.flongnumber asc
Caused exception message is: 无法从套接字读取更多的数据
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:226)
at com.kingdee.eas.base.myeas.app.MyEasFacadeControllerBean._getFastSwitchOrgs(MyEasFacadeControllerBean.java:37)
at com.kingdee.eas.base.myeas.app.AbstractMyEasFacadeControllerBean.getFastSwitchOrgs(AbstractMyEasFacadeControllerBean.java:45)
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:585)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:61)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy129.getFastSwitchOrgs(Unknown Source)
at com.kingdee.eas.base.myeas.MyEasFacade.getFastSwitchOrgs(MyEasFacade.java:44)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_myeas_1_IMyEasFacade.pi4(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_myeas_1_IMyEasFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:611)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)
Caused by: java.sql.SQLException: 无法从套接字读取更多的数据
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1122)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1074)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:479)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:809)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:849)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1125)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3383)
at com.kingdee.bos.sql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:294)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:210)
... 21 more
Caused by: java.sql.SQLException
java.sql.SQLException: 无法从套接字读取更多的数据
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1122)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1074)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:479)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:809)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:849)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1125)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3383)
at com.kingdee.bos.sql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:294)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:210)
at com.kingdee.eas.base.myeas.app.MyEasFacadeControllerBean._getFastSwitchOrgs(MyEasFacadeControllerBean.java:37)
at com.kingdee.eas.base.myeas.app.AbstractMyEasFacadeControllerBean.getFastSwitchOrgs(AbstractMyEasFacadeControllerBean.java:45)
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:585)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:61)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy129.getFastSwitchOrgs(Unknown Source)
at com.kingdee.eas.base.myeas.MyEasFacade.getFastSwitchOrgs(MyEasFacade.java:44)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_myeas_1_IMyEasFacade.pi4(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_myeas_1_IMyEasFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:611)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)
应该是数据库问题,BOS起的快测,在测试库中快捷切换组织就会出现问题,但在正式库时快捷切换组织就没有问题
可能是数据库连接问题,也可能是表空间不足。
1、新建一个临时表空间
2、将当前用户的临时表空间切换到新建的临时表空间上
你的问题建议提单来处理。
快捷切换组织时报错,求教?
本文2024-09-16 23:03:12发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-52108.html