Jay - Thank you for your input. I was able to delete direct from the dbo.ErrorMessages table with no issues. I left the last 5 rows, for a test and was also able to access them through the Admin and had no issues with timing out and deleting them there. So, no answer's to that. However, the problems I'm seeing is with SQL 2016 and NHibernate. This database was moved direct from a SQL 2008R2 to SQL 2016. I followed the Ablecommerce procedures for moving a database to new server: created new database [same name] and imported it to SQL 2016. Change tables from 100 to 130, and then created a new connection string. I've had problems ever since with exceptions being thrown. I'm no SQL guru but I do realize 2016 has more security protocols then it predecessor 2008R2. After cleaning up this last issue there is another acceptation error that popped up. Here is a snippet of the error
Code: Select all
Date: 6/3/2019 4:27:16 PM
Severity: Error
Message: An error has occured at https://xxxxxxxxxxxxxxx
Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown.
Stack Trace: at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Inner Exception: Failed to execute multi criteria[SQL: SELECT this_.ProductId as ProductId302_3_, this_.RowVersion as RowVersion302_3_, this_.StoreId as StoreId302_3_, this_.Name as Name302_3_, this_.Price as Price302_3_, this_.CostOfGoods as CostOfGo6_302_3_, this_.MSRP as MSRP302_3_, this_.Weight as Weight302_3_, this_.Length as Length302_3_, this_.Width as Width302_3_, this_.Height as Height302_3_, this_.ManufacturerId as Manufac12_302_3_, this_.Sku as Sku302_3_, this_.ModelNumber as ModelNu14_302_3_, this_.WebpageId as WebpageId302_3_, this_.TaxCodeId as TaxCodeId302_3_, this_.ShippableId as Shippab17_302_3_, this_.WarehouseId as Warehou18_302_3_, this_.InventoryModeId as Invento19_302_3_, this_.InStock as InStock302_3_, this_.AvailabilityDate as Availab21_302_3_, this_.InStockWarningLevel as InStock22_302_3_, this_.ThumbnailUrl as Thumbna23_302_3_, this_.ThumbnailAltText as Thumbna24_302_3_, this_.ImageUrl as ImageUrl302_3_, this_.ImageAltText as ImageAl26_302_3_, this_.Summary as Summary302_3_, this_.Description as Descrip28_302_3_, this_.ExtendedDescription as Extende29_302_3_, this_.VendorId as VendorId302_3_, this_.CreatedDate as Created31_302_3_, this_.LastModifiedDate as LastMod32_302_3_, this_.IsFeatured as IsFeatured302_3_, this_.IsProhibited as IsProhi34_302_3_, this_.AllowReviews as AllowRe35_302_3_, this_.AllowBackorder as AllowBa36_302_3_, this_.WrapGroupId as WrapGro37_302_3_, this_.ExcludeFromFeed as Exclude38_302_3_, this_.DisablePurchase as Disable39_302_3_, this_.MinQuantity as MinQuan40_302_3_, this_.MaxQuantity as MaxQuan41_302_3_, this_.VisibilityId as Visibil42_302_3_, this_.IconUrl as IconUrl302_3_, this_.IconAltText as IconAlt44_302_3_, this_.IsGiftCertificate as IsGiftC45_302_3_, this_.UseVariablePrice as UseVari46_302_3_, this_.MinimumPrice as Minimum47_302_3_, this_.MaximumPrice as Maximum48_302_3_, this_.HidePrice as HidePrice302_3_, this_.HandlingCharges as Handlin50_302_3_, this_.EnableGroups as EnableG51_302_3_, this_.Title as Title302_3_, this_.MetaDescription as MetaDes53_302_3_, this_.MetaKeywords as MetaKey54_302_3_, this_.SearchKeywords as SearchK55_302_3_, this_.HtmlHead as HtmlHead302_3_, this_.GTIN as GTIN302_3_, this_.GoogleCategory as GoogleC58_302_3_, this_.Condition as Condition302_3_, this_.Gender as Gender302_3_, this_.AgeGroup as AgeGroup302_3_, this_.Color as Color302_3_, this_.Size as Size302_3_, this_.AdwordsGrouping as Adwords64_302_3_, this_.AdwordsLabels as Adwords65_302_3_, this_.ExcludedDestination as Exclude66_302_3_, this_.AdwordsRedirect as Adwords67_302_3_, this_.PublishFeedAsVariants as Publish68_302_3_, this_.TIC as TIC302_3_, this_.OrderBy as OrderBy302_3_, this_.EnableRestockNotifications as EnableR71_302_3_, kit2_.ProductId as ProductId296_0_, kit2_.ItemizeDisplay as ItemizeD2_296_0_, specials3_.ProductId as ProductId5_, specials3_.SpecialId as SpecialId5_, specials3_.SpecialId as SpecialId315_1_, specials3_.ProductId as ProductId315_1_, specials3_.Price as Price315_1_, specials3_.StartDate as StartDate315_1_, specials3_.EndDate as EndDate315_1_, subscripti4_.ProductId as ProductId317_2_, subscripti4_.Name as Name317_2_, subscripti4_.IsOptional as IsOptional317_2_, subscripti4_.Description as Descript4_317_2_, subscripti4_.OneTimeCharge as OneTimeC5_317_2_, subscripti4_.OneTimeChargeModeId as OneTimeC6_317_2_, subscripti4_.OneTimeChargeTaxCodeId as OneTimeC7_317_2_, subscripti4_.OptionalPaymentFrequencies as Optional8_317_2_, subscripti4_.PaymentFrequencyTypeId as PaymentF9_317_2_, subscripti4_.NumberOfPayments as NumberO10_317_2_, subscripti4_.PaymentFrequency as Payment11_317_2_, subscripti4_.PaymentFrequencyUnitId as Payment12_317_2_, subscripti4_.RecurringCharge as Recurri13_317_2_, subscripti4_.RecurringChargeModeId as Recurri14_317_2_, subscripti4_.RepeatDiscounts as RepeatD15_317_2_, subscripti4_.RecurringChargeSpecified as Recurri16_317_2_, subscripti4_.GroupId as GroupId317_2_, subscripti4_.TaxCodeId as TaxCodeId317_2_ FROM ac_Products this_ left outer join ac_Kits kit2_ on this_.ProductId=kit2_.ProductId left outer join ac_Specials specials3_ on this_.ProductId=specials3_.ProductId left outer join ac_SubscriptionPlans subscripti4_ on this_.ProductId=subscripti4_.ProductId WHERE this_.ProductId in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
SELECT this_.ProductId as ProductId302_3_, this_.RowVersion as RowVersion302_3_, this_.StoreId as StoreId302_3_, this_.Name as Name302_3_, this_.Price as Price302_3_, this_.CostOfGoods as CostOfGo6_302_3_, this_.MSRP as MSRP302_3_, this_.Weight as Weight302_3_, this_.Length as Length302_3_, this_.Width as Width302_3_, this_.Height as Height302_3_, this_.ManufacturerId as Manufac12_302_3_, this_.Sku as Sku302_3_, this_.ModelNumber as ModelNu14_302_3_, this_.WebpageId as WebpageId302_3_, this_.TaxCodeId as TaxCodeId302_3_, this_.ShippableId as Shippab17_302_3_, this_.WarehouseId as Warehou18_302_3_, this_.InventoryModeId as Invento19_302_3_, this_.InStock as InStock302_3_, this_.AvailabilityDate as Availab21_302_3_, this_.InStockWarningLevel as InStock22_302_3_, this_.ThumbnailUrl as Thumbna23_302_3_, this_.ThumbnailAltText as Thumbna24_302_3_, this_.ImageUrl as ImageUrl302_3_, this_.ImageAltText as ImageAl26_302_3_, this_.Summary as Summary302_3_, this_.Description as Descrip28_302_3_, this_.ExtendedDescription as Extende29_302_3_, this_.VendorId as VendorId302_3_, this_.CreatedDate as Created31_302_3_, this_.LastModifiedDate as LastMod32_302_3_, this_.IsFeatured as IsFeatured302_3_, this_.IsProhibited as IsProhi34_302_3_, this_.AllowReviews as AllowRe35_302_3_, this_.AllowBackorder as AllowBa36_302_3_, this_.WrapGroupId as WrapGro37_302_3_, this_.ExcludeFromFeed as Exclude38_302_3_, this_.DisablePurchase as Disable39_302_3_, this_.MinQuantity as MinQuan40_302_3_, this_.MaxQuantity as MaxQuan41_302_3_, this_.VisibilityId as Visibil42_302_3_, this_.IconUrl as IconUrl302_3_, this_.IconAltText as IconAlt44_302_3_, this_.IsGiftCertificate as IsGiftC45_302_3_, this_.UseVariablePrice as UseVari46_302_3_, this_.MinimumPrice as Minimum47_302_3_, this_.MaximumPrice as Maximum48_302_3_, this_.HidePrice as HidePrice302_3_, this_.HandlingCharges as Handlin50_302_3_, this_.EnableGroups as EnableG51_302_3_, this_.Title as Title302_3_, this_.MetaDescription as MetaDes53_302_3_, this_.MetaKeywords as MetaKey54_302_3_, this_.SearchKeywords as SearchK55_302_3_, this_.HtmlHead as HtmlHead302_3_, this_.GTIN as GTIN302_3_, this_.GoogleCategory as GoogleC58_302_3_, this_.Condition as Condition302_3_, this_.Gender as Gender302_3_, this_.AgeGroup as AgeGroup302_3_, this_.Color as Color302_3_, this_.Size as Size302_3_, this_.AdwordsGrouping as Adwords64_302_3_, this_.AdwordsLabels as Adwords65_302_3_, this_.ExcludedDestination as Exclude66_302_3_, this_.AdwordsRedirect as Adwords67_302_3_, this_.PublishFeedAsVariants as Publish68_302_3_, this_.TIC as TIC302_3_, this_.OrderBy as OrderBy302_3_, this_.EnableRestockNotifications as EnableR71_302_3_, kit2_.ProductId as ProductId296_0_, kit2_.ItemizeDisplay as ItemizeD2_296_0_, productopt3_.ProductId as ProductId5_, productopt3_.ProductOptionId as ProductO1_5_, productopt3_.ProductOptionId as ProductO1_308_1_, productopt3_.ProductId as ProductId308_1_, productopt3_.OptionId as OptionId308_1_, productopt3_.OrderBy as OrderBy308_1_, subscripti4_.ProductId as ProductId317_2_, subscripti4_.Name as Name317_2_, subscripti4_.IsOptional as IsOptional317_2_, subscripti4_.Description as Descript4_317_2_, subscripti4_.OneTimeCharge as OneTimeC5_317_2_, subscripti4_.OneTimeChargeModeId as OneTimeC6_317_2_, subscripti4_.OneTimeChargeTaxCodeId as OneTimeC7_317_2_, subscripti4_.OptionalPaymentFrequencies as Optional8_317_2_, subscripti4_.PaymentFrequencyTypeId as PaymentF9_317_2_, subscripti4_.NumberOfPayments as NumberO10_317_2_, subscripti4_.PaymentFrequency as Payment11_317_2_, subscripti4_.PaymentFrequencyUnitId as Payment12_317_2_, subscripti4_.RecurringCharge as Recurri13_317_2_, subscripti4_.RecurringChargeModeId as Recurri14_317_2_, subscripti4_.RepeatDiscounts as RepeatD15_317_2_, subscripti4_.RecurringChargeSpecified as Recurri16_317_2_, subscripti4_.GroupId as GroupId317_2_, subscripti4_.TaxCodeId as TaxCodeId317_2_ FROM ac_Products this_ left outer join ac_Kits kit2_ on this_.ProductId=kit2_.ProductId left outer join ac_ProductOptions productopt3_ on this_.ProductId=productopt3_.ProductId left outer join ac_SubscriptionPlans subscripti4_ on this_.ProductId=subscripti4_.ProductId WHERE this_.ProductId in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY productopt3_.OrderBy asc;
SELECT this_.ProductId as ProductId302_3_, this_.RowVersion as RowVersion302_3_, this_.StoreId as StoreId302_3_, this_.Name as Name302_3_, this_.Price as Price302_3_, this_.CostOfGoods as CostOfGo6_302_3_, this_.MSRP as MSRP302_3_, this_.Weight as Weight302_3_, this_.Length as Length302_3_, this_.Width as Width302_3_, this_.Height as Height302_3_, this_.ManufacturerId as Manufac12_302_3_, this_.Sku as Sku302_3_, this_.ModelNumber as ModelNu14_302_3_, this_.WebpageId as WebpageId302_3_, this_.TaxCodeId as TaxCodeId302_3_, this_.ShippableId as Shippab17_302_3_, this_.WarehouseId as Warehou18_302_3_, this_.InventoryModeId as Invento19_302_3_, this_.InStock as InStock302_3_, this_.AvailabilityDate as Availab21_302_3_, this_.InStockWarningLevel as InStock22_302_3_, this_.ThumbnailUrl as Thumbna23_302_3_, this_.ThumbnailAltText as Thumbna24_302_3_, this_.ImageUrl as ImageUrl302_3_, this_.ImageAltText as ImageAl26_302_3_, this_.Summary as Summary302_3_, this_.Description as Descrip28_302_3_, this_.ExtendedDescription as Extende29_302_3_, this_.VendorId as VendorId302_3_, this_.CreatedDate as Created31_302_3_, this_.LastModifiedDate as LastMod32_302_3_, this_.IsFeatured as IsFeatured302_3_, this_.IsProhibited as IsProhi34_302_3_, this_.AllowReviews as AllowRe35_302_3_, this_.AllowBackorder as AllowBa36_302_3_, this_.WrapGroupId as WrapGro37_302_3_, this_.ExcludeFromFeed as Exclude38_302_3_, this_.DisablePurchase as Disable39_302_3_, this_.MinQuantity as MinQuan40_302_3_, this_.MaxQuantity as MaxQuan41_302_3_, this_.VisibilityId as Visibil42_302_3_, this_.IconUrl as IconUrl302_3_, this_.IconAltText as IconAlt44_302_3_, this_.IsGiftCertificate as IsGiftC45_302_3_, this_.UseVariablePrice as UseVari46_302_3_, this_.MinimumPrice as Minimum47_302_3_, this_.MaximumPrice as Maximum48_302_3_, this_.HidePrice as HidePrice302_3_, this_.HandlingCharges as Handlin50_302_3_, this_.EnableGroups as EnableG51_302_3_, this_.Title as Title302_3_, this_.MetaDescription as MetaDes53_302_3_, this_.MetaKeywords as MetaKey54_302_3_, this_.SearchKeywords as SearchK55_302_3_, this_.HtmlHead as HtmlHead302_3_, this_.GTIN as GTIN302_3_, this_.GoogleCategory as GoogleC58_302_3_, this_.Condition as Condition302_3_, this_.Gender as Gender302_3_, this_.AgeGroup as AgeGroup302_3_, this_.Color as Color302_3_, this_.Size as Size302_3_, this_.AdwordsGrouping as Adwords64_302_3_, this_.AdwordsLabels as Adwords65_302_3_, this_.ExcludedDestination as Exclude66_302_3_, this_.AdwordsRedirect as Adwords67_302_3_, this_.PublishFeedAsVariants as Publish68_302_3_, this_.TIC as TIC302_3_, this_.OrderBy as OrderBy302_3_, this_.EnableRestockNotifications as EnableR71_302_3_, kit2_.ProductId as ProductId296_0_, kit2_.ItemizeDisplay as ItemizeD2_296_0_, productkit3_.ProductId as ProductId5_, productkit3_.ProductKitComponentId as ProductK1_5_, productkit3_.ProductKitComponentId as ProductK1_307_1_, productkit3_.ProductId as ProductId307_1_, productkit3_.KitComponentId as KitCompo3_307_1_, productkit3_.OrderBy as OrderBy307_1_, subscripti4_.ProductId as ProductId317_2_, subscripti4_.Name as Name317_2_, subscripti4_.IsOptional as IsOptional317_2_, subscripti4_.Description as Descript4_317_2_, subscripti4_.OneTimeCharge as OneTimeC5_317_2_, subscripti4_.OneTimeChargeModeId as OneTimeC6_317_2_, subscripti4_.OneTimeChargeTaxCodeId as OneTimeC7_317_2_, subscripti4_.OptionalPaymentFrequencies as Optional8_317_2_, subscripti4_.PaymentFrequencyTypeId as PaymentF9_317_2_, subscripti4_.NumberOfPayments as NumberO10_317_2_, subscripti4_.PaymentFrequency as Payment11_317_2_, subscripti4_.PaymentFrequencyUnitId as Payment12_317_2_, subscripti4_.RecurringCharge as Recurri13_317_2_, subscripti4_.RecurringChargeModeId as Recurri14_317_2_, subscripti4_.RepeatDiscounts as RepeatD15_317_2_, subscripti4_.RecurringChargeSpecified as Recurri16_317_2_, subscripti4_.GroupId as GroupId317_2_, subscripti4_.TaxCodeId as TaxCodeId317_2_ FROM ac_Products this_ left outer join ac_Kits kit2_ on this_.ProductId=kit2_.ProductId left outer join ac_ProductKitComponents productkit3_ on this_.ProductId=productkit3_.ProductId left outer join ac_SubscriptionPlans subscripti4_ on this_.ProductId=subscripti4_.ProductId WHERE this_.ProductId in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY productkit3_.OrderBy asc;
SELECT this_.ProductId as ProductId302_3_, this_.RowVersion as RowVersion302_3_, this_.StoreId as StoreId302_3_, this_.Name as Name302_3_, this_.Price as Price302_3_, this_.CostOfGoods as CostOfGo6_302_3_, this_.MSRP as MSRP302_3_, this_.Weight as Weight302_3_, this_.Length as Length302_3_, this_.Width as Width302_3_, this_.Height as Height302_3_, this_.ManufacturerId as Manufac12_302_3_, this_.Sku as Sku302_3_, this_.ModelNumber as ModelNu14_302_3_, this_.WebpageId as WebpageId302_3_, this_.TaxCodeId as TaxCodeId302_3_, this_.ShippableId as Shippab17_302_3_, this_.WarehouseId as Warehou18_302_3_, this_.InventoryModeId as Invento19_302_3_, this_.InStock as InStock302_3_, this_.AvailabilityDate as Availab21_302_3_, this_.InStockWarningLevel as InStock22_302_3_, this_.ThumbnailUrl as Thumbna23_302_3_, this_.ThumbnailAltText as Thumbna24_302_3_, this_.ImageUrl as ImageUrl302_3_, this_.ImageAltText as ImageAl26_302_3_, this_.Summary as Summary302_3_, this_.Description as Descrip28_302_3_, this_.ExtendedDescription as Extende29_302_3_, this_.VendorId as VendorId302_3_, this_.CreatedDate as Created31_302_3_, this_.LastModifiedDate as LastMod32_302_3_, this_.IsFeatured as IsFeatured302_3_, this_.IsProhibited as IsProhi34_302_3_, this_.AllowReviews as AllowRe35_302_3_, this_.AllowBackorder as AllowBa36_302_3_, this_.WrapGroupId as WrapGro37_302_3_, this_.ExcludeFromFeed as Exclude38_302_3_, this_.DisablePurchase as Disable39_302_3_, this_.MinQuantity as MinQuan40_302_3_, this_.MaxQuantity as MaxQuan41_302_3_, this_.VisibilityId as Visibil42_302_3_, this_.IconUrl as IconUrl302_3_, this_.IconAltText as IconAlt44_302_3_, this_.IsGiftCertificate as IsGiftC45_302_3_, this_.UseVariablePrice as UseVari46_302_3_, this_.MinimumPrice as Minimum47_302_3_, this_.MaximumPrice as Maximum48_302_3_, this_.HidePrice as HidePrice302_3_, this_.HandlingCharges as Handlin50_302_3_, this_.EnableGroups as EnableG51_302_3_, this_.Title as Title302_3_, this_.MetaDescription as MetaDes53_302_3_, this_.MetaKeywords as MetaKey54_302_3_, this_.SearchKeywords as SearchK55_302_3_, this_.HtmlHead as HtmlHead302_3_, this_.GTIN as GTIN302_3_, this_.GoogleCategory as GoogleC58_302_3_, this_.Condition as Condition302_3_, this_.Gender as Gender302_3_, this_.AgeGroup as AgeGroup302_3_, this_.Color as Color302_3_, this_.Size as Size302_3_, this_.AdwordsGrouping as Adwords64_302_3_, this_.AdwordsLabels as Adwords65_302_3_, this_.ExcludedDestination as Exclude66_302_3_, this_.AdwordsRedirect as Adwords67_302_3_, this_.PublishFeedAsVariants as Publish68_302_3_, this_.TIC as TIC302_3_, this_.OrderBy as OrderBy302_3_, this_.EnableRestockNotifications as EnableR71_302_3_, kit2_.ProductId as ProductId296_0_, kit2_.ItemizeDisplay as ItemizeD2_296_0_, producttem3_.ProductId as ProductId5_, producttem4_.ProductTemplateId as ProductT2_5_, producttem4_.ProductTemplateId as ProductT1_310_1_, producttem4_.StoreId as StoreId310_1_, producttem4_.Name as Name310_1_, subscripti5_.ProductId as ProductId317_2_, subscripti5_.Name as Name317_2_, subscripti5_.IsOptional as IsOptional317_2_, subscripti5_.Description as Descript4_317_2_, subscripti5_.OneTimeCharge as OneTimeC5_317_2_, subscripti5_.OneTimeChargeModeId as OneTimeC6_317_2_, subscripti5_.OneTimeChargeTaxCodeId as OneTimeC7_317_2_, subscripti5_.OptionalPaymentFrequencies as Optional8_317_2_, subscripti5_.PaymentFrequencyTypeId as PaymentF9_317_2_, subscripti5_.NumberOfPayments as NumberO10_317_2_, subscripti5_.PaymentFrequency as Payment11_317_2_, subscripti5_.PaymentFrequencyUnitId as Payment12_317_2_, subscripti5_.RecurringCharge as Recurri13_317_2_, subscripti5_.RecurringChargeModeId as Recurri14_317_2_, subscripti5_.RepeatDiscounts as RepeatD15_317_2_, subscripti5_.RecurringChargeSpecified as Recurri16_317_2_, subscripti5_.GroupId as GroupId317_2_, subscripti5_.TaxCodeId as TaxCodeId317_2_ FROM ac_Products this_ left outer join ac_Kits kit2_ on this_.ProductId=kit2_.ProductId left outer join ac_ProductProductTemplates producttem3_ on this_.ProductId=producttem3_.ProductId left outer join ac_ProductTemplates producttem4_ on producttem3_.ProductTemplateId=producttem4_.ProductTemplateId left outer join ac_SubscriptionPlans subscripti5_ on this_.ProductId=subscripti5_.ProductId WHERE this_.ProductId in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
SELECT this_.ProductId as ProductId302_3_, this_.RowVersion as RowVersion302_3_, this_.StoreId as StoreId302_3_, this_.Name as Name302_3_, this_.Price as Price302_3_, this_.CostOfGoods as CostOfGo6_302_3_, this_.MSRP as MSRP302_3_, this_.Weight as Weight302_3_, this_.Length as Length302_3_, this_.Width as Width302_3_, this_.Height as Height302_3_, this_.ManufacturerId as Manufac12_302_3_, this_.Sku as Sku302_3_, this_.ModelNumber as ModelNu14_302_3_, this_.WebpageId as WebpageId302_3_, this_.TaxCodeId as TaxCodeId302_3_, this_.ShippableId as Shippab17_302_3_, this_.WarehouseId as Warehou18_302_3_, this_.InventoryModeId as Invento19_302_3_, this_.InStock as InStock302_3_, this_.AvailabilityDate as Availab21_302_3_, this_.InStockWarningLevel as InStock22_302_3_, this_.ThumbnailUrl as Thumbna23_302_3_, this_.ThumbnailAltText as Thumbna24_302_3_, this_.ImageUrl as ImageUrl302_3_, this_.ImageAltText as ImageAl26_302_3_, this_.Summary as Summary302_3_, this_.Description as Descrip28_302_3_, this_.ExtendedDescription as Extende29_302_3_, this_.VendorId as VendorId302_3_, this_.CreatedDate as Created31_302_3_, this_.LastModifiedDate as LastMod32_302_3_, this_.IsFeatured as IsFeatured302_3_, this_.IsProhibited as IsProhi34_302_3_, this_.AllowReviews as AllowRe35_302_3_, this_.AllowBackorder as AllowBa36_302_3_, this_.WrapGroupId as WrapGro37_302_3_, this_.ExcludeFromFeed as Exclude38_302_3_, this_.DisablePurchase as Disable39_302_3_, this_.MinQuantity as MinQuan40_302_3_, this_.MaxQuantity as MaxQuan41_302_3_, this_.VisibilityId as Visibil42_302_3_, this_.IconUrl as IconUrl302_3_, this_.IconAltText as IconAlt44_302_3_, this_.IsGiftCertificate as IsGiftC45_302_3_, this_.UseVariablePrice as UseVari46_302_3_, this_.MinimumPrice as Minimum47_302_3_, this_.MaximumPrice as Maximum48_302_3_, this_.HidePrice as HidePrice302_3_, this_.HandlingCharges as Handlin50_302_3_, this_.EnableGroups as EnableG51_302_3_, this_.Title as Title302_3_, this_.MetaDescription as MetaDes53_302_3_, this_.MetaKeywords as MetaKey54_302_3_, this_.SearchKeywords as SearchK55_302_3_, this_.HtmlHead as HtmlHead302_3_, this_.GTIN as GTIN302_3_, this_.GoogleCategory as GoogleC58_302_3_, this_.Condition as Condition302_3_, this_.Gender as Gender302_3_, this_.AgeGroup as AgeGroup302_3_, this_.Color as Color302_3_, this_.Size as Size302_3_, this_.AdwordsGrouping as Adwords64_302_3_, this_.AdwordsLabels as Adwords65_302_3_, this_.ExcludedDestination as Exclude66_302_3_, this_.AdwordsRedirect as Adwords67_302_3_, this_.PublishFeedAsVariants as Publish68_302_3_, this_.TIC as TIC302_3_, this_.OrderBy as OrderBy302_3_, this_.EnableRestockNotifications as EnableR71_302_3_, kit2_.ProductId as ProductId296_0_, kit2_.ItemizeDisplay as ItemizeD2_296_0_, reviews3_.ProductId as ProductId5_, reviews3_.ProductReviewId as ProductR1_5_, reviews3_.ProductReviewId as ProductR1_309_1_, reviews3_.ProductId as ProductId309_1_, reviews3_.ReviewerProfileId as Reviewer3_309_1_, reviews3_.ReviewDate as ReviewDate309_1_, reviews3_.Rating as Rating309_1_, reviews3_.ReviewTitle as ReviewTi6_309_1_, reviews3_.ReviewBody as ReviewBody309_1_, reviews3_.IsApproved as IsApproved309_1_, subscripti4_.ProductId as ProductId317_2_, subscripti4_.Name as Name317_2_, subscripti4_.IsOptional as IsOptional317_2_, subscripti4_.Description as Descript4_317_2_, subscripti4_.OneTimeCharge as OneTimeC5_317_2_, subscripti4_.OneTimeChargeModeId as OneTimeC6_317_2_, subscripti4_.OneTimeChargeTaxCodeId as OneTimeC7_317_2_, subscripti4_.OptionalPaymentFrequencies as Optional8_317_2_, subscripti4_.PaymentFrequencyTypeId as PaymentF9_317_2_, subscripti4_.NumberOfPayments as NumberO10_317_2_, subscripti4_.PaymentFrequency as Payment11_317_2_, subscripti4_.PaymentFrequencyUnitId as Payment12_317_2_, subscripti4_.RecurringCharge as Recurri13_317_2_, subscripti4_.RecurringChargeModeId as Recurri14_317_2_, subscripti4_.RepeatDiscounts as RepeatD15_317_2_, subscripti4_.RecurringChargeSpecified as Recurri16_317_2_, subscripti4_.GroupId as GroupId317_2_, subscripti4_.TaxCodeId as TaxCodeId317_2_ FROM ac_Products this_ left outer join ac_Kits kit2_ on this_.ProductId=kit2_.ProductId left outer join ac_ProductReviews reviews3_ on this_.ProductId=reviews3_.ProductId left outer join ac_SubscriptionPlans subscripti4_ on this_.ProductId=subscripti4_.ProductId WHERE this_.ProductId in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
]
Inner Exception Stack Trace: at NHibernate.Impl.MultiCriteriaImpl.GetResultsFromDatabase(IList results)
at NHibernate.Impl.MultiCriteriaImpl.List()
at NHibernate.Impl.FutureBatch`2.GetResults()
at NHibernate.Impl.FutureBatch`2.GetCurrentResult[TResult](Int32 currentIndex)
at NHibernate.Impl.DelayedEnumerator`1.<get_Enumerable>d__0.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at AbleCommerce.ConLib.CategoryGridPage.BindProductList()
at AbleCommerce.ConLib.CategoryGridPage.BindSearchResultsPanel()
at AbleCommerce.ConLib.CategoryGridPage.Page_PreRender(Object sender, EventArgs e)
at System.Web.UI.Control.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Inner Exception: Failed to execute multi criteria[SQL: SELECT this_.ProductId as ProductId302_3_, this_.RowVersion as RowVersion302_3_, this_.StoreId as StoreId302_3_, this_.Name as Name302_3_, this_.Price as Price302_3_, this_.CostOfGoods as CostOfGo6_302_3_, this_.MSRP as MSRP302_3_, this_.Weight as Weight302_3_, this_.Length as Length302_3_, this_.Width as Width302_3_, this_.Height as Height302_3_, this_.ManufacturerId as Manufac12_302_3_, this_.Sku as Sku302_3_, this_.ModelNumber as ModelNu14_302_3_, this_.WebpageId as WebpageId302_3_, this_.TaxCodeId as TaxCodeId302_3_, this_.ShippableId as Shippab17_302_3_, this_.WarehouseId as Warehou18_302_3_, this_.InventoryModeId as Invento19_302_3_, this_.InStock as InStock302_3_, this_.AvailabilityDate as Availab21_302_3_, this_.InStockWarningLevel as InStock22_302_3_, this_.ThumbnailUrl as Thumbna23_302_3_, this_.ThumbnailAltText as Thumbna24_302_3_, this_.ImageUrl as ImageUrl302_3_, this_.ImageAltText as ImageAl26_302_3_, this_.Summary as Summary302_3_, this_.Description as Descrip28_302_3_, this_.ExtendedDescription as Extende29_302_3_, this_.VendorId as VendorId302_3_, this_.CreatedDate as Created31_302_3_, this_.LastModifiedDate as LastMod32_302_3_, this_.IsFeatured as IsFeatured302_3_, this_.IsProhibited as IsProhi34_302_3_, this_.AllowReviews as AllowRe35_302_3_, this_.AllowBackorder as AllowBa36_302_3_, this_.WrapGroupId as WrapGro37_302_3_, this_.ExcludeFromFeed as Exclude38_302_3_, this_.DisablePurchase as Disable39_302_3_, this_.MinQuantity as MinQuan40_302_3_, this_.MaxQuantity as MaxQuan41_302_3_, this_.VisibilityId as Visibil42_302_3_, this_.IconUrl as IconUrl302_3_, this_.IconAltText as IconAlt44_302_3_, this_.IsGiftCertificate as IsGiftC45_302_3_, this_.UseVariablePrice as UseVari46_302_3_, this_.MinimumPrice as Minimum47_302_3_, this_.MaximumPrice as Maximum48_302_3_, this_.HidePrice as HidePrice302_3_, this_.HandlingCharges as Handlin50_302_3_, this_.EnableGroups as EnableG51_302_3_, this_.Title as Title302_3_, this_.MetaDescription as MetaDes53_302_3_, this_.MetaKeywords as MetaKey54_302_3_, this_.SearchKeywords as SearchK55_302_3_, this_.HtmlHead as HtmlHead302_3_, this_.GTIN as GTIN302_3_, this_.GoogleCategory as GoogleC58_302_3_, this_.Condition as Condition302_3_, this_.Gender as Gender302_3_, this_.AgeGroup as AgeGroup302_3_, this_.Color as Color302_3_, this_.Size as Size302_3_, this_.AdwordsGrouping as Adwords64_302_3_, this_.AdwordsLabels as Adwords65_302_3_, this_.ExcludedDestination as Exclude66_302_3_, this_.AdwordsRedirect as Adwords67_302_3_, this_.PublishFeedAsVariants as Publish68_302_3_, this_.TIC as TIC302_3_, this_.OrderBy as OrderBy302_3_, this_.EnableRestockNotifications as EnableR71_302_3_, kit2_.ProductId as ProductId296_0_, kit2_.ItemizeDisplay as ItemizeD2_296_0_, specials3_.ProductId as ProductId5_, specials3_.SpecialId as SpecialId5_, specials3_.SpecialId as SpecialId315_1_, specials3_.ProductId as ProductId315_1_, specials3_.Price as Price315_1_, specials3_.StartDate as StartDate315_1_, specials3_.EndDate as EndDate315_1_, subscripti4_.ProductId as ProductId317_2_, subscripti4_.Name as Name317_2_, subscripti4_.IsOptional as IsOptional317_2_, subscripti4_.Description as Descript4_317_2_, subscripti4_.OneTimeCharge as OneTimeC5_317_2_, subscripti4_.OneTimeChargeModeId as OneTimeC6_317_2_, subscripti4_.OneTimeChargeTaxCodeId as OneTimeC7_317_2_, subscripti4_.OptionalPaymentFrequencies as Optional8_317_2_, subscripti4_.PaymentFrequencyTypeId as PaymentF9_317_2_, subscripti4_.NumberOfPayments as NumberO10_317_2_, subscripti4_.PaymentFrequency as Payment11_317_2_, subscripti4_.PaymentFrequencyUnitId as Payment12_317_2_, subscripti4_.RecurringCharge as Recurri13_317_2_, subscripti4_.RecurringChargeModeId as Recurri14_317_2_, subscripti4_.RepeatDiscounts as RepeatD15_317_2_, subscripti4_.RecurringChargeSpecified as Recurri16_317_2_, subscripti4_.GroupId as GroupId317_2_, subscripti4_.TaxCodeId as TaxCodeId317_2_ FROM ac_Products this_ left outer join ac_Kits kit2_ on this_.ProductId=kit2_.ProductId left outer join ac_Specials specials3_ on this_.ProductId=specials3_.ProductId left outer join ac_SubscriptionPlans subscripti4_ on this_.ProductId=subscripti4_.ProductId WHERE this_.ProductId in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
SELECT this_.ProductId as ProductId302_3_, this_.RowVersion as RowVersion302_3_, this_.StoreId as StoreId302_3_, this_.Name as Name302_3_, this_.Price as Price302_3_, this_.CostOfGoods as CostOfGo6_302_3_, this_.MSRP as MSRP302_3_, this_.Weight as Weight302_3_, this_.Length as Length302_3_, this_.Width as Width302_3_, this_.Height as Height302_3_, this_.ManufacturerId as Manufac12_302_3_, this_.Sku as Sku302_3_, this_.ModelNumber as ModelNu14_302_3_, this_.WebpageId as WebpageId302_3_, this_.TaxCodeId as TaxCodeId302_3_, this_.ShippableId as Shippab17_302_3_, this_.WarehouseId as Warehou18_302_3_, this_.InventoryModeId as Invento19_302_3_, this_.InStock as InStock302_3_, this_.AvailabilityDate as Availab21_302_3_, this_.InStockWarningLevel as InStock22_302_3_, this_.ThumbnailUrl as Thumbna23_302_3_, this_.ThumbnailAltText as Thumbna24_302_3_, this_.ImageUrl as ImageUrl302_3_, this_.ImageAltText as ImageAl26_302_3_, this_.Summary as Summary302_3_, this_.Description as Descrip28_302_3_, this_.ExtendedDescription as Extende29_302_3_, this_.VendorId as VendorId302_3_, this_.CreatedDate as Created31_302_3_, this_.LastModifiedDate as LastMod32_302_3_, this_.IsFeatured as IsFeatured302_3_, this_.IsProhibited as IsProhi34_302_3_, this_.AllowReviews as AllowRe35_302_3_, this_.AllowBackorder as AllowBa36_302_3_, this_.WrapGroupId as WrapGro37_302_3_, this_.ExcludeFromFeed as Exclude38_302_3_, this_.DisablePurchase as Disable39_302_3_, this_.MinQuantity as MinQuan40_302_3_, this_.MaxQuantity as MaxQuan41_302_3_, this_.VisibilityId as Visibil42_302_3_, this_.IconUrl as IconUrl302_3_, this_.IconAltText as IconAlt44_302_3_, this_.IsGiftCertificate as IsGiftC45_302_3_, this_.UseVariablePrice as UseVari46_302_3_, this_.MinimumPrice as Minimum47_302_3_, this_.MaximumPrice as Maximum48_302_3_, this_.HidePrice as HidePrice302_3_, this_.HandlingCharges as Handlin50_302_3_, this_.EnableGroups as EnableG51_302_3_, this_.Title as Title302_3_, this_.MetaDescription as MetaDes53_302_3_, this_.MetaKeywords as MetaKey54_302_3_, this_.SearchKeywords as SearchK55_302_3_, this_.HtmlHead as HtmlHead302_3_, this_.GTIN as GTIN302_3_, this_.GoogleCategory as GoogleC58_302_3_, this_.Condition as Condition302_3_, this_.Gender as Gender302_3_, this_.AgeGroup as AgeGroup302_3_, this_.Color as Color302_3_, this_.Size as Size302_3_, this_.AdwordsGrouping as Adwords64_302_3_, this_.AdwordsLabels as Adwords65_302_3_, this_.ExcludedDestination as Exclude66_302_3_, this_.AdwordsRedirect as Adwords67_302_3_, this_.PublishFeedAsVariants as Publish68_302_3_, this_.TIC as TIC302_3_, this_.OrderBy as OrderBy302_3_, this_.EnableRestockNotifications as EnableR71_302_3_, kit2_.ProductId as ProductId296_0_, kit2_.ItemizeDisplay as ItemizeD2_296_0_, productopt3_.ProductId as ProductId5_, productopt3_.ProductOptionId as ProductO1_5_, productopt3_.ProductOptionId as ProductO1_308_1_, productopt3_.ProductId as ProductId308_1_, productopt3_.OptionId as OptionId308_1_, productopt3_.OrderBy as OrderBy308_1_, subscripti4_.ProductId as ProductId317_2_, subscripti4_.Name as Name317_2_, subscripti4_.IsOptional as IsOptional317_2_, subscripti4_.Description as Descript4_317_2_, subscripti4_.OneTimeCharge as OneTimeC5_317_2_, subscripti4_.OneTimeChargeModeId as OneTimeC6_317_2_, subscripti4_.OneTimeChargeTaxCodeId as OneTimeC7_317_2_, subscripti4_.OptionalPaymentFrequencies as Optional8_317_2_, subscripti4_.PaymentFrequencyTypeId as PaymentF9_317_2_, subscripti4_.NumberOfPayments as NumberO10_317_2_, subscripti4_.PaymentFrequency as Payment11_317_2_, subscripti4_.PaymentFrequencyUnitId as Payment12_317_2_, subscripti4_.RecurringCharge as Recurri13_317_2_, subscripti4_.RecurringChargeModeId as Recurri14_317_2_, subscripti4_.RepeatDiscounts as RepeatD15_317_2_, subscripti4_.RecurringChargeSpecified as Recurri16_317_2_, subscripti4_.GroupId as GroupId317_2_, subscripti4_.TaxCodeId as TaxCodeId317_2_ FROM ac_Products this_ left outer join ac_Kits kit2_ on this_.ProductId=kit2_.ProductId left outer join ac_ProductOptions productopt3_ on this_.ProductId=productopt3_.ProductId left outer join ac_SubscriptionPlans subscripti4_ on this_.ProductId=subscripti4_.ProductId WHERE this_.ProductId in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY productopt3_.OrderBy asc;
SELECT this_.ProductId as ProductId302_3_, this_.RowVersion as RowVersion302_3_, this_.StoreId as StoreId302_3_, this_.Name as Name302_3_, this_.Price as Price302_3_, this_.CostOfGoods as CostOfGo6_302_3_, this_.MSRP as MSRP302_3_, this_.Weight as Weight302_3_, this_.Length as Length302_3_, this_.Width as Width302_3_, this_.Height as Height302_3_, this_.ManufacturerId as Manufac12_302_3_, this_.Sku as Sku302_3_, this_.ModelNumber as ModelNu14_302_3_, this_.WebpageId as WebpageId302_3_, this_.TaxCodeId as TaxCodeId302_3_, this_.ShippableId as Shippab17_302_3_, this_.WarehouseId as Warehou18_302_3_, this_.InventoryModeId as Invento19_302_3_, this_.InStock as InStock302_3_, this_.AvailabilityDate as Availab21_302_3_, this_.InStockWarningLevel as InStock22_302_3_, this_.ThumbnailUrl as Thumbna23_302_3_, this_.ThumbnailAltText as Thumbna24_302_3_, this_.ImageUrl as ImageUrl302_3_, this_.ImageAltText as ImageAl26_302_3_, this_.Summary as Summary302_3_, this_.Description as Descrip28_302_3_, this_.ExtendedDescription as Extende29_302_3_, this_.VendorId as VendorId302_3_, this_.CreatedDate as Created31_302_3_, this_.LastModifiedDate as LastMod32_302_3_, this_.IsFeatured as IsFeatured302_3_, this_.IsProhibited as IsProhi34_302_3_, this_.AllowReviews as AllowRe35_302_3_, this_.AllowBackorder as AllowBa36_302_3_, this_.WrapGroupId as WrapGro37_302_3_, this_.ExcludeFromFeed as Exclude38_302_3_, this_.DisablePurchase as Disable39_302_3_, this_.MinQuantity as MinQuan40_302_3_, this_.MaxQuantity as MaxQuan41_302_3_, this_.VisibilityId as Visibil42_302_3_, this_.IconUrl as IconUrl302_3_, this_.IconAltText as IconAlt44_302_3_, this_.IsGiftCertificate as IsGiftC45_302_3_, this_.UseVariablePrice as UseVari46_302_3_, this_.MinimumPrice as Minimum47_302_3_, this_.MaximumPrice as Maximum48_302_3_, this_.HidePrice as HidePrice302_3_, this_.HandlingCharges as Handlin50_302_3_, this_.EnableGroups as EnableG51_302_3_, this_.Title as Title302_3_, this_.MetaDescription as MetaDes53_302_3_, this_.MetaKeywords as MetaKey54_302_3_, this_.SearchKeywords as SearchK55_302_3_, this_.HtmlHead as HtmlHead302_3_, this_.GTIN as GTIN302_3_, this_.GoogleCategory as GoogleC58_302_3_, this_.Condition as Condition302_3_, this_.Gender as Gender302_3_, this_.AgeGroup as AgeGroup302_3_, this_.Color as Color302_3_, this_.Size as Size302_3_, this_.AdwordsGrouping as Adwords64_302_3_, this_.AdwordsLabels as Adwords65_302_3_, this_.ExcludedDestination as Exclude66_302_3_, this_.AdwordsRedirect as Adwords67_302_3_, this_.PublishFeedAsVariants as Publish68_302_3_, this_.TIC as TIC302_3_, this_.OrderBy as OrderBy302_3_, this_.EnableRestockNotifications as EnableR71_302_3_, kit2_.ProductId as ProductId296_0_, kit2_.ItemizeDisplay as ItemizeD2_296_0_, productkit3_.ProductId as ProductId5_, productkit3_.ProductKitComponentId as ProductK1_5_, productkit3_.ProductKitComponentId as ProductK1_307_1_, productkit3_.ProductId as ProductId307_1_, productkit3_.KitComponentId as KitCompo3_307_1_, productkit3_.OrderBy as OrderBy307_1_, subscripti4_.ProductId as ProductId317_2_, subscripti4_.Name as Name317_2_, subscripti4_.IsOptional as IsOptional317_2_, subscripti4_.Description as Descript4_317_2_, subscripti4_.OneTimeCharge as OneTimeC5_317_2_, subscripti4_.OneTimeChargeModeId as OneTimeC6_317_2_, subscripti4_.OneTimeChargeTaxCodeId as OneTimeC7_317_2_, subscripti4_.OptionalPaymentFrequencies as Optional8_317_2_, subscripti4_.PaymentFrequencyTypeId as PaymentF9_317_2_, subscripti4_.NumberOfPayments as NumberO10_317_2_, subscripti4_.PaymentFrequency as Payment11_317_2_, subscripti4_.PaymentFrequencyUnitId as Payment12_317_2_, subscripti4_.RecurringCharge as Recurri13_317_2_, subscripti4_.RecurringChargeModeId as Recurri14_317_2_, subscripti4_.RepeatDiscounts as RepeatD15_317_2_, subscripti4_.RecurringChargeSpecified as Recurri16_317_2_, subscripti4_.GroupId as GroupId317_2_, subscripti4_.TaxCodeId as TaxCodeId317_2_ FROM ac_Products this_ left outer join ac_Kits kit2_ on this_.ProductId=kit2_.ProductId left outer join ac_ProductKitComponents productkit3_ on this_.ProductId=productkit3_.ProductId left outer join ac_SubscriptionPlans subscripti4_ on this_.ProductId=subscripti4_.ProductId WHERE this_.ProductId in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY productkit3_.OrderBy asc;
SELECT this_.ProductId as ProductId302_3_, this_.RowVersion as RowVersion302_3_, this_.StoreId as StoreId302_3_, this_.Name as Name302_3_, this_.Price as Price302_3_, this_.CostOfGoods as CostOfGo6_302_3_, this_.MSRP as MSRP302_3_, this_.Weight as Weight302_3_, this_.Length as Length302_3_, this_.Width as Width302_3_, this_.Height as Height302_3_, this_.ManufacturerId as Manufac12_302_3_, this_.Sku as Sku302_3_, this_.ModelNumber as ModelNu14_302_3_, this_.WebpageId as WebpageId302_3_, this_.TaxCodeId as TaxCodeId302_3_, this_.ShippableId as Shippab17_302_3_, this_.WarehouseId as Warehou18_302_3_, this_.InventoryModeId as Invento19_302_3_, this_.InStock as InStock302_3_, this_.AvailabilityDate as Availab21_302_3_, this_.InStockWarningLevel as InStock22_302_3_, this_.ThumbnailUrl as Thumbna23_302_3_, this_.ThumbnailAltText as Thumbna24_302_3_, this_.ImageUrl as ImageUrl302_3_, this_.ImageAltText as ImageAl26_302_3_, this_.Summary as Summary302_3_, this_.Description as Descrip28_302_3_, this_.ExtendedDescription as Extende29_302_3_, this_.VendorId as VendorId302_3_, this_.CreatedDate as Created31_302_3_, this_.LastModifiedDate as LastMod32_302_3_, this_.IsFeatured as IsFeatured302_3_, this_.IsProhibited as IsProhi34_302_3_, this_.AllowReviews as AllowRe35_302_3_, this_.AllowBackorder as AllowBa36_302_3_, this_.WrapGroupId as WrapGro37_302_3_, this_.ExcludeFromFeed as Exclude38_302_3_, this_.DisablePurchase as Disable39_302_3_, this_.MinQuantity as MinQuan40_302_3_, this_.MaxQuantity as MaxQuan41_302_3_, this_.VisibilityId as Visibil42_302_3_, this_.IconUrl as IconUrl302_3_, this_.IconAltText as IconAlt44_302_3_, this_.IsGiftCertificate as IsGiftC45_302_3_, this_.UseVariablePrice as UseVari46_302_3_, this_.MinimumPrice as Minimum47_302_3_, this_.MaximumPrice as Maximum48_302_3_, this_.HidePrice as HidePrice302_3_, this_.HandlingCharges as Handlin50_302_3_, this_.EnableGroups as EnableG51_302_3_, this_.Title as Title302_3_, this_.MetaDescription as MetaDes53_302_3_, this_.MetaKeywords as MetaKey54_302_3_, this_.SearchKeywords as SearchK55_302_3_, this_.HtmlHead as HtmlHead302_3_, this_.GTIN as GTIN302_3_, this_.GoogleCategory as GoogleC58_302_3_, this_.Condition as Condition302_3_, this_.Gender as Gender302_3_, this_.AgeGroup as AgeGroup302_3_, this_.Color as Color302_3_, this_.Size as Size302_3_, this_.AdwordsGrouping as Adwords64_302_3_, this_.AdwordsLabels as Adwords65_302_3_, this_.ExcludedDestination as Exclude66_302_3_, this_.AdwordsRedirect as Adwords67_302_3_, this_.PublishFeedAsVariants as Publish68_302_3_, this_.TIC as TIC302_3_, this_.OrderBy as OrderBy302_3_, this_.EnableRestockNotifications as EnableR71_302_3_, kit2_.ProductId as ProductId296_0_, kit2_.ItemizeDisplay as ItemizeD2_296_0_, producttem3_.ProductId as ProductId5_, producttem4_.ProductTemplateId as ProductT2_5_, producttem4_.ProductTemplateId as ProductT1_310_1_, producttem4_.StoreId as StoreId310_1_, producttem4_.Name as Name310_1_, subscripti5_.ProductId as ProductId317_2_, subscripti5_.Name as Name317_2_, subscripti5_.IsOptional as IsOptional317_2_, subscripti5_.Description as Descript4_317_2_, subscripti5_.OneTimeCharge as OneTimeC5_317_2_, subscripti5_.OneTimeChargeModeId as OneTimeC6_317_2_, subscripti5_.OneTimeChargeTaxCodeId as OneTimeC7_317_2_, subscripti5_.OptionalPaymentFrequencies as Optional8_317_2_, subscripti5_.PaymentFrequencyTypeId as PaymentF9_317_2_, subscripti5_.NumberOfPayments as NumberO10_317_2_, subscripti5_.PaymentFrequency as Payment11_317_2_, subscripti5_.PaymentFrequencyUnitId as Payment12_317_2_, subscripti5_.RecurringCharge as Recurri13_317_2_, subscripti5_.RecurringChargeModeId as Recurri14_317_2_, subscripti5_.RepeatDiscounts as RepeatD15_317_2_, subscripti5_.RecurringChargeSpecified as Recurri16_317_2_, subscripti5_.GroupId as GroupId317_2_, subscripti5_.TaxCodeId as TaxCodeId317_2_ FROM ac_Products this_ left outer join ac_Kits kit2_ on this_.ProductId=kit2_.ProductId left outer join ac_ProductProductTemplates producttem3_ on this_.ProductId=producttem3_.ProductId left outer join ac_ProductTemplates producttem4_ on producttem3_.ProductTemplateId=producttem4_.ProductTemplateId left outer join ac_SubscriptionPlans subscripti5_ on this_.ProductId=subscripti5_.ProductId WHERE this_.ProductId in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
SELECT this_.ProductId as ProductId302_3_, this_.RowVersion as RowVersion302_3_, this_.StoreId as StoreId302_3_, this_.Name as Name302_3_, this_.Price as Price302_3_, this_.CostOfGoods as CostOfGo6_302_3_, this_.MSRP as MSRP302_3_, this_.Weight as Weight302_3_, this_.Length as Length302_3_, this_.Width as Width302_3_, this_.Height as Height302_3_, this_.ManufacturerId as Manufac12_302_3_, this_.Sku as Sku302_3_, this_.ModelNumber as ModelNu14_302_3_, this_.WebpageId as WebpageId302_3_, this_.TaxCodeId as TaxCodeId302_3_, this_.ShippableId as Shippab17_302_3_, this_.WarehouseId as Warehou18_302_3_, this_.InventoryModeId as Invento19_302_3_, this_.InStock as InStock302_3_, this_.AvailabilityDate as Availab21_302_3_, this_.InStockWarningLevel as InStock22_302_3_, this_.ThumbnailUrl as Thumbna23_302_3_, this_.ThumbnailAltText as Thumbna24_302_3_, this_.ImageUrl as ImageUrl302_3_, this_.ImageAltText as ImageAl26_302_3_, this_.Summary as Summary302_3_, this_.Description as Descrip28_302_3_, this_.ExtendedDescription as Extende29_302_3_, this_.VendorId as VendorId302_3_, this_.CreatedDate as Created31_302_3_, this_.LastModifiedDate as LastMod32_302_3_, this_.IsFeatured as IsFeatured302_3_, this_.IsProhibited as IsProhi34_302_3_, this_.AllowReviews as AllowRe35_302_3_, this_.AllowBackorder as AllowBa36_302_3_, this_.WrapGroupId as WrapGro37_302_3_, this_.ExcludeFromFeed as Exclude38_302_3_, this_.DisablePurchase as Disable39_302_3_, this_.MinQuantity as MinQuan40_302_3_, this_.MaxQuantity as MaxQuan41_302_3_, this_.VisibilityId as Visibil42_302_3_, this_.IconUrl as IconUrl302_3_, this_.IconAltText as IconAlt44_302_3_, this_.IsGiftCertificate as IsGiftC45_302_3_, this_.UseVariablePrice as UseVari46_302_3_, this_.MinimumPrice as Minimum47_302_3_, this_.MaximumPrice as Maximum48_302_3_, this_.HidePrice as HidePrice302_3_, this_.HandlingCharges as Handlin50_302_3_, this_.EnableGroups as EnableG51_302_3_, this_.Title as Title302_3_, this_.MetaDescription as MetaDes53_302_3_, this_.MetaKeywords as MetaKey54_302_3_, this_.SearchKeywords as SearchK55_302_3_, this_.HtmlHead as HtmlHead302_3_, this_.GTIN as GTIN302_3_, this_.GoogleCategory as GoogleC58_302_3_, this_.Condition as Condition302_3_, this_.Gender as Gender302_3_, this_.AgeGroup as AgeGroup302_3_, this_.Color as Color302_3_, this_.Size as Size302_3_, this_.AdwordsGrouping as Adwords64_302_3_, this_.AdwordsLabels as Adwords65_302_3_, this_.ExcludedDestination as Exclude66_302_3_, this_.AdwordsRedirect as Adwords67_302_3_, this_.PublishFeedAsVariants as Publish68_302_3_, this_.TIC as TIC302_3_, this_.OrderBy as OrderBy302_3_, this_.EnableRestockNotifications as EnableR71_302_3_, kit2_.ProductId as ProductId296_0_, kit2_.ItemizeDisplay as ItemizeD2_296_0_, reviews3_.ProductId as ProductId5_, reviews3_.ProductReviewId as ProductR1_5_, reviews3_.ProductReviewId as ProductR1_309_1_, reviews3_.ProductId as ProductId309_1_, reviews3_.ReviewerProfileId as Reviewer3_309_1_, reviews3_.ReviewDate as ReviewDate309_1_, reviews3_.Rating as Rating309_1_, reviews3_.ReviewTitle as ReviewTi6_309_1_, reviews3_.ReviewBody as ReviewBody309_1_, reviews3_.IsApproved as IsApproved309_1_, subscripti4_.ProductId as ProductId317_2_, subscripti4_.Name as Name317_2_, subscripti4_.IsOptional as IsOptional317_2_, subscripti4_.Description as Descript4_317_2_, subscripti4_.OneTimeCharge as OneTimeC5_317_2_, subscripti4_.OneTimeChargeModeId as OneTimeC6_317_2_, subscripti4_.OneTimeChargeTaxCodeId as OneTimeC7_317_2_, subscripti4_.OptionalPaymentFrequencies as Optional8_317_2_, subscripti4_.PaymentFrequencyTypeId as PaymentF9_317_2_, subscripti4_.NumberOfPayments as NumberO10_317_2_, subscripti4_.PaymentFrequency as Payment11_317_2_, subscripti4_.PaymentFrequencyUnitId as Payment12_317_2_, subscripti4_.RecurringCharge as Recurri13_317_2_, subscripti4_.RecurringChargeModeId as Recurri14_317_2_, subscripti4_.RepeatDiscounts as RepeatD15_317_2_, subscripti4_.RecurringChargeSpecified as Recurri16_317_2_, subscripti4_.GroupId as GroupId317_2_, subscripti4_.TaxCodeId as TaxCodeId317_2_ FROM ac_Products this_ left outer join ac_Kits kit2_ on this_.ProductId=kit2_.ProductId left outer join ac_ProductReviews reviews3_ on this_.ProductId=reviews3_.ProductId left outer join ac_SubscriptionPlans subscripti4_ on this_.ProductId=subscripti4_.ProductId WHERE this_.ProductId in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
]
I hope that someone from Ablecommerce can give some feedback as well. Last, I know this is not the place to post this but, I have a ACV9 Candidate 3 development site running and I'm also getting simiular acceptions thrown. Around 4 or 5 a day. No issues yet with timing out or deleting log files through the admin but they are showing up.
I'll keep monitoring and testing to see why these acception error's continue to arise with our R12SR2 (build 9476) site.
Jay, thanks again for your help.