Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 4th, 2012  |  syntax: None  |  size: 26.28 KB  |  hits: 21  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Could not query database: System.AggregateException: One or more errors occurred. ---> NHibernate.Exceptions.GenericADOException: could not execute query
  2. [ select TOP (@p0) product0_.oid as oid19_, product0_.LastModified as LastModi2_19_, product0_.i_ClassType as i3_19_, product0_.CatalogName as CatalogN4_19_, product0_.PrimaryParentCategory as PrimaryP5_19_, product0_.Hide as Hide19_, product0_.Refurbished as Refurbis7_19_, product0_.DefinitionName as Definiti8_19_, product0_.SaleQtyLimit as SaleQtyL9_19_, product0_.ShippingWidth as Shippin10_19_, product0_.ShippingLength as Shippin11_19_, product0_.ShippingHeight as Shippin12_19_, product0_.ShippingWeight as Shippin13_19_, product0_.IPR_1Year as IPR14_19_, product0_.IPR_2Year as IPR15_19_, product0_.IPR_3Year as IPR16_19_, product0_.IPR_4Year as IPR17_19_, product0_.IPR_NO as IPR18_19_, product0_1_.DisplayName as DisplayN2_21_, product0_1_.Description as Descript3_21_, product0_.ProductID as ProductID19_, product0_.ShortDescription as ShortDe20_19_, product0_.keywords as keywords19_, product0_.ItemLookupCode as ItemLoo22_19_, product0_.ProductPartNo as Product23_19_, product0_.Manufacturer as Manufac24_19_, product0_.cy_list_price as cy25_19_, product0_.RegPrice as RegPrice19_, product0_.OriginalPrice as Origina27_19_, product0_.Cost as Cost19_, product0_.rmsDepartment as rmsDepa29_19_, product0_.rmsCategory as rmsCate30_19_, product0_.rmsName as rmsName19_, product0_.FlatShippingRate as FlatShi32_19_, product0_.SaleEndDate as SaleEnd33_19_, product0_.HotUntil as HotUntil19_, product0_.Warranty as Warranty19_, product0_.IntroductionDate as Introdu36_19_, product0_.CantAdvertise as CantAdv37_19_, product0_.DemandPerDay as DemandP38_19_, product0_.sp_3DCapable as sp53_19_, product0_.sp_AFPoints as sp54_19_, product0_.sp_Aperture as sp55_19_, product0_.sp_Architecture as sp56_19_, product0_.sp_BatteryLife as sp57_19_, product0_.sp_Brightness as sp58_19_, product0_.sp_CacheSize as sp59_19_, product0_.sp_CasLatency as sp60_19_, product0_.sp_Chipset as sp61_19_, product0_.sp_ClockSpeed as sp62_19_, product0_.sp_ContinuousShooting as sp63_19_, product0_.sp_ContrastRatio as sp64_19_, product0_.sp_CPUCores as sp65_19_, product0_.sp_CPUSockets as sp66_19_, product0_.sp_CPUThreads as sp67_19_, product0_.sp_DisplayTechnology as sp68_19_, product0_.sp_FocalLength as sp69_19_, product0_.sp_FormFactor as sp70_19_, product0_.sp_GPU as sp71_19_, product0_.sp_Graphics as sp72_19_, product0_.sp_HardDrive as sp73_19_, product0_.sp_Interface as sp74_19_, product0_.sp_LampLife as sp75_19_, product0_.sp_LANPorts as sp76_19_, product0_.sp_MaxPower as sp77_19_, product0_.sp_Memory as sp78_19_, product0_.sp_Modular as sp79_19_, product0_.sp_Network as sp80_19_, product0_.sp_OperatingSystem as sp81_19_, product0_.sp_OpticalDrive as sp82_19_, product0_.sp_OpticalZoom as sp83_19_, product0_.sp_PanelType as sp84_19_, product0_.sp_Processor as sp85_19_, product0_.sp_RAID as sp86_19_, product0_.sp_Resolution as sp87_19_, product0_.sp_ResponseTime as sp88_19_, product0_.sp_RPM as sp89_19_, product0_.sp_ScreenSize as sp90_19_, product0_.sp_SensorSize as sp91_19_, product0_.sp_Size as sp92_19_, product0_.sp_SocketType as sp93_19_, product0_.sp_Sound as sp94_19_, product0_.sp_Speed as sp95_19_, product0_.sp_Stabilization as sp96_19_, product0_.sp_StorageType as sp97_19_, product0_.sp_TouchScreen as sp98_19_, product0_.sp_Type as sp99_19_, product0_.sp_Unlocked as sp100_19_, product0_.sp_Video as sp101_19_, product0_.sp_Viewfinder as sp102_19_, product0_.sp_Voltage as sp103_19_, product0_.sp_VPN as sp104_19_, product0_.sp_WANPorts as sp105_19_, product0_.sp_Waterproof as sp106_19_, product0_.sp_Webcam as sp107_19_, product0_.sp_Wireless as sp108_19_, product0_.BrandCode as BrandCode19_, (SELECT p.SaleQtyLimit FROM Memx_productcatalog.dbo.[ME_CatalogProducts] p WHERE p.CategoryName = product0_.PrimaryParentCategory) as formula2_, (SELECT COUNT(*) FROM Memx_Custom.dbo.ProductReviews r WHERE r.ProductId = product0_.ProductId AND r.Approved = 1 AND r.Deleted = 0) as formula3_, (SELECT AVG(r.Rating) FROM Memx_Custom.dbo.ProductReviews r WHERE r.ProductId = product0_.ProductId AND r.Approved = 1 AND r.Deleted = 0) as formula4_, case when product0_.DefinitionName = 'Bundle' then 60 when product0_.DefinitionName = 'Promotion' then 61 else product0_.i_ClassType end as clazz_ from Memx_productcatalog.dbo.ME_CatalogProducts product0_ inner join Memx_productcatalog.dbo.[ME_en-US_Catalog] product0_1_ on product0_.oid=product0_1_.#Catalog_Lang_Oid where case when product0_.DefinitionName = 'Bundle' then 60 when product0_.DefinitionName = 'Promotion' then 61 else product0_.i_ClassType end in (4, 60, 61) ]
  3. [SQL: select TOP (@p0) product0_.oid as oid19_, product0_.LastModified as LastModi2_19_, product0_.i_ClassType as i3_19_, product0_.CatalogName as CatalogN4_19_, product0_.PrimaryParentCategory as PrimaryP5_19_, product0_.Hide as Hide19_, product0_.Refurbished as Refurbis7_19_, product0_.DefinitionName as Definiti8_19_, product0_.SaleQtyLimit as SaleQtyL9_19_, product0_.ShippingWidth as Shippin10_19_, product0_.ShippingLength as Shippin11_19_, product0_.ShippingHeight as Shippin12_19_, product0_.ShippingWeight as Shippin13_19_, product0_.IPR_1Year as IPR14_19_, product0_.IPR_2Year as IPR15_19_, product0_.IPR_3Year as IPR16_19_, product0_.IPR_4Year as IPR17_19_, product0_.IPR_NO as IPR18_19_, product0_1_.DisplayName as DisplayN2_21_, product0_1_.Description as Descript3_21_, product0_.ProductID as ProductID19_, product0_.ShortDescription as ShortDe20_19_, product0_.keywords as keywords19_, product0_.ItemLookupCode as ItemLoo22_19_, product0_.ProductPartNo as Product23_19_, product0_.Manufacturer as Manufac24_19_, product0_.cy_list_price as cy25_19_, product0_.RegPrice as RegPrice19_, product0_.OriginalPrice as Origina27_19_, product0_.Cost as Cost19_, product0_.rmsDepartment as rmsDepa29_19_, product0_.rmsCategory as rmsCate30_19_, product0_.rmsName as rmsName19_, product0_.FlatShippingRate as FlatShi32_19_, product0_.SaleEndDate as SaleEnd33_19_, product0_.HotUntil as HotUntil19_, product0_.Warranty as Warranty19_, product0_.IntroductionDate as Introdu36_19_, product0_.CantAdvertise as CantAdv37_19_, product0_.DemandPerDay as DemandP38_19_, product0_.sp_3DCapable as sp53_19_, product0_.sp_AFPoints as sp54_19_, product0_.sp_Aperture as sp55_19_, product0_.sp_Architecture as sp56_19_, product0_.sp_BatteryLife as sp57_19_, product0_.sp_Brightness as sp58_19_, product0_.sp_CacheSize as sp59_19_, product0_.sp_CasLatency as sp60_19_, product0_.sp_Chipset as sp61_19_, product0_.sp_ClockSpeed as sp62_19_, product0_.sp_ContinuousShooting as sp63_19_, product0_.sp_ContrastRatio as sp64_19_, product0_.sp_CPUCores as sp65_19_, product0_.sp_CPUSockets as sp66_19_, product0_.sp_CPUThreads as sp67_19_, product0_.sp_DisplayTechnology as sp68_19_, product0_.sp_FocalLength as sp69_19_, product0_.sp_FormFactor as sp70_19_, product0_.sp_GPU as sp71_19_, product0_.sp_Graphics as sp72_19_, product0_.sp_HardDrive as sp73_19_, product0_.sp_Interface as sp74_19_, product0_.sp_LampLife as sp75_19_, product0_.sp_LANPorts as sp76_19_, product0_.sp_MaxPower as sp77_19_, product0_.sp_Memory as sp78_19_, product0_.sp_Modular as sp79_19_, product0_.sp_Network as sp80_19_, product0_.sp_OperatingSystem as sp81_19_, product0_.sp_OpticalDrive as sp82_19_, product0_.sp_OpticalZoom as sp83_19_, product0_.sp_PanelType as sp84_19_, product0_.sp_Processor as sp85_19_, product0_.sp_RAID as sp86_19_, product0_.sp_Resolution as sp87_19_, product0_.sp_ResponseTime as sp88_19_, product0_.sp_RPM as sp89_19_, product0_.sp_ScreenSize as sp90_19_, product0_.sp_SensorSize as sp91_19_, product0_.sp_Size as sp92_19_, product0_.sp_SocketType as sp93_19_, product0_.sp_Sound as sp94_19_, product0_.sp_Speed as sp95_19_, product0_.sp_Stabilization as sp96_19_, product0_.sp_StorageType as sp97_19_, product0_.sp_TouchScreen as sp98_19_, product0_.sp_Type as sp99_19_, product0_.sp_Unlocked as sp100_19_, product0_.sp_Video as sp101_19_, product0_.sp_Viewfinder as sp102_19_, product0_.sp_Voltage as sp103_19_, product0_.sp_VPN as sp104_19_, product0_.sp_WANPorts as sp105_19_, product0_.sp_Waterproof as sp106_19_, product0_.sp_Webcam as sp107_19_, product0_.sp_Wireless as sp108_19_, product0_.BrandCode as BrandCode19_, (SELECT p.SaleQtyLimit FROM Memx_productcatalog.dbo.[ME_CatalogProducts] p WHERE p.CategoryName = product0_.PrimaryParentCategory) as formula2_, (SELECT COUNT(*) FROM Memx_Custom.dbo.ProductReviews r WHERE r.ProductId = product0_.ProductId AND r.Approved = 1 AND r.Deleted = 0) as formula3_, (SELECT AVG(r.Rating) FROM Memx_Custom.dbo.ProductReviews r WHERE r.ProductId = product0_.ProductId AND r.Approved = 1 AND r.Deleted = 0) as formula4_, case when product0_.DefinitionName = 'Bundle' then 60 when product0_.DefinitionName = 'Promotion' then 61 else product0_.i_ClassType end as clazz_ from Memx_productcatalog.dbo.ME_CatalogProducts product0_ inner join Memx_productcatalog.dbo.[ME_en-US_Catalog] product0_1_ on product0_.oid=product0_1_.#Catalog_Lang_Oid where case when product0_.DefinitionName = 'Bundle' then 60 when product0_.DefinitionName = 'Promotion' then 61 else product0_.i_ClassType end in (4, 60, 61)] ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
  4.    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
  5.    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
  6.    at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
  7.    at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
  8.    at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
  9.    at System.Data.SqlClient.TdsParserStateObject.ReadByte()
  10.    at System.Data.SqlClient.TdsParser.CommonProcessMetaData(TdsParserStateObject stateObj, _SqlMetaData col)
  11.    at System.Data.SqlClient.TdsParser.ProcessMetaData(Int32 cColumns, TdsParserStateObject stateObj)
  12.    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  13.    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
  14.    at System.Data.SqlClient.SqlDataReader.get_MetaData()
  15.    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
  16.    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
  17.    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
  18.    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
  19.    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
  20.    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
  21.    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
  22.    at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
  23.    at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
  24.    at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
  25.    at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
  26.    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
  27.    --- End of inner exception stack trace ---
  28.    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
  29.    at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
  30.    at NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.List(ISessionImplementor session, QueryParameters queryParameters)
  31.    at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor session, QueryParameters queryParameters)
  32.    at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters queryParameters, ISessionImplementor session, IList results)
  33.    at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, QueryParameters queryParameters, IList results)
  34.    at NHibernate.Impl.AbstractSessionImpl.List(IQueryExpression queryExpression, QueryParameters parameters)
  35.    at NHibernate.Impl.ExpressionQueryImpl.List()
  36.    at NHibernate.Linq.NhQueryProvider.ExecuteQuery(NhLinqExpression nhLinqExpression, IQuery query, NhLinqExpression nhQuery)
  37.    at NHibernate.Linq.NhQueryProvider.Execute[TResult](Expression expression)
  38.    at Remotion.Data.Linq.QueryableBase`1.GetEnumerator()
  39.    at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
  40.    at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
  41.    at MemX.UI.Modules.Web.Catalog.Browse.ViewModels.CatalogItemGridViewModel.<>c__DisplayClassa.<Search>b__6()
  42.    at System.Threading.Tasks.Task`1.InvokeFuture(Object futureAsObj)
  43.    at System.Threading.Tasks.Task.Execute()
  44.    --- End of inner exception stack trace ---
  45. ---> (Inner Exception #0) NHibernate.Exceptions.GenericADOException: could not execute query
  46. [ select TOP (@p0) product0_.oid as oid19_, product0_.LastModified as LastModi2_19_, product0_.i_ClassType as i3_19_, product0_.CatalogName as CatalogN4_19_, product0_.PrimaryParentCategory as PrimaryP5_19_, product0_.Hide as Hide19_, product0_.Refurbished as Refurbis7_19_, product0_.DefinitionName as Definiti8_19_, product0_.SaleQtyLimit as SaleQtyL9_19_, product0_.ShippingWidth as Shippin10_19_, product0_.ShippingLength as Shippin11_19_, product0_.ShippingHeight as Shippin12_19_, product0_.ShippingWeight as Shippin13_19_, product0_.IPR_1Year as IPR14_19_, product0_.IPR_2Year as IPR15_19_, product0_.IPR_3Year as IPR16_19_, product0_.IPR_4Year as IPR17_19_, product0_.IPR_NO as IPR18_19_, product0_1_.DisplayName as DisplayN2_21_, product0_1_.Description as Descript3_21_, product0_.ProductID as ProductID19_, product0_.ShortDescription as ShortDe20_19_, product0_.keywords as keywords19_, product0_.ItemLookupCode as ItemLoo22_19_, product0_.ProductPartNo as Product23_19_, product0_.Manufacturer as Manufac24_19_, product0_.cy_list_price as cy25_19_, product0_.RegPrice as RegPrice19_, product0_.OriginalPrice as Origina27_19_, product0_.Cost as Cost19_, product0_.rmsDepartment as rmsDepa29_19_, product0_.rmsCategory as rmsCate30_19_, product0_.rmsName as rmsName19_, product0_.FlatShippingRate as FlatShi32_19_, product0_.SaleEndDate as SaleEnd33_19_, product0_.HotUntil as HotUntil19_, product0_.Warranty as Warranty19_, product0_.IntroductionDate as Introdu36_19_, product0_.CantAdvertise as CantAdv37_19_, product0_.DemandPerDay as DemandP38_19_, product0_.sp_3DCapable as sp53_19_, product0_.sp_AFPoints as sp54_19_, product0_.sp_Aperture as sp55_19_, product0_.sp_Architecture as sp56_19_, product0_.sp_BatteryLife as sp57_19_, product0_.sp_Brightness as sp58_19_, product0_.sp_CacheSize as sp59_19_, product0_.sp_CasLatency as sp60_19_, product0_.sp_Chipset as sp61_19_, product0_.sp_ClockSpeed as sp62_19_, product0_.sp_ContinuousShooting as sp63_19_, product0_.sp_ContrastRatio as sp64_19_, product0_.sp_CPUCores as sp65_19_, product0_.sp_CPUSockets as sp66_19_, product0_.sp_CPUThreads as sp67_19_, product0_.sp_DisplayTechnology as sp68_19_, product0_.sp_FocalLength as sp69_19_, product0_.sp_FormFactor as sp70_19_, product0_.sp_GPU as sp71_19_, product0_.sp_Graphics as sp72_19_, product0_.sp_HardDrive as sp73_19_, product0_.sp_Interface as sp74_19_, product0_.sp_LampLife as sp75_19_, product0_.sp_LANPorts as sp76_19_, product0_.sp_MaxPower as sp77_19_, product0_.sp_Memory as sp78_19_, product0_.sp_Modular as sp79_19_, product0_.sp_Network as sp80_19_, product0_.sp_OperatingSystem as sp81_19_, product0_.sp_OpticalDrive as sp82_19_, product0_.sp_OpticalZoom as sp83_19_, product0_.sp_PanelType as sp84_19_, product0_.sp_Processor as sp85_19_, product0_.sp_RAID as sp86_19_, product0_.sp_Resolution as sp87_19_, product0_.sp_ResponseTime as sp88_19_, product0_.sp_RPM as sp89_19_, product0_.sp_ScreenSize as sp90_19_, product0_.sp_SensorSize as sp91_19_, product0_.sp_Size as sp92_19_, product0_.sp_SocketType as sp93_19_, product0_.sp_Sound as sp94_19_, product0_.sp_Speed as sp95_19_, product0_.sp_Stabilization as sp96_19_, product0_.sp_StorageType as sp97_19_, product0_.sp_TouchScreen as sp98_19_, product0_.sp_Type as sp99_19_, product0_.sp_Unlocked as sp100_19_, product0_.sp_Video as sp101_19_, product0_.sp_Viewfinder as sp102_19_, product0_.sp_Voltage as sp103_19_, product0_.sp_VPN as sp104_19_, product0_.sp_WANPorts as sp105_19_, product0_.sp_Waterproof as sp106_19_, product0_.sp_Webcam as sp107_19_, product0_.sp_Wireless as sp108_19_, product0_.BrandCode as BrandCode19_, (SELECT p.SaleQtyLimit FROM Memx_productcatalog.dbo.[ME_CatalogProducts] p WHERE p.CategoryName = product0_.PrimaryParentCategory) as formula2_, (SELECT COUNT(*) FROM Memx_Custom.dbo.ProductReviews r WHERE r.ProductId = product0_.ProductId AND r.Approved = 1 AND r.Deleted = 0) as formula3_, (SELECT AVG(r.Rating) FROM Memx_Custom.dbo.ProductReviews r WHERE r.ProductId = product0_.ProductId AND r.Approved = 1 AND r.Deleted = 0) as formula4_, case when product0_.DefinitionName = 'Bundle' then 60 when product0_.DefinitionName = 'Promotion' then 61 else product0_.i_ClassType end as clazz_ from Memx_productcatalog.dbo.ME_CatalogProducts product0_ inner join Memx_productcatalog.dbo.[ME_en-US_Catalog] product0_1_ on product0_.oid=product0_1_.#Catalog_Lang_Oid where case when product0_.DefinitionName = 'Bundle' then 60 when product0_.DefinitionName = 'Promotion' then 61 else product0_.i_ClassType end in (4, 60, 61) ]
  47. [SQL: select TOP (@p0) product0_.oid as oid19_, product0_.LastModified as LastModi2_19_, product0_.i_ClassType as i3_19_, product0_.CatalogName as CatalogN4_19_, product0_.PrimaryParentCategory as PrimaryP5_19_, product0_.Hide as Hide19_, product0_.Refurbished as Refurbis7_19_, product0_.DefinitionName as Definiti8_19_, product0_.SaleQtyLimit as SaleQtyL9_19_, product0_.ShippingWidth as Shippin10_19_, product0_.ShippingLength as Shippin11_19_, product0_.ShippingHeight as Shippin12_19_, product0_.ShippingWeight as Shippin13_19_, product0_.IPR_1Year as IPR14_19_, product0_.IPR_2Year as IPR15_19_, product0_.IPR_3Year as IPR16_19_, product0_.IPR_4Year as IPR17_19_, product0_.IPR_NO as IPR18_19_, product0_1_.DisplayName as DisplayN2_21_, product0_1_.Description as Descript3_21_, product0_.ProductID as ProductID19_, product0_.ShortDescription as ShortDe20_19_, product0_.keywords as keywords19_, product0_.ItemLookupCode as ItemLoo22_19_, product0_.ProductPartNo as Product23_19_, product0_.Manufacturer as Manufac24_19_, product0_.cy_list_price as cy25_19_, product0_.RegPrice as RegPrice19_, product0_.OriginalPrice as Origina27_19_, product0_.Cost as Cost19_, product0_.rmsDepartment as rmsDepa29_19_, product0_.rmsCategory as rmsCate30_19_, product0_.rmsName as rmsName19_, product0_.FlatShippingRate as FlatShi32_19_, product0_.SaleEndDate as SaleEnd33_19_, product0_.HotUntil as HotUntil19_, product0_.Warranty as Warranty19_, product0_.IntroductionDate as Introdu36_19_, product0_.CantAdvertise as CantAdv37_19_, product0_.DemandPerDay as DemandP38_19_, product0_.sp_3DCapable as sp53_19_, product0_.sp_AFPoints as sp54_19_, product0_.sp_Aperture as sp55_19_, product0_.sp_Architecture as sp56_19_, product0_.sp_BatteryLife as sp57_19_, product0_.sp_Brightness as sp58_19_, product0_.sp_CacheSize as sp59_19_, product0_.sp_CasLatency as sp60_19_, product0_.sp_Chipset as sp61_19_, product0_.sp_ClockSpeed as sp62_19_, product0_.sp_ContinuousShooting as sp63_19_, product0_.sp_ContrastRatio as sp64_19_, product0_.sp_CPUCores as sp65_19_, product0_.sp_CPUSockets as sp66_19_, product0_.sp_CPUThreads as sp67_19_, product0_.sp_DisplayTechnology as sp68_19_, product0_.sp_FocalLength as sp69_19_, product0_.sp_FormFactor as sp70_19_, product0_.sp_GPU as sp71_19_, product0_.sp_Graphics as sp72_19_, product0_.sp_HardDrive as sp73_19_, product0_.sp_Interface as sp74_19_, product0_.sp_LampLife as sp75_19_, product0_.sp_LANPorts as sp76_19_, product0_.sp_MaxPower as sp77_19_, product0_.sp_Memory as sp78_19_, product0_.sp_Modular as sp79_19_, product0_.sp_Network as sp80_19_, product0_.sp_OperatingSystem as sp81_19_, product0_.sp_OpticalDrive as sp82_19_, product0_.sp_OpticalZoom as sp83_19_, product0_.sp_PanelType as sp84_19_, product0_.sp_Processor as sp85_19_, product0_.sp_RAID as sp86_19_, product0_.sp_Resolution as sp87_19_, product0_.sp_ResponseTime as sp88_19_, product0_.sp_RPM as sp89_19_, product0_.sp_ScreenSize as sp90_19_, product0_.sp_SensorSize as sp91_19_, product0_.sp_Size as sp92_19_, product0_.sp_SocketType as sp93_19_, product0_.sp_Sound as sp94_19_, product0_.sp_Speed as sp95_19_, product0_.sp_Stabilization as sp96_19_, product0_.sp_StorageType as sp97_19_, product0_.sp_TouchScreen as sp98_19_, product0_.sp_Type as sp99_19_, product0_.sp_Unlocked as sp100_19_, product0_.sp_Video as sp101_19_, product0_.sp_Viewfinder as sp102_19_, product0_.sp_Voltage as sp103_19_, product0_.sp_VPN as sp104_19_, product0_.sp_WANPorts as sp105_19_, product0_.sp_Waterproof as sp106_19_, product0_.sp_Webcam as sp107_19_, product0_.sp_Wireless as sp108_19_, product0_.BrandCode as BrandCode19_, (SELECT p.SaleQtyLimit FROM Memx_productcatalog.dbo.[ME_CatalogProducts] p WHERE p.CategoryName = product0_.PrimaryParentCategory) as formula2_, (SELECT COUNT(*) FROM Memx_Custom.dbo.ProductReviews r WHERE r.ProductId = product0_.ProductId AND r.Approved = 1 AND r.Deleted = 0) as formula3_, (SELECT AVG(r.Rating) FROM Memx_Custom.dbo.ProductReviews r WHERE r.ProductId = product0_.ProductId AND r.Approved = 1 AND r.Deleted = 0) as formula4_, case when product0_.DefinitionName = 'Bundle' then 60 when product0_.DefinitionName = 'Promotion' then 61 else product0_.i_ClassType end as clazz_ from Memx_productcatalog.dbo.ME_CatalogProducts product0_ inner join Memx_productcatalog.dbo.[ME_en-US_Catalog] product0_1_ on product0_.oid=product0_1_.#Catalog_Lang_Oid where case when product0_.DefinitionName = 'Bundle' then 60 when product0_.DefinitionName = 'Promotion' then 61 else product0_.i_ClassType end in (4, 60, 61)] ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
  48.    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
  49.    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
  50.    at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
  51.    at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
  52.    at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
  53.    at System.Data.SqlClient.TdsParserStateObject.ReadByte()
  54.    at System.Data.SqlClient.TdsParser.CommonProcessMetaData(TdsParserStateObject stateObj, _SqlMetaData col)
  55.    at System.Data.SqlClient.TdsParser.ProcessMetaData(Int32 cColumns, TdsParserStateObject stateObj)
  56.    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  57.    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
  58.    at System.Data.SqlClient.SqlDataReader.get_MetaData()
  59.    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
  60.    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
  61.    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
  62.    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
  63.    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
  64.    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
  65.    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
  66.    at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
  67.    at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
  68.    at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
  69.    at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
  70.    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
  71.    --- End of inner exception stack trace ---
  72.    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
  73.    at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
  74.    at NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.List(ISessionImplementor session, QueryParameters queryParameters)
  75.    at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor session, QueryParameters queryParameters)
  76.    at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters queryParameters, ISessionImplementor session, IList results)
  77.    at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, QueryParameters queryParameters, IList results)
  78.    at NHibernate.Impl.AbstractSessionImpl.List(IQueryExpression queryExpression, QueryParameters parameters)
  79.    at NHibernate.Impl.ExpressionQueryImpl.List()
  80.    at NHibernate.Linq.NhQueryProvider.ExecuteQuery(NhLinqExpression nhLinqExpression, IQuery query, NhLinqExpression nhQuery)
  81.    at NHibernate.Linq.NhQueryProvider.Execute[TResult](Expression expression)
  82.    at Remotion.Data.Linq.QueryableBase`1.GetEnumerator()
  83.    at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
  84.    at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
  85.    at MemX.UI.Modules.Web.Catalog.Browse.ViewModels.CatalogItemGridViewModel.<>c__DisplayClassa.<Search>b__6()
  86.    at System.Threading.Tasks.Task`1.InvokeFuture(Object futureAsObj)
  87.    at System.Threading.Tasks.Task.Execute()<---
create a new version of this paste RAW Paste Data