重现步骤

[步骤]

(@CustomerID int,@IDs nvarchar(199))select [ID],[CustomerID],[OrderSourceID],[ListingBasicID],[ListingProductID],[SKU],[SKUAvailableInventory],[OrderAdvance],[SKUSales],[OrderSourceSKUSales],[ProcurementNum],[TransportNum],[BuyerPrice],[SyncTime],[NeedReplenishment],[SkuEstimateSaleDay]   from  [RB_Ebay_Listing_Product_Sales_V2] (nolock) where CustomerID=@CustomerID and [ListingBasicID] in (select item from dbo.CharSplitForIn(@IDs,','))



[09:10:29]  -------------------------------------------------------------
CODE:N0910292
Error:11_-2_0_-2146232060
SQL:select [ID],[CustomerID],[OrderSourceID],[ListingBasicID],[ListingProductID],[SKU],[SKUAvailableInventory],[OrderAdvance],[SKUSales],[OrderSourceSKUSales],[ProcurementNum],[TransportNum],[BuyerPrice],[SyncTime],[NeedReplenishment],[SkuEstimateSaleDay]   from  [RB_Ebay_Listing_Product_Sales_V2] (nolock) where CustomerID=@CustomerID and [ListingBasicID] in (select item from dbo.CharSplitForIn(@IDs,','))
PARAMS:@CustomerID = 1 ,@IDs = 288091719,288091689,288087799,288087629,288081009,288081006,288081005,288081004,288081003,288066147,288066145,288066144,288066142,288066141,288066140,288066139,287986913,287986912,287986911,287986910 ,
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.DALExtend.RB_Ebay_Listing_Product_Sales_V2Extend.GetModelsByListingBasicIDs(Int32 CustomerID, List`1 IDs)
   在 PandaBuy.ERP.Web.IrobotBox.EbayV2.ListingList.GetELPSListByListingBasicIDs()
   在 PandaBuy.ERP.Web.IrobotBox.EbayV2.ListingList.OnPreInit(EventArgs e)
   在 System.Web.UI.Page.PerformPreInit()
   在 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.ProcessRequest(HttpContext context)
   在 ASP.irobotbox_ebayv2_listinglist_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.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)

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


[结果]


[期望]

修复ListingBasicID 和 item 类型 保持一直 


历史记录  
  1. 2024-11-07 09:29:09, 由 袁慧斌 创建。
  2. 2024-11-07 09:32:44, 由 李乐同 指派给 胡笑锋。
    修改了 指派给,旧值为 "liletong",新值为 "huxiaofeng"。
  3. 2024-11-07 09:41:00, 由 胡笑锋 指派给 刘朋飞。
    修改了 指派给,旧值为 "huxiaofeng",新值为 "liupengfei"。
  4. 2024-11-07 10:00:18, 由 刘朋飞 解决,方案为 历史bug(180天以上) 。
    修改了 解决方案,旧值为 "",新值为 "history"。
    修改了 解决版本,旧值为 "",新值为 "trunk"。
    修改了 解决日期,旧值为 "",新值为 "2024-11-07 09:58:31"。
    修改了 指派给 ,旧值为 "liupengfei",新值为 "yuanhuibin"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    修改了 解决者 ,旧值为 "",新值为 "liupengfei"。

    ERP 性能历史问题:

    通知DBA 给表添加索引:

    表:RB_Ebay_Listing_Product_Sales_V2 添加索引

  5. 2024-11-07 10:05:20, 由 袁慧斌 激活。
    修改了 指派给 ,旧值为 "yuanhuibin",新值为 "liupengfei"。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "active"。
    修改了 激活日期,旧值为 "",新值为 "2024-11-07 10:05:20"。
    修改了 激活次数,旧值为 "0",新值为 "1"。
    修改了 解决方案,旧值为 "history",新值为 ""。
    修改了 解决日期,旧值为 "2024-11-07 09:58:31",新值为 "0000-00-00"。
    修改了 解决者 ,旧值为 "liupengfei",新值为 ""。
    修改了 解决版本,旧值为 "trunk",新值为 ""。
    修改了 关闭日期,旧值为 "",新值为 "0000-00-00"。
    类型不一致的 代码 也需要整改好 
  6. 2024-11-08 09:12:51, 由 刘朋飞 编辑。
    修改了 解决时效,旧值为 "0",新值为 "-1"。
    修改了 重现步骤,区别为:
    004- [09:10:29] -------------------------------------------------------------CODE:N0910292Error:11_-2_0_-2146232060SQL:select [ID],[CustomerID],[OrderSourceID],[ListingBasicID],[ListingProductID],[SKU],[SKUAvailableInventory],[OrderAdvance],[SKUSales],[OrderSourceSKUSales],[ProcurementNum],[TransportNum],[BuyerPrice],[SyncTime],[NeedReplenishment],[SkuEstimateSaleDay] from [RB_Ebay_Listing_Product_Sales_V2] (nolock) where CustomerID=@CustomerID and [ListingBasicID] in (select item from dbo.CharSplitForIn(@IDs,','))PARAMS:@CustomerID = 1 ,@IDs = 288091719,288091689,288087799,288087629,288081009,288081006,288081005,288081004,288081003,288066147,288066145,288066144,288066142,288066141,288066140,288066139,287986913,287986912,287986911,287986910 ,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.DALExtend.RB_Ebay_Listing_Product_Sales_V2Extend.GetModelsByListingBasicIDs(Int32 CustomerID, List`1 IDs) 在 PandaBuy.ERP.Web.IrobotBox.EbayV2.ListingList.GetELPSListByListingBasicIDs() 在 PandaBuy.ERP.Web.IrobotBox.EbayV2.ListingList.OnPreInit(EventArgs e) 在 System.Web.UI.Page.PerformPreInit() 在 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.ProcessRequest(HttpContext context) 在 ASP.irobotbox_ebayv2_listinglist_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.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)-------------------------------------------------------------
    004+ [09:10:29] -------------------------------------------------------------CODE:N0910292Error:11_-2_0_-2146232060SQL:select [ID],[CustomerID],[OrderSourceID],[ListingBasicID],[ListingProductID],[SKU],[SKUAvailableInventory],[OrderAdvance],[SKUSales],[OrderSourceSKUSales],[ProcurementNum],[TransportNum],[BuyerPrice],[SyncTime],[NeedReplenishment],[SkuEstimateSaleDay] from [RB_Ebay_Listing_Product_Sales_V2] (nolock) where CustomerID=@CustomerID and [ListingBasicID] in (select item from dbo.CharSplitForIn(@IDs,','))PARAMS:@CustomerID = 1 ,@IDs = 288091719,288091689,288087799,288087629,288081009,288081006,288081005,288081004,288081003,288066147,288066145,288066144,288066142,288066141,288066140,288066139,287986913,287986912,287986911,287986910 ,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.DALExtend.RB_Ebay_Listing_Product_Sales_V2Extend.GetModelsByListingBasicIDs(Int32 CustomerID, List`1 IDs) 在 PandaBuy.ERP.Web.IrobotBox.EbayV2.ListingList.GetELPSListByListingBasicIDs() 在 PandaBuy.ERP.Web.IrobotBox.EbayV2.ListingList.OnPreInit(EventArgs e) 在 System.Web.UI.Page.PerformPreInit() 在 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.ProcessRequest(HttpContext context) 在 ASP.irobotbox_ebayv2_listinglist_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.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)-------------------------------------------------------------
    005-
    005+
    006-
    006+ [结果]
    007- [结果]
    007+ [期望] 修复ListingBasicID 和 item类型 保持一直
    008- [期望] 修复ListingBasicID 和 item类型 保持一直
    008+
    009-
    004- <p><br />[09:10:29] -------------------------------------------------------------<br />CODE:N0910292<br />Error:11_-2_0_-2146232060<br />SQL:select [ID],[CustomerID],[OrderSourceID],[ListingBasicID],[ListingProductID],[SKU],[SKUAvailableInventory],[OrderAdvance],[SKUSales],[OrderSourceSKUSales],[ProcurementNum],[TransportNum],[BuyerPrice],[SyncTime],[NeedReplenishment],[SkuEstimateSaleDay] from [RB_Ebay_Listing_Product_Sales_V2] (nolock) where CustomerID=@CustomerID and [ListingBasicID] in (select item from dbo.CharSplitForIn(@IDs,','))<br />PARAMS:@CustomerID = 1 ,@IDs = 288091719,288091689,288087799,288087629,288081009,288081006,288081005,288081004,288081003,288066147,288066145,288066144,288066142,288066141,288066140,288066139,287986913,287986912,287986911,287986910 ,<br />MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。<br />TRACE: 在 System.Data.SqlClient.SqlConnection.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.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_Ebay_Listing_Product_Sales_V2Extend.GetModelsByListingBasicIDs(Int32 CustomerID, List`1 IDs)<br /> 在 PandaBuy.ERP.Web.IrobotBox.EbayV2.ListingList.GetELPSListByListingBasicIDs()<br /> 在 PandaBuy.ERP.Web.IrobotBox.EbayV2.ListingList.OnPreInit(EventArgs e)<br /> 在 System.Web.UI.Page.PerformPreInit()<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.ProcessRequest(HttpContext context)<br /> 在 ASP.irobotbox_ebayv2_listinglist_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.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 /><br />-------------------------------------------------------------<br /></p><div><br /></div>
    004+ <p><br />[09:10:29] -------------------------------------------------------------<br />CODE:N0910292<br />Error:11_-2_0_-2146232060<br />SQL:select [ID],[CustomerID],[OrderSourceID],[ListingBasicID],[ListingProductID],[SKU],[SKUAvailableInventory],[OrderAdvance],[SKUSales],[OrderSourceSKUSales],[ProcurementNum],[TransportNum],[BuyerPrice],[SyncTime],[NeedReplenishment],[SkuEstimateSaleDay] from [RB_Ebay_Listing_Product_Sales_V2] (nolock) where CustomerID=@CustomerID and [ListingBasicID] in (select item from dbo.CharSplitForIn(@IDs,','))<br />PARAMS:@CustomerID = 1 ,@IDs = 288091719,288091689,288087799,288087629,288081009,288081006,288081005,288081004,288081003,288066147,288066145,288066144,288066142,288066141,288066140,288066139,287986913,287986912,287986911,287986910 ,<br />MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。<br />TRACE: 在 System.Data.SqlClient.SqlConnection.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.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_Ebay_Listing_Product_Sales_V2Extend.GetModelsByListingBasicIDs(Int32 CustomerID, List`1 IDs)<br /> 在 PandaBuy.ERP.Web.IrobotBox.EbayV2.ListingList.GetELPSListByListingBasicIDs()<br /> 在 PandaBuy.ERP.Web.IrobotBox.EbayV2.ListingList.OnPreInit(EventArgs e)<br /> 在 System.Web.UI.Page.PerformPreInit()<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.ProcessRequest(HttpContext context)<br /> 在 ASP.irobotbox_ebayv2_listinglist_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.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 /><br />-------------------------------------------------------------</p>
    005-
    005+ <div><br /></div>
    006- <p></p>
    006+ <p>[结果]</p>
    007- <p>[结果]</p>
    007+ <br /><p>[期望] 修复<span>ListingBasicID 和 item</span>类型 保持一直</p>
    008- <br /><p>[期望] 修复<span>ListingBasicID 和 item</span>类型 保持一直</p>
    008+ <br />
    009- <br />
    这个是DBA优化后的,不需要
  7. 2024-11-08 09:13:38, 由 刘朋飞 解决,方案为 非BUG-纯属误判 。
    修改了 解决方案,旧值为 "",新值为 "feibug"。
    修改了 解决版本,旧值为 "",新值为 "trunk"。
    修改了 解决日期,旧值为 "",新值为 "2024-11-08 09:13:07"。
    修改了 指派给 ,旧值为 "liupengfei",新值为 "yuanhuibin"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 解决者 ,旧值为 "",新值为 "liupengfei"。
    这个是dba优化后,无需修改
  8. 2024-11-08 16:32:26, 由 袁慧斌 指派给 李乐同。
    修改了 指派给,旧值为 "yuanhuibin",新值为 "liletong"。
    请填写测试责任人
  9. 2024-11-11 16:55:53, 由 李乐同 编辑。
    修改了 测试责任人,旧值为 "",新值为 "wangxiaoqin"。
    修改了 解决时效 ,旧值为 "0",新值为 "23.73"。
    修改了 上线时效 ,旧值为 "-1",新值为 "17750265.49"。
  10. 2024-11-11 16:56:21, 由 李乐同 指派给 袁慧斌。
    修改了 指派给,旧值为 "liletong",新值为 "yuanhuibin"。
  11. 2024-11-11 17:02:01, 由 袁慧斌 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 指派给 ,旧值为 "yuanhuibin",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "yuanhuibin"。
    修改了 关闭日期,旧值为 "",新值为 "2024-11-11 17:02:01"。
所属项目 技术中心-需求池
所属模块 多平台   Ebay
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P1
Bug状态 已关闭
业务部门
影响功能
开发责任人 刘朋飞
测试责任人 王小勤
解决时效 23.73
激活次数 1
激活日期 2024-11-07 10:05:20
是否确认 是
当前指派 Closed 于 2024-11-11 17:02:01
截止日期 0000-00-00
上线时间 0000-00-00 00:00:00
上线时效 17750300
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 袁慧斌 于 2024-11-07 09:29:09
影响环境 577
由谁解决 刘朋飞 于 2024-11-08 09:13:07
解决版本 主干
解决方案 非BUG-纯属误判
由谁关闭 袁慧斌 于 2024-11-11 17:02:01
最后修改 袁慧斌 于 2024-11-11 17:02:01
相关Bug