BUG #63632 性能优化-本地服务2 报告履行库存收据查询传入了大量ID 查询失败日志打爆 - 技术中心-需求池

重现步骤

[步骤]

[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.<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()

[结果]

[期望]

分批次处理 ID 减少报错

历史记录

2026-06-03 11:13:59, 由 袁慧斌 创建。
2026-06-10 09:37:59, 由 李乐同 指派给程伟。
修改了 指派给，旧值为 "liletong"，新值为 "chengwei"。
2026-06-10 09:38:50, 由程伟指派给 张明磊。
修改了 指派给，旧值为 "chengwei"，新值为 "zhangminglei"。
2026-06-10 21:35:25, 由 张明磊 指派给林很。
修改了 指派给，旧值为 "zhangminglei"，新值为 "linhen"。
2026-06-10 21:37:08, 由林很转为需求，编号为 #35867 性能优化-本地服务2 报告履行库存收据查询传入了大量ID 查询失败日志打爆 。
2026-06-10 21:37:08, 由林很关闭。
2026-06-26 15:12:16, 由 陈莉珍 编辑。
修改了 测试责任人，旧值为 ""，新值为 "linhen"。
修改了 解决时效 ，旧值为 "0"，新值为 "130.39"。
修改了 解决方案 ，旧值为 "tostory"，新值为 "performance"。
修改了 是否确认 ，旧值为 "0"，新值为 "1"。
修改了 重现步骤 ，区别为：
007- 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.<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()
007+ 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.<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()

007- 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.<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() 
007+ 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.<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()

基本信息
迭代/需求/任务

所属项目	技术中心-需求池
所属模块	供应链仓储物流备库订单
所属计划
所属迭代
Bug类型
严重程度	一般
优先级	P1
Bug状态	已关闭
业务部门
影响功能
开发责任人	林很
测试责任人	林很
解决时效	130.39
激活次数	0
激活日期
是否确认	是
当前指派	Closed 于 2026-06-26 15:12:16
截止日期	0000-00-00
上线时间	2026-06-04 18:00:00
上线时效	30.77
操作系统
浏览器
关键词
抄送给

所属迭代
相关需求
相关任务

Bug的一生
其他相关

由谁创建	袁慧斌于 2026-06-03 11:13:59
影响环境	生产环境-业务反馈
由谁解决	林很于 2026-06-10 21:37:08
解决版本
解决方案	性能问题
由谁关闭	林很于 2026-06-10 21:37:08
最后修改	陈莉珍于 2026-06-26 15:12:16

相关Bug
转需求	#35867 性能优化-本地服务2 报告履行库存收据查询传入了大量ID 查询失败日志打爆