[步骤]
[16:01:12] -------------------------------------------------------------
CODE:N160112246
Error:17_8632_2_-2146232060
SQL:select ID,CustomerID,ClientOrderCode from RB_Mercadolibre_BillingInfo with(nolock) where CustomerID=1 and ClientOrderCode in ('2000008251160988','2000008253809584','2000008255240590','2000008258242974','2000008263143154','2000008263247318','2000008263247322','2000008263915262','2000008267187774','2000008267367694','2000008269281394','2000008271922380','2000008273255492','2000008274832106','2000008276665106','2000008279561610','2000008283819776','2000008284247766','2000008284494174','2000008284491884','2000008289699464','2000008290558908','2000008290738944','2000008293270584','2000008293446152','2000008294480842','2000008297665794','2000008301659510','2000008303179566','2000008303460928','2000008300824208','2000008306821198','2000008307626142','2000008308081806','2000008309091876','2000008315329096','2000008315570216','2000008316629546','2000008320254562','2000008320254548','2000008320802432'
PARAMS:
MESSAGE:Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.
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.DALExtendV2.Generate.RB_Mercadolibre_BillingInfoExtendV2.GetBillingInfoList(Int32 customerID, IEnumerable`1 clientOrderIdList, String executeStatus)
在 Biz.Mercadolibre.OrderBill.MercadolibreBillingInfoService.FilterProcessedClientOrderCodeList(Int32 customerId, List`1 paramModels)
在 Biz.Mercadolibre.OrderBill.MercadolibreBillingInfoService.Process(Int32 customerId, Nullable`1 orderSourceId)
在 ChinaDownLoadImage.Task.Mercadolibre.Task_Mercadolibre_ShipmentCompensation.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()
[结果]
[期望]
分批次 查询 或者 采用 表传值方式 不报错