[步骤]

[12:38:41]  -------------------------------------------------------------
CODE:N1238414
Error:11_-2_0_-2146232060
SQL:SELECT 
                                  o.CustomerID, 
                                  o.OrderSourceID, 
                                  s.OrderSourceCountry,
                                  l.ASIN, 
                                  Sum(l.ProductNum + l.ProductNumUpdate - Isnull(pod.ProductNum, 0)) / Isnull (( SELECT Sum(SkuNum) AS Expr1 
                                  FROM dbo.RB_Product_GroupSku AS g WITH (NOLOCK) WHERE g.CustomerID = o.CustomerID AND ( GroupSku = ( CASE WHEN l.GroupSKU = '' THEN l.SKU ELSE l.GroupSKU END ) )), 1) AS ProductNum
                                  FROM dbo.RB_OrderInfo AS o WITH (NOLOCK) 
                                  INNER JOIN dbo.RB_OrderSource s ON o.OrderSourceID = s.ID AND o.CustomerID = s.CustomerID 
                                  INNER JOIN dbo.RB_OrderList AS l WITH (NOLOCK) ON o.OrderCode = l.OrderCode AND o.CustomerID = l.CustomerID 
                                  LEFT JOIN dbo.RB_OrderInfo_BeikuExpand h WITH (NOLOCK) ON o.OrderCode = h.OrderCode AND o.CustomerID = h.CustomerID 
                                  LEFT JOIN ( SELECT d.OrderCode, OrderListID, d.CustomerID, Sum(ProductNum) AS ProductNum FROM RB_Procurement_Order_Package p WITH (NOLOCK) 
                                  INNER JOIN dbo.RB_Procurement_Order_Package_OrderDetail d WITH (NOLOCK) ON d.CustomerID = p.CustomerID AND d.PackageID = p.ID 
                                  LEFT JOIN RB_OrderInfo o WITH (nolock) ON d.OrderCode = o.OrderCode AND d.CustomerID = o.CustomerID 
                                  LEFT JOIN dbo.RB_OrderInfo_BeikuExpand h WITH (NOLOCK) ON o.OrderCode = h.OrderCode AND o.CustomerID = h.CustomerID 
                                  WHERE p.PackageState = 3 AND o.AddTime > Dateadd(month, -6, Getdate()) AND o.IsStockOrder = 1 AND h.orderBuildType in (1, 2) AND o.OrderStatus = 0 AND o.OrderState < 2 
                                  GROUP BY d.OrderCode, OrderListID, d.CustomerID ) AS pod ON pod.OrderCode = l.OrderCode AND pod.CustomerID = l.CustomerID AND pod.OrderListID = l.ID 
                                  WHERE l.ProductNum + l.ProductNumUpdate - Isnull(pod.ProductNum, 0) > 0 AND s.OrderSourceType = 1 AND o.OrderStatus = 0 AND o.OrderState < 2 AND l.ASIN IN (SELECT item FROM dbo.CharSplitForIn(@ASINStr, ',')) AND o.CustomerID=@CustomerID AND s.OrderSourceCountry IN (SELECT item FROM dbo.CharSplitForIn(@CountryStr, ','))
                                  AND o.IsStockOrder = 1 AND h.orderBuildType in (1, 2) AND o.AddTime > Dateadd(month, -6, Getdate()) 
                                  GROUP BY o.CustomerID, l.ASIN,s.OrderSourceCountry, o.OrderSourceID, CASE WHEN l.GroupSKU = '' THEN l.SKU ELSE l.GroupSKU END 
PARAMS:@CustomerID = 1 ,@ASINStr = B09H7KZX94,B095H7TXP3,B0CRZ3H2J1,B0CFJ8XM8S,B0CKRWRMVN,B0CGP8TYZF,B0CDSHKRJV,B0CPLD8F4T,B0833TDLP7,B0BRSQ7J23,B07CVP5CJT,B0CK538VTV,B0856XRQWV,B0CLF4BGMK,B09R1SWKNJ,B0D8PTTHWQ,B0821CM1SS,B0DDJC7MRJ,B0C958JRW9,B0CDRT7YZY,B0CH95JX6K,B0D1CF6RXX,B07H9WTMGF,B085HRGFG2,B0CST7F6W7,B0DHYZVZ3M,B0C6YKZNMC,B0C2K5V61H,B0CK49T36H,B099DXMKCR,B0C3Z69DSP,B0CGHD3V6B,B0CGPHS135,B01E87UMHG,B08THVCK6B,B0BZWNGYYL,B09VDD33JC,B0D783HRNT,B0CF4XKPDX,B084P9L1ZR,B07YJTX8YP,B0DPGHGBPZ,B0CKF5G22T,B0CD4XC5D9,B0CGFG4SP7,B0D7HH9S8Z,B0CNWMQBL2,B0CS6K7RDV,B0CF9ZJ28F,B07M8VHP9P,B0C39X3GF4,B0CJXS9JPC,B0CD9DZT2C,B0CG4PZM5Y,B0BYMS8RQN,B0CD73T9N3,B0B632Y4C5,B0B6VY7178,B0CGP7SMNL,B097GJH9VG,B0CF7482XH,B0CPZ8QNDQ,B0CDZSBVPV,B09J54FVVW,B0D4TMY15Z,B0DN687WWW,B0CPBXG6S1,B0DJPJKLDQ,B07J9J2MQJ,B09HK9JRTR,B0CFWVPKZ7,B0936HDJ43,B0CNJSF8ZG,B0BD8F5MVM,B095754RQ2,B082LVQGZ8,B0CKS7GDZZ,B0BNQST5RY,B0CCXGTQFH,B0CCTG12KR,B09TTBTTP1,B07L6FN8PG,B0CPHQ1STS,B0CD1QH1SK,B0CYT3C2FH,B08ZDD6Q94,B0B3DB8VYX,B016DI93FU,B083DKDP65,B0CPF1C9DX,B0CCG1T9FX,B0CG5ZKJ2J,B09QHSGYBJ,B0D6WMFWQG,B0BRQXQYZX,B0C544FZZ4,B0CTHYQC96,B082NW34ML,B0D5BJHZHF,B077Z2HQMX,B09R4M1QJK,B0BN1Z2F1C,B074V6LG8K,B0CN3ZV21W,B07TV4MDF4,B07G57KNCV,B0B5KD465Z,B0BRMGFTTW,B0D2Y1NFVY,B0CS6M6Z2D,B0CJTD47VV,B0DDMW7YRB,B099MPXMH1,B07WFXLS6D,B07B8JJ3HL,B0C3FDD66L,B0BKKXS6LM,B0B1WW7JXT,B0DC1M44MT,B0D4J56RHC,B0CR1B73ZG,B0CD7TR16C,B0CN4HKD9Z,B099N5S7BJ,B0CDB473LG,B0CYHTNBD4,B09HGJMH2W,B0CD529TYB,B0CFWKBYPL,B09QHN7W4R,B0CRZRZ7M9,B0BSF6P4CV,B08Y5QRYZ8,B076BZKY3Z,B0CPJ49WPJ,B0BBFMSGGB,B0C5WPQ7TP,B0CDVRMDSV,B0987S4XHH,B09TB9XS9C,B09R7R8BJK,B0BTH53ZNW,B09VNXX436,B096FXFMNB,B0BNLNZ11J,B0CBGHRLM9,B0CW9RWT7X,B0CDXT5GT4,B0C19KLBNJ,B085BPYXWT,B0CMVJH6JF,B0CD9GPNFJ,B085HKF6ZN,B0C6QPMGHZ,B09NVRHT4P,B0C66KBQMY,B0CJLT49SW,B0CF56P5N2,B09SJ2JDS6,B0C27KG74Q,B0CJ61JJCG,B0758DLY5C,B0C4N1CDMY,B08L98W4B6,B0CJY574GF,B0D5K9Y8C2,B07J3HKXM3,B0BJL6N7XC,B0CYH9HD5K,B098J3BWPL,B0CQ8CFKXB,B0CCLP4XXK,B088FJ5GT6,B0BSCKWV54,B0CVMZTRK9,B0B9WTSQ2S,B08H1YGTL5,B0CGFSD5FJ,B087FXBPV7,B0CVVWCGNQ,B0CYCJXT4B,B0CFYWCT7P,B0BHRHQLFK,B0953RR66B,B0917JGKLJ,B07RXHN36C,B08CTG6Z3M,B0CFJ4DGQR,B0BNBSYG8Z,B0DGG9F7F8,B0CLH3B86K,B0CH9X9Y5V,B082F9V5WH,B0C6PJ4S6B,B07QL4BMV2,B0D356NFK7,B0CKDQKYNH,B0CZ72WCQD,B0CVVQQLZF,B0CSB74Y45 ,@CountryStr = US,IT,MX,MX,FR,US,PL,MX,TR,MX,SE,BE,GB,US,BR,GB,GB,JP,MX,BE,AU,AU,JP,CA,MX,DE,US,CA,US,NL,PL,PL,PL,BE,US,GB,MX,DE,PL,DE,CA,DE,NL,SE,AU,US,MX,US,NL,FR,US,FR,ES,CA,IT,US,US,DE,US,BE,AU,AU,NL,GB,AE,US,IT,GB,NL,FR,BE,GB,GB,US,FR,GB,FR,ES,BE,SE,CA,US,DE,PL,CA,SE,CA,DE,BE,FR,US,SE,SE,JP,AU,MX,GB,DE,SE,US,NL,SE,TR,MX,FR,US,AU,CA,IT,US,NL,GB,IN,GB,DE,IT,MX,MX,ES,DE,SE,CA,MX,CA,MX,US,CA,PL,IT,CA,MX,US,BE,ES,ES,ES,FR,CA,IT,FR,US,DE,CA,AU,MX,MX,US,JP,CA,ES,CA,CA,DE,US,GB,AU,SE,PL,PL,DE,NL,DE,FR,CA,DE,PL,US,FR,CA,GB,US,AU,US,SE,FR,US,US,JP,GB,US,JP,MX,CA,US,US,IT,GB,PL,US,IT,GB,DE,FR,SE,CA,GB,BE,MX,GB,ES ,
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.RB_RecentStockOrder.GetProductNumByASINAndCountry(Int32 CustomerID, List`1 ASIN, List`1 Country)
   在 RB.WebApi.ApiCode.API_Methods.GetASINOrderInfo(GetASINOrderInfoDataRequest request)
   在 System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   在 System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   在 RB.WebApi.ApiCode.API_Entrance.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)

[结果]

[期望]

l.ASIN IN (SELECT item  类型为nvarchar 建议改成 l.ASIN IN (SELECT convert(varchar(100),item)

s.OrderSourceCountry IN (SELECT item 同理