请教大神看看这个问题怎么解决
1人赞赏了该文章
479次浏览
编辑于2019年05月08日 18:17:43
错误信息: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: 等待用于页 (1:786463),数据库 ID 7 的缓冲区闩锁类型 2 时发生超时。
错误详细堆栈信息: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: 等待用于页 (1:786463),数据库 ID 7 的缓冲区闩锁类型 2 时发生超时。
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.GeneratedMethodAccessor631.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:64)
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 com.sun.proxy.$Proxy316.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.pi1(
Caused exception message is: 等待用于页 (1:786463),数据库 ID 7 的缓冲区闩锁类型 2 时发生超时。
错误详细堆栈信息: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: 等待用于页 (1:786463),数据库 ID 7 的缓冲区闩锁类型 2 时发生超时。
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.GeneratedMethodAccessor631.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:64)
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 com.sun.proxy.$Proxy316.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.pi1(