[步骤]
CODE:N1448281Error:11_-2_0_-2146232060
SQL: DECLARE @ProductSKUS TABLE(SKU VARCHAR(50) primary key); DECLARE @AddUserIdTable TABLE(item VARCHAR(50) primary key); DECLARE @ReviewUserIdTable TABLE(item VARCHAR(50) primary key); INSERT INTO @AddUserIdTable SELECT DISTINCT item FROM dbo.CharSplitForIn(@AddAdminID,',') INSERT INTO @ReviewUserIdTable SELECT DISTINCT item FROM dbo.CharSplitForIn(@ReviewAdminID,',') INSERT INTO @ProductSKUS
SELECT DISTINCT SKU FROM (
SELECT
ROW_NUMBER() OVER (ORDER BY IsEditRepulse DESC, AddTime ASC) AS [PageIndex], * FROM (
SELECT P.SKU, pic.IsEditRepulse , pa.AddTime FROM dbo.RB_Product (NOLOCK) p LEFT JOIN RB_Product_Admin pa WITH ( NOLOCK ) ON pa.SKU = p.SKU AND pa.CustomerID = p.CustomerID INNER JOIN dbo.RB_Product_ImageCheck pic WITH ( NOLOCK ) ON pic.SKU = P.SKU AND pic.CustomerID = p.CustomerID LEFT JOIN ( SELECT MAX(IsDesignRepulse) IsDesignRepulse,SKU,CustomerID FROM RB_Product_Image(nolock) WHERE Status <> 2 GROUP BY SKU,CustomerID ) pi on pa.CustomerID=pi.CustomerID AND pa.SKU=pi.SKU WHERE p.CustomerID =1 AND p.DeleteStatus =0 AND pa.ImageAdminID = 4762 AND Exists (select 1 from RB_Product_PropertyChange ppc where pic.SKU = ppc.SKU and ppc.PropertyType in(1,2,3) and ppc.Status=1)
) AS TempTable
) AS PagerTable
WHERE PagerTable.[PageIndex] BETWEEN 1 AND 25;
SELECT ROW_NUMBER() OVER (ORDER BY IsEditRepulse DESC, AddTime ASC) AS [PageIndex], * FROM (SELECT p.ID,
p.CustomerID,
p.ClientSKU,
p.SKU,
p.ProductGroupSKU,
p.ImageUrl,
pa.ImageStatus,
pa.ImageAdminID,
pa.ImageAdminName,
pa.ImageTime,
pa.EditStatus,
pa.EditAdminID,
pa.EditAdminName,
pa.EditTime,
ISNULL(pa.PhotographerId, 0) PhotographerId,
ISNULL(pa.PhotographerName, '') PhotographerName,
pa.PhotographerTime,
ISNULL(pa.ProductPicAndTextAuditAdminId, 0) PicAndTextReviewerId,
ISNULL(pa.ProductPicAndTextAuditUserName, '') PicAndTextReviewerName,
pa.ProductPicAndTextAuditTime PicAndTextReviewerTime,
pa.DevelopStatus,
pa.DevelopAdminID,
pa.DevelopAdminName,
pa.DevelopTime,
pic.Status ImageCheckStatus,
pic.IsEditRepulse IsEditRepulse,
pa.AddTime,
pa.CheckStatus,
ISNULL(pi.IsDesignRepulse,0) IsDesignRepulse,
pic.AddTime picAddTime,
pic.CheckTime
FROM (SELECT * FROM dbo.RB_Product (NOLOCK) WHERE SKU IN (SELECT * FROM @ProductSKUS)) p
LEFT JOIN RB_Product_Admin pa WITH ( NOLOCK )
ON pa.SKU = p.SKU AND pa.CustomerID = p.CustomerID
INNER JOIN dbo.RB_Product_ImageCheck pic WITH ( NOLOCK )
ON pic.SKU = P.SKU AND pic.CustomerID = p.CustomerID
LEFT JOIN (
SELECT MAX(IsDesignRepulse) IsDesignRepulse,SKU,CustomerID
FROM RB_Product_Image(nolock)
WHERE Status <> 2
GROUP BY SKU,CustomerID
) pi on pa.CustomerID=pi.CustomerID AND pa.SKU=pi.SKU WHERE p.CustomerID =1 AND p.DeleteStatus =0 AND pa.ImageAdminID = 4762 AND Exists (select 1 from RB_Product_PropertyChange ppc where pic.SKU = ppc.SKU and ppc.PropertyType in(1,2,3) and ppc.Status=1)) AS TempTable;
SELECT COUNT(1) FROM (SELECT P.SKU, pic.IsEditRepulse , pa.AddTime FROM dbo.RB_Product (NOLOCK) p LEFT JOIN RB_Product_Admin pa WITH ( NOLOCK ) ON pa.SKU = p.SKU AND pa.CustomerID = p.CustomerID INNER JOIN dbo.RB_Product_ImageCheck pic WITH ( NOLOCK ) ON pic.SKU = P.SKU AND pic.CustomerID = p.CustomerID LEFT JOIN ( SELECT MAX(IsDesignRepulse) IsDesignRepulse,SKU,CustomerID FROM RB_Product_Image(nolock) WHERE Status <> 2 GROUP BY SKU,CustomerID ) pi on pa.CustomerID=pi.CustomerID AND pa.SKU=pi.SKU WHERE p.CustomerID =1 AND p.DeleteStatus =0 AND pa.ImageAdminID = 4762 AND Exists (select 1 from RB_Product_PropertyChange ppc where pic.SKU = ppc.SKU and ppc.PropertyType in(1,2,3) and ppc.Status=1)) AS TempCount;
SELECT ImageCheckStatus,COUNT(*) Num FROM (SELECT pic.Status ImageCheckStatus
FROM dbo.RB_Product (NOLOCK) p
LEFT JOIN RB_Product_Admin pa WITH ( NOLOCK )
ON pa.SKU = p.SKU AND pa.CustomerID = p.CustomerID
INNER JOIN dbo.RB_Product_ImageCheck pic WITH ( NOLOCK )
ON pic.SKU = P.SKU AND pic.CustomerID = p.CustomerID
LEFT JOIN (
SELECT MAX(IsDesignRepulse) IsDesignRepulse,SKU,CustomerID
FROM RB_Product_Image(nolock)
WHERE Status <> 2
GROUP BY SKU,CustomerID
) pi on pa.CustomerID=pi.CustomerID AND pa.SKU=pi.SKU WHERE p.CustomerID =1 AND p.DeleteStatus =0 AND pa.ImageAdminID = 4762) AS TempGroup Group by ImageCheckStatus;
PARAMS:@AddAdminID = 4762 ,@ReviewAdminID = ,
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.DALExtendV2.RB_Product_ImageCheckExtendV2.QueryTemporaryTablePagerNew(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, String getStatusSql, Boolean isAliasOrderBy, SqlParameter[] parameters)
在 RB.DALExtendV2.RB_Product_ImageCheckExtendV2.GetProductImageCheckList(CM_Product_ImageCheckParam param, Int32& recordCount, Dictionary`2& statusDic)
在 PandaBuy.ERP.Web.IrobotBox.Product.MultiImageEdit.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_multiimageedit_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)
[结果]
[期望]
请把 未 添加 nolock 的 表 补充完整
在 RB.DALExtendV2.RB_Product_ImageCheckExtendV2.QueryTemporaryTablePagerNew(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, String getStatusSql, Boolean isAliasOrderBy, SqlParameter[] parameters)
找到对应代码 补充下