修改了 所属计划，旧值为 ""，新值为 "1762"。
修改了 所处阶段，旧值为 "wait"，新值为 "planned"。

修改了 版本号 ，旧值为 "1"，新值为 "2"。
修改了 需求名称，区别为：

001- web 订单利润报告 异常
001+ 【性能优化】订单利润报告SQL优化

001- web 订单利润报告 异常
001+ 【性能优化】订单利润报告SQL优化

修改了 需求描述，区别为：

003- CODE:N1012422Error:16_8152_30_-2146232060SQL:if  exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TbODS01') and type='U'))  begin drop table #TbODS01 endcreate table #TbODS01 (Id int primary key)insert into #TbODS01(Id) select Item from CharSplitForIn('17561,16459,16401,16088,16087,16086,16085,16083,16082,16081,16080,16079,16078,16077,16076,16075,16074,22006,22004,22003,22002,22001,22000,21999,21997,21996,22695,21994,21998,21995,3000,6642,21767,21803,12440,12439,12438,16116,6644,12437,22005,16084',',');SELECT COUNT(DISTINCT SellerSKU)  as SellerSKUCount FROM RB_Report_OrderSettlement a with(nolock)  inner join #TbODS01 os on a.OrderSourceID=os.Id inner join @tb_BatchAsins tba on a.ASINorItemID=tba.Id=@DateStartTime and ShipDate<>'' PARAMS:@CustomerID = 1 ,@DateStartTime = 2023-01-01 ,@DateEndTime = 2025/2/12 0:00:00 ,@tb_BatchAsins = 34U184016PS Z81757512V5J9JV2 386B8LX13240BXHN Y1722P36EMUP 6BS837LXMBLEL09K49EEXZ 394I8H385OTXRGL216BRUN 11MFTM26RDNWK8AP53LV0APX1 UL170719VE8JZMHE 6D09XDAI0Z4149LGTADK C39X5R8GMY15Z0710Q9K2 2U0957583G7BC6SH 220QO30SEG17MIPQ6R 71112U0662MQUFML3S 53NE03O14OA MUYM4167B7DNM173KED 2V095813DC9N0OFA OLYR092V28317DGL U29P4A17IS7095WU VQ9AK8T57B4355HDP15C I7O11PJY4037EOQI80BV HF172431E4774C0H YL11REWG195MWBM066C27XF4 ATFRZE54575DO09BV UR0XOY20260QIVS3010V5 L4610AVN17K09Y17UIP28 AJ161602CA9H8ZMQ F46494K41509V9BSY 9K142213GTRMVG1W U5103624X9T0BUCV MR20Q30XG109 V7175500GAGKMEX2 J4195H17T6 7L0BM13N24FRJ380V3IMU657Q LC1414394LC7KD2D 607NK10VFOG6Y55R57PA21JT8 S9N11P440BI38OTAU4BMF UR1M271831MZ3GEWSU 89-T15U-C6LK BWZ09T35BU09JKVDH7A 84104549OY1UMJOT P83ZY039M1J30099N10J5QY5U J8100114811CFA7 YJ1553097W 56TI16FJ41QKK LN04PB12F4150RY 6O14163042SRHR7W 17RRV33J0650NCL3 6B144322SLGBMLNN R3119LXDRC2NM0UCB09CA10C amzn.gr.07BR33IE191-7Sb4dyKeBEF-213bw-LN amzn.gr.URIE21H47304S10KVH9PU1-IJg8cA-VG A1718229MIPTZF 2713OZKH098 153085136NQZLSN 07EW3NL57CL309B SBAYJ5262U1511NHK, ,MESSAGE:String or binary data would be truncated.The statement has been terminated.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, Int32 times, Boolean IsWriteDB)   在 RB.DALExtendV2.Generate.Report.RB_Report_OrderSettlementExtendV2.GetSellerSKUCount(CM_ProductSKU_Settlement_ReportParam param)   在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesProductReportHandler.ProcessRequest(HttpContext context)   在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()   在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)   在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)   在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)   在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)   在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)   在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)   在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
003+ CODE:N1012422Error:16_8152_30_-2146232060SQL:if exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TbODS01') and type='U')) begin drop table #TbODS01 endcreate table #TbODS01 (Id int primary key)insert into #TbODS01(Id) select Item from CharSplitForIn('17561,16459,16401,16088,16087,16086,16085,16083,16082,16081,16080,16079,16078,16077,16076,16075,16074,22006,22004,22003,22002,22001,22000,21999,21997,21996,22695,21994,21998,21995,3000,6642,21767,21803,12440,12439,12438,16116,6644,12437,22005,16084',',');SELECT COUNT(DISTINCT SellerSKU) as SellerSKUCount FROM RB_Report_OrderSettlement a with(nolock) inner join #TbODS01 os on a.OrderSourceID=os.Id inner join @tb_BatchAsins tba on a.ASINorItemID=tba.Id=@DateStartTime and ShipDate<>'' PARAMS:@CustomerID = 1 ,@DateStartTime = 2023-01-01 ,@DateEndTime = 2025/2/12 0:00:00 ,@tb_BatchAsins = 34U184016PS Z81757512V5J9JV2 386B8LX13240BXHN Y1722P36EMUP 6BS837LXMBLEL09K49EEXZ 394I8H385OTXRGL216BRUN 11MFTM26RDNWK8AP53LV0APX1 UL170719VE8JZMHE 6D09XDAI0Z4149LGTADK C39X5R8GMY15Z0710Q9K2 2U0957583G7BC6SH 220QO30SEG17MIPQ6R 71112U0662MQUFML3S 53NE03O14OA MUYM4167B7DNM173KED 2V095813DC9N0OFA OLYR092V28317DGL U29P4A17IS7095WU VQ9AK8T57B4355HDP15C I7O11PJY4037EOQI80BV HF172431E4774C0H YL11REWG195MWBM066C27XF4 ATFRZE54575DO09BV UR0XOY20260QIVS3010V5 L4610AVN17K09Y17UIP28 AJ161602CA9H8ZMQ F46494K41509V9BSY 9K142213GTRMVG1W U5103624X9T0BUCV MR20Q30XG109 V7175500GAGKMEX2 J4195H17T6 7L0BM13N24FRJ380V3IMU657Q LC1414394LC7KD2D 607NK10VFOG6Y55R57PA21JT8 S9N11P440BI38OTAU4BMF UR1M271831MZ3GEWSU 89-T15U-C6LK BWZ09T35BU09JKVDH7A 84104549OY1UMJOT P83ZY039M1J30099N10J5QY5U J8100114811CFA7 YJ1553097W 56TI16FJ41QKK LN04PB12F4150RY 6O14163042SRHR7W 17RRV33J0650NCL3 6B144322SLGBMLNN R3119LXDRC2NM0UCB09CA10C amzn.gr.07BR33IE191-7Sb4dyKeBEF-213bw-LN amzn.gr.URIE21H47304S10KVH9PU1-IJg8cA-VG A1718229MIPTZF 2713OZKH098 153085136NQZLSN 07EW3NL57CL309B SBAYJ5262U1511NHK, ,MESSAGE:String or binary data would be truncated.The statement has been terminated.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, Int32 times, Boolean IsWriteDB) 在 RB.DALExtendV2.Generate.Report.RB_Report_OrderSettlementExtendV2.GetSellerSKUCount(CM_ProductSKU_Settlement_ReportParam param) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesProductReportHandler.ProcessRequest(HttpContext context) 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

003- CODE:N1012422<br /><br />Error:16_8152_30_-2146232060<br /><br />SQL:<br /><br />if  exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TbODS01') and type='U'))  <br /><br />begin<br /><br /> drop table #TbODS01 <br /><br />end<br /><br />create table #TbODS01 (Id int primary key)<br /><br />insert into #TbODS01(Id) select Item from CharSplitForIn('17561,16459,16401,16088,16087,16086,16085,16083,16082,16081,16080,16079,16078,16077,16076,16075,16074,22006,22004,22003,22002,22001,22000,21999,21997,21996,22695,21994,21998,21995,3000,6642,21767,21803,12440,12439,12438,16116,6644,12437,22005,16084',',');<br /><br /><br /><br />SELECT COUNT(DISTINCT SellerSKU)  as SellerSKUCount FROM RB_Report_OrderSettlement a with(nolock)  inner join #TbODS01 os on a.OrderSourceID=os.Id inner join @tb_BatchAsins tba on a.ASINorItemID=tba.Id<br /><br />=@DateStartTime and ShipDate&lt;&gt;'' <br /><br />PARAMS:@CustomerID = 1 ,@DateStartTime = 2023-01-01 ,@DateEndTime = 2025/2/12 0:00:00 ,@tb_BatchAsins = 34U184016PS Z81757512V5J9JV2 386B8LX13240BXHN Y1722P36EMUP 6BS837LXMBLEL09K49EEXZ 394I8H385OTXRGL216BRUN 11MFTM26RDNWK8AP53LV0APX1 UL170719VE8JZMHE 6D09XDAI0Z4149LGTADK C39X5R8GMY15Z0710Q9K2 2U0957583G7BC6SH 220QO30SEG17MIPQ6R 71112U0662MQUFML3S 53NE03O14OA MUYM4167B7DNM173KED 2V095813DC9N0OFA OLYR092V28317DGL U29P4A17IS7095WU VQ9AK8T57B4355HDP15C I7O11PJY4037EOQI80BV HF172431E4774C0H YL11REWG195MWBM066C27XF4 ATFRZE54575DO09BV UR0XOY20260QIVS3010V5 L4610AVN17K09Y17UIP28 AJ161602CA9H8ZMQ F46494K41509V9BSY 9K142213GTRMVG1W U5103624X9T0BUCV MR20Q30XG109 V7175500GAGKMEX2 J4195H17T6 7L0BM13N24FRJ380V3IMU657Q LC1414394LC7KD2D 607NK10VFOG6Y55R57PA21JT8 S9N11P440BI38OTAU4BMF UR1M271831MZ3GEWSU 89-T15U-C6LK BWZ09T35BU09JKVDH7A 84104549OY1UMJOT P83ZY039M1J30099N10J5QY5U J8100114811CFA7 YJ1553097W 56TI16FJ41QKK LN04PB12F4150RY 6O14163042SRHR7W 17RRV33J0650NCL3 6B144322SLGBMLNN R3119LXDRC2NM0UCB09CA10C amzn.gr.07BR33IE191-7Sb4dyKeBEF-213bw-LN amzn.gr.URIE21H47304S10KVH9PU1-IJg8cA-VG A1718229MIPTZF 2713OZKH098 153085136NQZLSN 07EW3NL57CL309B SBAYJ5262U1511NHK, ,<br /><br />MESSAGE:String or binary data would be truncated.<br /><br />The statement has been terminated.<br /><br />TRACE:   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /><br />   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /><br />   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /><br />   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /><br />   在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /><br />   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /><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 /><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 /><br />   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /><br />   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)<br /><br />   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /><br />   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /><br />   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)<br /><br />   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)   在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /><br />   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /><br />   在 RB.DAL.DBOperator.QueryDataRow(String SQLString, SqlParameter[] cmdParms, Int32 times, Boolean IsWriteDB)<br /><br />   在 RB.DALExtendV2.Generate.Report.RB_Report_OrderSettlementExtendV2.GetSellerSKUCount(CM_ProductSKU_Settlement_ReportParam param)<br /><br />   在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesProductReportHandler.ProcessRequest(HttpContext context)<br /><br />   在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()<br /><br />   在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)<br /><br />   在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)<br /><br />   在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)<br /><br />   在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)<br /><br />   在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)<br /><br />   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br />   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br />   在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br />   在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br />   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br />   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><div><br /></div>
003+ CODE:N1012422<br /><br />Error:16_8152_30_-2146232060<br /><br />SQL:<br /><br />if exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TbODS01') and type='U')) <br /><br />begin<br /><br /> drop table #TbODS01 <br /><br />end<br /><br />create table #TbODS01 (Id int primary key)<br /><br />insert into #TbODS01(Id) select Item from CharSplitForIn('17561,16459,16401,16088,16087,16086,16085,16083,16082,16081,16080,16079,16078,16077,16076,16075,16074,22006,22004,22003,22002,22001,22000,21999,21997,21996,22695,21994,21998,21995,3000,6642,21767,21803,12440,12439,12438,16116,6644,12437,22005,16084',',');<br /><br /><br /><br />SELECT COUNT(DISTINCT SellerSKU) as SellerSKUCount FROM RB_Report_OrderSettlement a with(nolock) inner join #TbODS01 os on a.OrderSourceID=os.Id inner join @tb_BatchAsins tba on a.ASINorItemID=tba.Id<br /><br />=@DateStartTime and ShipDate&lt;&gt;'' <br /><br />PARAMS:@CustomerID = 1 ,@DateStartTime = 2023-01-01 ,@DateEndTime = 2025/2/12 0:00:00 ,@tb_BatchAsins = 34U184016PS Z81757512V5J9JV2 386B8LX13240BXHN Y1722P36EMUP 6BS837LXMBLEL09K49EEXZ 394I8H385OTXRGL216BRUN 11MFTM26RDNWK8AP53LV0APX1 UL170719VE8JZMHE 6D09XDAI0Z4149LGTADK C39X5R8GMY15Z0710Q9K2 2U0957583G7BC6SH 220QO30SEG17MIPQ6R 71112U0662MQUFML3S 53NE03O14OA MUYM4167B7DNM173KED 2V095813DC9N0OFA OLYR092V28317DGL U29P4A17IS7095WU VQ9AK8T57B4355HDP15C I7O11PJY4037EOQI80BV HF172431E4774C0H YL11REWG195MWBM066C27XF4 ATFRZE54575DO09BV UR0XOY20260QIVS3010V5 L4610AVN17K09Y17UIP28 AJ161602CA9H8ZMQ F46494K41509V9BSY 9K142213GTRMVG1W U5103624X9T0BUCV MR20Q30XG109 V7175500GAGKMEX2 J4195H17T6 7L0BM13N24FRJ380V3IMU657Q LC1414394LC7KD2D 607NK10VFOG6Y55R57PA21JT8 S9N11P440BI38OTAU4BMF UR1M271831MZ3GEWSU 89-T15U-C6LK BWZ09T35BU09JKVDH7A 84104549OY1UMJOT P83ZY039M1J30099N10J5QY5U J8100114811CFA7 YJ1553097W 56TI16FJ41QKK LN04PB12F4150RY 6O14163042SRHR7W 17RRV33J0650NCL3 6B144322SLGBMLNN R3119LXDRC2NM0UCB09CA10C amzn.gr.07BR33IE191-7Sb4dyKeBEF-213bw-LN amzn.gr.URIE21H47304S10KVH9PU1-IJg8cA-VG A1718229MIPTZF 2713OZKH098 153085136NQZLSN 07EW3NL57CL309B SBAYJ5262U1511NHK, ,<br /><br />MESSAGE:String or binary data would be truncated.<br /><br />The statement has been terminated.<br /><br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /><br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /><br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /><br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /><br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /><br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /><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 /><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 /><br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /><br /> 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)<br /><br /> 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /><br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /><br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)<br /><br /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /><br /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /><br /> 在 RB.DAL.DBOperator.QueryDataRow(String SQLString, SqlParameter[] cmdParms, Int32 times, Boolean IsWriteDB)<br /><br /> 在 RB.DALExtendV2.Generate.Report.RB_Report_OrderSettlementExtendV2.GetSellerSKUCount(CM_ProductSKU_Settlement_ReportParam param)<br /><br /> 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesProductReportHandler.ProcessRequest(HttpContext context)<br /><br /> 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()<br /><br /> 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)<br /><br /> 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)<br /><br /> 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)<br /><br /> 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)<br /><br /> 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><div><br /></div>

修改了 版本号 ，旧值为 "2"，新值为 "3"。
修改了 需求描述，区别为：

001- [步骤]
001+ <a href="https://alidocs.dingtalk.com/i/nodes/EpGBa2Lm8azdO4Lps9pEqZXBWgN7R35y">https://alidocs.dingtalk.com/i/nodes/EpGBa2Lm8azdO4Lps9pEqZXBWgN7R35y
002-
002+ [步骤]
003- CODE:N1012422Error:16_8152_30_-2146232060SQL:if exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TbODS01') and type='U')) begin drop table #TbODS01 endcreate table #TbODS01 (Id int primary key)insert into #TbODS01(Id) select Item from CharSplitForIn('17561,16459,16401,16088,16087,16086,16085,16083,16082,16081,16080,16079,16078,16077,16076,16075,16074,22006,22004,22003,22002,22001,22000,21999,21997,21996,22695,21994,21998,21995,3000,6642,21767,21803,12440,12439,12438,16116,6644,12437,22005,16084',',');SELECT COUNT(DISTINCT SellerSKU) as SellerSKUCount FROM RB_Report_OrderSettlement a with(nolock) inner join #TbODS01 os on a.OrderSourceID=os.Id inner join @tb_BatchAsins tba on a.ASINorItemID=tba.Id=@DateStartTime and ShipDate&lt;&gt;'' PARAMS:@CustomerID = 1 ,@DateStartTime = 2023-01-01 ,@DateEndTime = 2025/2/12 0:00:00 ,@tb_BatchAsins = 34U184016PS Z81757512V5J9JV2 386B8LX13240BXHN Y1722P36EMUP 6BS837LXMBLEL09K49EEXZ 394I8H385OTXRGL216BRUN 11MFTM26RDNWK8AP53LV0APX1 UL170719VE8JZMHE 6D09XDAI0Z4149LGTADK C39X5R8GMY15Z0710Q9K2 2U0957583G7BC6SH 220QO30SEG17MIPQ6R 71112U0662MQUFML3S 53NE03O14OA MUYM4167B7DNM173KED 2V095813DC9N0OFA OLYR092V28317DGL U29P4A17IS7095WU VQ9AK8T57B4355HDP15C I7O11PJY4037EOQI80BV HF172431E4774C0H YL11REWG195MWBM066C27XF4 ATFRZE54575DO09BV UR0XOY20260QIVS3010V5 L4610AVN17K09Y17UIP28 AJ161602CA9H8ZMQ F46494K41509V9BSY 9K142213GTRMVG1W U5103624X9T0BUCV MR20Q30XG109 V7175500GAGKMEX2 J4195H17T6 7L0BM13N24FRJ380V3IMU657Q LC1414394LC7KD2D 607NK10VFOG6Y55R57PA21JT8 S9N11P440BI38OTAU4BMF UR1M271831MZ3GEWSU 89-T15U-C6LK BWZ09T35BU09JKVDH7A 84104549OY1UMJOT P83ZY039M1J30099N10J5QY5U J8100114811CFA7 YJ1553097W 56TI16FJ41QKK LN04PB12F4150RY 6O14163042SRHR7W 17RRV33J0650NCL3 6B144322SLGBMLNN R3119LXDRC2NM0UCB09CA10C amzn.gr.07BR33IE191-7Sb4dyKeBEF-213bw-LN amzn.gr.URIE21H47304S10KVH9PU1-IJg8cA-VG A1718229MIPTZF 2713OZKH098 153085136NQZLSN 07EW3NL57CL309B SBAYJ5262U1511NHK, ,MESSAGE:String or binary data would be truncated.The statement has been terminated.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.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&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.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, Int32 times, Boolean IsWriteDB) 在 RB.DALExtendV2.Generate.Report.RB_Report_OrderSettlementExtendV2.GetSellerSKUCount(CM_ProductSKU_Settlement_ReportParam param) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesProductReportHandler.ProcessRequest(HttpContext context) 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously) 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
003+
004- [结果]
004+ CODE:N1012422Error:16_8152_30_-2146232060SQL:if exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TbODS01') and type='U')) begin drop table #TbODS01 endcreate table #TbODS01 (Id int primary key)insert into #TbODS01(Id) select Item from CharSplitForIn('17561,16459,16401,16088,16087,16086,16085,16083,16082,16081,16080,16079,16078,16077,16076,16075,16074,22006,22004,22003,22002,22001,22000,21999,21997,21996,22695,21994,21998,21995,3000,6642,21767,21803,12440,12439,12438,16116,6644,12437,22005,16084',',');SELECT COUNT(DISTINCT SellerSKU) as SellerSKUCount FROM RB_Report_OrderSettlement a with(nolock) inner join #TbODS01 os on a.OrderSourceID=os.Id inner join @tb_BatchAsins tba on a.ASINorItemID=tba.Id=@DateStartTime and ShipDate&lt;&gt;'' PARAMS:@CustomerID = 1 ,@DateStartTime = 2023-01-01 ,@DateEndTime = 2025/2/12 0:00:00 ,@tb_BatchAsins = 34U184016PS Z81757512V5J9JV2 386B8LX13240BXHN Y1722P36EMUP 6BS837LXMBLEL09K49EEXZ 394I8H385OTXRGL216BRUN 11MFTM26RDNWK8AP53LV0APX1 UL170719VE8JZMHE 6D09XDAI0Z4149LGTADK C39X5R8GMY15Z0710Q9K2 2U0957583G7BC6SH 220QO30SEG17MIPQ6R 71112U0662MQUFML3S 53NE03O14OA MUYM4167B7DNM173KED 2V095813DC9N0OFA OLYR092V28317DGL U29P4A17IS7095WU VQ9AK8T57B4355HDP15C I7O11PJY4037EOQI80BV HF172431E4774C0H YL11REWG195MWBM066C27XF4 ATFRZE54575DO09BV UR0XOY20260QIVS3010V5 L4610AVN17K09Y17UIP28 AJ161602CA9H8ZMQ F46494K41509V9BSY 9K142213GTRMVG1W U5103624X9T0BUCV MR20Q30XG109 V7175500GAGKMEX2 J4195H17T6 7L0BM13N24FRJ380V3IMU657Q LC1414394LC7KD2D 607NK10VFOG6Y55R57PA21JT8 S9N11P440BI38OTAU4BMF UR1M271831MZ3GEWSU 89-T15U-C6LK BWZ09T35BU09JKVDH7A 84104549OY1UMJOT P83ZY039M1J30099N10J5QY5U J8100114811CFA7 YJ1553097W 56TI16FJ41QKK LN04PB12F4150RY 6O14163042SRHR7W 17RRV33J0650NCL3 6B144322SLGBMLNN R3119LXDRC2NM0UCB09CA10C amzn.gr.07BR33IE191-7Sb4dyKeBEF-213bw-LN amzn.gr.URIE21H47304S10KVH9PU1-IJg8cA-VG A1718229MIPTZF 2713OZKH098 153085136NQZLSN 07EW3NL57CL309B SBAYJ5262U1511NHK, ,MESSAGE:String or binary data would be truncated.The statement has been terminated.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.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&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.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, Int32 times, Boolean IsWriteDB) 在 RB.DALExtendV2.Generate.Report.RB_Report_OrderSettlementExtendV2.GetSellerSKUCount(CM_ProductSKU_Settlement_ReportParam param) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesProductReportHandler.ProcessRequest(HttpContext context) 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously) 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
005- [期望]
005+ [结果]
006- 修复异常
006+ [期望]
007+ 修复异常

001- <p>[步骤]</p>
001+ <p><a href="https://alidocs.dingtalk.com/i/nodes/EpGBa2Lm8azdO4Lps9pEqZXBWgN7R35y">https://alidocs.dingtalk.com/i/nodes/EpGBa2Lm8azdO4Lps9pEqZXBWgN7R35y</a></p>
002- <br />
002+ <p>[步骤]</p>
003- CODE:N1012422<br /><br />Error:16_8152_30_-2146232060<br /><br />SQL:<br /><br />if exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TbODS01') and type='U')) <br /><br />begin<br /><br /> drop table #TbODS01 <br /><br />end<br /><br />create table #TbODS01 (Id int primary key)<br /><br />insert into #TbODS01(Id) select Item from CharSplitForIn('17561,16459,16401,16088,16087,16086,16085,16083,16082,16081,16080,16079,16078,16077,16076,16075,16074,22006,22004,22003,22002,22001,22000,21999,21997,21996,22695,21994,21998,21995,3000,6642,21767,21803,12440,12439,12438,16116,6644,12437,22005,16084',',');<br /><br /><br /><br />SELECT COUNT(DISTINCT SellerSKU) as SellerSKUCount FROM RB_Report_OrderSettlement a with(nolock) inner join #TbODS01 os on a.OrderSourceID=os.Id inner join @tb_BatchAsins tba on a.ASINorItemID=tba.Id<br /><br />=@DateStartTime and ShipDate&lt;&gt;'' <br /><br />PARAMS:@CustomerID = 1 ,@DateStartTime = 2023-01-01 ,@DateEndTime = 2025/2/12 0:00:00 ,@tb_BatchAsins = 34U184016PS Z81757512V5J9JV2 386B8LX13240BXHN Y1722P36EMUP 6BS837LXMBLEL09K49EEXZ 394I8H385OTXRGL216BRUN 11MFTM26RDNWK8AP53LV0APX1 UL170719VE8JZMHE 6D09XDAI0Z4149LGTADK C39X5R8GMY15Z0710Q9K2 2U0957583G7BC6SH 220QO30SEG17MIPQ6R 71112U0662MQUFML3S 53NE03O14OA MUYM4167B7DNM173KED 2V095813DC9N0OFA OLYR092V28317DGL U29P4A17IS7095WU VQ9AK8T57B4355HDP15C I7O11PJY4037EOQI80BV HF172431E4774C0H YL11REWG195MWBM066C27XF4 ATFRZE54575DO09BV UR0XOY20260QIVS3010V5 L4610AVN17K09Y17UIP28 AJ161602CA9H8ZMQ F46494K41509V9BSY 9K142213GTRMVG1W U5103624X9T0BUCV MR20Q30XG109 V7175500GAGKMEX2 J4195H17T6 7L0BM13N24FRJ380V3IMU657Q LC1414394LC7KD2D 607NK10VFOG6Y55R57PA21JT8 S9N11P440BI38OTAU4BMF UR1M271831MZ3GEWSU 89-T15U-C6LK BWZ09T35BU09JKVDH7A 84104549OY1UMJOT P83ZY039M1J30099N10J5QY5U J8100114811CFA7 YJ1553097W 56TI16FJ41QKK LN04PB12F4150RY 6O14163042SRHR7W 17RRV33J0650NCL3 6B144322SLGBMLNN R3119LXDRC2NM0UCB09CA10C amzn.gr.07BR33IE191-7Sb4dyKeBEF-213bw-LN amzn.gr.URIE21H47304S10KVH9PU1-IJg8cA-VG A1718229MIPTZF 2713OZKH098 153085136NQZLSN 07EW3NL57CL309B SBAYJ5262U1511NHK, ,<br /><br />MESSAGE:String or binary data would be truncated.<br /><br />The statement has been terminated.<br /><br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /><br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /><br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /><br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /><br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /><br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /><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 /><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 /><br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /><br /> 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)<br /><br /> 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /><br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /><br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)<br /><br /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /><br /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /><br /> 在 RB.DAL.DBOperator.QueryDataRow(String SQLString, SqlParameter[] cmdParms, Int32 times, Boolean IsWriteDB)<br /><br /> 在 RB.DALExtendV2.Generate.Report.RB_Report_OrderSettlementExtendV2.GetSellerSKUCount(CM_ProductSKU_Settlement_ReportParam param)<br /><br /> 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesProductReportHandler.ProcessRequest(HttpContext context)<br /><br /> 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()<br /><br /> 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)<br /><br /> 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)<br /><br /> 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)<br /><br /> 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)<br /><br /> 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><div><br /></div>
003+ <br />
004- <br /><p>[结果]</p>
004+ CODE:N1012422<br /><br />Error:16_8152_30_-2146232060<br /><br />SQL:<br /><br />if exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TbODS01') and type='U')) <br /><br />begin<br /><br /> drop table #TbODS01 <br /><br />end<br /><br />create table #TbODS01 (Id int primary key)<br /><br />insert into #TbODS01(Id) select Item from CharSplitForIn('17561,16459,16401,16088,16087,16086,16085,16083,16082,16081,16080,16079,16078,16077,16076,16075,16074,22006,22004,22003,22002,22001,22000,21999,21997,21996,22695,21994,21998,21995,3000,6642,21767,21803,12440,12439,12438,16116,6644,12437,22005,16084',',');<br /><br /><br /><br />SELECT COUNT(DISTINCT SellerSKU) as SellerSKUCount FROM RB_Report_OrderSettlement a with(nolock) inner join #TbODS01 os on a.OrderSourceID=os.Id inner join @tb_BatchAsins tba on a.ASINorItemID=tba.Id<br /><br />=@DateStartTime and ShipDate&lt;&gt;'' <br /><br />PARAMS:@CustomerID = 1 ,@DateStartTime = 2023-01-01 ,@DateEndTime = 2025/2/12 0:00:00 ,@tb_BatchAsins = 34U184016PS Z81757512V5J9JV2 386B8LX13240BXHN Y1722P36EMUP 6BS837LXMBLEL09K49EEXZ 394I8H385OTXRGL216BRUN 11MFTM26RDNWK8AP53LV0APX1 UL170719VE8JZMHE 6D09XDAI0Z4149LGTADK C39X5R8GMY15Z0710Q9K2 2U0957583G7BC6SH 220QO30SEG17MIPQ6R 71112U0662MQUFML3S 53NE03O14OA MUYM4167B7DNM173KED 2V095813DC9N0OFA OLYR092V28317DGL U29P4A17IS7095WU VQ9AK8T57B4355HDP15C I7O11PJY4037EOQI80BV HF172431E4774C0H YL11REWG195MWBM066C27XF4 ATFRZE54575DO09BV UR0XOY20260QIVS3010V5 L4610AVN17K09Y17UIP28 AJ161602CA9H8ZMQ F46494K41509V9BSY 9K142213GTRMVG1W U5103624X9T0BUCV MR20Q30XG109 V7175500GAGKMEX2 J4195H17T6 7L0BM13N24FRJ380V3IMU657Q LC1414394LC7KD2D 607NK10VFOG6Y55R57PA21JT8 S9N11P440BI38OTAU4BMF UR1M271831MZ3GEWSU 89-T15U-C6LK BWZ09T35BU09JKVDH7A 84104549OY1UMJOT P83ZY039M1J30099N10J5QY5U J8100114811CFA7 YJ1553097W 56TI16FJ41QKK LN04PB12F4150RY 6O14163042SRHR7W 17RRV33J0650NCL3 6B144322SLGBMLNN R3119LXDRC2NM0UCB09CA10C amzn.gr.07BR33IE191-7Sb4dyKeBEF-213bw-LN amzn.gr.URIE21H47304S10KVH9PU1-IJg8cA-VG A1718229MIPTZF 2713OZKH098 153085136NQZLSN 07EW3NL57CL309B SBAYJ5262U1511NHK, ,<br /><br />MESSAGE:String or binary data would be truncated.<br /><br />The statement has been terminated.<br /><br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /><br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /><br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /><br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /><br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /><br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /><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 /><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 /><br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /><br /> 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)<br /><br /> 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /><br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /><br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)<br /><br /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /><br /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /><br /> 在 RB.DAL.DBOperator.QueryDataRow(String SQLString, SqlParameter[] cmdParms, Int32 times, Boolean IsWriteDB)<br /><br /> 在 RB.DALExtendV2.Generate.Report.RB_Report_OrderSettlementExtendV2.GetSellerSKUCount(CM_ProductSKU_Settlement_ReportParam param)<br /><br /> 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesProductReportHandler.ProcessRequest(HttpContext context)<br /><br /> 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()<br /><br /> 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)<br /><br /> 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)<br /><br /> 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)<br /><br /> 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)<br /><br /> 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><div><br /></div>
005- <br /><p>[期望]</p>
005+ <br /><p>[结果]</p>
006- 修复异常
006+ <br /><p>[期望]</p>
007+ 修复异常

修改了 版本号 ，旧值为 "3"，新值为 "4"。
修改了 需求名称，区别为：

001- 【性能优化】订单利润报告SQL优化
001+ 【性能优化】增加约束条件防止产品利润输入Asin超长

001- 【性能优化】订单利润报告SQL优化
001+ 【性能优化】增加约束条件防止产品利润输入Asin超长

修改了 版本号 ，旧值为 "4"，新值为 "5"。
修改了 需求描述，区别为：

001- <a href="https://alidocs.dingtalk.com/i/nodes/EpGBa2Lm8azdO4Lps9pEqZXBWgN7R35y">https://alidocs.dingtalk.com/i/nodes/EpGBa2Lm8azdO4Lps9pEqZXBWgN7R35y
001+ <a href="https://alidocs.dingtalk.com/i/nodes/EpGBa2Lm8azdO4Lps9pEqZXBWgN7R35y">https://alidocs.dingtalk.com/i/nodes/EpGBa2Lm8azdO4Lps9pEqZXBWgN7R35y
002- [步骤]
003-
004- CODE:N1012422Error:16_8152_30_-2146232060SQL:if exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TbODS01') and type='U')) begin drop table #TbODS01 endcreate table #TbODS01 (Id int primary key)insert into #TbODS01(Id) select Item from CharSplitForIn('17561,16459,16401,16088,16087,16086,16085,16083,16082,16081,16080,16079,16078,16077,16076,16075,16074,22006,22004,22003,22002,22001,22000,21999,21997,21996,22695,21994,21998,21995,3000,6642,21767,21803,12440,12439,12438,16116,6644,12437,22005,16084',',');SELECT COUNT(DISTINCT SellerSKU) as SellerSKUCount FROM RB_Report_OrderSettlement a with(nolock) inner join #TbODS01 os on a.OrderSourceID=os.Id inner join @tb_BatchAsins tba on a.ASINorItemID=tba.Id=@DateStartTime and ShipDate&lt;&gt;'' PARAMS:@CustomerID = 1 ,@DateStartTime = 2023-01-01 ,@DateEndTime = 2025/2/12 0:00:00 ,@tb_BatchAsins = 34U184016PS Z81757512V5J9JV2 386B8LX13240BXHN Y1722P36EMUP 6BS837LXMBLEL09K49EEXZ 394I8H385OTXRGL216BRUN 11MFTM26RDNWK8AP53LV0APX1 UL170719VE8JZMHE 6D09XDAI0Z4149LGTADK C39X5R8GMY15Z0710Q9K2 2U0957583G7BC6SH 220QO30SEG17MIPQ6R 71112U0662MQUFML3S 53NE03O14OA MUYM4167B7DNM173KED 2V095813DC9N0OFA OLYR092V28317DGL U29P4A17IS7095WU VQ9AK8T57B4355HDP15C I7O11PJY4037EOQI80BV HF172431E4774C0H YL11REWG195MWBM066C27XF4 ATFRZE54575DO09BV UR0XOY20260QIVS3010V5 L4610AVN17K09Y17UIP28 AJ161602CA9H8ZMQ F46494K41509V9BSY 9K142213GTRMVG1W U5103624X9T0BUCV MR20Q30XG109 V7175500GAGKMEX2 J4195H17T6 7L0BM13N24FRJ380V3IMU657Q LC1414394LC7KD2D 607NK10VFOG6Y55R57PA21JT8 S9N11P440BI38OTAU4BMF UR1M271831MZ3GEWSU 89-T15U-C6LK BWZ09T35BU09JKVDH7A 84104549OY1UMJOT P83ZY039M1J30099N10J5QY5U J8100114811CFA7 YJ1553097W 56TI16FJ41QKK LN04PB12F4150RY 6O14163042SRHR7W 17RRV33J0650NCL3 6B144322SLGBMLNN R3119LXDRC2NM0UCB09CA10C amzn.gr.07BR33IE191-7Sb4dyKeBEF-213bw-LN amzn.gr.URIE21H47304S10KVH9PU1-IJg8cA-VG A1718229MIPTZF 2713OZKH098 153085136NQZLSN 07EW3NL57CL309B SBAYJ5262U1511NHK, ,MESSAGE:String or binary data would be truncated.The statement has been terminated.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.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&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.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, Int32 times, Boolean IsWriteDB) 在 RB.DALExtendV2.Generate.Report.RB_Report_OrderSettlementExtendV2.GetSellerSKUCount(CM_ProductSKU_Settlement_ReportParam param) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesProductReportHandler.ProcessRequest(HttpContext context) 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously) 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
005- [结果]
006- [期望]
007- 修复异常

001- <p><a href="https://alidocs.dingtalk.com/i/nodes/EpGBa2Lm8azdO4Lps9pEqZXBWgN7R35y">https://alidocs.dingtalk.com/i/nodes/EpGBa2Lm8azdO4Lps9pEqZXBWgN7R35y</a></p>
001+ <p><a href="https://alidocs.dingtalk.com/i/nodes/EpGBa2Lm8azdO4Lps9pEqZXBWgN7R35y">https://alidocs.dingtalk.com/i/nodes/EpGBa2Lm8azdO4Lps9pEqZXBWgN7R35y</a></p>
002- <p>[步骤]</p>
003- <br />
004- CODE:N1012422<br /><br />Error:16_8152_30_-2146232060<br /><br />SQL:<br /><br />if exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TbODS01') and type='U')) <br /><br />begin<br /><br /> drop table #TbODS01 <br /><br />end<br /><br />create table #TbODS01 (Id int primary key)<br /><br />insert into #TbODS01(Id) select Item from CharSplitForIn('17561,16459,16401,16088,16087,16086,16085,16083,16082,16081,16080,16079,16078,16077,16076,16075,16074,22006,22004,22003,22002,22001,22000,21999,21997,21996,22695,21994,21998,21995,3000,6642,21767,21803,12440,12439,12438,16116,6644,12437,22005,16084',',');<br /><br /><br /><br />SELECT COUNT(DISTINCT SellerSKU) as SellerSKUCount FROM RB_Report_OrderSettlement a with(nolock) inner join #TbODS01 os on a.OrderSourceID=os.Id inner join @tb_BatchAsins tba on a.ASINorItemID=tba.Id<br /><br />=@DateStartTime and ShipDate&lt;&gt;'' <br /><br />PARAMS:@CustomerID = 1 ,@DateStartTime = 2023-01-01 ,@DateEndTime = 2025/2/12 0:00:00 ,@tb_BatchAsins = 34U184016PS Z81757512V5J9JV2 386B8LX13240BXHN Y1722P36EMUP 6BS837LXMBLEL09K49EEXZ 394I8H385OTXRGL216BRUN 11MFTM26RDNWK8AP53LV0APX1 UL170719VE8JZMHE 6D09XDAI0Z4149LGTADK C39X5R8GMY15Z0710Q9K2 2U0957583G7BC6SH 220QO30SEG17MIPQ6R 71112U0662MQUFML3S 53NE03O14OA MUYM4167B7DNM173KED 2V095813DC9N0OFA OLYR092V28317DGL U29P4A17IS7095WU VQ9AK8T57B4355HDP15C I7O11PJY4037EOQI80BV HF172431E4774C0H YL11REWG195MWBM066C27XF4 ATFRZE54575DO09BV UR0XOY20260QIVS3010V5 L4610AVN17K09Y17UIP28 AJ161602CA9H8ZMQ F46494K41509V9BSY 9K142213GTRMVG1W U5103624X9T0BUCV MR20Q30XG109 V7175500GAGKMEX2 J4195H17T6 7L0BM13N24FRJ380V3IMU657Q LC1414394LC7KD2D 607NK10VFOG6Y55R57PA21JT8 S9N11P440BI38OTAU4BMF UR1M271831MZ3GEWSU 89-T15U-C6LK BWZ09T35BU09JKVDH7A 84104549OY1UMJOT P83ZY039M1J30099N10J5QY5U J8100114811CFA7 YJ1553097W 56TI16FJ41QKK LN04PB12F4150RY 6O14163042SRHR7W 17RRV33J0650NCL3 6B144322SLGBMLNN R3119LXDRC2NM0UCB09CA10C amzn.gr.07BR33IE191-7Sb4dyKeBEF-213bw-LN amzn.gr.URIE21H47304S10KVH9PU1-IJg8cA-VG A1718229MIPTZF 2713OZKH098 153085136NQZLSN 07EW3NL57CL309B SBAYJ5262U1511NHK, ,<br /><br />MESSAGE:String or binary data would be truncated.<br /><br />The statement has been terminated.<br /><br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /><br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /><br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /><br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /><br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /><br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /><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 /><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 /><br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /><br /> 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)<br /><br /> 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /><br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /><br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)<br /><br /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /><br /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /><br /> 在 RB.DAL.DBOperator.QueryDataRow(String SQLString, SqlParameter[] cmdParms, Int32 times, Boolean IsWriteDB)<br /><br /> 在 RB.DALExtendV2.Generate.Report.RB_Report_OrderSettlementExtendV2.GetSellerSKUCount(CM_ProductSKU_Settlement_ReportParam param)<br /><br /> 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesProductReportHandler.ProcessRequest(HttpContext context)<br /><br /> 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()<br /><br /> 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)<br /><br /> 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)<br /><br /> 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)<br /><br /> 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)<br /><br /> 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><div><br /></div>
005- <br /><p>[结果]</p>
006- <br /><p>[期望]</p>
007- 修复异常

修改了 指派给，旧值为 "lihuiyun"，新值为 "xuruifeng"。

修改了 高价值，旧值为 ""，新值为 "0"。
修改了 主被动，旧值为 ""，新值为 "1"。
修改了 复杂度，旧值为 ""，新值为 "1"。

修改了 预计工时，旧值为 "11"，新值为 "3"。
修改了 ROI ，旧值为 "10.91"，新值为 "40"。
修改了 成本 ，旧值为 "5500"，新值为 "1500"。

修改了 计划验收时间，旧值为 "0000-00-00"，新值为 "2025-03-07"。

修改了 测试人员，旧值为 ""，新值为 "zengqian"。

修改了 所处阶段 ，旧值为 "projected"，新值为 "developed"。
修改了 设置阶段者，旧值为 "zhoujie"，新值为 "liletong"。

修改了 所处阶段 ，旧值为 "tested"，新值为 "released"。
修改了 设置阶段者，旧值为 ""，新值为 "zengqian"。

修改了 所处阶段 ，旧值为 "released"，新值为 "bepending"。
修改了 设置阶段者，旧值为 "zengqian"，新值为 "zhoujie"。

修改了 所处阶段，旧值为 "业务验收中"，新值为 "业务验收通过"。

修改了 由谁关闭，旧值为 ""，新值为 "zhoujie"。
修改了 关闭日期，旧值为 "0000-00-00 00:00:00"，新值为 "2025-03-07 14:09:15"。
修改了 指派给 ，旧值为 "hezhijun"，新值为 "closed"。
修改了 当前状态，旧值为 "active"，新值为 "closed"。
修改了 所处阶段，旧值为 "verified"，新值为 "closed"。
修改了 关闭原因，旧值为 ""，新值为 "done"。

修改了 业务回填价值，旧值为 "0"，新值为 "10000"。
修改了 actualAchieveDesc ，旧值为 ""，新值为 "基本达成预期效果"。