点即时库存时会出错,错识如下:
563次浏览
编辑于2015年12月22日 15:06:19
点即时库存时会出错,错识如下:
[{"operation":"STK_InvSumQuery_List.LoadData"}]
发生时间: 2015-12-22 03:00:41
错误编号: ExecuteBatch
错误信息: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Sql语句: SELECT t0.FQTY As FQTY,t0.FSTOCKUNITID As FSTOCKUNITID,t0.FBASEUNITID As FBASEUNITID,t0.FBASEQTY As FBASEQTY,t0.FSECQTY As FSECQTY,t0.FSECUNITID As FSECUNITID,t0.FLOCKQTY As FLOCKQTY,t0.FBASELOCKQTY As FBASELOCKQTY,t0.FSECLOCKQTY As FSECLOCKQTY,t0.FAVBQTY As FAVBQTY,t0.FBASEAVBQTY As FBASEAVBQTY,t0.FSECAVBQTY As FSECAVBQTY,t0.FMATERIALID As FMATERIALID,t0.FSTOCKID As FSTOCKID,t0.FLOT As FLOT,t0.FSTOCKORGID As FSTOCKORGID,st014.FPRECISION As FStockUnitId_FPrecision,t0.FOBJECTTYPEID As FOBJECTTYPEID,t0.FID As FID,ROW_NUMBER() OVER(ORDER BY t0.FID ) fidentityid INTO TMPA1FF89BBA87911E5895542F2E99
FROM T_STK_INVENTORY t0 LEFT JOIN
T_BD_UNIT st014 ON (t0.FSTOCKUNITID=st014.FUNITID)
WHERE (((t0.FSTOCKORGID = 0 OR (t0.FSTOCKORGID IN (100001) AND t0.FSTOCKORGID IN (1, 100001, 100002, 100003))) AND ((t0.FBASEQTY <> 0) OR (t0.FSECQTY <> 0))))
AND
t0.FOBJECTTYPEID = 'STK_Inventory'
CREATE INDEX IDX_TMPA1FF89BBA8 ON TMPA1FF89BBA87911E5895542F2E99(fidentityid)
CREATE INDEX IDX_TMPA1FF89BBA8_Pk ON TMPA1FF89BBA87911E5895542F2E99(FID)
DELETE FROM TMPA1FF89BBA87911E5895542F2E99 WHERE EXISTS(SELECT 1 FROM T_BD_LOTMASTER T1 INNER JOIN T_STK_INVENTORY T2 ON T1.FLOTID = T2.FLOT WHERE T1.FCANCELSTATUS = 'B' AND TMPA1FF89BBA87911E5895542F2E99.FID = T2.FID )
===================================================
调用堆栈:
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)
at Kingdee.K3.SCM.App.Core.StockInvService.FillInvSumQueryData(Context ctx, Dictionary`2 para)
at Kingdee.K3.SCM.ServiceHelper.StockServiceHelper.FillInvSumQueryData(Context ctx, Dictionary`2 para)
at Kingdee.K3.SCM.Stock.Business.PlugIn.InvSumQueryList.BuildSumVewData(String queryFilter, Int32 maxRowCount)
at Kingdee.K3.SCM.Stock.Business.PlugIn.InvSumQueryList.PrepareFilterParameter(FilterArgs e)
at Kingdee.BOS.Core.List.PlugIn.ListModelPlugInProxy.FirePrepareFilterParameter(FilterArgs e)
at Kingdee.BOS.Model.List.ListModel.CreateSqlBuilderParameter()
at Kingdee.BOS.Model.List.ListModel.CreateSqlBuilder()
at Kingdee.BOS.Web.List.ListView.ShowListFilter()
at Kingdee.BOS.Web.List.ListView.LoadData()
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.LoadData()
[{"operation":"STK_InvSumQuery_List.LoadData"}]
发生时间: 2015-12-22 03:00:41
错误编号: ExecuteBatch
错误信息: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Sql语句: SELECT t0.FQTY As FQTY,t0.FSTOCKUNITID As FSTOCKUNITID,t0.FBASEUNITID As FBASEUNITID,t0.FBASEQTY As FBASEQTY,t0.FSECQTY As FSECQTY,t0.FSECUNITID As FSECUNITID,t0.FLOCKQTY As FLOCKQTY,t0.FBASELOCKQTY As FBASELOCKQTY,t0.FSECLOCKQTY As FSECLOCKQTY,t0.FAVBQTY As FAVBQTY,t0.FBASEAVBQTY As FBASEAVBQTY,t0.FSECAVBQTY As FSECAVBQTY,t0.FMATERIALID As FMATERIALID,t0.FSTOCKID As FSTOCKID,t0.FLOT As FLOT,t0.FSTOCKORGID As FSTOCKORGID,st014.FPRECISION As FStockUnitId_FPrecision,t0.FOBJECTTYPEID As FOBJECTTYPEID,t0.FID As FID,ROW_NUMBER() OVER(ORDER BY t0.FID ) fidentityid INTO TMPA1FF89BBA87911E5895542F2E99
FROM T_STK_INVENTORY t0 LEFT JOIN
T_BD_UNIT st014 ON (t0.FSTOCKUNITID=st014.FUNITID)
WHERE (((t0.FSTOCKORGID = 0 OR (t0.FSTOCKORGID IN (100001) AND t0.FSTOCKORGID IN (1, 100001, 100002, 100003))) AND ((t0.FBASEQTY <> 0) OR (t0.FSECQTY <> 0))))
AND
t0.FOBJECTTYPEID = 'STK_Inventory'
CREATE INDEX IDX_TMPA1FF89BBA8 ON TMPA1FF89BBA87911E5895542F2E99(fidentityid)
CREATE INDEX IDX_TMPA1FF89BBA8_Pk ON TMPA1FF89BBA87911E5895542F2E99(FID)
DELETE FROM TMPA1FF89BBA87911E5895542F2E99 WHERE EXISTS(SELECT 1 FROM T_BD_LOTMASTER T1 INNER JOIN T_STK_INVENTORY T2 ON T1.FLOTID = T2.FLOT WHERE T1.FCANCELSTATUS = 'B' AND TMPA1FF89BBA87911E5895542F2E99.FID = T2.FID )
===================================================
调用堆栈:
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)
at Kingdee.K3.SCM.App.Core.StockInvService.FillInvSumQueryData(Context ctx, Dictionary`2 para)
at Kingdee.K3.SCM.ServiceHelper.StockServiceHelper.FillInvSumQueryData(Context ctx, Dictionary`2 para)
at Kingdee.K3.SCM.Stock.Business.PlugIn.InvSumQueryList.BuildSumVewData(String queryFilter, Int32 maxRowCount)
at Kingdee.K3.SCM.Stock.Business.PlugIn.InvSumQueryList.PrepareFilterParameter(FilterArgs e)
at Kingdee.BOS.Core.List.PlugIn.ListModelPlugInProxy.FirePrepareFilterParameter(FilterArgs e)
at Kingdee.BOS.Model.List.ListModel.CreateSqlBuilderParameter()
at Kingdee.BOS.Model.List.ListModel.CreateSqlBuilder()
at Kingdee.BOS.Web.List.ListView.ShowListFilter()
at Kingdee.BOS.Web.List.ListView.LoadData()
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.LoadData()
推荐阅读