工作流被死锁

从昨天开始部分单据工作流审核出现死锁的情况

发生时间： 2014-10-14 09:17:30
错误编号： BOS_ExecuteScalar
错误信息： 事务(进程 ID 63)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。
Sql语句： SELECT count(DISTINCT T_WF_ASSIGN.FACTINSTID) FROM T_WF_ASSIGN INNER JOIN T_WF_RECEIVER ON T_WF_ASSIGN.FASSIGNID = T_WF_RECEIVER.FASSIGNID INNER JOIN T_WF_PROCINST ON T_WF_ASSIGN.FPROCINSTID = T_WF_PROCINST.FPROCINSTID INNER JOIN T_WF_ACTINST ON T_WF_ASSIGN.FACTINSTID = T_WF_ACTINST.FACTINSTID INNER JOIN T_WF_APPROVALASSIGN ON T_WF_ASSIGN.FASSIGNID = T_WF_APPROVALASSIGN.FASSIGNID LEFT OUTER JOIN T_WF_APPROVALITEM ON (T_WF_APPROVALASSIGN.FAPPROVALASSIGNID = T_WF_APPROVALITEM.FAPPROVALASSIGNID AND T_WF_RECEIVER.FRECEIVERID = T_WF_APPROVALITEM.FRECEIVERID) WHERE ((((T_WF_ASSIGN.FSTATUS = '0' AND T_WF_ACTINST.FSTATUS = '2') AND T_WF_PROCINST.FSTATUS = '2') AND ((T_WF_APPROVALITEM.FAPPROVALITEMID IS NULL) OR T_WF_APPROVALITEM.FSTATUS = '0')) AND T_WF_RECEIVER.freceiverid = @FReceiverId)
===================================================
调用堆栈：
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteScalar(DbCommand command, SqlParam[] paramList)
at Kingdee.BOS.App.Data.DBUtils.ExecuteScalar[T](Context ctx, String strSql, T defaultValue, SqlParam[] paramList)
at Kingdee.BOS.Workflow.App.Core.CenterService.ReadAssign(Context ctx, Int64 userId, CenterInfo& centerInfo)
at Kingdee.BOS.Workflow.App.Core.CenterService.GetPersonalCenterInfo(Context ctx, Int64 userId)
at Kingdee.BOS.Workflow.ServiceHelper.CenterServiceHelper.GetPersonalCenterInfo(Context ctx, Int64 userId)
at Kingdee.BOS.Workflow.PlugIns.AssignmentList.RefreshLeftTree()
at Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireAfterBindData(EventArgs e)
at Kingdee.BOS.Web.List.ListView.GetListData()
at Kingdee.BOS.Web.List.ListView.ShowListFilter()
at Kingdee.BOS.Web.List.ListView.LoadData()
at Kingdee.BOS.Web.List.ListView.OnRefresh()
at Kingdee.BOS.Web.DynamicForm.AbstractDynamicWebFormView.Refresh()
at Kingdee.BOS.Workflow.PlugIns.AssignApprovalBaseEdit.BeforeClosed(BeforeClosedEventArgs e)
at Kingdee.BOS.Workflow.PlugIns.AssignmentApproval.BeforeClosed(BeforeClosedEventArgs e)
at Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireBeforeClosed(BeforeClosedEventArgs e)
at Kingdee.BOS.Web.DynamicForm.AbstractDynamicWebFormView.Close()
at Kingdee.BOS.Workflow.PlugIns.AssignmentApproval.SubmitAssignment(Nullable`1 postId, OperateOption option)
at Kingdee.BOS.Workflow.PlugIns.AssignApprovalBaseEdit.Submit(OperateOption option)
at Kingdee.BOS.Workflow.PlugIns.AssignmentApproval.BarItemClick(BarItemClickEventArgs e)
at Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireBarItemClick(BarItemClickEventArgs e)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.BarItemClick(String parentKey, String barItemKey, BarDataManager bar, Int32 bartype)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.MainBarItemClick(String barItemKey)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.MainBarItemClick(String itemKey, JSONArray postDatas)
不是每张都会出现