重现步骤

[性能问题描述] ERP 查询 超时,IN的内容 居多


[16:12:08]  -------------------------------------------------------------
CODE:N1612081
Error:11_-2_0_-2146232060
SQL:SELECT p.SKU,
                               ISNULL(w.WareHouseName, csw.WareHouseName) LocalWareHouseName
                        FROM dbo.RB_Product p (NOLOCK)
                            LEFT JOIN RB_Product_SupplierPrice psp (NOLOCK)
                                ON psp.CustomerID = p.CustomerID
                                   AND p.SKU = psp.SKU
                                   AND psp.IsDefault = 1
                            LEFT JOIN dbo.RB_Product_Supplier ps (NOLOCK)
                                ON ps.CustomerID = psp.CustomerID
                                   AND psp.SupplierID = ps.ID
                            LEFT JOIN RB_WareHouse w (NOLOCK)
                                ON w.CustomerID = ps.CustomerID
                                   AND ps.TheWareHouseID = w.ID
                            LEFT JOIN RB_Customer_Setting cs (NOLOCK)
                                ON cs.CustomerID = p.CustomerID
                            LEFT JOIN RB_WareHouse csw (NOLOCK)
                                ON csw.CustomerID = cs.CustomerID
                                   AND cs.DefaultWareHouseID = csw.ID
                        WHERE p.CustomerID = @CustomerID
                              AND p.SKU IN ( SELECT CAST(item AS VARCHAR(50)) FROM dbo.CharSplitForIn(@SKUStr,',') );
                        
PARAMS:@CustomerID = 1 ,@SKUStr = 2216517,11027130,4718878,8720215,4119553,2615681,3744350,1904964,4840413,3819286,11295718,3159120,2588495,1902244,3159187,13523964,3013923,1934688,6073533,7908561,3363785,6355736,7734041,13938706,13100286,10960777,13907989,13533667,11389502,12221462,9141542,5663410,13578325,13895490,13490378,12591799,10026764,7300900,14169670,10384486,6245765,13413555,3278944,11010181,6707281,9967780,14291642,3972776,11860311,13502412,6659973,5977866,8628525,10386469,12147023,7028933,14358194,5429570,14308393,11199839,11258974,11586333,9978557,12073270,11873390,14002201,13687854,7539828,11226434,10809976,8106543,8754012,13739638,11855892,14018050,10704148,11267313,5207660,12093325,5561895,3631686,4008938,11803518,6020630,11818817,3538447,8934938,2261194,8631050,6389688,5404340,6752749,9272086,9731556,5303370,6676757,6855455,9223607,6249595,11642795,6604367,2901719,11849649,14325503,6827551,5900912,8360730,14058439,10524437,2714241,5799780,5240294,11046693,13782572,9240035,8403164,4089343,2739164,10687567,6148702,4385820,6337247,2929691,6314178,11848123,14287654,1924715,8004041,7290037,9343737,3063090,10601570,9010943,6100550,14370176,11283414,10524538,3081065,8552968,8701119,1487201,7935479,5579843,10695336,5733776,10517781,10096728,4157457,2321171,5682903,8891823,6795784,5187523,4984625,4112751,6150690,8279738,13751459,3513274,10446132,9338084,14284384,6809580,11354704,4257695,13696704,8320096,6697990,3665498,7870124,8174184,10755462,8452462,1738156,3210414,14593403,13971644,7593170,7420939,4154746,3968850,6793990,8356673,1750495,2816305,12601285,4565226,3152470,13966779,3050946,8757601,1813720,2259936,13242723,3235782,10094627,6477211,11307082,5745216,10890786,1673235,2636519,7785787,8207289,14401281,9711986,3934024,12017869,11510607,2978439,12053075,3758506,2733049,10905535,10736285,2168742,8452621,8330186,14017667,4963183,10555896,11062099,2962444,10514562,10477532,14593377,7233694,13885844,10652891,10828631,11769510,4003097,4485649,10372360,9840556,3660333,13108698,7321041,6995232,8646981,7117335,10893428,12859945,12060624
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_OrderInfoExtendV2.GetOrderProductWareHouseList(Int32 customerId, List`1 skuList)
   在 PandaBuy.ERP.Web.IrobotBox.Restock.Local.LocalOrderList.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_restock_local_localorderlist_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. 2022-08-05 16:41:37, 由 袁慧斌 创建。
  2. 2022-08-21 23:34:25, 由 胡晓龙 指派给 何建宝。
    修改了 指派给,旧值为 "huxiaolong",新值为 "hejianbao"。
  3. 2022-08-22 15:18:13, 由 何建宝 指派给 田新旭。
    修改了 指派给,旧值为 "hejianbao",新值为 "tianxinxu"。
    调整SQL逻辑:先将SKU插入临时表,再从临时表获取SKU
  4. 2022-08-22 16:16:18, 由 田新旭 解决,方案为 性能问题 。
    修改了 解决方案,旧值为 "",新值为 "performance"。
    修改了 解决版本,旧值为 "",新值为 "617"。
    修改了 解决日期,旧值为 "",新值为 "2022-08-22 16:14:45"。
    修改了 指派给 ,旧值为 "tianxinxu",新值为 "yuanhuibin"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    修改了 解决者 ,旧值为 "",新值为 "tianxinxu"。

    解决方案:使用临时表

    实际测试:



  5. 2022-08-23 15:15:54, 由 tanhongbo 编辑。
    修改了 重现步骤,区别为:
    002- [16:12:08] -------------------------------------------------------------CODE:N1612081Error:11_-2_0_-2146232060SQL:SELECT p.SKU, ISNULL(w.WareHouseName, csw.WareHouseName) LocalWareHouseName FROM dbo.RB_Product p (NOLOCK) LEFT JOIN RB_Product_SupplierPrice psp (NOLOCK) ON psp.CustomerID = p.CustomerID AND p.SKU = psp.SKU AND psp.IsDefault = 1 LEFT JOIN dbo.RB_Product_Supplier ps (NOLOCK) ON ps.CustomerID = psp.CustomerID AND psp.SupplierID = ps.ID LEFT JOIN RB_WareHouse w (NOLOCK) ON w.CustomerID = ps.CustomerID AND ps.TheWareHouseID = w.ID LEFT JOIN RB_Customer_Setting cs (NOLOCK) ON cs.CustomerID = p.CustomerID LEFT JOIN RB_WareHouse csw (NOLOCK) ON csw.CustomerID = cs.CustomerID AND cs.DefaultWareHouseID = csw.ID WHERE p.CustomerID = @CustomerID AND p.SKU IN ( SELECT CAST(item AS VARCHAR(50)) FROM dbo.CharSplitForIn(@SKUStr,',') ); PARAMS:@CustomerID = 1 ,@SKUStr = 2216517,11027130,4718878,8720215,4119553,2615681,3744350,1904964,4840413,3819286,11295718,3159120,2588495,1902244,3159187,13523964,3013923,1934688,6073533,7908561,3363785,6355736,7734041,13938706,13100286,10960777,13907989,13533667,11389502,12221462,9141542,5663410,13578325,13895490,13490378,12591799,10026764,7300900,14169670,10384486,6245765,13413555,3278944,11010181,6707281,9967780,14291642,3972776,11860311,13502412,6659973,5977866,8628525,10386469,12147023,7028933,14358194,5429570,14308393,11199839,11258974,11586333,9978557,12073270,11873390,14002201,13687854,7539828,11226434,10809976,8106543,8754012,13739638,11855892,14018050,10704148,11267313,5207660,12093325,5561895,3631686,4008938,11803518,6020630,11818817,3538447,8934938,2261194,8631050,6389688,5404340,6752749,9272086,9731556,5303370,6676757,6855455,9223607,6249595,11642795,6604367,2901719,11849649,14325503,6827551,5900912,8360730,14058439,10524437,2714241,5799780,5240294,11046693,13782572,9240035,8403164,4089343,2739164,10687567,6148702,4385820,6337247,2929691,6314178,11848123,14287654,1924715,8004041,7290037,9343737,3063090,10601570,9010943,6100550,14370176,11283414,10524538,3081065,8552968,8701119,1487201,7935479,5579843,10695336,5733776,10517781,10096728,4157457,2321171,5682903,8891823,6795784,5187523,4984625,4112751,6150690,8279738,13751459,3513274,10446132,9338084,14284384,6809580,11354704,4257695,13696704,8320096,6697990,3665498,7870124,8174184,10755462,8452462,1738156,3210414,14593403,13971644,7593170,7420939,4154746,3968850,6793990,8356673,1750495,2816305,12601285,4565226,3152470,13966779,3050946,8757601,1813720,2259936,13242723,3235782,10094627,6477211,11307082,5745216,10890786,1673235,2636519,7785787,8207289,14401281,9711986,3934024,12017869,11510607,2978439,12053075,3758506,2733049,10905535,10736285,2168742,8452621,8330186,14017667,4963183,10555896,11062099,2962444,10514562,10477532,14593377,7233694,13885844,10652891,10828631,11769510,4003097,4485649,10372360,9840556,3660333,13108698,7321041,6995232,8646981,7117335,10893428,12859945,12060624MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。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_OrderInfoExtendV2.GetOrderProductWareHouseList(Int32 customerId, List`1 skuList) 在 PandaBuy.ERP.Web.IrobotBox.Restock.Local.LocalOrderList.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_restock_local_localorderlist_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)
    002+ [16:12:08] -------------------------------------------------------------CODE:N1612081Error:11_-2_0_-2146232060SQL:SELECT p.SKU, ISNULL(w.WareHouseName, csw.WareHouseName) LocalWareHouseName FROM dbo.RB_Product p (NOLOCK) LEFT JOIN RB_Product_SupplierPrice psp (NOLOCK) ON psp.CustomerID = p.CustomerID AND p.SKU = psp.SKU AND psp.IsDefault = 1 LEFT JOIN dbo.RB_Product_Supplier ps (NOLOCK) ON ps.CustomerID = psp.CustomerID AND psp.SupplierID = ps.ID LEFT JOIN RB_WareHouse w (NOLOCK) ON w.CustomerID = ps.CustomerID AND ps.TheWareHouseID = w.ID LEFT JOIN RB_Customer_Setting cs (NOLOCK) ON cs.CustomerID = p.CustomerID LEFT JOIN RB_WareHouse csw (NOLOCK) ON csw.CustomerID = cs.CustomerID AND cs.DefaultWareHouseID = csw.ID WHERE p.CustomerID = @CustomerID AND p.SKU IN ( SELECT CAST(item AS VARCHAR(50)) FROM dbo.CharSplitForIn(@SKUStr,',') ); PARAMS:@CustomerID = 1 ,@SKUStr = 2216517,11027130,4718878,8720215,4119553,2615681,3744350,1904964,4840413,3819286,11295718,3159120,2588495,1902244,3159187,13523964,3013923,1934688,6073533,7908561,3363785,6355736,7734041,13938706,13100286,10960777,13907989,13533667,11389502,12221462,9141542,5663410,13578325,13895490,13490378,12591799,10026764,7300900,14169670,10384486,6245765,13413555,3278944,11010181,6707281,9967780,14291642,3972776,11860311,13502412,6659973,5977866,8628525,10386469,12147023,7028933,14358194,5429570,14308393,11199839,11258974,11586333,9978557,12073270,11873390,14002201,13687854,7539828,11226434,10809976,8106543,8754012,13739638,11855892,14018050,10704148,11267313,5207660,12093325,5561895,3631686,4008938,11803518,6020630,11818817,3538447,8934938,2261194,8631050,6389688,5404340,6752749,9272086,9731556,5303370,6676757,6855455,9223607,6249595,11642795,6604367,2901719,11849649,14325503,6827551,5900912,8360730,14058439,10524437,2714241,5799780,5240294,11046693,13782572,9240035,8403164,4089343,2739164,10687567,6148702,4385820,6337247,2929691,6314178,11848123,14287654,1924715,8004041,7290037,9343737,3063090,10601570,9010943,6100550,14370176,11283414,10524538,3081065,8552968,8701119,1487201,7935479,5579843,10695336,5733776,10517781,10096728,4157457,2321171,5682903,8891823,6795784,5187523,4984625,4112751,6150690,8279738,13751459,3513274,10446132,9338084,14284384,6809580,11354704,4257695,13696704,8320096,6697990,3665498,7870124,8174184,10755462,8452462,1738156,3210414,14593403,13971644,7593170,7420939,4154746,3968850,6793990,8356673,1750495,2816305,12601285,4565226,3152470,13966779,3050946,8757601,1813720,2259936,13242723,3235782,10094627,6477211,11307082,5745216,10890786,1673235,2636519,7785787,8207289,14401281,9711986,3934024,12017869,11510607,2978439,12053075,3758506,2733049,10905535,10736285,2168742,8452621,8330186,14017667,4963183,10555896,11062099,2962444,10514562,10477532,14593377,7233694,13885844,10652891,10828631,11769510,4003097,4485649,10372360,9840556,3660333,13108698,7321041,6995232,8646981,7117335,10893428,12859945,12060624MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。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_OrderInfoExtendV2.GetOrderProductWareHouseList(Int32 customerId, List`1 skuList) 在 PandaBuy.ERP.Web.IrobotBox.Restock.Local.LocalOrderList.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_restock_local_localorderlist_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)
    003-
    003+
    002- <p><br />[16:12:08] -------------------------------------------------------------<br />CODE:N1612081<br />Error:11_-2_0_-2146232060<br />SQL:SELECT p.SKU,<br /> ISNULL(w.WareHouseName, csw.WareHouseName) LocalWareHouseName<br /> FROM dbo.RB_Product p (NOLOCK)<br /> LEFT JOIN RB_Product_SupplierPrice psp (NOLOCK)<br /> ON psp.CustomerID = p.CustomerID<br /> AND p.SKU = psp.SKU<br /> AND psp.IsDefault = 1<br /> LEFT JOIN dbo.RB_Product_Supplier ps (NOLOCK)<br /> ON ps.CustomerID = psp.CustomerID<br /> AND psp.SupplierID = ps.ID<br /> LEFT JOIN RB_WareHouse w (NOLOCK)<br /> ON w.CustomerID = ps.CustomerID<br /> AND ps.TheWareHouseID = w.ID<br /> LEFT JOIN RB_Customer_Setting cs (NOLOCK)<br /> ON cs.CustomerID = p.CustomerID<br /> LEFT JOIN RB_WareHouse csw (NOLOCK)<br /> ON csw.CustomerID = cs.CustomerID<br /> AND cs.DefaultWareHouseID = csw.ID<br /> WHERE p.CustomerID = @CustomerID<br /> AND p.SKU IN ( SELECT CAST(item AS VARCHAR(50)) FROM dbo.CharSplitForIn(@SKUStr,',') );<br /> <br />PARAMS:@CustomerID = 1 ,@SKUStr = 2216517,11027130,4718878,8720215,4119553,2615681,3744350,1904964,4840413,3819286,11295718,3159120,2588495,1902244,3159187,13523964,3013923,1934688,6073533,7908561,3363785,6355736,7734041,13938706,13100286,10960777,13907989,13533667,11389502,12221462,9141542,5663410,13578325,13895490,13490378,12591799,10026764,7300900,14169670,10384486,6245765,13413555,3278944,11010181,6707281,9967780,14291642,3972776,11860311,13502412,6659973,5977866,8628525,10386469,12147023,7028933,14358194,5429570,14308393,11199839,11258974,11586333,9978557,12073270,11873390,14002201,13687854,7539828,11226434,10809976,8106543,8754012,13739638,11855892,14018050,10704148,11267313,5207660,12093325,5561895,3631686,4008938,11803518,6020630,11818817,3538447,8934938,2261194,8631050,6389688,5404340,6752749,9272086,9731556,5303370,6676757,6855455,9223607,6249595,11642795,6604367,2901719,11849649,14325503,6827551,5900912,8360730,14058439,10524437,2714241,5799780,5240294,11046693,13782572,9240035,8403164,4089343,2739164,10687567,6148702,4385820,6337247,2929691,6314178,11848123,14287654,1924715,8004041,7290037,9343737,3063090,10601570,9010943,6100550,14370176,11283414,10524538,3081065,8552968,8701119,1487201,7935479,5579843,10695336,5733776,10517781,10096728,4157457,2321171,5682903,8891823,6795784,5187523,4984625,4112751,6150690,8279738,13751459,3513274,10446132,9338084,14284384,6809580,11354704,4257695,13696704,8320096,6697990,3665498,7870124,8174184,10755462,8452462,1738156,3210414,14593403,13971644,7593170,7420939,4154746,3968850,6793990,8356673,1750495,2816305,12601285,4565226,3152470,13966779,3050946,8757601,1813720,2259936,13242723,3235782,10094627,6477211,11307082,5745216,10890786,1673235,2636519,7785787,8207289,14401281,9711986,3934024,12017869,11510607,2978439,12053075,3758506,2733049,10905535,10736285,2168742,8452621,8330186,14017667,4963183,10555896,11062099,2962444,10514562,10477532,14593377,7233694,13885844,10652891,10828631,11769510,4003097,4485649,10372360,9840556,3660333,13108698,7321041,6995232,8646981,7117335,10893428,12859945,12060624<br />MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。<br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /> 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<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 /> 在 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 /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /> 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)<br /> 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)<br /> 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)<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 /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /> 在 RB.DALExtendV2.RB_OrderInfoExtendV2.GetOrderProductWareHouseList(Int32 customerId, List`1 skuList)<br /> 在 PandaBuy.ERP.Web.IrobotBox.Restock.Local.LocalOrderList.Page_Load(Object sender, EventArgs e)<br /> 在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)<br /> 在 System.Web.UI.Control.OnLoad(EventArgs e)<br /> 在 System.Web.UI.Control.LoadRecursive()<br /> 在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<br /> 在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<br /> 在 System.Web.UI.Page.ProcessRequest()<br /> 在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)<br /> 在 System.Web.UI.Page.ProcessRequest(HttpContext context)<br /> 在 ASP.irobotbox_restock_local_localorderlist_aspx.ProcessRequest(HttpContext context)<br /> 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()<br /> 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)<br /> 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)<br /> 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)<br /> 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)<br /> 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)<br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /></p><div><br /></div>
    002+ <p><br />[16:12:08] -------------------------------------------------------------<br />CODE:N1612081<br />Error:11_-2_0_-2146232060<br />SQL:SELECT p.SKU,<br /> ISNULL(w.WareHouseName, csw.WareHouseName) LocalWareHouseName<br /> FROM dbo.RB_Product p (NOLOCK)<br /> LEFT JOIN RB_Product_SupplierPrice psp (NOLOCK)<br /> ON psp.CustomerID = p.CustomerID<br /> AND p.SKU = psp.SKU<br /> AND psp.IsDefault = 1<br /> LEFT JOIN dbo.RB_Product_Supplier ps (NOLOCK)<br /> ON ps.CustomerID = psp.CustomerID<br /> AND psp.SupplierID = ps.ID<br /> LEFT JOIN RB_WareHouse w (NOLOCK)<br /> ON w.CustomerID = ps.CustomerID<br /> AND ps.TheWareHouseID = w.ID<br /> LEFT JOIN RB_Customer_Setting cs (NOLOCK)<br /> ON cs.CustomerID = p.CustomerID<br /> LEFT JOIN RB_WareHouse csw (NOLOCK)<br /> ON csw.CustomerID = cs.CustomerID<br /> AND cs.DefaultWareHouseID = csw.ID<br /> WHERE p.CustomerID = @CustomerID<br /> AND p.SKU IN ( SELECT CAST(item AS VARCHAR(50)) FROM dbo.CharSplitForIn(@SKUStr,',') );<br /> <br />PARAMS:@CustomerID = 1 ,@SKUStr = 2216517,11027130,4718878,8720215,4119553,2615681,3744350,1904964,4840413,3819286,11295718,3159120,2588495,1902244,3159187,13523964,3013923,1934688,6073533,7908561,3363785,6355736,7734041,13938706,13100286,10960777,13907989,13533667,11389502,12221462,9141542,5663410,13578325,13895490,13490378,12591799,10026764,7300900,14169670,10384486,6245765,13413555,3278944,11010181,6707281,9967780,14291642,3972776,11860311,13502412,6659973,5977866,8628525,10386469,12147023,7028933,14358194,5429570,14308393,11199839,11258974,11586333,9978557,12073270,11873390,14002201,13687854,7539828,11226434,10809976,8106543,8754012,13739638,11855892,14018050,10704148,11267313,5207660,12093325,5561895,3631686,4008938,11803518,6020630,11818817,3538447,8934938,2261194,8631050,6389688,5404340,6752749,9272086,9731556,5303370,6676757,6855455,9223607,6249595,11642795,6604367,2901719,11849649,14325503,6827551,5900912,8360730,14058439,10524437,2714241,5799780,5240294,11046693,13782572,9240035,8403164,4089343,2739164,10687567,6148702,4385820,6337247,2929691,6314178,11848123,14287654,1924715,8004041,7290037,9343737,3063090,10601570,9010943,6100550,14370176,11283414,10524538,3081065,8552968,8701119,1487201,7935479,5579843,10695336,5733776,10517781,10096728,4157457,2321171,5682903,8891823,6795784,5187523,4984625,4112751,6150690,8279738,13751459,3513274,10446132,9338084,14284384,6809580,11354704,4257695,13696704,8320096,6697990,3665498,7870124,8174184,10755462,8452462,1738156,3210414,14593403,13971644,7593170,7420939,4154746,3968850,6793990,8356673,1750495,2816305,12601285,4565226,3152470,13966779,3050946,8757601,1813720,2259936,13242723,3235782,10094627,6477211,11307082,5745216,10890786,1673235,2636519,7785787,8207289,14401281,9711986,3934024,12017869,11510607,2978439,12053075,3758506,2733049,10905535,10736285,2168742,8452621,8330186,14017667,4963183,10555896,11062099,2962444,10514562,10477532,14593377,7233694,13885844,10652891,10828631,11769510,4003097,4485649,10372360,9840556,3660333,13108698,7321041,6995232,8646981,7117335,10893428,12859945,12060624<br />MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。<br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /> 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<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 /> 在 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 /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /> 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)<br /> 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)<br /> 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)<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 /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /> 在 RB.DALExtendV2.RB_OrderInfoExtendV2.GetOrderProductWareHouseList(Int32 customerId, List`1 skuList)<br /> 在 PandaBuy.ERP.Web.IrobotBox.Restock.Local.LocalOrderList.Page_Load(Object sender, EventArgs e)<br /> 在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)<br /> 在 System.Web.UI.Control.OnLoad(EventArgs e)<br /> 在 System.Web.UI.Control.LoadRecursive()<br /> 在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<br /> 在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<br /> 在 System.Web.UI.Page.ProcessRequest()<br /> 在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)<br /> 在 System.Web.UI.Page.ProcessRequest(HttpContext context)<br /> 在 ASP.irobotbox_restock_local_localorderlist_aspx.ProcessRequest(HttpContext context)<br /> 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()<br /> 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)<br /> 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)<br /> 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)<br /> 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)<br /> 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)<br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)</p>
    003-
    003+ <div><br /></div>

    产品库查询功能正常

  6. 2022-08-23 15:16:40, 由 tanhongbo 指派给 袁慧斌。
    麻烦发版后  跟进一下线上环境,是否还有此问题
  7. 2022-09-21 13:54:59, 由 袁慧斌 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 指派给 ,旧值为 "yuanhuibin",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "yuanhuibin"。
    修改了 关闭日期,旧值为 "",新值为 "2022-09-21 13:54:59"。
    已未发现
  8. 2023-11-17 09:53:56, 由 刘超 编辑。
    修改了 所属模块,旧值为 "0",新值为 "1863"。
所属项目 技术中心-需求池
所属模块 系统运维   性能优化
所属计划
所属迭代
Bug类型
严重程度 提示
优先级 P0
Bug状态 已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2022-09-21 13:54:59
截止日期 0000-00-00
上线时间
上线时效
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 袁慧斌 于 2022-08-05 16:41:37
影响环境 577
由谁解决 田新旭 于 2022-08-22 16:14:45
解决版本 八月分支
解决方案 性能问题
由谁关闭 袁慧斌 于 2022-09-21 13:54:59
最后修改 刘超 于 2023-11-17 09:53:48
相关Bug