[步骤]
[00:43:10] -------------------------------------------------------------CODE:N0043105
Error:11_-2_0_-2146232060
SQL:select [ID],[CustomerID],[OrderSourceID],[DevIDSellerId],[received-date],[fnsku],[sku],[product-name],[quantity],[fba-shipment-id],[fulfillment-center-id],[received-date-utc],[AddTime],[UpdateTime],[ReportId],[Status],[RemarkID],[FeatureId],[Remark],[Disposition],[BackupSKU] from [RB_Report_FULFILLMENT_INVENTORY_RECEIPTS] (nolock) where [ID] IN (14723909,14696979,14689057,14681870,14681873,14638175,14769128,14733254,14786115,14786116,14602663,14572891,14572890,14572883,14572882,14777086,14660369,14667079,14610843,14579404,14588034,14602665,14723909,14696979,14689057,14681870,14681873,14638175,14769128,14733254,14786115,14786116,14602663,14572891,14572890,14572883,14572882,14777086,14660369,14667079,14610843,14579404,14588034,14602665,14713760,14696977,14681874,14681875,14588028,14594292,14793377,14602660,14572892,14769131,14760983,14733260,14741821,14713760,14696977,14681874,14681875,14588028,14594292,14793377,14602660,14572892,14769131,14760983,14733260,14741821,14723909,14696979,14689057,14681870,14681873,14638175,14769128,14733254,14786115,14786116,14602663,14572891,14572890,14572883,14572882,14777086,14660369,14667079,14610843,14579404,14588034,14602665,14723909,14696979,14689057,14681870,14681873,14638175,14769128,14733254,14786115,14786116,14602663,14572891,14572890,14572883,14572882,14777086,14660369,14667079,14610843,14579404,14588034,14602665,14713760,14696977,14681874,14681875,14588028,14594292,14793377,14602660,14572892,14769131,14760983,14733260,14741821,14713760,14696977,14681874,14681875,14588028,14594292,14793377,14602660,14572892,14769131,14760983,14733260,14741821,14723909,14696979,14689057,14681870,14681873,14638175,14769128,14733254,14786115,14786116,14602663,14572891,14572890,14572883,14572882,14777086,14660369,14667079,14610843,14579404,14588034,14602665,14713760,14696977,14681874,14681875,14588028,14594292,14793377,14602660,14572892,14769131,14760983,14733260,14741821,14713760,14696977,14681874,14681875,14588028,14594292,14793377,14602660,14572892,14769131,14760983,14733260,14741821,14723909,14696979,14689057,14681870,14681873,14638175,14769128,14733254,14786115,14786116,14602663,14572891,14572890,14572883,14572882,14777086,14660369,14667079,14610843,14579404,14588034,14602665,14713760,14696977,14681874,14681875,14588028,14594292,14793377
省略 无数个
14639873,14743744,14655632,14684051,14711107,14686849,14686850,14650260,14650259,14658472,14584934,14627730,14627731,14711139,14672891,14562057,14570262,14570246,14599603,14592222,14770157,14761952,14734410,14734411,14653887,14594981,14685130,14575682,14590798,14625479,14736834,14764420,14763899,14727213,14699936,14708606,14678460,14772015,14772014,14745274,14717174,14764058,14756086,14606297,14727229,14736378,14567749,14648100,14691872,14656149,14662817,14596771,14672547,14747961,14747966,14757993,14766030,14782931,14780134,14684588,14686860,14643062,14658459,14584920,14592214,14627720,14617209,14738689,14758409,14758411,14711116,14788517,14595901,14726409,14581474,14758441,14655509,14702441,14717944,14590792,14707831,14647485,14633774,14558746,14558767,14623925,14629160,14578210,14586312,14651542,14702456,14664919,14617227,14711137,14789506,14736376,14736386,14575311,14575304,14559436,14606089,14669957,14780145,14748481,14748482,14748691,14748692,14758420,14758439,14758440,14774641,14694268,14650241,14782977,14782960,14586756,14589161,14555809,14572121,14777088,14696241,14624783,14606092,14672028,14585229,14595279,14687071,14687073,14580622,14608585,14650487,14608587,14632586,14632591,14632587,14570563,14720848,14709197,14678760,14685118,14670589,14575675,14575663,14597379,14575662,14590795,14625464,14727894,14780730,14764414,14650256,14643051,14612943,14647621,14662262,14762351,14567223,14567222,14647620,14707834,14558768,14779371,14738673,14627706,14584915,14562025,14658430,14658431,14643039,14592010,14592011,14616650,14616652,14664594,14679836,14747963,14738234,14686500,14719952,14719953,14729802,14790864,14790863,14658118,14702108,14744195,14754913,14779143,14567015,14605385,14595698,14690834,14707613,14707614,14726151,14644595,14632034,14653883,14746831,14664245,14722841,14760326,14760327,14776325,14776326,14751508,14751509,14756090,14756087,14727515,14754120,14787506,14638906,14638907,14638910,14632032,14580237,14611891,14611892,14611893,14566131,14632033,14668104,14668105,14677314,14714756,14682651,14780132,14763894,14745277,14567734,14590411,14648098,14640520,14662827,14780379,14756067,14692072,14634448,14606263,14614093,14625011,14672896,14766425,14711155)
PARAMS:
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
TRACE: 在 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
在 System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
在 System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
在 System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
在 System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
在 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.DALExtendV3.Generate.Inventory.RB_Report_FULFILLMENT_INVENTORY_RECEIPTSExtendV3.GetModels(List`1 IDList)
在 Biz.Inventory.InventoryReportFulfillmentSkuMapService.Step2(Int32 customerId, Nullable`1 startDate)
在 Biz.Inventory.InventoryReportFulfillmentSkuMapService.Execute(Int32 customerId, Nullable`1 startDate)
在 ChinaDownLoadImage.Task.Task_Order_CalcFee.Execute()
在 RB.Utility.SystemTask.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()
[结果]
[期望]
分批次 处理 ID 减少报错