重现步骤

[步骤]



[05:30:31]  -------------------------------------------------------------
CODE:N053031124
Error:11_-2_0_-2146232060
SQL: DECLARE @tempTable TABLE(item varchar(50)); 
                                        INSERT INTO @tempTable 
                                        EXEC proc_string_split @skuStr,',';  SELECT COUNT(*) AS TotalCount 
                            FROM RB_Procurement_Detail_PutList RPDP with(nolock) 
                            LEFT JOIN RB_Procurement_List RPL with(nolock) 
                            ON RPDP.CustomerID = RPL.CustomerID AND RPDP.P_Code = RPL.P_Code
                            JOIN RB_Product p with(nolock) 
                            ON RPDP.CustomerID = p.CustomerID AND RPDP.SKU=P.SKU
                            WHERE  RPDP.CustomerID=@CustomerID 
                                   AND RPDP.AddTime>=@AddTime 
                                   AND ISNULL(RPL.IsSample,0) =0 
                                    AND EXISTS (SELECT 1 FROM  @tempTable WHERE item=RPDP.SKU) ;
PARAMS:@CustomerID = 1 ,@AddTime = 2024/10/18 5:30:01 ,@skuStr = 16731239,21696936,18565589,13355830,21450347,13385430,11850347,17742873,8603322,13672181,6755482,21734574,10453123,10590570,20744961,16719449,19438113,19935652,16214740,17882530,16287930,20763688,6316780,18093170,3890543,20107978,12848035,16858879,17855940,11818279,18627894,7161414,13608708,20906744,4778327,16083002,16318515,18087812,16368118,11885871,17493149,20007217,14633266,19492971,17578794,3981665,17962762



89565,21750115,19675459,7122278,17817775,4248359,17643756,16179168,13205486 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 
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.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.DAL.DBOperator.QueryDataRow(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB)
   在 RB.DALExtend.RB_Procurement_Detail_PutListExtend.GetProcurementDetailPutListRecord(Int32 customerId, DateTime addTime, List`1 skuList)
   在 Biz.Irobotbox.Product.ProductService.BatchUpdateProductPurchaseDaysService()
   在 ChinaDownLoadImage.Task.Product.Task_Product_PurchaseDays.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. 2025-10-21 09:38:05, 由 袁慧斌 创建。
  2. 2025-10-21 16:34:48, 由 李乐同 指派给 何建宝。
    修改了 指派给，旧值为 "liletong"，新值为 "hejianbao"。
  3. 2025-10-21 18:11:11, 由 何建宝 解决，方案为 性能问题 。
    修改了 解决方案，旧值为 ""，新值为 "performance"。
    修改了 解决版本，旧值为 ""，新值为 "trunk"。
    修改了 解决日期，旧值为 ""，新值为 "2025-10-21 18:10:44"。
    修改了 指派给 ，旧值为 "hejianbao"，新值为 "yuanhuibin"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "hejianbao"。
    已优化处理，发布后观察下效果
  4. 2025-10-21 18:12:23, 由 袁慧斌 编辑。
    修改了 开发责任人，旧值为 ""，新值为 "admin"。
    修改了 测试责任人，旧值为 ""，新值为 "admin"。
    修改了 解决时效 ，旧值为 "0"，新值为 "8.54"。
    修改了 截止日期 ，旧值为 "0000-00-00"，新值为 "2025-10-21"。
    修改了 重现步骤 ，区别为：
    002- [05:30:31] -------------------------------------------------------------CODE:N053031124Error:11_-2_0_-2146232060SQL: DECLARE @tempTable TABLE(item varchar(50)); INSERT INTO @tempTable EXEC proc_string_split @skuStr,','; SELECT COUNT(*) AS TotalCount FROM RB_Procurement_Detail_PutList RPDP with(nolock) LEFT JOIN RB_Procurement_List RPL with(nolock) ON RPDP.CustomerID = RPL.CustomerID AND RPDP.P_Code = RPL.P_Code JOIN RB_Product p with(nolock) ON RPDP.CustomerID = p.CustomerID AND RPDP.SKU=P.SKU WHERE RPDP.CustomerID=@CustomerID AND RPDP.AddTime&gt;=@AddTime AND ISNULL(RPL.IsSample,0) =0 AND EXISTS (SELECT 1 FROM @tempTable WHERE item=RPDP.SKU) ;PARAMS:@CustomerID = 1 ,@AddTime = 2024/10/18 5:30:01 ,@skuStr = 16731239,21696936,18565589,13355830,21450347,13385430,11850347,17742873,8603322,13672181,6755482,21734574,10453123,10590570,20744961,16719449,19438113,19935652,16214740,17882530,16287930,20763688,6316780,18093170,3890543,20107978,12848035,16858879,17855940,11818279,18627894,7161414,13608708,20906744,4778327,16083002,16318515,18087812,16368118,11885871,17493149,20007217,14633266,19492971,17578794,3981665,17962762
    002+ [05:30:31] -------------------------------------------------------------CODE:N053031124Error:11_-2_0_-2146232060SQL: DECLARE @tempTable TABLE(item varchar(50)); INSERT INTO @tempTable EXEC proc_string_split @skuStr,','; SELECT COUNT(*) AS TotalCount FROM RB_Procurement_Detail_PutList RPDP with(nolock) LEFT JOIN RB_Procurement_List RPL with(nolock) ON RPDP.CustomerID = RPL.CustomerID AND RPDP.P_Code = RPL.P_Code JOIN RB_Product p with(nolock) ON RPDP.CustomerID = p.CustomerID AND RPDP.SKU=P.SKU WHERE RPDP.CustomerID=@CustomerID AND RPDP.AddTime&gt;=@AddTime AND ISNULL(RPL.IsSample,0) =0 AND EXISTS (SELECT 1 FROM @tempTable WHERE item=RPDP.SKU) ;PARAMS:@CustomerID = 1 ,@AddTime = 2024/10/18 5:30:01 ,@skuStr = 16731239,21696936,18565589,13355830,21450347,13385430,11850347,17742873,8603322,13672181,6755482,21734574,10453123,10590570,20744961,16719449,19438113,19935652,16214740,17882530,16287930,20763688,6316780,18093170,3890543,20107978,12848035,16858879,17855940,11818279,18627894,7161414,13608708,20906744,4778327,16083002,16318515,18087812,16368118,11885871,17493149,20007217,14633266,19492971,17578794,3981665,17962762
    002- <p><br /><br />[05:30:31] -------------------------------------------------------------<br />CODE:N053031124<br />Error:11_-2_0_-2146232060<br />SQL: DECLARE @tempTable TABLE(item varchar(50));<br /> INSERT INTO @tempTable<br /> EXEC proc_string_split @skuStr,','; SELECT COUNT(*) AS TotalCount<br /> FROM RB_Procurement_Detail_PutList RPDP with(nolock)<br /> LEFT JOIN RB_Procurement_List RPL with(nolock)<br /> ON RPDP.CustomerID = RPL.CustomerID AND RPDP.P_Code = RPL.P_Code<br /> JOIN RB_Product p with(nolock)<br /> ON RPDP.CustomerID = p.CustomerID AND RPDP.SKU=P.SKU<br /> WHERE RPDP.CustomerID=@CustomerID<br /> AND RPDP.AddTime&gt;=@AddTime<br /> AND ISNULL(RPL.IsSample,0) =0<br /> AND EXISTS (SELECT 1 FROM @tempTable WHERE item=RPDP.SKU) ;<br />PARAMS:@CustomerID = 1 ,@AddTime = 2024/10/18 5:30:01 ,@skuStr = 16731239,21696936,18565589,13355830,21450347,13385430,11850347,17742873,8603322,13672181,6755482,21734574,10453123,10590570,20744961,16719449,19438113,19935652,16214740,17882530,16287930,20763688,6316780,18093170,3890543,20107978,12848035,16858879,17855940,11818279,18627894,7161414,13608708,20906744,4778327,16083002,16318515,18087812,16368118,11885871,17493149,20007217,14633266,19492971,17578794,3981665,17962762<br /></p>
    002+ <p><br /><br />[05:30:31] -------------------------------------------------------------<br />CODE:N053031124<br />Error:11_-2_0_-2146232060<br />SQL: DECLARE @tempTable TABLE(item varchar(50));<br /> INSERT INTO @tempTable<br /> EXEC proc_string_split @skuStr,','; SELECT COUNT(*) AS TotalCount<br /> FROM RB_Procurement_Detail_PutList RPDP with(nolock)<br /> LEFT JOIN RB_Procurement_List RPL with(nolock)<br /> ON RPDP.CustomerID = RPL.CustomerID AND RPDP.P_Code = RPL.P_Code<br /> JOIN RB_Product p with(nolock)<br /> ON RPDP.CustomerID = p.CustomerID AND RPDP.SKU=P.SKU<br /> WHERE RPDP.CustomerID=@CustomerID<br /> AND RPDP.AddTime&gt;=@AddTime<br /> AND ISNULL(RPL.IsSample,0) =0<br /> AND EXISTS (SELECT 1 FROM @tempTable WHERE item=RPDP.SKU) ;<br />PARAMS:@CustomerID = 1 ,@AddTime = 2024/10/18 5:30:01 ,@skuStr = 16731239,21696936,18565589,13355830,21450347,13385430,11850347,17742873,8603322,13672181,6755482,21734574,10453123,10590570,20744961,16719449,19438113,19935652,16214740,17882530,16287930,20763688,6316780,18093170,3890543,20107978,12848035,16858879,17855940,11818279,18627894,7161414,13608708,20906744,4778327,16083002,16318515,18087812,16368118,11885871,17493149,20007217,14633266,19492971,17578794,3981665,17962762</p>
  5. 2025-10-21 18:12:26, 由 袁慧斌 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "yuanhuibin"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "yuanhuibin"。
    修改了 关闭日期，旧值为 ""，新值为 "2025-10-21 18:12:26"。
所属项目 技术中心-需求池
所属模块 供应链   产品采购   采购
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P1
Bug状态 已关闭
业务部门 供应链管理中心
影响功能
开发责任人 admin
测试责任人 admin
解决时效 8.54
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-10-21 18:12:26
截止日期 2025-10-21
上线时间 0000-00-00 00:00:00
上线时效 -1
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 袁慧斌 于 2025-10-21 09:38:05
影响环境 生产环境-线上测试
由谁解决 何建宝 于 2025-10-21 18:10:44
解决版本 主干
解决方案 性能问题
由谁关闭 袁慧斌 于 2025-10-21 18:12:26
最后修改 袁慧斌 于 2025-10-21 18:12:26
相关Bug