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

修改了 重现步骤，区别为：

005- CODE:N1005321Error:11_-2_0_-2146232060SQL: SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY case when ProductProperty=2 then 100 else ProductProperty end desc ) AS [PageIndex] ,* FROM ( select vtb.ID, vtb.ParentID, vtb.IsVariation, pa.RecommendValue, vtb.IsFirstLevelProduct, vtb.IsSaleProduct, vtb.isEmergencyStock, vtb.ExpectedArrivalDays, vtb.DeliveryDay, Isnull(BuyBoxNum1, 0) BuyBoxNum1, Isnull(BuyBoxNum2, 0) BuyBoxNum2, Isnull(AllBuyBoxNum1, 0) AllBuyBoxNum1, Isnull(BuyBoxNum3, 0) BuyBoxNum3, Isnull(AllBuyBoxNum2, 0) AllBuyBoxNum2, Isnull(AllBuyBoxNum3, 0) AllBuyBoxNum3, Isnull(OrdinaryBuyBoxNum1, 0) OrdinaryBuyBoxNum1, Isnull(OrdinaryAllBuyBoxNum1, 0) OrdinaryAllBuyBoxNum1, Isnull(OrdinaryBuyBoxNum2, 0) OrdinaryBuyBoxNum2, Isnull(OrdinaryAllBuyBoxNum2, 0) OrdinaryAllBuyBoxNum2, Isnull(OrdinaryBuyBoxNum3, 0) OrdinaryBuyBoxNum3, Isnull(OrdinaryAllBuyBoxNum3, 0) OrdinaryAllBuyBoxNum3, AUID, vtb.ImageUrl, vtb.ClientSKU, vtb.ProductName, vtb.ProductNameCN, PID, vtb.SalePrice, vtb.LastBuyPrice, vtb.LastSupplierPrice, vtb.GrossWeight, vtb.PackWeight, vtb.IsGroup, vtb.ProductProperty, o.OrderSourceCountry, o.OrderSourceName, cgzNum, ystzNum, ProductNum, ReadyLibraryNum, todaysaleNum, zsaleNum, qsaleNum, sqsaleNum, WeekSaleNum, TwoWeekSaleNum, vtb.APIID, DevIDSellerId, Cycle, vtb.SafetyDays, WPID, LastUPdateTime, vtb.AddCycle, vtb.HaulageTime, vtb.EstimatedSaleNum, vtb.BuyTime, IsBuyBox, RobBuyBox, Kl, vtb.AvgDailySales, ToBuyBoxProduct, IsTiming, vtb.WID, vtb.CustomerID, vtb.BasePrice, vtb.OrderSourceID, vtb.UpdateTime, vtb.FNSKU, vtb.LockNum, IsFBA, vtb.OrderSourceSKU, vtb.WareHouseName, ASINorItemID, SellerType, vtb.SKU, vtb.BusinessTeam, vtb.BusinessTeamName, vtb.OrderSourceSKUID, KykcNum, CnKyNum, CnWPID, vtb.WareHouseType, msaleNum, lastmsaleNum, zhanyong, vtb.IsActive, vtb.AddTime, daysNum, BuyBoxUpdateTime, SyncLastUpdateTime, isBeiKu, LastUpTiming, LastDownTiming, rankNum, rankZTNum, rankQTNum, rankSQNum, rankClassName, bhnum, IsOffShelf, ListingPrice, ListingSoldNum, StopProduct, StopAndNullStockProduct, BusinessAdminID, BusinessUserName, vtb.Currency, ExchangeRMB, FBASeller_Num, ThreeMonthSaleNum, RobBuyBoxType, Attention, Isnull(LowestPriceBuyBoxNum1, 0) LowestPriceBuyBoxNum1, Isnull(LowestPriceAllBuyBoxNum1, 0) LowestPriceAllBuyBoxNum1, Isnull(LowestPriceBuyBoxNum2, 0) LowestPriceBuyBoxNum2, Isnull(LowestPriceAllBuyBoxNum2, 0) LowestPriceAllBuyBoxNum2, Isnull(LowestPriceBuyBoxNum3, 0) LowestPriceBuyBoxNum3, Isnull(LowestPriceAllBuyBoxNum3, 0) LowestPriceAllBuyBoxNum3, ProductVitalityType, ProductNewType, UnsalableDayNum, AmazonShelvesNum, EbayShelvesNum, SMTShelvesNum, WishShelvesNum, OtherShelvesNum, TotalShelvesNum, vtb.FirstLegShippingType, IsRemind, (SELECT TOP 1 ID FROM RB_Listing_Sync_GoodNum sync (nolock) WHERE sync.IsActive = 1 AND sync.ListingType = 2 AND sync.ListingID = vtb.OrderSourceSKUID AND sync.CustomerID = vtb.CustomerID) IsSet, Isnull(vtb.BrandType, 0) BrandType, Isnull(scd.ID, 0) AS IsClear, scs.Name, scd.WarehouseNum, ( WarehouseNum - Inventory ) AS ClearInventory, vtb.IsAmazonListingReview, vtb.ReviewStar, vtb.ReviewNum, vtb.ReviewUnReadNum, vtb.LastReviewCollectionTime, vtb.LastSynReviewTime, vtb.BadReviewNum, vtb.ThreeDayReviewNum, vtb.SevenDayDayReviewNum, vtb.IsAmazonKeywordRank, vtb.FBA_Reserved_CustomerOrders, vtb.FBA_Reserved_Transfers, vtb.FBA_Reserved_Processing, YesterdaySessions, BeforeYesterdaySessions, HeretoforeSessions, Isnull(YesterdayUnitSessionPercentage, 0) AS YesterdayUnitSessionPercentage, Isnull(BeforeYesterdayUnitSessionPercentage, 0) AS BeforeYesterdayUnitSessionPercentage, Isnull(HeretoforeUnitSessionPercentage, 0) AS HeretoforeUnitSessionPercentage, vtb.TaxPoint, vtb.TaxRate, Isnull(vtb.IsFBABarCode, 0) IsFBABarCode, Isnull(vtb.IsRecommendOcean, 0) IsRecommendOcean, Isnull(w.WareHouseName, '') AS DefaultWareHouseName, Isnull(vtb.YesterdaySpend, 0) YesterdaySpend, Isnull(vtb.TotalSpend, 0) TotalSpend, Isnull(vtb.YesterdayAvgCPC, 0) YesterdayAvgCPC, Isnull(vtb.TotalAvgCPC, 0) TotalAvgCPC, Isnull(vtb.YesterdayClicks, 0) YesterdayClicks, Isnull(vtb.TotalClicks, 0) TotalClicks, Isnull(vtb.YesterdayImpressions, 0) YesterdayImpressions, Isnull(vtb.TotalImpressions, 0) TotalImpressions, Isnull(vtb.IsEFN, 0) AS IsEFN, vtb.EFNCountry, Isnull(vtb.IsCheckDeclarationCode, 0) IsCheckDeclarationCode, Isnull(vtb.IsCheckTransport, 0) IsCheckTransport, Isnull(vtb.IsSalesRank, 0) IsSalesRank, p.ProdutcArrivalDate, vtb.HolidaysID, wh.WareHouseName AS DefaultLocalWarehouse, swh.WareHouseName SupplierWareHouseName, vtb.AddAdminName, vtb.IsSetNoSupplyReason, vtb.IsEmergencyStockReminder, vtb.TranslateStatus, p.MinSaleNum, p.WithBattery, pa.IsAmazonSale, pa.NoSalePlatform, vtb.TemplateID, vtb.LableColor, vtb.LableName, p.PictureSource, pa.ImageTime, vtb.ProfitMargin, vtb.PublishTime, vtb.MonthAvgProfits, vtb.PlanID, vtb.PlanDetailId, vtb.PlanName, vtb.IsAgainPublish, vtb.IsAutoAdjustPrice, vtb.IsAutoLowerShelf, vtb.IsAutoPromotion, OnShelfMode, vtb.OrderSourceSkuOrderTime, vtb.AsinOrderTime, p.IsIntelligentStocking, ntf.Reason, vtb.WaitToFbaType , vtb.SevenDaySales, vtb.SevenDayAcos, vtb.DefaultWarehouseID, vtb.RecommendedOrderQuantity, vtb.DiscountStartTime, vtb.DiscountEndTime, vtb.DiscountSalesPrice, p.ImageUrl as ProductImageUrl, p.ProductName as ProductTitle, vtb.IsAdvertising, vtb.UnsellableQuatity, pa.NoSaleCountry, vtb.IsNARF, vtb.MaximumShipmentQuantity, vtb.RecommendFinalNum, vtb.MonitorStockFinalNum, vtb.IsJoinSmall, vtb.RecommendJoinSmall, vtb.NoJoinSmallReason from [RB_Amazon_Product_Base] (nolock) vtb LEFT JOIN RB_StockClearDetailed scd (nolock) ON(vtb.OrderSourceSKUID=scd.ListId AND vtb.CustomerID=scd.CustomerID AND (clearType=1 OR clearType=3)) LEFT JOIN RB_StockClearStrategy scs (nolock) ON(scd.scsID=scs.ID AND scd.CustomerID=scs.CustomerID) LEFT JOIN (SELECT sum(GoodNum) AS Inventory,WareHouseID,SKU,CustomerID FROM RB_WareHouse_Product (nolock) GROUP BY WareHouseID,SKU,CustomerID) AS tbWHN ON(vtb.WID=tbWHN.WareHouseID AND vtb.SKU=tbWHN.SKU AND vtb.CustomerID=tbWHN.CustomerID) LEFT JOIN RB_WareHouse w (nolock) ON w.CustomerID=vtb.CustomerID and w.ID=vtb.DefaultWarehouseID LEFT JOIN RB_OrderSource o (nolock) on vtb.CustomerID=o.CustomerID and vtb.OrderSourceID = o.ID Left join RB_Product_Admin pa(nolock) on vtb.CustomerID=pa.CustomerID and vtb.SKU = pa.SKU left join RB_Product p (nolock) on p.CustomerID=vtb.CustomerID and vtb.SKU = p.SKU left join RB_WareHouse wh(nolock) on wh.CustomerID=p.CustomerID and wh.ID=p.DefaultLocalWarehouse left join RB_WareHouse swh(nolock) on swh.CustomerID=vtb.CustomerID and swh.ID=vtb.TheWareHouseID left join RB_Amazon_NotToFbaReason ntf (nolock) on vtb.CustomerID=ntf.CustomerID and vtb.NotToFbaReasonId=ntf.ID WHERE vtb.CustomerID=@CustomerID AND vtb.IsDelete=0 and isnull(IsOffShelf,0) in (1,4,5,2,0) and vtb.OrderSourceSKUID>0 ) AS TempTable ) AS PagerTable WHERE PagerTable.[PageIndex] BETWEEN 1 AND 20 option(maxdop 8)PARAMS:@CustomerID = 1 ,@UserID = 7172 ,@Count1 = ,@Count2 = ,MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 TRACE: 在 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) 在 System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() 在 System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() 在 System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() 在 System.Data.SqlClient.TdsParserStateObject.TryReadByteArray(Byte[] buff, Int32 offset, Int32 len, Int32& totalRead) 在 System.Data.SqlClient.TdsParserStateObject.TryReadString(Int32 length, String& value) 在 System.Data.SqlClient.TdsParser.TryCommonProcessMetaData(TdsParserStateObject stateObj, _SqlMetaData col, Nullable`1 cipherTable, Boolean fColMD, SqlCommandColumnEncryptionSetting columnEncryptionSetting) 在 System.Data.SqlClient.TdsParser.TryProcessMetaData(Int32 cColumns, TdsParserStateObject stateObj, _SqlMetaDataSet& metaData, SqlCommandColumnEncryptionSetting columnEncryptionSetting) 在 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.DAL.DBOperator.Query(String SQLString, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DALExtend.RB_Amazon_Product_BaseExtend.GetModelPagerList(RB_Amazon_Product_Base_PSParameters parameters, Int32& recordCount, String FolderID, Int32 CustomerID, Int32 AdminID, List`1 PermissionAdminIds, Int32 currentAdminId, String childWhere) 在 PandaBuy.ERP.Web.IrobotBox.Amazon.AmazonListingList.Page_Load(Object sender, EventArgs e) 在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) 在 System.Web.UI.Control.OnLoad(EventArgs e) 在 System.Web.UI.Control.LoadRecursive() 在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 在 System.Web.UI.Page.ProcessRequest() 在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) 在 System.Web.UI.Page.ProcessRequest(HttpContext context) 在 ASP.irobotbox_amazon_amazonlistinglist_aspx.ProcessRequest(HttpContext context) 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)-------------------------------------------------------------
005+ CODE:N1005321Error:11_-2_0_-2146232060SQL: SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY case when ProductProperty=2 then 100 else ProductProperty end desc ) AS [PageIndex] ,* FROM ( select vtb.ID, vtb.ParentID, vtb.IsVariation, pa.RecommendValue, vtb.IsFirstLevelProduct, vtb.IsSaleProduct, vtb.isEmergencyStock, vtb.ExpectedArrivalDays, vtb.DeliveryDay, Isnull(BuyBoxNum1, 0) BuyBoxNum1, Isnull(BuyBoxNum2, 0) BuyBoxNum2, Isnull(AllBuyBoxNum1, 0) AllBuyBoxNum1, Isnull(BuyBoxNum3, 0) BuyBoxNum3, Isnull(AllBuyBoxNum2, 0) AllBuyBoxNum2, Isnull(AllBuyBoxNum3, 0) AllBuyBoxNum3, Isnull(OrdinaryBuyBoxNum1, 0) OrdinaryBuyBoxNum1, Isnull(OrdinaryAllBuyBoxNum1, 0) OrdinaryAllBuyBoxNum1, Isnull(OrdinaryBuyBoxNum2, 0) OrdinaryBuyBoxNum2, Isnull(OrdinaryAllBuyBoxNum2, 0) OrdinaryAllBuyBoxNum2, Isnull(OrdinaryBuyBoxNum3, 0) OrdinaryBuyBoxNum3, Isnull(OrdinaryAllBuyBoxNum3, 0) OrdinaryAllBuyBoxNum3, AUID, vtb.ImageUrl, vtb.ClientSKU, vtb.ProductName, vtb.ProductNameCN, PID, vtb.SalePrice, vtb.LastBuyPrice, vtb.LastSupplierPrice, vtb.GrossWeight, vtb.PackWeight, vtb.IsGroup, vtb.ProductProperty, o.OrderSourceCountry, o.OrderSourceName, cgzNum, ystzNum, ProductNum, ReadyLibraryNum, todaysaleNum, zsaleNum, qsaleNum, sqsaleNum, WeekSaleNum, TwoWeekSaleNum, vtb.APIID, DevIDSellerId, Cycle, vtb.SafetyDays, WPID, LastUPdateTime, vtb.AddCycle, vtb.HaulageTime, vtb.EstimatedSaleNum, vtb.BuyTime, IsBuyBox, RobBuyBox, Kl, vtb.AvgDailySales, ToBuyBoxProduct, IsTiming, vtb.WID, vtb.CustomerID, vtb.BasePrice, vtb.OrderSourceID, vtb.UpdateTime, vtb.FNSKU, vtb.LockNum, IsFBA, vtb.OrderSourceSKU, vtb.WareHouseName, ASINorItemID, SellerType, vtb.SKU, vtb.BusinessTeam, vtb.BusinessTeamName, vtb.OrderSourceSKUID, KykcNum, CnKyNum, CnWPID, vtb.WareHouseType, msaleNum, lastmsaleNum, zhanyong, vtb.IsActive, vtb.AddTime, daysNum, BuyBoxUpdateTime, SyncLastUpdateTime, isBeiKu, LastUpTiming, LastDownTiming, rankNum, rankZTNum, rankQTNum, rankSQNum, rankClassName, bhnum, IsOffShelf, ListingPrice, ListingSoldNum, StopProduct, StopAndNullStockProduct, BusinessAdminID, BusinessUserName, vtb.Currency, ExchangeRMB, FBASeller_Num, ThreeMonthSaleNum, RobBuyBoxType, Attention, Isnull(LowestPriceBuyBoxNum1, 0) LowestPriceBuyBoxNum1, Isnull(LowestPriceAllBuyBoxNum1, 0) LowestPriceAllBuyBoxNum1, Isnull(LowestPriceBuyBoxNum2, 0) LowestPriceBuyBoxNum2, Isnull(LowestPriceAllBuyBoxNum2, 0) LowestPriceAllBuyBoxNum2, Isnull(LowestPriceBuyBoxNum3, 0) LowestPriceBuyBoxNum3, Isnull(LowestPriceAllBuyBoxNum3, 0) LowestPriceAllBuyBoxNum3, ProductVitalityType, ProductNewType, UnsalableDayNum, AmazonShelvesNum, EbayShelvesNum, SMTShelvesNum, WishShelvesNum, OtherShelvesNum, TotalShelvesNum, vtb.FirstLegShippingType, IsRemind, (SELECT TOP 1 ID FROM RB_Listing_Sync_GoodNum sync (nolock) WHERE sync.IsActive = 1 AND sync.ListingType = 2 AND sync.ListingID = vtb.OrderSourceSKUID AND sync.CustomerID = vtb.CustomerID) IsSet, Isnull(vtb.BrandType, 0) BrandType, Isnull(scd.ID, 0) AS IsClear, scs.Name, scd.WarehouseNum, ( WarehouseNum - Inventory ) AS ClearInventory, vtb.IsAmazonListingReview, vtb.ReviewStar, vtb.ReviewNum, vtb.ReviewUnReadNum, vtb.LastReviewCollectionTime, vtb.LastSynReviewTime, vtb.BadReviewNum, vtb.ThreeDayReviewNum, vtb.SevenDayDayReviewNum, vtb.IsAmazonKeywordRank, vtb.FBA_Reserved_CustomerOrders, vtb.FBA_Reserved_Transfers, vtb.FBA_Reserved_Processing, YesterdaySessions, BeforeYesterdaySessions, HeretoforeSessions, Isnull(YesterdayUnitSessionPercentage, 0) AS YesterdayUnitSessionPercentage, Isnull(BeforeYesterdayUnitSessionPercentage, 0) AS BeforeYesterdayUnitSessionPercentage, Isnull(HeretoforeUnitSessionPercentage, 0) AS HeretoforeUnitSessionPercentage, vtb.TaxPoint, vtb.TaxRate, Isnull(vtb.IsFBABarCode, 0) IsFBABarCode, Isnull(vtb.IsRecommendOcean, 0) IsRecommendOcean, Isnull(w.WareHouseName, '') AS DefaultWareHouseName, Isnull(vtb.YesterdaySpend, 0) YesterdaySpend, Isnull(vtb.TotalSpend, 0) TotalSpend, Isnull(vtb.YesterdayAvgCPC, 0) YesterdayAvgCPC, Isnull(vtb.TotalAvgCPC, 0) TotalAvgCPC, Isnull(vtb.YesterdayClicks, 0) YesterdayClicks, Isnull(vtb.TotalClicks, 0) TotalClicks, Isnull(vtb.YesterdayImpressions, 0) YesterdayImpressions, Isnull(vtb.TotalImpressions, 0) TotalImpressions, Isnull(vtb.IsEFN, 0) AS IsEFN, vtb.EFNCountry, Isnull(vtb.IsCheckDeclarationCode, 0) IsCheckDeclarationCode, Isnull(vtb.IsCheckTransport, 0) IsCheckTransport, Isnull(vtb.IsSalesRank, 0) IsSalesRank, p.ProdutcArrivalDate, vtb.HolidaysID, wh.WareHouseName AS DefaultLocalWarehouse, swh.WareHouseName SupplierWareHouseName, vtb.AddAdminName, vtb.IsSetNoSupplyReason, vtb.IsEmergencyStockReminder, vtb.TranslateStatus, p.MinSaleNum, p.WithBattery, pa.IsAmazonSale, pa.NoSalePlatform, vtb.TemplateID, vtb.LableColor, vtb.LableName, p.PictureSource, pa.ImageTime, vtb.ProfitMargin, vtb.PublishTime, vtb.MonthAvgProfits, vtb.PlanID, vtb.PlanDetailId, vtb.PlanName, vtb.IsAgainPublish, vtb.IsAutoAdjustPrice, vtb.IsAutoLowerShelf, vtb.IsAutoPromotion, OnShelfMode, vtb.OrderSourceSkuOrderTime, vtb.AsinOrderTime, p.IsIntelligentStocking, ntf.Reason, vtb.WaitToFbaType , vtb.SevenDaySales, vtb.SevenDayAcos, vtb.DefaultWarehouseID, vtb.RecommendedOrderQuantity, vtb.DiscountStartTime, vtb.DiscountEndTime, vtb.DiscountSalesPrice, p.ImageUrl as ProductImageUrl, p.ProductName as ProductTitle, vtb.IsAdvertising, vtb.UnsellableQuatity, pa.NoSaleCountry, vtb.IsNARF, vtb.MaximumShipmentQuantity, vtb.RecommendFinalNum, vtb.MonitorStockFinalNum, vtb.IsJoinSmall, vtb.RecommendJoinSmall, vtb.NoJoinSmallReason from [RB_Amazon_Product_Base] (nolock) vtb LEFT JOIN RB_StockClearDetailed scd (nolock) ON(vtb.OrderSourceSKUID=scd.ListId AND vtb.CustomerID=scd.CustomerID AND (clearType=1 OR clearType=3)) LEFT JOIN RB_StockClearStrategy scs (nolock) ON(scd.scsID=scs.ID AND scd.CustomerID=scs.CustomerID) LEFT JOIN (SELECT sum(GoodNum) AS Inventory,WareHouseID,SKU,CustomerID FROM RB_WareHouse_Product (nolock) GROUP BY WareHouseID,SKU,CustomerID) AS tbWHN ON(vtb.WID=tbWHN.WareHouseID AND vtb.SKU=tbWHN.SKU AND vtb.CustomerID=tbWHN.CustomerID) LEFT JOIN RB_WareHouse w (nolock) ON w.CustomerID=vtb.CustomerID and w.ID=vtb.DefaultWarehouseID LEFT JOIN RB_OrderSource o (nolock) on vtb.CustomerID=o.CustomerID and vtb.OrderSourceID = o.ID Left join RB_Product_Admin pa(nolock) on vtb.CustomerID=pa.CustomerID and vtb.SKU = pa.SKU left join RB_Product p (nolock) on p.CustomerID=vtb.CustomerID and vtb.SKU = p.SKU left join RB_WareHouse wh(nolock) on wh.CustomerID=p.CustomerID and wh.ID=p.DefaultLocalWarehouse left join RB_WareHouse swh(nolock) on swh.CustomerID=vtb.CustomerID and swh.ID=vtb.TheWareHouseID left join RB_Amazon_NotToFbaReason ntf (nolock) on vtb.CustomerID=ntf.CustomerID and vtb.NotToFbaReasonId=ntf.ID WHERE vtb.CustomerID=@CustomerID AND vtb.IsDelete=0 and isnull(IsOffShelf,0) in (1,4,5,2,0) and vtb.OrderSourceSKUID>0 ) AS TempTable ) AS PagerTable WHERE PagerTable.[PageIndex] BETWEEN 1 AND 20 option(maxdop 8)PARAMS:@CustomerID = 1 ,@UserID = 7172 ,@Count1 = ,@Count2 = ,MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 TRACE: 在 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) 在 System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() 在 System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() 在 System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() 在 System.Data.SqlClient.TdsParserStateObject.TryReadByteArray(Byte[] buff, Int32 offset, Int32 len, Int32& totalRead) 在 System.Data.SqlClient.TdsParserStateObject.TryReadString(Int32 length, String& value) 在 System.Data.SqlClient.TdsParser.TryCommonProcessMetaData(TdsParserStateObject stateObj, _SqlMetaData col, Nullable`1 cipherTable, Boolean fColMD, SqlCommandColumnEncryptionSetting columnEncryptionSetting) 在 System.Data.SqlClient.TdsParser.TryProcessMetaData(Int32 cColumns, TdsParserStateObject stateObj, _SqlMetaDataSet& metaData, SqlCommandColumnEncryptionSetting columnEncryptionSetting) 在 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.DAL.DBOperator.Query(String SQLString, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DALExtend.RB_Amazon_Product_BaseExtend.GetModelPagerList(RB_Amazon_Product_Base_PSParameters parameters, Int32& recordCount, String FolderID, Int32 CustomerID, Int32 AdminID, List`1 PermissionAdminIds, Int32 currentAdminId, String childWhere) 在 PandaBuy.ERP.Web.IrobotBox.Amazon.AmazonListingList.Page_Load(Object sender, EventArgs e) 在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) 在 System.Web.UI.Control.OnLoad(EventArgs e) 在 System.Web.UI.Control.LoadRecursive() 在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 在 System.Web.UI.Page.ProcessRequest() 在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) 在 System.Web.UI.Page.ProcessRequest(HttpContext context) 在 ASP.irobotbox_amazon_amazonlistinglist_aspx.ProcessRequest(HttpContext context) 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)-------------------------------------------------------------

005- <p>CODE:N1005321<br />Error:11_-2_0_-2146232060<br />SQL: <br /> SELECT * FROM (<br /> SELECT<br /> ROW_NUMBER() OVER (ORDER BY case when ProductProperty=2 then 100 else ProductProperty end desc ) AS [PageIndex] ,* FROM ( select vtb.ID,<br /> vtb.ParentID,<br /> vtb.IsVariation,<br /> pa.RecommendValue,<br /> vtb.IsFirstLevelProduct,<br /> vtb.IsSaleProduct,<br /> vtb.isEmergencyStock,<br /> vtb.ExpectedArrivalDays,<br /> vtb.DeliveryDay,<br /> Isnull(BuyBoxNum1, 0) BuyBoxNum1,<br /> Isnull(BuyBoxNum2, 0) BuyBoxNum2,<br /> Isnull(AllBuyBoxNum1, 0) AllBuyBoxNum1,<br /> Isnull(BuyBoxNum3, 0) BuyBoxNum3,<br /> Isnull(AllBuyBoxNum2, 0) AllBuyBoxNum2,<br /> Isnull(AllBuyBoxNum3, 0) AllBuyBoxNum3,<br /> Isnull(OrdinaryBuyBoxNum1, 0) OrdinaryBuyBoxNum1,<br /> Isnull(OrdinaryAllBuyBoxNum1, 0) OrdinaryAllBuyBoxNum1,<br /> Isnull(OrdinaryBuyBoxNum2, 0) OrdinaryBuyBoxNum2,<br /> Isnull(OrdinaryAllBuyBoxNum2, 0) OrdinaryAllBuyBoxNum2,<br /> Isnull(OrdinaryBuyBoxNum3, 0) OrdinaryBuyBoxNum3,<br /> Isnull(OrdinaryAllBuyBoxNum3, 0) OrdinaryAllBuyBoxNum3,<br /> AUID,<br /> vtb.ImageUrl,<br /> vtb.ClientSKU,<br /> vtb.ProductName,<br /> vtb.ProductNameCN,<br /> PID,<br /> vtb.SalePrice,<br /> vtb.LastBuyPrice,<br /> vtb.LastSupplierPrice,<br /> vtb.GrossWeight,<br /> vtb.PackWeight,<br /> vtb.IsGroup,<br /> vtb.ProductProperty,<br /> o.OrderSourceCountry,<br /> o.OrderSourceName,<br /> cgzNum,<br /> ystzNum,<br /> ProductNum,<br /> ReadyLibraryNum,<br /> todaysaleNum,<br /> zsaleNum,<br /> qsaleNum,<br /> sqsaleNum,<br /> WeekSaleNum,<br /> TwoWeekSaleNum,<br /> vtb.APIID,<br /> DevIDSellerId,<br /> Cycle,<br /> vtb.SafetyDays,<br /> WPID,<br /> LastUPdateTime,<br /> vtb.AddCycle,<br /> vtb.HaulageTime,<br /> vtb.EstimatedSaleNum,<br /> vtb.BuyTime,<br /> IsBuyBox,<br /> RobBuyBox,<br /> Kl,<br /> vtb.AvgDailySales,<br /> ToBuyBoxProduct,<br /> IsTiming,<br /> vtb.WID,<br /> vtb.CustomerID,<br /> vtb.BasePrice,<br /> vtb.OrderSourceID,<br /> vtb.UpdateTime,<br /> vtb.FNSKU,<br /> vtb.LockNum,<br /> IsFBA,<br /> vtb.OrderSourceSKU,<br /> vtb.WareHouseName,<br /> ASINorItemID,<br /> SellerType,<br /> vtb.SKU,<br /> vtb.BusinessTeam,<br /> vtb.BusinessTeamName,<br /> vtb.OrderSourceSKUID,<br /> KykcNum,<br /> CnKyNum,<br /> CnWPID,<br /> vtb.WareHouseType,<br /> msaleNum,<br /> lastmsaleNum,<br /> zhanyong,<br /> vtb.IsActive,<br /> vtb.AddTime,<br /> daysNum,<br /> BuyBoxUpdateTime,<br /> SyncLastUpdateTime,<br /> isBeiKu,<br /> LastUpTiming,<br /> LastDownTiming,<br /> rankNum,<br /> rankZTNum,<br /> rankQTNum,<br /> rankSQNum,<br /> rankClassName,<br /> bhnum,<br /> IsOffShelf,<br /> ListingPrice,<br /> ListingSoldNum,<br /> StopProduct,<br /> StopAndNullStockProduct,<br /> BusinessAdminID,<br /> BusinessUserName,<br /> vtb.Currency,<br /> ExchangeRMB,<br /> FBASeller_Num,<br /> ThreeMonthSaleNum,<br /> RobBuyBoxType,<br /> Attention,<br /> Isnull(LowestPriceBuyBoxNum1, 0) LowestPriceBuyBoxNum1,<br /> Isnull(LowestPriceAllBuyBoxNum1, 0) LowestPriceAllBuyBoxNum1,<br /> Isnull(LowestPriceBuyBoxNum2, 0) LowestPriceBuyBoxNum2,<br /> Isnull(LowestPriceAllBuyBoxNum2, 0) LowestPriceAllBuyBoxNum2,<br /> Isnull(LowestPriceBuyBoxNum3, 0) LowestPriceBuyBoxNum3,<br /> Isnull(LowestPriceAllBuyBoxNum3, 0) LowestPriceAllBuyBoxNum3,<br /> ProductVitalityType,<br /> ProductNewType,<br /> UnsalableDayNum,<br /> AmazonShelvesNum,<br /> EbayShelvesNum,<br /> SMTShelvesNum,<br /> WishShelvesNum,<br /> OtherShelvesNum,<br /> TotalShelvesNum,<br /> vtb.FirstLegShippingType,<br /> IsRemind,<br /> (SELECT TOP 1 ID FROM RB_Listing_Sync_GoodNum sync (nolock) WHERE sync.IsActive = 1 AND sync.ListingType = 2 AND sync.ListingID = vtb.OrderSourceSKUID AND sync.CustomerID = vtb.CustomerID) IsSet,<br /> Isnull(vtb.BrandType, 0) BrandType,<br /> Isnull(scd.ID, 0) AS IsClear,<br /> scs.Name,<br /> scd.WarehouseNum,<br /> ( WarehouseNum - Inventory ) AS ClearInventory,<br /> vtb.IsAmazonListingReview,<br /> vtb.ReviewStar,<br /> vtb.ReviewNum,<br /> vtb.ReviewUnReadNum,<br /> vtb.LastReviewCollectionTime,<br /> vtb.LastSynReviewTime,<br /> vtb.BadReviewNum,<br /> vtb.ThreeDayReviewNum,<br /> vtb.SevenDayDayReviewNum,<br /> vtb.IsAmazonKeywordRank,<br /> vtb.FBA_Reserved_CustomerOrders,<br /> vtb.FBA_Reserved_Transfers,<br /> vtb.FBA_Reserved_Processing,<br /> YesterdaySessions,<br /> BeforeYesterdaySessions,<br /> HeretoforeSessions,<br /> Isnull(YesterdayUnitSessionPercentage, 0) AS YesterdayUnitSessionPercentage,<br /> Isnull(BeforeYesterdayUnitSessionPercentage, 0) AS BeforeYesterdayUnitSessionPercentage,<br /> Isnull(HeretoforeUnitSessionPercentage, 0) AS HeretoforeUnitSessionPercentage,<br /> vtb.TaxPoint,<br /> vtb.TaxRate,<br /> Isnull(vtb.IsFBABarCode, 0) IsFBABarCode,<br /> Isnull(vtb.IsRecommendOcean, 0) IsRecommendOcean,<br /> Isnull(w.WareHouseName, '') AS DefaultWareHouseName,<br /> Isnull(vtb.YesterdaySpend, 0) YesterdaySpend,<br /> Isnull(vtb.TotalSpend, 0) TotalSpend,<br /> Isnull(vtb.YesterdayAvgCPC, 0) YesterdayAvgCPC,<br /> Isnull(vtb.TotalAvgCPC, 0) TotalAvgCPC,<br /> Isnull(vtb.YesterdayClicks, 0) YesterdayClicks,<br /> Isnull(vtb.TotalClicks, 0) TotalClicks,<br /> Isnull(vtb.YesterdayImpressions, 0) YesterdayImpressions,<br /> Isnull(vtb.TotalImpressions, 0) TotalImpressions,<br /> Isnull(vtb.IsEFN, 0) AS IsEFN,<br /> vtb.EFNCountry,<br /> Isnull(vtb.IsCheckDeclarationCode, 0) IsCheckDeclarationCode,<br /> Isnull(vtb.IsCheckTransport, 0) IsCheckTransport,<br /> Isnull(vtb.IsSalesRank, 0) IsSalesRank,<br /> p.ProdutcArrivalDate,<br /> vtb.HolidaysID,<br /> wh.WareHouseName AS DefaultLocalWarehouse,<br /> swh.WareHouseName SupplierWareHouseName,<br /> vtb.AddAdminName,<br /> vtb.IsSetNoSupplyReason,<br /> vtb.IsEmergencyStockReminder,<br /> vtb.TranslateStatus,<br /> p.MinSaleNum,<br /> p.WithBattery,<br /> pa.IsAmazonSale,<br /> pa.NoSalePlatform,<br /> vtb.TemplateID,<br /> vtb.LableColor,<br /> vtb.LableName,<br /> p.PictureSource,<br /> pa.ImageTime,<br /> vtb.ProfitMargin,<br /> vtb.PublishTime,<br /> vtb.MonthAvgProfits,<br /> vtb.PlanID,<br /> vtb.PlanDetailId,<br /> vtb.PlanName,<br /> vtb.IsAgainPublish,<br /> vtb.IsAutoAdjustPrice,<br /> vtb.IsAutoLowerShelf,<br /> vtb.IsAutoPromotion,<br /> OnShelfMode,<br /> vtb.OrderSourceSkuOrderTime,<br /> vtb.AsinOrderTime,<br /> p.IsIntelligentStocking,<br /> ntf.Reason,<br /> vtb.WaitToFbaType , <br /> vtb.SevenDaySales,<br /> vtb.SevenDayAcos,<br /> vtb.DefaultWarehouseID,<br /> vtb.RecommendedOrderQuantity,<br /> vtb.DiscountStartTime,<br /> vtb.DiscountEndTime,<br /> vtb.DiscountSalesPrice,<br /> p.ImageUrl as ProductImageUrl,<br /> p.ProductName as ProductTitle,<br /> vtb.IsAdvertising,<br /> vtb.UnsellableQuatity,<br /> pa.NoSaleCountry,<br /> vtb.IsNARF,<br /> vtb.MaximumShipmentQuantity,<br /> vtb.RecommendFinalNum,<br /> vtb.MonitorStockFinalNum,<br /> vtb.IsJoinSmall,<br /> vtb.RecommendJoinSmall,<br /> vtb.NoJoinSmallReason from [RB_Amazon_Product_Base] (nolock) vtb LEFT JOIN RB_StockClearDetailed scd (nolock) ON(vtb.OrderSourceSKUID=scd.ListId AND vtb.CustomerID=scd.CustomerID AND (clearType=1 OR clearType=3))<br /> LEFT JOIN RB_StockClearStrategy scs (nolock) ON(scd.scsID=scs.ID AND scd.CustomerID=scs.CustomerID) <br /> LEFT JOIN (SELECT sum(GoodNum) AS Inventory,WareHouseID,SKU,CustomerID FROM RB_WareHouse_Product (nolock) GROUP BY WareHouseID,SKU,CustomerID) AS tbWHN ON(vtb.WID=tbWHN.WareHouseID AND vtb.SKU=tbWHN.SKU AND vtb.CustomerID=tbWHN.CustomerID)<br /> LEFT JOIN RB_WareHouse w (nolock) ON w.CustomerID=vtb.CustomerID and w.ID=vtb.DefaultWarehouseID <br /> LEFT JOIN RB_OrderSource o (nolock) on vtb.CustomerID=o.CustomerID and vtb.OrderSourceID = o.ID<br /> Left join RB_Product_Admin pa(nolock) on vtb.CustomerID=pa.CustomerID and vtb.SKU = pa.SKU<br /> left join RB_Product p (nolock) on p.CustomerID=vtb.CustomerID and vtb.SKU = p.SKU <br /> left join RB_WareHouse wh(nolock) on wh.CustomerID=p.CustomerID and wh.ID=p.DefaultLocalWarehouse<br /> left join RB_WareHouse swh(nolock) on swh.CustomerID=vtb.CustomerID and swh.ID=vtb.TheWareHouseID<br /> left join RB_Amazon_NotToFbaReason ntf (nolock) on vtb.CustomerID=ntf.CustomerID and vtb.NotToFbaReasonId=ntf.ID WHERE vtb.CustomerID=@CustomerID AND vtb.IsDelete=0 and isnull(IsOffShelf,0) in (1,4,5,2,0) and vtb.OrderSourceSKUID&gt;0 ) AS TempTable ) AS PagerTable WHERE PagerTable.[PageIndex] BETWEEN 1 AND 20 option(maxdop 8)<br />PARAMS:@CustomerID = 1 ,@UserID = 7172 ,@Count1 = ,@Count2 = ,<br />MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 <br />TRACE: 在 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)<br /> 在 System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()<br /> 在 System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()<br /> 在 System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()<br /> 在 System.Data.SqlClient.TdsParserStateObject.TryReadByteArray(Byte[] buff, Int32 offset, Int32 len, Int32&amp; totalRead)<br /> 在 System.Data.SqlClient.TdsParserStateObject.TryReadString(Int32 length, String&amp; value)<br /> 在 System.Data.SqlClient.TdsParser.TryCommonProcessMetaData(TdsParserStateObject stateObj, _SqlMetaData col, Nullable`1 cipherTable, Boolean fColMD, SqlCommandColumnEncryptionSetting columnEncryptionSetting)<br /> 在 System.Data.SqlClient.TdsParser.TryProcessMetaData(Int32 cColumns, TdsParserStateObject stateObj, _SqlMetaDataSet&amp; metaData, SqlCommandColumnEncryptionSetting columnEncryptionSetting)<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.DAL.DBOperator.Query(String SQLString, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /> 在 RB.DALExtend.RB_Amazon_Product_BaseExtend.GetModelPagerList(RB_Amazon_Product_Base_PSParameters parameters, Int32&amp; recordCount, String FolderID, Int32 CustomerID, Int32 AdminID, List`1 PermissionAdminIds, Int32 currentAdminId, String childWhere)<br /> 在 PandaBuy.ERP.Web.IrobotBox.Amazon.AmazonListingList.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_amazon_amazonlistinglist_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 /><br />-------------------------------------------------------------<br /><br /> <br /></p>
005+ <p>CODE:N1005321<br />Error:11_-2_0_-2146232060<br />SQL: <br /> SELECT * FROM (<br /> SELECT<br /> ROW_NUMBER() OVER (ORDER BY case when ProductProperty=2 then 100 else ProductProperty end desc ) AS [PageIndex] ,* FROM ( select vtb.ID,<br /> vtb.ParentID,<br /> vtb.IsVariation,<br /> pa.RecommendValue,<br /> vtb.IsFirstLevelProduct,<br /> vtb.IsSaleProduct,<br /> vtb.isEmergencyStock,<br /> vtb.ExpectedArrivalDays,<br /> vtb.DeliveryDay,<br /> Isnull(BuyBoxNum1, 0) BuyBoxNum1,<br /> Isnull(BuyBoxNum2, 0) BuyBoxNum2,<br /> Isnull(AllBuyBoxNum1, 0) AllBuyBoxNum1,<br /> Isnull(BuyBoxNum3, 0) BuyBoxNum3,<br /> Isnull(AllBuyBoxNum2, 0) AllBuyBoxNum2,<br /> Isnull(AllBuyBoxNum3, 0) AllBuyBoxNum3,<br /> Isnull(OrdinaryBuyBoxNum1, 0) OrdinaryBuyBoxNum1,<br /> Isnull(OrdinaryAllBuyBoxNum1, 0) OrdinaryAllBuyBoxNum1,<br /> Isnull(OrdinaryBuyBoxNum2, 0) OrdinaryBuyBoxNum2,<br /> Isnull(OrdinaryAllBuyBoxNum2, 0) OrdinaryAllBuyBoxNum2,<br /> Isnull(OrdinaryBuyBoxNum3, 0) OrdinaryBuyBoxNum3,<br /> Isnull(OrdinaryAllBuyBoxNum3, 0) OrdinaryAllBuyBoxNum3,<br /> AUID,<br /> vtb.ImageUrl,<br /> vtb.ClientSKU,<br /> vtb.ProductName,<br /> vtb.ProductNameCN,<br /> PID,<br /> vtb.SalePrice,<br /> vtb.LastBuyPrice,<br /> vtb.LastSupplierPrice,<br /> vtb.GrossWeight,<br /> vtb.PackWeight,<br /> vtb.IsGroup,<br /> vtb.ProductProperty,<br /> o.OrderSourceCountry,<br /> o.OrderSourceName,<br /> cgzNum,<br /> ystzNum,<br /> ProductNum,<br /> ReadyLibraryNum,<br /> todaysaleNum,<br /> zsaleNum,<br /> qsaleNum,<br /> sqsaleNum,<br /> WeekSaleNum,<br /> TwoWeekSaleNum,<br /> vtb.APIID,<br /> DevIDSellerId,<br /> Cycle,<br /> vtb.SafetyDays,<br /> WPID,<br /> LastUPdateTime,<br /> vtb.AddCycle,<br /> vtb.HaulageTime,<br /> vtb.EstimatedSaleNum,<br /> vtb.BuyTime,<br /> IsBuyBox,<br /> RobBuyBox,<br /> Kl,<br /> vtb.AvgDailySales,<br /> ToBuyBoxProduct,<br /> IsTiming,<br /> vtb.WID,<br /> vtb.CustomerID,<br /> vtb.BasePrice,<br /> vtb.OrderSourceID,<br /> vtb.UpdateTime,<br /> vtb.FNSKU,<br /> vtb.LockNum,<br /> IsFBA,<br /> vtb.OrderSourceSKU,<br /> vtb.WareHouseName,<br /> ASINorItemID,<br /> SellerType,<br /> vtb.SKU,<br /> vtb.BusinessTeam,<br /> vtb.BusinessTeamName,<br /> vtb.OrderSourceSKUID,<br /> KykcNum,<br /> CnKyNum,<br /> CnWPID,<br /> vtb.WareHouseType,<br /> msaleNum,<br /> lastmsaleNum,<br /> zhanyong,<br /> vtb.IsActive,<br /> vtb.AddTime,<br /> daysNum,<br /> BuyBoxUpdateTime,<br /> SyncLastUpdateTime,<br /> isBeiKu,<br /> LastUpTiming,<br /> LastDownTiming,<br /> rankNum,<br /> rankZTNum,<br /> rankQTNum,<br /> rankSQNum,<br /> rankClassName,<br /> bhnum,<br /> IsOffShelf,<br /> ListingPrice,<br /> ListingSoldNum,<br /> StopProduct,<br /> StopAndNullStockProduct,<br /> BusinessAdminID,<br /> BusinessUserName,<br /> vtb.Currency,<br /> ExchangeRMB,<br /> FBASeller_Num,<br /> ThreeMonthSaleNum,<br /> RobBuyBoxType,<br /> Attention,<br /> Isnull(LowestPriceBuyBoxNum1, 0) LowestPriceBuyBoxNum1,<br /> Isnull(LowestPriceAllBuyBoxNum1, 0) LowestPriceAllBuyBoxNum1,<br /> Isnull(LowestPriceBuyBoxNum2, 0) LowestPriceBuyBoxNum2,<br /> Isnull(LowestPriceAllBuyBoxNum2, 0) LowestPriceAllBuyBoxNum2,<br /> Isnull(LowestPriceBuyBoxNum3, 0) LowestPriceBuyBoxNum3,<br /> Isnull(LowestPriceAllBuyBoxNum3, 0) LowestPriceAllBuyBoxNum3,<br /> ProductVitalityType,<br /> ProductNewType,<br /> UnsalableDayNum,<br /> AmazonShelvesNum,<br /> EbayShelvesNum,<br /> SMTShelvesNum,<br /> WishShelvesNum,<br /> OtherShelvesNum,<br /> TotalShelvesNum,<br /> vtb.FirstLegShippingType,<br /> IsRemind,<br /> (SELECT TOP 1 ID FROM RB_Listing_Sync_GoodNum sync (nolock) WHERE sync.IsActive = 1 AND sync.ListingType = 2 AND sync.ListingID = vtb.OrderSourceSKUID AND sync.CustomerID = vtb.CustomerID) IsSet,<br /> Isnull(vtb.BrandType, 0) BrandType,<br /> Isnull(scd.ID, 0) AS IsClear,<br /> scs.Name,<br /> scd.WarehouseNum,<br /> ( WarehouseNum - Inventory ) AS ClearInventory,<br /> vtb.IsAmazonListingReview,<br /> vtb.ReviewStar,<br /> vtb.ReviewNum,<br /> vtb.ReviewUnReadNum,<br /> vtb.LastReviewCollectionTime,<br /> vtb.LastSynReviewTime,<br /> vtb.BadReviewNum,<br /> vtb.ThreeDayReviewNum,<br /> vtb.SevenDayDayReviewNum,<br /> vtb.IsAmazonKeywordRank,<br /> vtb.FBA_Reserved_CustomerOrders,<br /> vtb.FBA_Reserved_Transfers,<br /> vtb.FBA_Reserved_Processing,<br /> YesterdaySessions,<br /> BeforeYesterdaySessions,<br /> HeretoforeSessions,<br /> Isnull(YesterdayUnitSessionPercentage, 0) AS YesterdayUnitSessionPercentage,<br /> Isnull(BeforeYesterdayUnitSessionPercentage, 0) AS BeforeYesterdayUnitSessionPercentage,<br /> Isnull(HeretoforeUnitSessionPercentage, 0) AS HeretoforeUnitSessionPercentage,<br /> vtb.TaxPoint,<br /> vtb.TaxRate,<br /> Isnull(vtb.IsFBABarCode, 0) IsFBABarCode,<br /> Isnull(vtb.IsRecommendOcean, 0) IsRecommendOcean,<br /> Isnull(w.WareHouseName, '') AS DefaultWareHouseName,<br /> Isnull(vtb.YesterdaySpend, 0) YesterdaySpend,<br /> Isnull(vtb.TotalSpend, 0) TotalSpend,<br /> Isnull(vtb.YesterdayAvgCPC, 0) YesterdayAvgCPC,<br /> Isnull(vtb.TotalAvgCPC, 0) TotalAvgCPC,<br /> Isnull(vtb.YesterdayClicks, 0) YesterdayClicks,<br /> Isnull(vtb.TotalClicks, 0) TotalClicks,<br /> Isnull(vtb.YesterdayImpressions, 0) YesterdayImpressions,<br /> Isnull(vtb.TotalImpressions, 0) TotalImpressions,<br /> Isnull(vtb.IsEFN, 0) AS IsEFN,<br /> vtb.EFNCountry,<br /> Isnull(vtb.IsCheckDeclarationCode, 0) IsCheckDeclarationCode,<br /> Isnull(vtb.IsCheckTransport, 0) IsCheckTransport,<br /> Isnull(vtb.IsSalesRank, 0) IsSalesRank,<br /> p.ProdutcArrivalDate,<br /> vtb.HolidaysID,<br /> wh.WareHouseName AS DefaultLocalWarehouse,<br /> swh.WareHouseName SupplierWareHouseName,<br /> vtb.AddAdminName,<br /> vtb.IsSetNoSupplyReason,<br /> vtb.IsEmergencyStockReminder,<br /> vtb.TranslateStatus,<br /> p.MinSaleNum,<br /> p.WithBattery,<br /> pa.IsAmazonSale,<br /> pa.NoSalePlatform,<br /> vtb.TemplateID,<br /> vtb.LableColor,<br /> vtb.LableName,<br /> p.PictureSource,<br /> pa.ImageTime,<br /> vtb.ProfitMargin,<br /> vtb.PublishTime,<br /> vtb.MonthAvgProfits,<br /> vtb.PlanID,<br /> vtb.PlanDetailId,<br /> vtb.PlanName,<br /> vtb.IsAgainPublish,<br /> vtb.IsAutoAdjustPrice,<br /> vtb.IsAutoLowerShelf,<br /> vtb.IsAutoPromotion,<br /> OnShelfMode,<br /> vtb.OrderSourceSkuOrderTime,<br /> vtb.AsinOrderTime,<br /> p.IsIntelligentStocking,<br /> ntf.Reason,<br /> vtb.WaitToFbaType , <br /> vtb.SevenDaySales,<br /> vtb.SevenDayAcos,<br /> vtb.DefaultWarehouseID,<br /> vtb.RecommendedOrderQuantity,<br /> vtb.DiscountStartTime,<br /> vtb.DiscountEndTime,<br /> vtb.DiscountSalesPrice,<br /> p.ImageUrl as ProductImageUrl,<br /> p.ProductName as ProductTitle,<br /> vtb.IsAdvertising,<br /> vtb.UnsellableQuatity,<br /> pa.NoSaleCountry,<br /> vtb.IsNARF,<br /> vtb.MaximumShipmentQuantity,<br /> vtb.RecommendFinalNum,<br /> vtb.MonitorStockFinalNum,<br /> vtb.IsJoinSmall,<br /> vtb.RecommendJoinSmall,<br /> vtb.NoJoinSmallReason from [RB_Amazon_Product_Base] (nolock) vtb LEFT JOIN RB_StockClearDetailed scd (nolock) ON(vtb.OrderSourceSKUID=scd.ListId AND vtb.CustomerID=scd.CustomerID AND (clearType=1 OR clearType=3))<br /> LEFT JOIN RB_StockClearStrategy scs (nolock) ON(scd.scsID=scs.ID AND scd.CustomerID=scs.CustomerID) <br /> LEFT JOIN (SELECT sum(GoodNum) AS Inventory,WareHouseID,SKU,CustomerID FROM RB_WareHouse_Product (nolock) GROUP BY WareHouseID,SKU,CustomerID) AS tbWHN ON(vtb.WID=tbWHN.WareHouseID AND vtb.SKU=tbWHN.SKU AND vtb.CustomerID=tbWHN.CustomerID)<br /> LEFT JOIN RB_WareHouse w (nolock) ON w.CustomerID=vtb.CustomerID and w.ID=vtb.DefaultWarehouseID <br /> LEFT JOIN RB_OrderSource o (nolock) on vtb.CustomerID=o.CustomerID and vtb.OrderSourceID = o.ID<br /> Left join RB_Product_Admin pa(nolock) on vtb.CustomerID=pa.CustomerID and vtb.SKU = pa.SKU<br /> left join RB_Product p (nolock) on p.CustomerID=vtb.CustomerID and vtb.SKU = p.SKU <br /> left join RB_WareHouse wh(nolock) on wh.CustomerID=p.CustomerID and wh.ID=p.DefaultLocalWarehouse<br /> left join RB_WareHouse swh(nolock) on swh.CustomerID=vtb.CustomerID and swh.ID=vtb.TheWareHouseID<br /> left join RB_Amazon_NotToFbaReason ntf (nolock) on vtb.CustomerID=ntf.CustomerID and vtb.NotToFbaReasonId=ntf.ID WHERE vtb.CustomerID=@CustomerID AND vtb.IsDelete=0 and isnull(IsOffShelf,0) in (1,4,5,2,0) and vtb.OrderSourceSKUID&gt;0 ) AS TempTable ) AS PagerTable WHERE PagerTable.[PageIndex] BETWEEN 1 AND 20 option(maxdop 8)<br />PARAMS:@CustomerID = 1 ,@UserID = 7172 ,@Count1 = ,@Count2 = ,<br />MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 <br />TRACE: 在 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)<br /> 在 System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()<br /> 在 System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()<br /> 在 System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()<br /> 在 System.Data.SqlClient.TdsParserStateObject.TryReadByteArray(Byte[] buff, Int32 offset, Int32 len, Int32&amp; totalRead)<br /> 在 System.Data.SqlClient.TdsParserStateObject.TryReadString(Int32 length, String&amp; value)<br /> 在 System.Data.SqlClient.TdsParser.TryCommonProcessMetaData(TdsParserStateObject stateObj, _SqlMetaData col, Nullable`1 cipherTable, Boolean fColMD, SqlCommandColumnEncryptionSetting columnEncryptionSetting)<br /> 在 System.Data.SqlClient.TdsParser.TryProcessMetaData(Int32 cColumns, TdsParserStateObject stateObj, _SqlMetaDataSet&amp; metaData, SqlCommandColumnEncryptionSetting columnEncryptionSetting)<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.DAL.DBOperator.Query(String SQLString, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /> 在 RB.DALExtend.RB_Amazon_Product_BaseExtend.GetModelPagerList(RB_Amazon_Product_Base_PSParameters parameters, Int32&amp; recordCount, String FolderID, Int32 CustomerID, Int32 AdminID, List`1 PermissionAdminIds, Int32 currentAdminId, String childWhere)<br /> 在 PandaBuy.ERP.Web.IrobotBox.Amazon.AmazonListingList.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_amazon_amazonlistinglist_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 /><br />-------------------------------------------------------------<br /><br /></p>

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

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

修改了 指派给，旧值为 "chenshaojun"，新值为 "huangjinlong"。
修改了 抄送给，旧值为 ""，新值为 ",pengkang"。

修改了 解决方案，旧值为 ""，新值为 "performance"。
修改了 解决日期，旧值为 ""，新值为 "2022-09-16 11:07:05"。
修改了 指派给 ，旧值为 "huangjinlong"，新值为 "xiayu"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "huangjinlong"。

修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "xiayu"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "xiayu"。
修改了 关闭日期，旧值为 ""，新值为 "2022-09-16 18:27:13"。