[步骤]

CODE:N1012422

Error:16_8152_30_-2146232060

SQL:

if  exists ((select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TbODS01') and type='U'))  

begin

drop table #TbODS01 

end

create 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

                                    WHERE 1=1  AND a.CustomerID=@CustomerID AND ShipDate>=@DateStartTime and ShipDate<@DateEndTime AND SellerSKU IS NOT NULL and SellerSKU<>'' 

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)

[结果]

[期望]

修复异常