[步骤]
4.ErrorCode=N1029343
修复小黄建
Error:11_-2_0_-2146232060
SQL:SELECT COUNT(1) FROM ( SELECT a.*,c.StrategyId,c.StrategyName,b.BatchNo,d.OrderSourceName,c.AddTime AS StrategyExcuteTime,c.AddUserName AS StrategyExcuteUserName,c.ServiceProvider,e.BrandName FROM dbo.RB_ProductVideo_List a(NOLOCK)
LEFT JOIN dbo.RB_ProductVideo_Strategy_Batch b (NOLOCK) ON a.CustomerID=b.CustomerID AND a.BatchId=b.Id
LEFT JOIN dbo.RB_ProductVideo_Strategy_History c (NOLOCK) ON b.CustomerID=c.CustomerID AND b.Id=c.BatchId
LEFT JOIN dbo.RB_OrderSource d (NOLOCK) ON a.OrderSourceId=d.ID AND a.CustomerID=d.CustomerID
LEFT JOIN RB_Amazon_Product_Base_Brand e(NOLOCK) ON a.OrderSourceId=e.OrderSourceId AND a.OrderSourceSKU=e.OrderSourceSKU AND a.CustomerID = e.CustomerId
WHERE a.CustomerID=@CustomerID AND (a.DataSource=1 OR (a.DataSource=0 AND d.ID IN(select [OrderSourceID] from [RB_OrderSource_SaleAdmin] (nolock) where CustomerID = @CustomerID AND AdminID = @ListingAdminId))) ) AS PagerTable
PARAMS:@CustomerID = 1 ,@ListingAdminId = 3804 ,
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.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, SqlParameter[] cmdParms)
在 RB.DALExtendV2.RB_ProductVideo_ListExtendV2.GetPagerModels(ProductVideoListSearchParameters param, Int32& recordCount)
在 PandaBuy.ERP.Web.IrobotBox.Product.ProductVideo.ProductVideoList.BindData()
在 PandaBuy.ERP.Web.IrobotBox.Product.ProductVideo.ProductVideoList.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_productvideo_productvideolist_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)
[结果]
[期望]
把语句OR 条件 拆分成两条 用 union 关联
declare @CustomerID int= 1 ,@ListingAdminId int= 3804
SELECT COUNT(1) FROM ( SELECT a.Id FROM dbo.RB_ProductVideo_List a with(NOLOCK)
LEFT JOIN dbo.RB_ProductVideo_Strategy_Batch b (NOLOCK) ON a.CustomerID=b.CustomerID AND a.BatchId=b.Id
LEFT JOIN dbo.RB_ProductVideo_Strategy_History c (NOLOCK) ON b.CustomerID=c.CustomerID AND b.Id=c.BatchId
LEFT JOIN dbo.RB_OrderSource d (NOLOCK) ON a.OrderSourceId=d.ID AND a.CustomerID=d.CustomerID
LEFT JOIN RB_Amazon_Product_Base_Brand e with(NOLOCK) ON a.OrderSourceId=e.OrderSourceId AND a.OrderSourceSKU=e.OrderSourceSKU AND a.CustomerID = e.CustomerId
WHERE a.CustomerID=@CustomerID AND (a.DataSource=1 )
union
SELECT a.Id FROM dbo.RB_ProductVideo_List a with(NOLOCK)
LEFT JOIN dbo.RB_ProductVideo_Strategy_Batch b (NOLOCK) ON a.CustomerID=b.CustomerID AND a.BatchId=b.Id
LEFT JOIN dbo.RB_ProductVideo_Strategy_History c (NOLOCK) ON b.CustomerID=c.CustomerID AND b.Id=c.BatchId
LEFT JOIN dbo.RB_OrderSource d (NOLOCK) ON a.OrderSourceId=d.ID AND a.CustomerID=d.CustomerID
LEFT JOIN RB_Amazon_Product_Base_Brand e with(NOLOCK) ON a.OrderSourceId=e.OrderSourceId AND a.OrderSourceSKU=e.OrderSourceSKU AND a.CustomerID = e.CustomerId
WHERE a.CustomerID=@CustomerID AND ((a.DataSource=0 AND d.ID IN(select [OrderSourceID] from [RB_OrderSource_SaleAdmin] (nolock) where CustomerID = @CustomerID AND AdminID = @ListingAdminId))
) ) AS PagerTable