深圳智汇创想科技有限公司

SQL:select  CustomerID,UniqueID from  
                                    RB_ClearStockSKU_V2(nolock)
                                    where  CustomerID=@CustomerID
                                    and  ClearStockStatus=@ClearStockStatus
                                    and  SKU IN(SELECT item FROM Charsplitforin(@SKUs, ','))
PARAMS:@CustomerID = 1 ,@ClearStockStatus = 1 ,@SKUs = 14372980,8890945,11994545,11166453,10360835,7310771,13494651,7851572,7799709,9414232,8766685,4526865,11431857,5870624,15046892,3487561,7658695,7064506,11106348,8128055,11542555,14580266,8002830,10420328,10407519,3802623,7281877,6962683,5122412,4538723,7692978,13022671,13084673,9588071,8410982,10127144,9313619,4652878,6950328,7023973,10407750,12090936,7784534,10218920,14082844,3713403,10928044,10401675,8045255,4419164,10021978,13569296,15615659,11650739,13340770,7730089,9777464,7045435,12594701,11770147,11741514,13340663,3665498,3727246,14406401,10442854,8121835,14926890,10810465,10918716,11113696,14082647,12185759,14032655,3827862,10597258,7658130,11282156,7665078,11524486,10235184,10675474,10013668,11582669,11225345,13196935,4352316,10628997,5838626,2385966,10893501,10748839,8027268,10936578,14001517,11613237,4231915,2328257,3038411,10333250,11603400,5040132,7998841,9706809,11637318,8935610,10401351,7930134,7478544,9607466,10150144,7171480,8548329,7622595,11366214,9412819,9249750,11198559,10725907,10110061,10024509,10915158,10756743,7164608,10422501,5196226,10735938,7374158,11134237,7083162,6778618,3116903,7622957,4048013,8123599,8654782,3755565,10225289,8800512,7510946,7164579,9597107,6655548,8866339,2499246,8419236,3694395,7954139,2803156,7075656,4744373,6360501,7400856,11119444,7897660,11224518,7344854,11724617,11446064,11001187,12186742,10797237,13193355,11486273,8320605,13360091,7427441,10327411,7203887,12212628,2936307,9729135,10691351,4620299,13753926,12263652,14001700,11947028,10740448,13644110,5370732,13903961,2885250,8163863,13993832,10736285,12189250,4274981,14001672,2211833,3822477,10295380,13359012,10512047,8440741,11982376,3712401,5356747,11356893,13924197,14394132,10691295,3665591,6680983,11786279,10575140,3835101,10736265,10125643,7844423,9277800,11113686,14392131,10471134,11377180,10445361,4265152,7134562,6480677,14815224,6267531,13662428,6267153,11258419,6897358,11524179,13601483,10934798,10624791,14069354,10831521,12395555,14300868,14472548,10452093,10484848,3489934,9769410,11236128,3208592,10367178,3311115,11588429,10570001,13379253,11486621,10985027,11637798,11542785,11113703,7206537,6793990,13552063,13540606,14312064,11072976,7942186,13673036,13151729,1675961,6462230,12123947,2585615,12217816,14526370,9267340,13615410,7501539,13753952,14166961,11972444,10218074,7941688,2192525,7244724,13789822,8272220,8970524,11718056,14446830,13566307,10211574,10409425,14287715,13189289,15026435,12579201,10058419,11442455,12579202,3263249,14125692,11817321,13782006,12375160,14144567,10558031,11079687,7224599,10790216,13277143,13157257,11811068,10152821,10287877,5081070,15619720,6760308,13891395,10701354,8200549,12134963,10994652,11728551,12309002,7064491,9919976,7173514,6760155,12838530,13210806,12091225,3162056,6219682,9068443,10686325,13588034,6064314,3749841,12179948,11602817,10349279,13210072,5282335,14711742,11389053,11762678,9628124,12503576,7307105,14486986,10430426,9861017,7969501,14148547,2817319,7327721,13699954,11773787,11165346,8010138,12261702,13237164,4411911,14413387,4149563,10764065,7147217,5868570,3614358,13102912,7612681,9593018,5061803,12447425,6029064,11504581,13583625,14666656,10860892,8413938,6504821,7468857,13471022,15639662,13273845,14614965,6168547,13542587,2152903,7173718,8564410,13239089,10677670,8851853,15659857,15008515,14597939,11902845,6225161,13600463,14426048,14774097,7419383,10857402,13475513,7119085,3501849,5459116,12057761,11258316,14096464,14141482,13509106,8304045,11970595,11795580,10373420,11505792,9274379,10503438,15774811,15598946,15718801,14989670,6239759,8948651,2921488,9401914,7249322,4370549,14114316,11682758,9274539,3027928,7797488,14125475,10267804,14100559,13210772,13602923,3901947,8574524,15782882,2517862,6978199,14322072,9955611,9313826,13668163,13452229,13588027,10936377,10222657,8801524,11923632,10830843,13982845,9401799,12262090,10037512,11766575,5075099,11647552,7658489,9689882,10830679,2794698,13399114,13172646,7960378 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 
TRACE:   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 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.DALExtendV2.RB_ClearStockSKU_V2ExtendV2.GetClearStockSKUBySkus(Int32 customerID, List`1 skus)
   在 PandaBuy.ERP.Web.IrobotBox.Amazon.AmazonListingList.Page_Load(Object sender, EventArgs e)
   在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   在 System.Web.UI.Control.OnLoad(EventArgs e)
   在 System.Web.UI.Control.LoadRecursive()
   在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   在 System.Web.UI.Page.ProcessRequest()
   在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   在 System.Web.UI.Page.ProcessRequest(HttpContext context)
   在 ASP.irobotbox_amazon_amazonlistinglist_aspx.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.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

-------------------------------------------------------------

整改方案：

1、改成表值参数，同时改成 join 表值参数。不要用in