重现步骤
CODE:N0857152
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)



历史记录  
  1. 2023-05-25 09:21:17, 由 吴高发 创建。
  2. 2023-05-25 09:23:30, 由 吴高发 编辑。
    修改了 指派给 ，旧值为 ""，新值为 "wangxiangyu"。
    修改了 影响环境，旧值为 "577,"，新值为 "577"。

    建议优化为：


    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)

  3. 2023-05-25 09:28:59, 由 王翔宇 指派给 冯名明。
    修改了 指派给，旧值为 "wangxiangyu"，新值为 "fengmingming"。
  4. 2023-05-25 11:15:31, 由 冯名明 解决，方案为 性能问题 。
    修改了 解决方案，旧值为 ""，新值为 "performance"。
    修改了 解决版本，旧值为 ""，新值为 "596"。
    修改了 解决日期，旧值为 ""，新值为 "2023-05-25 11:13:37"。
    修改了 指派给 ，旧值为 "fengmingming"，新值为 "guanyilin"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "fengmingming"。


    V2队列界面，系统部建了Bug，说经常超时。

    条件都是只有来源渠道，其他都没有过滤，这种查出来的数据没有意义。

    加上两个默认值，上传类型默认产品，上传方式默认人工，必填。



  5. 2023-05-25 12:18:50, 由 关依林 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "guanyilin"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "guanyilin"。
    修改了 关闭日期，旧值为 ""，新值为 "2023-05-25 12:18:50"。
  6. 2023-05-31 10:45:05, 由 周杰 关联到发布 发布上线：上线版本_20230530。
  7. 2023-11-17 09:53:26, 由 刘超 编辑。
    修改了 所属模块，旧值为 "1740"，新值为 "1863"。
所属项目 技术中心-需求池
所属模块 系统运维   性能优化
所属计划
所属迭代
Bug类型 性能问题
严重程度 提示
优先级 P2
Bug状态 已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2023-05-25 12:18:50
截止日期 0000-00-00
上线时间
上线时效
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 吴高发 于 2023-05-25 09:21:17
影响环境 577
由谁解决 冯名明 于 2023-05-25 11:13:37
解决版本 五月分支
解决方案 性能问题
由谁关闭 关依林 于 2023-05-25 12:18:50
最后修改 刘超 于 2023-11-17 09:53:23
相关Bug