重现步骤

[步骤]

content: [00:19:20]  -------------------------------------------------------------
CODE:N00192029
Error:16_8003_1_-2146232060
SQL:update [RB_OrderList] set  [ProductNum] = @ProductNum_1  , [ProductNumUpdate] = @ProductNumUpdate_1  , [GroupProductNum] = @GroupProductNum_1  , [GroupProductNumUpdate] = @GroupProductNumUpdate_1  , [LockNum] = @LockNum_1  , [UpdateTime] = @UpdateTime_1,   [PurchaseType] = @PurchaseType_1,   [ItemMemo] = @ItemMemo_1   where ID=@ID_1 ;update [RB_OrderList] set  [ProductNum] = @ProductNum_2  , [ProductNumUpdate] = @ProductNumUpdate_2  
此处省略 好多个 

@GroupProductNumUpdate_250 = null ,@LockNum_250 = 0 ,@UpdateTime_250 = 2024/5/29 0:19:20 ,@PurchaseType_250 = 0 ,@ItemMemo_250 =  ,
MESSAGE:The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
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.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.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.DALExtendV3.RB_OrderListExtendV3.BatchUpdateOrderListAllNum(List`1 models)
   在 Biz.Irobotbox.ReStock.FBAOrderService.BatchNumShipmentAutoUpdate()
   在 Biz.Irobotbox.ReStock.FBAOrderService.AutoCombinedOrder()
   在 ChinaDownLoadImage.Task.Restock.Task_Restock_AutoCombinedOrder.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()

[结果]


[期望]

建议分批次处理。


历史记录  
  1. 2024-05-29 09:27:59, 由 袁慧斌 创建。
  2. 2024-05-29 09:51:56, 由 李乐同 指派给 程伟。
    修改了 指派给,旧值为 "liletong",新值为 "chengwei"。
  3. 2024-05-29 12:06:19, 由 程伟 指派给 鞠智明。
    修改了 指派给,旧值为 "chengwei",新值为 "juzhiming"。
  4. 2024-05-29 15:21:49, 由 鞠智明 解决,方案为 程序BUG 。
    修改了 解决方案,旧值为 "",新值为 "code"。
    修改了 解决版本,旧值为 "",新值为 "trunk"。
    修改了 解决日期,旧值为 "",新值为 "2024-05-29 15:21:24"。
    修改了 指派给 ,旧值为 "juzhiming",新值为 "liuchao"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    修改了 解决者 ,旧值为 "",新值为 "juzhiming"。

    开发报告

    1.长度调整

  5. 2024-05-31 13:52:13, 由 刘超 编辑。
    修改了 严重程度,旧值为 "2",新值为 "3"。
    修改了 优先级 ,旧值为 "2",新值为 "3"。
    修改了 解决时效,旧值为 "0",新值为 ""。
    修改了 重现步骤,区别为:
    003-
    003+ @GroupProductNumUpdate_250 = null ,@LockNum_250 = 0 ,@UpdateTime_250 = 2024/5/29 0:19:20 ,@PurchaseType_250 = 0 ,@ItemMemo_250 = ,
    004- @GroupProductNumUpdate_250 = null ,@LockNum_250 = 0 ,@UpdateTime_250 = 2024/5/29 0:19:20 ,@PurchaseType_250 = 0 ,@ItemMemo_250 = ,
    004+ MESSAGE:The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.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&amp; dataReady) 在 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&amp; 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&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean&amp; 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.DALExtendV3.RB_OrderListExtendV3.BatchUpdateOrderListAllNum(List`1 models) 在 Biz.Irobotbox.ReStock.FBAOrderService.BatchNumShipmentAutoUpdate() 在 Biz.Irobotbox.ReStock.FBAOrderService.AutoCombinedOrder() 在 ChinaDownLoadImage.Task.Restock.Task_Restock_AutoCombinedOrder.Execute() 在 RB.Utility.SystemTask.&lt;doTask&gt;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&amp; currentTaskSlot) 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution) 在 System.Threading.ThreadPoolWorkQueue.Dispatch()[结果]
    005- MESSAGE:The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.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&amp; dataReady) 在 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&amp; 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&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean&amp; 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.DALExtendV3.RB_OrderListExtendV3.BatchUpdateOrderListAllNum(List`1 models) 在 Biz.Irobotbox.ReStock.FBAOrderService.BatchNumShipmentAutoUpdate() 在 Biz.Irobotbox.ReStock.FBAOrderService.AutoCombinedOrder() 在 ChinaDownLoadImage.Task.Restock.Task_Restock_AutoCombinedOrder.Execute() 在 RB.Utility.SystemTask.&lt;doTask&gt;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&amp; currentTaskSlot) 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution) 在 System.Threading.ThreadPoolWorkQueue.Dispatch()[结果]
    005+ [期望] 建议分批次处理。
    006- [期望] 建议分批次处理。
    006+
    007-
    003- <p></p>
    003+ @GroupProductNumUpdate_250 = null ,@LockNum_250 = 0 ,@UpdateTime_250 = 2024/5/29 0:19:20 ,@PurchaseType_250 = 0 ,@ItemMemo_250 = ,<br />
    004- @GroupProductNumUpdate_250 = null ,@LockNum_250 = 0 ,@UpdateTime_250 = 2024/5/29 0:19:20 ,@PurchaseType_250 = 0 ,@ItemMemo_250 = ,<br />
    004+ MESSAGE:The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.<br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)<br /> 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)<br /> 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()<br /> 在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /> 在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms)<br /> 在 RB.DALExtendV3.RB_OrderListExtendV3.BatchUpdateOrderListAllNum(List`1 models)<br /> 在 Biz.Irobotbox.ReStock.FBAOrderService.BatchNumShipmentAutoUpdate()<br /> 在 Biz.Irobotbox.ReStock.FBAOrderService.AutoCombinedOrder()<br /> 在 ChinaDownLoadImage.Task.Restock.Task_Restock_AutoCombinedOrder.Execute()<br /> 在 RB.Utility.SystemTask.&lt;doTask&gt;b__43_0()<br /> 在 System.Threading.Tasks.Task.Execute()<br /> 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /> 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /> 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task&amp; currentTaskSlot)<br /> 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)<br /> 在 System.Threading.ThreadPoolWorkQueue.Dispatch()<br /><br /><p>[结果]</p>
    005- MESSAGE:The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.<br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)<br /> 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)<br /> 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()<br /> 在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /> 在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms)<br /> 在 RB.DALExtendV3.RB_OrderListExtendV3.BatchUpdateOrderListAllNum(List`1 models)<br /> 在 Biz.Irobotbox.ReStock.FBAOrderService.BatchNumShipmentAutoUpdate()<br /> 在 Biz.Irobotbox.ReStock.FBAOrderService.AutoCombinedOrder()<br /> 在 ChinaDownLoadImage.Task.Restock.Task_Restock_AutoCombinedOrder.Execute()<br /> 在 RB.Utility.SystemTask.&lt;doTask&gt;b__43_0()<br /> 在 System.Threading.Tasks.Task.Execute()<br /> 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /> 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /> 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task&amp; currentTaskSlot)<br /> 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)<br /> 在 System.Threading.ThreadPoolWorkQueue.Dispatch()<br /><br /><p>[结果]</p>
    005+ <br /><p>[期望] 建议分批次处理。</p>
    006- <br /><p>[期望] 建议分批次处理。</p>
    006+ <br />
    007- <br />
  6. 2024-05-31 13:52:16, 由 刘超 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 指派给 ,旧值为 "liuchao",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "liuchao"。
    修改了 关闭日期,旧值为 "",新值为 "2024-05-31 13:52:16"。
所属项目 技术中心-需求池
所属模块 供应链   仓储物流   备库订单
所属计划
所属迭代
Bug类型
严重程度 提示
优先级 P2
Bug状态 已关闭
业务部门
影响功能
开发责任人 鞠智明
测试责任人
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2024-05-31 13:52:16
截止日期 0000-00-00
上线时间 0000-00-00 00:00:00
上线时效 -1
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 袁慧斌 于 2024-05-29 09:27:58
影响环境 577
由谁解决 鞠智明 于 2024-05-29 15:21:24
解决版本 主干
解决方案 程序BUG
由谁关闭 刘超 于 2024-05-31 13:52:16
最后修改 刘超 于 2024-05-31 13:52:16
相关Bug