业务需求
需求描述

[步骤]

[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 减少报错
验收标准
10000
价值描述
10000
历史记录  
  1. 2026-06-10 21:37:08, 由 林很 Bug转化而来,Bug编号为 63632 。
  2. 2026-06-10 21:37:25, 由 林很 编辑。
    修改了 所属计划,旧值为 "",新值为 "2658"。
    修改了 所处阶段,旧值为 "wait",新值为 "planned"。
  3. 2026-06-11 14:57:14, 由 张明磊 编辑。
    修改了 预计工时,旧值为 "8",新值为 "1"。
    修改了 成本 ,旧值为 "4000",新值为 "500"。
    修改了 ROI ,旧值为 "15.00",新值为 "120.00"。
  4. 2026-06-11 15:12:03, 由 张明磊 记录评审结果,结果为 确认通过。
  5. 2026-06-11 15:18:05, 由 周杰 关联到迭代 主干_6月V4版本_20260623 。
  6. 2026-06-11 16:05:57, 由 周杰 编辑。
    修改了 计划验收时间,旧值为 "0000-00-00",新值为 "2026-06-26"。
  7. 2026-06-15 17:24:27, 由 曾倩 编辑。
    修改了 测试人员,旧值为 "",新值为 "zengqian"。
  8. 2026-06-23 15:12:21, 由 周杰 编辑。
    修改了 所处阶段 ,旧值为 "tested",新值为 "bepending"。
    修改了 设置阶段者,旧值为 "",新值为 "zhoujie"。
  9. 2026-07-06 18:32:45, 由 周杰 关闭,原因为 已完成 。
    修改了 由谁关闭,旧值为 "",新值为 "zhoujie"。
    修改了 关闭日期,旧值为 "0000-00-00 00:00:00",新值为 "2026-07-06 18:32:45"。
    修改了 指派给 ,旧值为 "zhangminglei",新值为 "closed"。
    修改了 当前状态,旧值为 "active",新值为 "closed"。
    修改了 所处阶段,旧值为 "bepending",新值为 "closed"。
    修改了 关闭原因,旧值为 "",新值为 "done"。
迭代版本
提报业务部门 技术研发中心
提报人员 林很
需求来源 bug转需求
所属项目 技术中心-需求池
所属模块 财务   财务管理
所属计划
业务价值
开发组 财务开发组
受益业务部门 技术研发中心
验收人员 许瑞丰
业务目标类型
中心业务目标
业务价值 控制风险
每月价值量 10000
每月节省人数 0
优先级 P2
价值类型 长期价值
预计工时 1
成本 500
ROI 120.00
操作手册 否
高价值 -
主被动 被动接收
复杂度 一般性
工作流ID
工作流创建时间 0000-00-00 00:00:00
更新点
是否高危 否
评分
当前状态 已关闭
所处阶段 已关闭
关键词
评审次数 一次
计划上线 0000-00-00
上线时间 2026-06-23
计划验收时间 2026-06-26
业务验收时间
满意度
价值验收
满意度分值
业务回填价值
验收达成价值
验收达成ROI
抄送给 袁慧斌  
由谁创建 林很 于 2026-06-10 21:37:08
指派给 Closed 于 2026-07-06 18:32:45
由谁评审 张明磊
评审时间 2026-06-11
由谁关闭 周杰 于 2026-07-06 18:32:45
关闭原因 已完成
最后修改 周杰 于 2026-07-06 18:32:45