[步骤]
[18:01:00] -------------------------------------------------------------
CODE:N1801001
Error:11_-2_0_-2146232060
SQL:
SELECT
ol.CustomerID,ol.SKU,SUM(ol.ProductNum+ol.ProductNumUpdate-ISNULL(popc.SingleNum,0)) NoSingleNum,oi.WareHouseID
FROM
dbo.RB_OrderInfo oi
INNER JOIN RB_OrderInfo_BeikuExpand(nolock) oibe ON oibe.CustomerID = oi.CustomerID AND oibe.OrderCode=oi.OrderCode
INNER JOIN RB_OrderSource(NOLOCK) os ON oi.CustomerID = os.CustomerID AND oi.OrderSourceID = os.ID
INNER JOIN dbo.RB_OrderList (NOLOCK) ol ON oi.CustomerID=ol.CustomerID AND oi.OrderCode=ol.OrderCode
LEFT JOIN dbo.RB_Procurement_Order_PositionCode (NOLOCK) popc ON ol.CustomerID=popc.CustomerID AND ol.OrderCode=popc.OrderCode AND ol.SKU=popc.SKU AND ol.ID = popc.OrderListID
WHERE oi.CustomerID=@CustomerID AND oi.OrderStatus=@OrderStatus AND oibe.RestockType=@RestockType AND os.OrderSourceType=@OrderSourceType
AND ol.SKU IN (SELECT item AS SKU FROM dbo.CharSplitForIn(@skus,','))
GROUP BY ol.CustomerID,ol.SKU,oi.WareHouseID
PARAMS:@CustomerID = 1 ,@OrderStatus = 0 ,@RestockType = 2 ,@OrderSourceType = 20 ,@skus = 18787510,18787568,1881539,1881565,18827270,18932000,18932282,18932407,18946654,18996616,19007162,19007515,19009020,19009235,19013175,19013208,19129702,19129928,19130082,19168271,1918742,1918751,1925701,1925842,19291030,19291436,19291627,19291678,19291909,19292063 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
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.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DALExtendV2.RB_Factory_InventoryExtendV2.GetNoSingleNumLst(Int32 customerId, List`1 skuLst)
在 RB.DALExtendV2.RB_Factory_InventoryExtendV2.GetFactoryInventoryDataForBi(Int32 customerId, List`1 skus)
在 RB.WebApi.ApiCode.API_Methods.GetFactoryInventoryData(GetFactoryInventoryDataRequest 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.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)
[结果]
[期望]
dbo.RB_OrderInfo oi 所有的表补充完整的nolock