直接调拨单保存时报错,调拨物料启用了序列号管理。
报错提示:Timeout 时间已到。在操作完成之前超时时间已过或服务器未响应。语句已终止。
发生时间: 2017-07-06 04:18:00
错误编号: ExecuteBatch
错误信息: Timeout 时间已到。在操作完成之前超时时间已过或服务器未响应。
语句已终止。
Sql语句: /*dialect*/
UPDATE IT SET IT.FPREINVID = IT2.FINVID
FROM #TM_BD_UPSERIALMASTER IT INNER JOIN (SELECT ISNULL(T0.FINVID, '') AS FINVID,T0.FSERIALID,T0.FBILLTRACEID
FROM T_BD_SERIALBILLTRACE T0 INNER JOIN (SELECT MAX(TM.FBILLTRACEID) AS FBILLTRACEID,TM.FSERIALID
FROM T_BD_SERIALBILLTRACE TM WHERE NOT EXISTS (SELECT 1 FROM #TM_BD_UPSERIALMASTER TP WHERE TP.FBILLTRACEID = TM.FBILLTRACEID)
GROUP BY TM.FSERIALID) TG ON T0.FBILLTRACEID = TG.FBILLTRACEID) IT2
ON IT2.FSERIALID = IT.FSERIALID
WHERE IT.FBILLTRACEID = 0;
===================================================
调用堆栈:
Server stack trace:
在 Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 sqlArray, Int32 batchSize)
在 Kingdee.K3.BD.App.Core.AppBusinessService.SerialMasterUpdator.MatchSerialToTempTable()
在 Kingdee.K3.BD.App.Core.AppBusinessService.SerialMasterUpdator.DoUpdateAction(DynamicObject billDataEntity)
在 Kingdee.K3.BD.App.Core.AppBusinessService.SaveBillSerialService.DoAction(AppBusinessServiceArgs e)
在 Kingdee.BOS.App.Core.AbstractOprerationService.ExecuteFormBusinessService(IAppFormBusinessService iBusiness, DynamicObject dataObject, FormBusinessService service)
在 Kingdee.BOS.App.Core.AbstractOprerationService.InvokeFormBusiness(DynamicObject[] objs, Int32 iActionPoint)
在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperation(DynamicObject[]& objs)
在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperatinTransaction(DynamicObject[] objs)
在 Kingdee.BOS.App.Core.AbstractOprerationService.DoExcete()
在 Kingdee.BOS.App.Core.AbstractOprerationService.Excute(DynamicObject[] dataEntities)
在 Kingdee.BOS.App.Core.SaveService.Save(Context ctx, BusinessInfo info, DynamicObject[] dataEntities, OperateOption option, String operationNumber)
Exception rethrown at [0]:
在 Kingdee.BOS.ServiceHelper.BusinessDataServiceHelper.Save(Context ctx, BusinessInfo businessInfo, DynamicObject dataObject, OperateOption option, String operationNumber)
在 Kingdee.BOS.Model.Bill.BillModel.Save(OperateOption option)
在 Kingdee.BOS.Business.Bill.Operation.Save.ExecuteBillOperation(OperateOption option)
在 Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormOperation.Operation(CallBackWfAfterOperation callbackwf, IOperationResult result)
1.png(47.71KB)
推荐阅读