[步骤]
[00:16:25] -------------------------------------------------------------
CODE:N00162517
Error:16_8623_1_-2146232060
SQL:DELETE FROM [RB_Mercadolibre_BillingInfo] WHERE [ID] IN (42511356,42511374,42511382,42511408,42511410,42511413,42511420,42511429,42520341,42520354,42520356,42520358,42520362,42520364,42520380,42520387,42520392,42520395,42520404,42520406,42520413,42520429,42520435,42520447,42520451,42520457,42520462,42520464,42520466,42520467,42520471,42520472,42520474,42520484,42520487,42520488,42520493,42520495,42520500,42520506,42520514,42511341,42511344,42511346,42511347,42511348,42511349,42511350,42511352,42511354,42511360,42511362,42511365,42511375,42511381,42511386,42511387,42511390,42511391,42511392,42511399,42511401,42511407,42511423,42511425,42511432,42511436,42511437,42511439,42511448,42511466,42511470,42511476,42511482,42511493,42511501,42511502,42511522,42511525,42511543,42511552,42511554,42511556,42511558,42511561,42511572,42520330,42520331,42511342,42511345,42511355,42511357,42511364,42520327,42520329,42520337,42520340,42520349,42520351,42520352,42520363,42520365,42520366
PARAMS:
MESSAGE:The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.
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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
Ԛ System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
Ԛ System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
Ԛ RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms) Ԛ RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
Ԛ RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms)
Ԛ RB.DAL.RB_Mercadolibre_BillingInfo.DeleteList(List`1 IDList, List`1& hasDelList)
Ԛ Biz.Mercadolibre.OrderBill.MercadolibreBillingInfoService.BulkCopyAddNew(Int32 customerId, List`1 billingInfoList, Dictionary`2 addtionalDic)
Ԛ 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()
[结果]
[期望]
分批处理删除