[步骤]
[16:57:54] -------------------------------------------------------------
CODE:N1657542
Error:21_596_1_-2146232060
SQL:SELECT a.CustomerID,
a.WareHouseID,
SKU,
DATEDIFF(DAY,a.PutTime,GETDATE()) type,
SUM(a.PutInNum) OperateNum
INTO #temp_OperateNum
FROM dbo.RB_WareHouse_Product_PutIn_Log (NOLOCK) a
LEFT JOIN dbo.RB_WareHouse (NOLOCK) b
ON b.CustomerID = a.CustomerID
AND a.WareHouseID = b.ID
WHERE a.CustomerID = @CustomerID
AND a.PutTime >= DATEADD(YEAR, -2,GETDATE())
AND a.PutInNum > 0
GROUP BY DATEDIFF(DAY,a.PutTime,GETDATE()),
a.CustomerID,
a.WareHouseID,
a.SKU
SELECT a.CustomerID,
a.WareHouseID,
a.SKU,
SUM(a.GoodNum+a.LockNum) EndQuantity
INTO #temp_InventoryNum
FROM dbo.RB_WareHouse_Product(NOLOCK) a
LEFT JOIN dbo.RB_WareHouse(NOLOCK) b ON b.CustomerID = a.CustomerID AND a.WareHouseID=b.ID
WHERE a.CustomerID=@CustomerID AND b.WareHouseType=1 AND a.GoodNum+a.LockNum>0 AND a.SKU!=''
GROUP BY a.CustomerID,
a.WareHouseID,a.SKU
CREATE INDEX IX_ID2
ON #temp_OperateNum
( WareHouseID,
SKU
);
SELECT a.WareHouseID,
a.SKU,
a.EndQuantity,b.OperateNum,
b.type,
ISNULL(lastProductNum, 0) lastProductNum,
CASE
WHEN a.EndQuantity - ISNULL(lastProductNum, 0) > 0 AND b.OperateNum>0 THEN
CASE
WHEN a.EndQuantity - ISNULL(lastProductNum, 0) - b.OperateNum > 0 THEN
b.OperateNum
ELSE
a.EndQuantity - ISNULL(lastProductNum, 0)
END
ELSE
-1
END ApportionNum
INTO #temp_ApportionProduct_kl
FROM #temp_InventoryNum (NOLOCK) a
LEFT JOIN #temp_OperateNum b
ON a.WareHouseID = b.WareHouseID
AND a.SKU = b.SKU
OUTER APPLY
(
SELECT SUM(OperateNum) lastProductNum
FROM #temp_OperateNum
WHERE CustomerID = b.CustomerID
AND WareHouseID=b.WareHouseID
AND SKU = b.SKU
AND type < b.type
) c
SELECT t.* INTO #temp_klbg FROM (
SELECT WareHouseID,Sku,type,ApportionNum,EndQuantity FROM #temp_ApportionProduct_kl WHERE ApportionNum>0
UNION ALL
SELECT a.WareHouseID,a.Sku,1000,a.EndQuantity-ISNULL(b.ApportionNum,0),a.EndQuantity FROM #temp_InventoryNum a
LEFT JOIN (SELECT WareHouseID,Sku,SUM(ApportionNum) ApportionNum FROM #temp_ApportionProduct_kl WHERE ApportionNum>0
GROUP BY WareHouseID,Sku) b ON b.WareHouseID = a.WareHouseID AND b.Sku = a.Sku
WHERE a.EndQuantity-ISNULL(b.ApportionNum,0)>0)t
SELECT
ol.SKU,MAX(oi.AddTime) AddTime
INTO #order
FROM
dbo.RB_OrderInfo (NOLOCK) oi
LEFT JOIN rb_orderlist(NOLOCK) ol ON ol.CustomerID = oi.CustomerID AND ol.OrderCode = oi.OrderCode
WHERE
oi.CustomerID = @CustomerID
AND oi.IsStockOrder = 0
AND oi.OrderStatus!=2
AND oi.IsPay=1
-- AND DATEDIFF(d,oi.AddTime,GETDATE()) <= 365
GROUP BY ol.SKU
SELECT
T.SKU,MAX(S.AddTime) AddTime
INTO #xd
FROM
RB_Procurement_Detail_BuyList_Detail T WITH (NOLOCK)
INNER JOIN dbo.RB_Procurement_Detail_BuyList S WITH (NOLOCK) ON T.CustomerID = S.CustomerID
AND T.ListNo = S.ListNo
WHERE
T.CustomerID = @CustomerID
GROUP BY T.SKU
SELECT
AI.SKU,SUM(CASE WHEN w.WareHouseType=1 THEN AI.GoodNum ELSE 0 end)GoodNum,SUM(AI.GoodNum) allGoodNum
INTO #allgood
FROM
dbo.RB_WareHouse_Product AI (NOLOCK)
LEFT JOIN dbo.RB_WareHouse w (NOLOCK) ON w.CustomerID = AI.CustomerID AND AI.WareHouseID=w.ID
WHERE
AI.CustomerID = @CustomerID
AND w.IsActive = 1
GROUP BY AI.SKU
SELECT
a.SKU,
CASE WHEN MAX(type)=1000 THEN '2年以上' ELSE CONVERT(NVARCHAR(10),MAX(type)) end AS '最高库龄'
INTO #zgkl
FROM
#temp_klbg AS a
GROUP BY
a.SKU
SELECT
a.SKU,
a.WareHouseID,
Memo = STUFF((SELECT DISTINCT ',' + c.PositionCode
FROM RB_WareHouse_OneProductMorePosition_Product (NOLOCK) AS b
LEFT JOIN RB_WareHouse_Position (NOLOCK) AS c
ON b.PositionID = c.ID AND b.CustomerID = c.CustomerID AND b.WareHouseID = c.WareHouseID
WHERE a.SKU = b.SKU AND a.WareHouseID = b.WareHouseID
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')
INTO #mod1
FROM
(
SELECT
a.SKU,
a.WareHouseID
FROM
RB_WareHouse_OneProductMorePosition_Product (NOLOCK) AS a
LEFT JOIN RB_WareHouse_Position (NOLOCK) AS b
ON a.PositionID = b.ID AND a.CustomerID = b.CustomerID AND a.WareHouseID = b.WareHouseID
WHERE a.CustomerID = @CustomerID
GROUP BY
a.SKU,
a.WareHouseID
) AS a
SELECT
wh.WareHouseName '仓库',
A.SKU,
sup.SupplierName '默认供应商',
c.ProductNameCN '产品名称',
ISNULL(
CASE
WHEN c.ProductProperty = 0 THEN '未选择'
WHEN c.ProductProperty = 1 THEN '非仿牌'
WHEN c.ProductProperty = 2 AND pa.HasImitationCountry=2 THEN '部分国家仿牌'
WHEN c.ProductProperty = 2 AND pa.HasImitationCountry<>2 THEN '仿牌'
WHEN c.ProductProperty = 3 THEN '灰色产品'
WHEN c.ProductProperty = 4 THEN '疑似仿牌'
END,
''
) '产品侵权风险',
t1.AddTime'最新销单时间',
t.AddTime '最近客户单日期',
CASE WHEN c.LastBuyPrice>0 THEN c.LastBuyPrice ELSE c.LastSupplierPrice END '最新采购价',
a.GoodNum '本仓可用库存',
t3.最高库龄,
ISNULL(A.GoodNum, 0) *CASE WHEN c.LastBuyPrice>0 THEN c.LastBuyPrice ELSE c.LastSupplierPrice END '本仓采购总价',
ISNULL(vt.AllAvgDailySales, 0) '全仓估算日销量',
SUM(
CASE
WHEN wh.WareHouseType = 1 THEN vt.ThreeMonthSaleNum
ELSE 0
END
) OVER (PARTITION BY A.SKU)'本地仓90天销量',
ROUND(
(
CASE
WHEN ISNULL(vt.AllAvgDailySales, 0) = 0 THEN 0
ELSE ISNULL(t2.allGoodNum,0) / vt.AllAvgDailySales
END
),
2
) '全仓可售天数',
ISNULL(pspd.PaymentName,'')账期类型,
CASE sup.SupplierClassification
WHEN 1 THEN 'A类'
WHEN 2 THEN 'B类'
WHEN 3 THEN 'C类'
WHEN 4 THEN 'D类'
WHEN 5 THEN 'E类' ELSE '' END 供应商类型,
pa.BuyerName '采购员',
pa.DevelopAdminName AS '开发员',
ISNULL(e.ClassNameCn,'') 一级品类,
ISNULL(f.ClassNameCn,'') 二级品类,
ISNULL(d.ClassNameCn,'') 三级品类,
-------新增物流属性
(
CASE
WHEN c.WithBattery = 0 THEN '未选择'
WHEN c.WithBattery = 1 THEN '普货'
WHEN c.WithBattery = 2 THEN '纯电池'
WHEN c.WithBattery = 3 THEN '带内置电池'
WHEN c.WithBattery = 4 THEN '带外置电池'
WHEN c.WithBattery = 5 THEN '含纽扣电池'
WHEN c.WithBattery = 6 THEN '液体'
WHEN c.WithBattery = 7 THEN '粉末'
WHEN c.WithBattery = 8 THEN '打火机'
WHEN c.WithBattery = 9 THEN '刀具_剪刀_仿真枪'
WHEN c.WithBattery = 10 THEN '带磁物品'
WHEN c.WithBattery = 12 THEN '木质类_竹质类'
WHEN c.WithBattery = 11 THEN '其他禁运物品'
WHEN c.WithBattery = 13 THEN '膏状'
WHEN c.WithBattery = 14 THEN '易碎'
WHEN c.WithBattery = 15 THEN '动物羽毛类'
WHEN c.WithBattery = 16 THEN '大功率电池'
WHEN c.WithBattery = 17 THEN '电子烟'
WHEN c.WithBattery = 18 THEN '移动电源'
WHEN c.WithBattery = 19 THEN '可拆卸电池'
WHEN c.WithBattery = 20 THEN '厨具'
WHEN c.WithBattery = 21 THEN '电机_马达'
WHEN c.WithBattery = 22 THEN '超体积普'
WHEN c.WithBattery = 23 THEN '超体积非普'
WHEN c.WithBattery = 24 THEN '手机'
WHEN c.WithBattery = 25 THEN '平衡车'
WHEN c.WithBattery = 26 THEN '液体笔类'
WHEN c.WithBattery = 27 THEN '纺织品'
WHEN c.WithBattery = 28 THEN '植物种子'
WHEN c.WithBattery = 29 THEN '深圳普货'
WHEN c.WithBattery = 30 THEN '成人用品'
WHEN c.WithBattery = 31 THEN '无'
WHEN c.WithBattery = 32 THEN '眼镜'
WHEN c.WithBattery = 33 THEN '口红'
WHEN c.WithBattery = 34 THEN '手表'
WHEN c.WithBattery = 35 THEN '香水'
WHEN c.WithBattery = 36 THEN '纯液体'
WHEN c.WithBattery = 37 THEN '医疗设备'
WHEN c.WithBattery = 38 THEN '人造羽毛'
WHEN c.WithBattery = 39 THEN '内置锂金属电池'
WHEN c.WithBattery = 40 THEN '配套干电池'
WHEN c.WithBattery = 41 THEN '厨房刀具'
WHEN c.WithBattery = 42 THEN '军工刀具'
WHEN c.WithBattery = 45 THEN '无线充'
WHEN c.WithBattery = 46 THEN '原木'
WHEN c.WithBattery = 47 THEN '面具类'
WHEN c.WithBattery = 48 THEN '金属高密度'
WHEN c.WithBattery = 49 THEN '防疫用品'
WHEN c.WithBattery = 50 THEN '酒精'
WHEN c.WithBattery = 51 THEN '酒精棉'
WHEN c.WithBattery = 52 THEN '纸巾'
WHEN c.WithBattery = 109 THEN '纯普货'
WHEN c.WithBattery = 110 THEN '尖锐利器'
WHEN c.WithBattery = 111 THEN '无电池电子产品'
WHEN c.WithBattery = 112 THEN '内置纽扣电池'
WHEN c.WithBattery = 113 THEN '内置柱状电池'
WHEN c.WithBattery = 114 THEN '内置块状电池'
WHEN c.WithBattery = 115 THEN '其它内置电池'
WHEN c.WithBattery = 116 THEN '配套纽扣电池'
WHEN c.WithBattery = 117 THEN '配套柱状电池'
WHEN c.WithBattery = 118 THEN '配套块状电池'
WHEN c.WithBattery = 119 THEN '其它配套电池'
WHEN c.WithBattery = 120 THEN '纽扣电池'
WHEN c.WithBattery = 121 THEN '柱状电池'
WHEN c.WithBattery = 122 THEN '块状电池'
WHEN c.WithBattery = 123 THEN '其它纯电池'
WHEN c.WithBattery = 124 THEN '易碎玻璃'
WHEN c.WithBattery = 125 THEN '强磁'
WHEN c.WithBattery = 126 THEN '微量膏体'
WHEN c.WithBattery = 127 THEN '其它膏体'
WHEN c.WithBattery = 128 THEN '微量粉末'
WHEN c.WithBattery = 129 THEN '其它粉末'
WHEN c.WithBattery = 130 THEN '微量液体'
WHEN c.WithBattery = 131 THEN '少量液体'
WHEN c.WithBattery = 132 THEN '较多液体'
WHEN c.WithBattery = 133 THEN '其它液体'
WHEN c.WithBattery = 134 THEN '办公刀具小尺寸'
WHEN c.WithBattery = 135 THEN '办公刀具中尺寸'
WHEN c.WithBattery = 136 THEN '办公刀具大尺寸'
WHEN c.WithBattery = 137 THEN '厨房刀具小尺寸'
WHEN c.WithBattery = 138 THEN '厨房刀具中尺寸'
WHEN c.WithBattery = 139 THEN '厨房刀具大尺寸'
WHEN c.WithBattery = 140 THEN '户外刀具小尺寸'
WHEN c.WithBattery = 141 THEN '户外刀具中尺寸'
WHEN c.WithBattery = 142 THEN '户外刀具大尺寸'
WHEN c.WithBattery = 143 THEN '间谍器材'
WHEN c.WithBattery = 144 THEN '其它易燃易爆'
WHEN c.WithBattery = 145 THEN '管制刀具小尺寸'
WHEN c.WithBattery = 146 THEN '其它管制器具'
WHEN c.WithBattery = 147 THEN '枪支弹药'
WHEN c.WithBattery = 148 THEN '其它禁寄物品'
WHEN c.WithBattery = 150 THEN '其它泛普货'
WHEN c.WithBattery = 151 THEN '虎指'
WHEN c.WithBattery = 152 THEN '甩棍'
WHEN c.WithBattery = 153 THEN '弓弩'
WHEN c.WithBattery = 154 THEN '金属大体积'
WHEN c.WithBattery = 155 THEN '迷你蓝牙耳机'
WHEN c.WithBattery = 156 THEN '其它蓝牙耳机'
WHEN c.WithBattery = 157 THEN '迷你蓝牙音响'
WHEN c.WithBattery = 158 THEN '其它蓝牙音响'
WHEN c.WithBattery = 159 THEN '迷你移动电源'
WHEN c.WithBattery = 160 THEN '其它移动电源'
WHEN c.WithBattery = 161 THEN '其它带磁带电'
WHEN c.WithBattery = 162 THEN '微量固体'
WHEN c.WithBattery = 163 THEN '其它固体'
WHEN c.WithBattery = 164 THEN '打火石'
WHEN c.WithBattery = 165 THEN '指甲油'
WHEN c.WithBattery = 166 THEN '香 水'
WHEN c.WithBattery = 167 THEN '管制刀具中尺寸'
WHEN c.WithBattery = 168 THEN '管制刀具大尺寸'
WHEN c.WithBattery = 169 THEN '微量胶体'
WHEN c.WithBattery = 170 THEN '少量胶体'
WHEN c.WithBattery = 171 THEN '较多胶体'
WHEN c.WithBattery = 172 THEN '其它胶体'
WHEN c.WithBattery = 190 THEN '面膜鼻膜眼膜'
WHEN c.WithBattery = 191 THEN '办公刀具超大尺寸'
WHEN c.WithBattery = 192 THEN '厨房刀具超大尺寸'
WHEN c.WithBattery = 193 THEN '户外刀具超大尺寸'
WHEN c.WithBattery = 194 THEN '管制刀具超大尺寸'
WHEN c.WithBattery = 195 THEN '内电打火机'
WHEN c.WithBattery = 196 THEN '压电打火机'
WHEN c.WithBattery = 197 THEN '火石打火机'
WHEN c.WithBattery = 477 THEN '干电池（纯电池）'
ELSE ''
END
) AS '产品物流属性',
wh2.WareHouseName AS '供应商对应本地仓库',
wh3.WareHouseName AS 'SKU默认本地发货仓库',
--------------------------------------------
ROUND(
(
CASE
WHEN ISNULL(vt.AvgDailySales, 0) = 0 THEN 0
ELSE A.GoodNum /ISNULL(vt.AvgDailySales, 0)
END
),
2
) '本仓可售天数',
ISNULL(vt.CGNUM,0) '采购中',
A.ProtectNum '保护库存',
vt.kcjyNum '库存结余',
ISNULL(t2.GoodNum,0)'本地仓可用库存',
ISNULL(t2.GoodNum,0)*(c.Pack_Length*c.Pack_Width*c.Pack_Height)/1000000
'库存总包装体积（立方米）',
ISNULL(sh.HolidaysName,'') 节假日,
ISNULL(t2.allGoodNum,0) '所有仓库可用库存',
ISNULL(vt.AvgDailySales, 0) '本仓估算日销量',
ROUND(
(
CASE
WHEN ISNULL(vt.AllAvgDailySales, 0) = 0 THEN 0
ELSE ISNULL(t2.GoodNum,0) / (vt.AllAvgDailySales * 1.00)
END
),
2
) '本地全仓可售天数',
vt.Kl '库龄',
(
CASE
ps.ProductVitalityType
WHEN 0 THEN '普通款'
WHEN 1 THEN '爆款'
WHEN 2 THEN '平款'
WHEN 3 THEN '旺款'
WHEN 4 THEN '滞销款'
ELSE ''
END
) AS '产品活跃状态',
vt.LastInOperateTime '最后入库',
vt.LastOutOperateTime '最后出库',
(
CASE
C.ProductState
WHEN 0 THEN '正常'
WHEN 1 THEN '起批量'
WHEN 2 THEN '停产'
WHEN 3 THEN '锁定'
WHEN 4 THEN '暂时缺货'
WHEN 5 THEN '清库'
ELSE ''
END
) '产品状态',
(
CASE
WHEN c.ProductType = 1 THEN '采购包材'
WHEN c.ProductType = 2 THEN '物流包材'
WHEN c.ProductType = 3 THEN '配件'
WHEN c.ProductType = 4 THEN '加工成品'
ELSE '普通产品'
END
) '产品类型',
(
CASE
WHEN pa.DevelopStatus = 0 THEN '初级品'
WHEN pa.DevelopStatus = 1 THEN '成型品'
WHEN pa.DevelopStatus = 2 THEN '不通过'
ELSE '通过'
END
) '开发状态',
(
CASE
WHEN C.OnlineStatus = 0 THEN '未上架'
WHEN C.OnlineStatus = 1 THEN '已上架'
ELSE '已下架'
END
) '上架状态',
pa.OnlineTime 上架时间,
pa.AddTime '添加时间',
CASE WHEN pb.BrandName IS NOT NULL THEN pb.BrandName ELSE '非自有品牌' END AS '品牌名称',
ISNULL(dp.DepartmentName,0) '部门',
C.Pack_Length * C.Pack_Width * C.Pack_Height '单个包装体积',
C.GrossWeight '毛重',
whs.WareHouseName '一级默认仓',
(
CASE
WHEN C.IsGroup = 1 THEN '是'
ELSE '否'
END
) '是否为组合SKU',
t4.Memo AS '库位编码',
A.GoodNum+A.LockNum '当前库存',
A.LockNum '锁定库存',
r.ActiveDays '活跃天数',
pl.LineName 产品线
FROM
dbo.RB_WareHouse_Product A WITH (NOLOCK)
LEFT JOIN RB_Product C WITH (NOLOCK) ON A.SKU = C.SKU
AND A.CustomerID = C.CustomerID
LEFT JOIN RB_Product_Brand(NOLOCK) AS pb ON C.CustomerID = pb.CustomerID AND C.BrandID = pb.ID
LEFT JOIN RB_Product_Admin pa WITH (NOLOCK) ON pa.SKU = C.SKU
AND pa.CustomerID = C.CustomerID
LEFT JOIN RB_Product_Class D WITH (NOLOCK) ON D.CustomerID = A.CustomerID
AND D.ID = c.ClassID
LEFT JOIN RB_Product_Class E WITH (NOLOCK) ON E.CustomerID = A.CustomerID
AND E.ID = c.ClassID1
LEFT JOIN RB_Product_Class F WITH (NOLOCK) ON F.CustomerID = A.CustomerID
AND F.ID = c.ClassID2
LEFT JOIN dbo.RB_Product_SalesStatus (NOLOCK) ps ON ps.CustomerID = A.CustomerID
AND ps.SKU = A.SKU
LEFT JOIN dbo.RB_WareHouse wh WITH (NOLOCK) ON A.CustomerID = wh.CustomerID
AND A.WareHouseID = wh.ID
LEFT JOIN dbo.RB_Product_SupplierPrice(NOLOCK) psp ON psp.CustomerID = A.CustomerID AND psp.SKU = A.SKU AND psp.IsDefault=1
LEFT JOIN dbo.RB_Product_Supplier sup WITH (NOLOCK) ON A.CustomerID = sup.CustomerID
AND psp.SupplierID = sup.ID
LEFT JOIN dbo.RB_Product_Supplier_PaymentDay(NOLOCK) pspd ON sup.PaymentDayNew=pspd.ID
LEFT JOIN RB_WareHouse whs WITH (NOLOCK) ON c.DefaultLocalWarehouse = whs.ID
AND whs.CustomerID = A.CustomerID
LEFT JOIN RB_Warehouse_Product_ActiveInfo r WITH (NOLOCK) ON A.CustomerID = r.CustomerID
AND A.SKU = r.SKU
AND A.WareHouseID = r.WarehouseID
LEFT JOIN dbo.RB_Admin(NOLOCK) ad ON ad.CustomerID = pa.CustomerID AND pa.BuyerID=ad.ID
LEFT JOIN dbo.RB_Department(NOLOCK) dp ON dp.CustomerID = ad.CustomerID AND dp.ID=ad.DepartmentID
LEFT JOIN dbo.RB_SalesSactorHolidays(NOLOCK) sh ON c.HolidayID=sh.ID
LEFT JOIN dbo.View_RB_ProductChina_WareHouse_Table(NOLOCK) vt ON vt.CustomerID = A.CustomerID AND vt.WareHouseID = A.WareHouseID AND vt.SKU = A.SKU
LEFT JOIN #order t ON t.SKU = A.SKU
LEFT JOIN #xd t1 ON t1.SKU = A.SKU
LEFT JOIN #allgood t2 ON t2.SKU = A.SKU
LEFT JOIN #zgkl AS t3 ON t3.SKU = a.SKU
LEFT JOIN #mod1 AS t4 ON a.SKU = t4.SKU AND a.WareHouseID = t4.WareHouseID AND a.CustomerID = 1
LEFT JOIN dbo.RB_WareHouse(NOLOCK) wh2 ON sup.CustomerID=wh2.CustomerID AND sup.TheWareHouseID=wh2.ID
LEFT JOIN dbo.RB_WareHouse(NOLOCK) WH3 ON wh3.CustomerID=ad.CustomerID AND wh3.ID=c.DefaultLocalWarehouse
LEFT JOIN
(SELECT SKU,ProductLineID FROM rb_product_extendinfo(NOLOCK) WHERE CustomerID=1) pe ON A.SKU=pe.SKU
LEFT JOIN
(SELECT ID,LineName FROM rb_product_productline(NOLOCK) WHERE CustomerID=1) pl ON pe.ProductLineID=pl.ID
WHERE
A.CustomerID =@CustomerID
AND wh.WareHouseType = 1
AND wh.IsActive=1
AND A.GoodNum+A.LockNum > 0
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
DROP TABLE #temp_klbg;
DROP TABLE #temp_InventoryNum;
DROP TABLE #temp_OperateNum;
DROP TABLE #temp_ApportionProduct_kl;
DROP TABLE #allgood
DROP TABLE #mod1
DROP TABLE #order
DROP TABLE #xd
PARAMS:@CustomerId = 1 ,
MESSAGE:Cannot continue the execution because the session is in the kill state.
当前命令发生了严重错误。应放弃任何可能产生的结果。
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout)
在 Biz.Irobotbox.ReportCentre.CustomReportService.GetPageDataForCustomReportToSqlDataReader(String firstFileFullPath, RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramList, List`1 exportFields, String orderBy, Int32 timeOut)
在 Biz.Irobotbox.ReportCentre.CustomReportService.ExportCSVBySteam(RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramValues, List`1 exportFields, String orderField, Int32 timeOut)
在 Biz.Irobotbox.ReportCentre.CustomReportService.ExecuteCustomReportTask(List`1 customReportList)
在 System.Threading.Tasks.Task.Execute()
在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
在 System.Threading.Tasks.Schedulers.LimitedConcurrencyLevelTaskScheduler.<NotifyThreadPoolOfPendingWork>b__6_0(Object _)
在 System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
在 System.Threading.ThreadPoolWorkQueue.Dispatch()
[结果]
[期望]
加入核心条件 或者分页处理 减少阻塞
