CODE:N16362421
Error:11_-2_0_-2146232060
SQL:SELECT COUNT(1) FROM ( SELECT DISTINCT
s.ID AS OrderSourceID,
o.ServiceAdminID,
o.ServiceAdminName,
o.AmazonShipmentId,
o.ToWareHouseID,
s.OrderSourceName,
o.AddTime AS OrderAddTime,
o.OrderCode,
fhwh.ID AS DeliveryWareHouseID,
fhwh.WareHouseName AS DeliveryWareHouseName,
bkwh.ID AS RestockWareHouseID,
bkwh.WareHouseName AS RestockWareHouseName,
o.TransportId,
t.TransportName,
beikuExpand.OrderBuildType,
(CASE
WHEN t.TransferType IS NULL THEN
beikuExpand.TransferType
ELSE
t.TransferType
END
) AS TransferType,
CASE
WHEN ISNULL(ol.GroupSKU, '') <> '' THEN
ol.GroupSKU
ELSE
CASE
WHEN ISNULL(ol.SKU, '') <> '' THEN
ol.SKU
ELSE
CASE
WHEN ISNULL(oll.GroupSKU, '') = '' THEN
oll.SKU
ELSE
oll.GroupSKU
END
END
END SKU,
CASE
WHEN ISNULL(ol.SellerSKU, '') = '' THEN
oll.SellerSKU
ELSE
ol.SellerSKU
END OrderSourceSKU,
CASE
WHEN ISNULL(whp.ASIN, '') = '' THEN
whp2.ASIN
ELSE
whp.ASIN
END ASIN,
'' OverseasSKU,
CASE
WHEN ISNULL(
CASE
WHEN ISNULL(ol.GroupSKU, '') = '' THEN
(ol.ProductNum + ISNULL(ol.ProductNumUpdate, 0))
ELSE
(ol.GroupProductNum + ISNULL(ol.GroupProductNumUpdate, 0))
END, '') = '' THEN
(CASE
WHEN ISNULL(oll.GroupSKU, '') = '' THEN
(oll.ProductNum + ISNULL(oll.ProductNumUpdate, 0))
ELSE
(oll.GroupProductNum + ISNULL(oll.GroupProductNumUpdate, 0))
END)
ELSE
(CASE
WHEN ISNULL(ol.GroupSKU, '') = '' THEN
(ol.ProductNum + ISNULL(ol.ProductNumUpdate, 0))
ELSE
(ol.GroupProductNum + ISNULL(ol.GroupProductNumUpdate, 0))
END )
END ShipNumber,
COALESCE(p.ShipTime,o.ShipTime) ShipTime,
p.PackageState,
p.ID AS PackageID,
CASE WHEN ISNULL(p.TrackNumber, '') = '' THEN ISNULL(o.TrackNumbers,'')
ELSE p.TrackNumber end TrackNumber,
s.SaleAdminID,
s.SaleAdminName
FROM RB_OrderInfo o (NOLOCK)
LEFT JOIN RB_Procurement_Order_Package p (NOLOCK)
ON p.MergerPackageNo = o.OrderCode
AND p.CustomerID = o.CustomerID
LEFT JOIN dbo.RB_Procurement_Order_Package_OrderDetail (NOLOCK) opd
ON p.CustomerID = opd.CustomerID
AND p.ID = opd.PackageID
LEFT JOIN RB_OrderList ol (NOLOCK)
ON ol.ID = opd.OrderListID
AND ol.OrderCode = opd.OrderCode
AND ol.CustomerID = opd.CustomerID
LEFT JOIN RB_OrderList oll (NOLOCK)
ON oll.OrderCode = o.OrderCode
AND oll.CustomerID = o.CustomerID
LEFT JOIN RB_WareHouse_Product whp (NOLOCK)
ON whp.OrderSourceID = o.OrderSourceID
AND whp.CustomerID = ol.CustomerID
AND whp.OrderSourceSKU = ol.SellerSKU
LEFT JOIN RB_WareHouse_Product whp2 (NOLOCK)
ON whp2.OrderSourceID = o.OrderSourceID
AND whp2.CustomerID = oll.CustomerID
AND whp2.OrderSourceSKU = oll.SellerSKU
LEFT JOIN RB_OrderSource s (NOLOCK)
ON o.OrderSourceID = s.ID
AND s.CustomerID = o.CustomerID
LEFT JOIN RB_Transport t (NOLOCK)
ON o.TransportID = t.ID
AND o.CustomerID = t.CustomerID
LEFT JOIN RB_OrderInfo_BeikuExpand beikuExpand (NOLOCK)
ON beikuExpand.CustomerID = o.CustomerID
AND o.OrderCode = beikuExpand.OrderCode
LEFT JOIN RB_WareHouse bkwh (NOLOCK)
ON bkwh.CustomerID = o.CustomerID
AND o.ToWareHouseID = bkwh.ID
LEFT JOIN RB_WareHouse fhwh (NOLOCK)
ON fhwh.CustomerID = o.CustomerID
AND o.WareHouseID = fhwh.ID where o.CustomerID = @CustomerID AND o.IsStockOrder=@IsStockOrder AND o.OrderStatus <> @OrderStatus and o.AmazonShipmentId IN(SELECT item FROM CharsplitForIn(@ShipmentIdList,',')) ) AS PagerTable
PARAMS:@IsStockOrder = 1 ,@CustomerID = 1 ,@OrderStatus = 2 ,@ShipmentIdList = FBA15DH7J8DW,FBA15DHRP4YF ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.SqlInternalConnection.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.ExecuteScalar()
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, SqlParameter[] cmdParms)
在 RB.DALExtendV2.RB_Procurement_Order_PackageExtendV2.GetStockOrderAndPackageInfoList(CM_GetStockOrderInfoParam param, Int32& recordCount)
在 RB.WebApi.ApiCode.API_Methods.GetStockOrderInfo(GetStockOrderInfoRequest request)
在 System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
在 System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
在 RB.WebApi.ApiCode.API_Entrance.ProcessRequest(HttpContext context)
在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
建议优化：
末尾添加： option(maxdop 1)
优化方案：在末尾添加： option(maxdop 1)