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

修改了 优先级 ，旧值为 "3"，新值为 "1"。
修改了 重现步骤，区别为：

002- [16:05:27] -------------------------------------------------------------CODE:N1605272Error:16_8623_1_-2146232060SQL:SELECT p.DefaultLocalWarehouse AS WID, rbwp.WareHouseName, rbwp.WareHouseType, p.SKU, p.CustomerID FROM RB_Product p(nolock) LEFT OUTER JOIN dbo.RB_WareHouse rbwp WITH (NOLOCK) ON rbwp.ID = p.DefaultLocalWarehouse AND rbwp.CustomerID = p.CustomerID WHERE p.SKU IN ('3084311','2803978','3088476','2744211','2795996','2593680','2901061','2854333','2971825','3082794','3084237','3084326','3084347','3084363','3084379','3088384','3088408','3088449','3088566','3088585','2864955','3087585','3087557','2854186','3071180','3081984','3081956','3081870','3071907','3088676','3094406','3083397','3094417','3094434','3094447','3094496','3083368','3094490','3094500','3094509','3091582','2804085','2804546','2828362','2703310','2711572','2711593','2713396','2715033','2718660','2723659','2723716','2736951','2835617','3091680','3091687','3092842','3094038','3094040','3094066','3094080','3094086','3094090','3082344','3082454','3021195','3020694','3079901','3042711','3021118','3021006','3113363','3109751','3109694','3109595','2981239','2981185','2980977','2958685','3120214','3114919','3121361','3121341','3121333','3121321','3130880','3127768','3121288','3121081','3121143','3121170','3121207','3121260','3148392','3148142','3147990','3147901','3154129','3064937','3123694','3123610','3108336','3154118','3151605','3151530','3151181','3155603','3155588','3163361','3174792','3175081','3175070','3169445','3177109','3174762','3174665','3163165','3162568','3155620','3155619','3155618','3155613','3128860','3128850','3128768','3124532','3124514','3124502','3124494','3124485','3124428','3117899','3117896','3117895','3117876','3117525','3117523','3117504','3117500','3117498','3113482','3113456','3113444','3111986','3111978','3111974','3111961','3111954','3111943','3111871','3111861','3111847','3111804','3111798','3111730','3105431','3105403','3105365','3105117','3105095','3105072','3105048','3104962','3094053','3094052','3094048','3094043','3092790','3092778','3092773','3092768','3092765','3092729','3091665','3091661','3091659','3091649','3091647','3100484','3100473','3100469','3100460','3099317','3099309','3099295','3099267','3099254','3099227','3099219','3099215','3099150','3099131','3099088','3099081','3099074','3097648','3097637','3097629','3097394','3097386','3097373','3097310','3097300','3096752','3096745','3096727','3096716','3083299','3083275','3083258','3083245','3083135','3083118','3083075','3083017','3083007','3082875','3082818','3021489','3070199','3071519','3071539','3130699','3134562','3199294','3195001','3188503','3188334','3213632','3216827','3231087','3230868','3230760','3213213','3236459','3213729','3213723','3213720','3213679','3213661','3213652','3213649','3213631','3213625','3213619','3213616','3212983','3208795','3208793','3208792','3208791','3208788','3208785','3208784','3208782','3208778','3208777','3208774','3208771','3208770','3208767','3208765','3208764','3208763','3208272','3208266','3208212','3208198','3208193','3208179','3208172','3208164','3208155','3208151','9764258','9343290','3959020','4246677','9942270','9909627','6914001','4254305','8250386','8250751','2928567','3130752','2928473','10147286','5511808','10356669','8802897','10243162','10266205','5062231','5475595','10240465','2928544','10875232') and p.CustomerID=@CustomerIDPARAMS:@CustomerID = 1 ,MESSAGE:The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.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.DALExtend.RB_ProductExtend.GetGetWarehouseInfoModels(Int32 customerID, List`1 skus) 在 PandaBuy.ERP.Web.IrobotBox.SalesAnalysis.BatchUpdateSalePrice.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_salesanalysis_batchupdatesaleprice_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)
002+ [16:05:27] -------------------------------------------------------------CODE:N1605272Error:16_8623_1_-2146232060SQL:SELECT p.DefaultLocalWarehouse AS WID, rbwp.WareHouseName, rbwp.WareHouseType, p.SKU, p.CustomerID FROM RB_Product p(nolock) LEFT OUTER JOIN dbo.RB_WareHouse rbwp WITH (NOLOCK) ON rbwp.ID = p.DefaultLocalWarehouse AND rbwp.CustomerID = p.CustomerID WHERE p.SKU IN ('3084311','2803978','3088476','2744211','2795996','2593680','2901061','2854333','2971825','3082794','3084237','3084326','3084347','3084363','3084379','3088384','3088408','3088449','3088566','3088585','2864955','3087585','3087557','2854186','3071180','3081984','3081956','3081870','3071907','3088676','3094406','3083397','3094417','3094434','3094447','3094496','3083368','3094490','3094500','3094509','3091582','2804085','2804546','2828362','2703310','2711572','2711593','2713396','2715033','2718660','2723659','2723716','2736951','2835617','3091680','3091687','3092842','3094038','3094040','3094066','3094080','3094086','3094090','3082344','3082454','3021195','3020694','3079901','3042711','3021118','3021006','3113363','3109751','3109694','3109595','2981239','2981185','2980977','2958685','3120214','3114919','3121361','3121341','3121333','3121321','3130880','3127768','3121288','3121081','3121143','3121170','3121207','3121260','3148392','3148142','3147990','3147901','3154129','3064937','3123694','3123610','3108336','3154118','3151605','3151530','3151181','3155603','3155588','3163361','3174792','3175081','3175070','3169445','3177109','3174762','3174665','3163165','3162568','3155620','3155619','3155618','3155613','3128860','3128850','3128768','3124532','3124514','3124502','3124494','3124485','3124428','3117899','3117896','3117895','3117876','3117525','3117523','3117504','3117500','3117498','3113482','3113456','3113444','3111986','3111978','3111974','3111961','3111954','3111943','3111871','3111861','3111847','3111804','3111798','3111730','3105431','3105403','3105365','3105117','3105095','3105072','3105048','3104962','3094053','3094052','3094048','3094043','3092790','3092778','3092773','3092768','3092765','3092729','3091665','3091661','3091659','3091649','3091647','3100484','3100473','3100469','3100460','3099317','3099309','3099295','3099267','3099254','3099227','3099219','3099215','3099150','3099131','3099088','3099081','3099074','3097648','3097637','3097629','3097394','3097386','3097373','3097310','3097300','3096752','3096745','3096727','3096716','3083299','3083275','3083258','3083245','3083135','3083118','3083075','3083017','3083007','3082875','3082818','3021489','3070199','3071519','3071539','3130699','3134562','3199294','3195001','3188503','3188334','3213632','3216827','3231087','3230868','3230760','3213213','3236459','3213729','3213723','3213720','3213679','3213661','3213652','3213649','3213631','3213625','3213619','3213616','3212983','3208795','3208793','3208792','3208791','3208788','3208785','3208784','3208782','3208778','3208777','3208774','3208771','3208770','3208767','3208765','3208764','3208763','3208272','3208266','3208212','3208198','3208193','3208179','3208172','3208164','3208155','3208151','9764258','9343290','3959020','4246677','9942270','9909627','6914001','4254305','8250386','8250751','2928567','3130752','2928473','10147286','5511808','10356669','8802897','10243162','10266205','5062231','5475595','10240465','2928544','10875232') and p.CustomerID=@CustomerIDPARAMS:@CustomerID = 1 ,MESSAGE:The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.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.DALExtend.RB_ProductExtend.GetGetWarehouseInfoModels(Int32 customerID, List`1 skus) 在 PandaBuy.ERP.Web.IrobotBox.SalesAnalysis.BatchUpdateSalePrice.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_salesanalysis_batchupdatesaleprice_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)
003-
003+

002- <p><br />[16:05:27] -------------------------------------------------------------<br />CODE:N1605272<br />Error:16_8623_1_-2146232060<br />SQL:SELECT p.DefaultLocalWarehouse AS WID,<br /> rbwp.WareHouseName,<br /> rbwp.WareHouseType,<br /> p.SKU,<br /> p.CustomerID<br /> FROM RB_Product p(nolock)<br /> LEFT OUTER JOIN dbo.RB_WareHouse rbwp WITH (NOLOCK)<br /> ON rbwp.ID = p.DefaultLocalWarehouse<br /> AND rbwp.CustomerID = p.CustomerID<br /> WHERE p.SKU IN ('3084311','2803978','3088476','2744211','2795996','2593680','2901061','2854333','2971825','3082794','3084237','3084326','3084347','3084363','3084379','3088384','3088408','3088449','3088566','3088585','2864955','3087585','3087557','2854186','3071180','3081984','3081956','3081870','3071907','3088676','3094406','3083397','3094417','3094434','3094447','3094496','3083368','3094490','3094500','3094509','3091582','2804085','2804546','2828362','2703310','2711572','2711593','2713396','2715033','2718660','2723659','2723716','2736951','2835617','3091680','3091687','3092842','3094038','3094040','3094066','3094080','3094086','3094090','3082344','3082454','3021195','3020694','3079901','3042711','3021118','3021006','3113363','3109751','3109694','3109595','2981239','2981185','2980977','2958685','3120214','3114919','3121361','3121341','3121333','3121321','3130880','3127768','3121288','3121081','3121143','3121170','3121207','3121260','3148392','3148142','3147990','3147901','3154129','3064937','3123694','3123610','3108336','3154118','3151605','3151530','3151181','3155603','3155588','3163361','3174792','3175081','3175070','3169445','3177109','3174762','3174665','3163165','3162568','3155620','3155619','3155618','3155613','3128860','3128850','3128768','3124532','3124514','3124502','3124494','3124485','3124428','3117899','3117896','3117895','3117876','3117525','3117523','3117504','3117500','3117498','3113482','3113456','3113444','3111986','3111978','3111974','3111961','3111954','3111943','3111871','3111861','3111847','3111804','3111798','3111730','3105431','3105403','3105365','3105117','3105095','3105072','3105048','3104962','3094053','3094052','3094048','3094043','3092790','3092778','3092773','3092768','3092765','3092729','3091665','3091661','3091659','3091649','3091647','3100484','3100473','3100469','3100460','3099317','3099309','3099295','3099267','3099254','3099227','3099219','3099215','3099150','3099131','3099088','3099081','3099074','3097648','3097637','3097629','3097394','3097386','3097373','3097310','3097300','3096752','3096745','3096727','3096716','3083299','3083275','3083258','3083245','3083135','3083118','3083075','3083017','3083007','3082875','3082818','3021489','3070199','3071519','3071539','3130699','3134562','3199294','3195001','3188503','3188334','3213632','3216827','3231087','3230868','3230760','3213213','3236459','3213729','3213723','3213720','3213679','3213661','3213652','3213649','3213631','3213625','3213619','3213616','3212983','3208795','3208793','3208792','3208791','3208788','3208785','3208784','3208782','3208778','3208777','3208774','3208771','3208770','3208767','3208765','3208764','3208763','3208272','3208266','3208212','3208198','3208193','3208179','3208172','3208164','3208155','3208151'<br />,'9764258','9343290','3959020','4246677','9942270','9909627','6914001','4254305','8250386','8250751','2928567','3130752','2928473','10147286','5511808','10356669','8802897','10243162','10266205','5062231','5475595','10240465','2928544','10875232') and p.CustomerID=@CustomerID<br />PARAMS:@CustomerID = 1 ,<br />MESSAGE:The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.<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.DALExtend.RB_ProductExtend.GetGetWarehouseInfoModels(Int32 customerID, List`1 skus)<br /> 在 PandaBuy.ERP.Web.IrobotBox.SalesAnalysis.BatchUpdateSalePrice.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_salesanalysis_batchupdatesaleprice_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 /></p><div><br /></div>
002+ <p><br />[16:05:27] -------------------------------------------------------------<br />CODE:N1605272<br />Error:16_8623_1_-2146232060<br />SQL:SELECT p.DefaultLocalWarehouse AS WID,<br /> rbwp.WareHouseName,<br /> rbwp.WareHouseType,<br /> p.SKU,<br /> p.CustomerID<br /> FROM RB_Product p(nolock)<br /> LEFT OUTER JOIN dbo.RB_WareHouse rbwp WITH (NOLOCK)<br /> ON rbwp.ID = p.DefaultLocalWarehouse<br /> AND rbwp.CustomerID = p.CustomerID<br /> WHERE p.SKU IN ('3084311','2803978','3088476','2744211','2795996','2593680','2901061','2854333','2971825','3082794','3084237','3084326','3084347','3084363','3084379','3088384','3088408','3088449','3088566','3088585','2864955','3087585','3087557','2854186','3071180','3081984','3081956','3081870','3071907','3088676','3094406','3083397','3094417','3094434','3094447','3094496','3083368','3094490','3094500','3094509','3091582','2804085','2804546','2828362','2703310','2711572','2711593','2713396','2715033','2718660','2723659','2723716','2736951','2835617','3091680','3091687','3092842','3094038','3094040','3094066','3094080','3094086','3094090','3082344','3082454','3021195','3020694','3079901','3042711','3021118','3021006','3113363','3109751','3109694','3109595','2981239','2981185','2980977','2958685','3120214','3114919','3121361','3121341','3121333','3121321','3130880','3127768','3121288','3121081','3121143','3121170','3121207','3121260','3148392','3148142','3147990','3147901','3154129','3064937','3123694','3123610','3108336','3154118','3151605','3151530','3151181','3155603','3155588','3163361','3174792','3175081','3175070','3169445','3177109','3174762','3174665','3163165','3162568','3155620','3155619','3155618','3155613','3128860','3128850','3128768','3124532','3124514','3124502','3124494','3124485','3124428','3117899','3117896','3117895','3117876','3117525','3117523','3117504','3117500','3117498','3113482','3113456','3113444','3111986','3111978','3111974','3111961','3111954','3111943','3111871','3111861','3111847','3111804','3111798','3111730','3105431','3105403','3105365','3105117','3105095','3105072','3105048','3104962','3094053','3094052','3094048','3094043','3092790','3092778','3092773','3092768','3092765','3092729','3091665','3091661','3091659','3091649','3091647','3100484','3100473','3100469','3100460','3099317','3099309','3099295','3099267','3099254','3099227','3099219','3099215','3099150','3099131','3099088','3099081','3099074','3097648','3097637','3097629','3097394','3097386','3097373','3097310','3097300','3096752','3096745','3096727','3096716','3083299','3083275','3083258','3083245','3083135','3083118','3083075','3083017','3083007','3082875','3082818','3021489','3070199','3071519','3071539','3130699','3134562','3199294','3195001','3188503','3188334','3213632','3216827','3231087','3230868','3230760','3213213','3236459','3213729','3213723','3213720','3213679','3213661','3213652','3213649','3213631','3213625','3213619','3213616','3212983','3208795','3208793','3208792','3208791','3208788','3208785','3208784','3208782','3208778','3208777','3208774','3208771','3208770','3208767','3208765','3208764','3208763','3208272','3208266','3208212','3208198','3208193','3208179','3208172','3208164','3208155','3208151'<br />,'9764258','9343290','3959020','4246677','9942270','9909627','6914001','4254305','8250386','8250751','2928567','3130752','2928473','10147286','5511808','10356669','8802897','10243162','10266205','5062231','5475595','10240465','2928544','10875232') and p.CustomerID=@CustomerID<br />PARAMS:@CustomerID = 1 ,<br />MESSAGE:The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.<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.DALExtend.RB_ProductExtend.GetGetWarehouseInfoModels(Int32 customerID, List`1 skus)<br /> 在 PandaBuy.ERP.Web.IrobotBox.SalesAnalysis.BatchUpdateSalePrice.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_salesanalysis_batchupdatesaleprice_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)</p>
003-
003+ <div><br /></div>

修改了 指派给，旧值为 "huxiaolong"，新值为 "hejianbao"。

修改了 指派给，旧值为 "hejianbao"，新值为 "huxiaolong"。

修改了 指派给，旧值为 "huxiaolong"，新值为 "wangxiangyu"。

修改了 指派给，旧值为 "wangxiangyu"，新值为 "pengkang"。

修改了 解决方案，旧值为 ""，新值为 "performance"。
修改了 解决版本，旧值为 ""，新值为 "652"。
修改了 解决日期，旧值为 ""，新值为 "2023-02-09 10:22:21"。
修改了 指派给 ，旧值为 "pengkang"，新值为 "yuanhuibin"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "pengkang"。

修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "yuanhuibin"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "yuanhuibin"。
修改了 关闭日期，旧值为 ""，新值为 "2023-02-15 14:42:12"。

修改了 所属模块，旧值为 "1810"，新值为 "1852"。

修改了 所属模块，旧值为 "1852"，新值为 "1863"。