MRP 运算报错 事务(进程 ID 104)与另一个进程被死锁在 锁 资...
金蝶云社区-余伟强
余伟强
1人赞赏了该文章 1321次浏览 未经作者许可,禁止转载编辑于2016年04月11日 11:56:32

打了最新补丁后 经常报错:
补丁版本:K/3_Cloud_K3Cloud智造服务平台.V5.0_BOS平台_全局(PT102021)_周期综合补丁

source: IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE UPPER(KSQL_COL_TABNAME) = 'T_ENG_BOMEXPANDSOURCE_D' AND UPPER(KSQL_COL_NAME) IN ('FWORKSHOPID_REG'))
ALTER TABLE T_ENG_BOMEXPANDSOURCE_D ADD ( FWORKSHOPID_REG bigint default 0
);

message:事务(进程 ID 104)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
stacktrace:
Server stack trace:
at Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 sqlArray, Int32 batchSize)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Kingdee.BOS.Contracts.IDBService.ExecuteBatch(Context ctx, List`1 sqlArray)
at Kingdee.K3.MFG.ENG.App.Core.BomExpandMemService.ExpandBomForward(Context ctx, List`1 lstBomOpenSource, MemBomExpandOption option, AbstractBomExpandStrategy bomExpandStrategy)
at Kingdee.K3.MFG.ENG.App.Core.BomExpandMemService.ExpandBomForward(Context ctx, List`1 lstBomOpenSource, MemBomExpandOption option)
at Kingdee.K3.MFG.PLN.App.MrpModel.PolicyImpl.NetCalc.DelayDemandStrategy.CreateDelayDemandByVirtualMtrl.CreateMrpDelayDemandData(Object mrpDemandData, DynamicObject planOrderData)
at Kingdee.K3.MFG.PLN.App.MrpModel.PolicyImpl.NetCalc.DelayDemandStrategy.CreateDelayDemandByVirtualMtrl.ProcessVirtualMtrlDelayDemand()
at Kingdee.K3.MFG.PLN.App.MrpModel.PolicyImpl.NetCalc.DelayDemandStrategy.CreateDelayDemandByVirtualMtrl.OnExecuteSubLogicUnit()
at Kingdee.K3.MFG.PLN.App.MrpModel.PolicyImpl.NetCalc.UpdateParentPLBomPolicy.OnExecuteDataPolicy()
at Kingdee.K3.MFG.PLN.App.MrpModel.AbstractMrpDataPolicy.Execute()
at Kingdee.K3.MFG.PLN.App.MrpModel.LogicUnitImpl.Mrp.NetCalcLogicUnit.DoFirstSingleDataPolicy(MrpDemandDimContext mrpDemandDimContext)
at Kingdee.K3.MFG.PLN.App.MrpModel.Log