Error:11_-2_0_-2146232060
SQL:
SELECT * FROM (
SELECT
ROW_NUMBER() OVER (ORDER BY ID DESC , AddTime DESC ) AS [PageIndex] ,* FROM ( SELECT a.ID,
a.CustomerID,
a.OrderSourceID,
a.OrderSourceSKU,
a.OrderSourceSKUID,
a.SKU,
a.Status,
a.Price,
a.QueueID,
a.Msg,
a.IsParent,
a.AddTime,
a.UpdateTime,
a.PlanID,
a.PlanDetailId,
a.PlanName,
a.UploadType,
b.RecommendedBrowseNodeName,
b.RecommendedBrowseNode,
b.FeedSubmissionId,
b.AddUserName,
o.OrderSourceName,
o.OrderSourceCountry,
a.UPCorEAN
FROM RB_AmazonUploadProduct_V2 (nolock) AS a
INNER JOIN @tb_OrderSourceIDs IDS ON a.OrderSourceID = IDS.Id
LEFT JOIN RB_AmazonUploadResult_V2 (nolock) AS b
ON a.QueueID = b.ID
AND a.CustomerID = b.CustomerID
LEFT JOIN RB_OrderSource (nolock) AS o
ON o.ID = a.OrderSourceID
AND o.CustomerID = a.CustomerID
WHERE 1 = 1 AND a.CustomerID=@CustomerID AND a.AddTime >=@StartDate AND a.AddTime <=@EndDate ) AS TempTable ) AS PagerTable WHERE PagerTable.[PageIndex] BETWEEN 1 AND 20 option(maxdop 12)
PARAMS:@CustomerID = 1 ,@tb_OrderSourceIDs = 19196,19192,19194,19185,19188,19187,19184,19186,19197,19195,19191,19189,19190,19193, ,@StartDate = 2023-05-18 00:00:00 ,@EndDate = 2023-05-25 23:59:59 ,
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.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
在 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.DALExtend.RB_AmazonUploadProduct_V2Extend.GetAmazonUpList_V2PagerList(CM_AmazonUpList_V2Param parameters)
在 PandaBuy.ERP.Web.IrobotBox.Product.AmazonUpList_V2.BandingData()
在 PandaBuy.ERP.Web.IrobotBox.Product.AmazonUpList_V2.Page_Load(Object sender, EventArgs e)
在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
在 System.Web.UI.Control.OnLoad(EventArgs e)
在 System.Web.UI.Control.LoadRecursive()
在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest()
在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
在 System.Web.UI.Page.ProcessRequest(HttpContext context)
在 ASP.irobotbox_product_amazonuplist_v2_aspx.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)
建议优化为：
declare @CustomerID int= 1 , @StartDate datetime= '2023-05-18 00:00:00' ,@EndDate datetime= '2023-05-25 23:59:59';
declare @tb_OrderSourceIDs table(id int primary key);
insert into @tb_OrderSourceIDs values(19196),(19192),(19194),(19185),(19188),(19187),(19184),(19186),(19197),(19195),(19191),(19189),(19190),(19193);
SELECT * FROM (
SELECT
ROW_NUMBER() OVER (ORDER BY ID DESC , AddTime DESC ) AS [PageIndex] ,* FROM ( SELECT a.ID,
a.CustomerID,
a.OrderSourceID,
a.OrderSourceSKU,
a.OrderSourceSKUID,
a.SKU,
a.Status,
a.Price,
a.QueueID,
a.Msg,
a.IsParent,
a.AddTime,
a.UpdateTime,
a.PlanID,
a.PlanDetailId,
a.PlanName,
a.UploadType,
b.RecommendedBrowseNodeName,
b.RecommendedBrowseNode,
b.FeedSubmissionId,
b.AddUserName,
o.OrderSourceName,
o.OrderSourceCountry,
a.UPCorEAN
FROM RB_AmazonUploadProduct_V2 AS a with(nolock,index(IX_RB_AmazonUploadProduct_V2_CustomerID_OrderSourceID_AddTime))
INNER JOIN @tb_OrderSourceIDs IDS ON a.OrderSourceID = IDS.Id
LEFT JOIN RB_AmazonUploadResult_V2 (nolock) AS b
ON a.QueueID = b.ID
AND a.CustomerID = b.CustomerID
LEFT JOIN RB_OrderSource (nolock) AS o
ON o.ID = a.OrderSourceID
AND o.CustomerID = a.CustomerID
WHERE 1 = 1 AND a.CustomerID=@CustomerID AND a.AddTime >=@StartDate AND a.AddTime <=@EndDate ) AS TempTable ) AS PagerTable WHERE PagerTable.[PageIndex] BETWEEN 1 AND 20 option(maxdop 12)