[步骤]
[09:18:38] -------------------------------------------------------------
CODE:N0918383
Error:11_-2_0_-2146232060
SQL:
SELECT * FROM (
SELECT
ROW_NUMBER() OVER (ORDER BY ID ASC) AS [PageIndex] ,* FROM ( SELECT ri.ID,
ri.CustomerID,
ri.ClientOrderCode,
ri.OrderCode,
ri.OrderSourceID,
os.OrderSourceName
FROM RB_OrderInfo ri (nolock)
INNER JOIN RB_OrderSource os (NOLOCK)
ON ri.CustomerID = os.CustomerID
AND ri.OrderSourceID = os.ID
WHERE ri.CustomerID = @CustomerID
AND ri.IsStockOrder = 0
AND ri.IsPay = 1
AND os.OrderSourceType = 1 and exists (select top 1 0 from RB_OrderList ol (nolock) where ri.CustomerID=ol.CustomerID and ri.OrderCode= ol.OrderCode and ol.ASIN =@ASINs ) and ri.PayTime >=@StartDate and ri.PayTime<@EndDate ) AS TempTable ) AS PagerTable WHERE PagerTable.[PageIndex] BETWEEN 1 AND 200
PARAMS:@CustomerID = 1 ,@ASINs = B08JZ7VS41 ,@StartDate = 2024-03-30 ,@EndDate = 2024-06-24 ,
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.DALExtend.RB_Amazon_RequestReview_StrategyExtend.GetStragetyOrderCodeList(CM_AmazonStragetyPilotRun model, Int32 pageIndex, Int32 pageSize)
在 Biz.Irobotbox.Amazon.Amazon_RequestReviewStrategy.RequestReviewStrategyOrderCode(CM_AmazonStragetyPilotRun stragetyModel)
在 System.Collections.Generic.List`1.ForEach(Action`1 action)
在 Biz.Irobotbox.Amazon.Amazon_RequestReviewStrategy.RequestReviewStrategy()
在 ChinaDownLoadImage.Task.Amazon.Task_Amazon_RequestReview_Strategy.Execute()
在 RB.Utility.SystemTask.<doTask>b__43_0()
在 System.Threading.Tasks.Task.Execute()
在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
在 System.Threading.ThreadPoolWorkQueue.Dispatch()
[结果]
[期望]
检测SQL 参数化 类型是否和数据库一致，不一致请修正
