Cannot Access Error Logs Through Admin

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
rlopez
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 96
Joined: Mon Mar 15, 2004 1:08 pm
Contact:

Cannot Access Error Logs Through Admin

Post by rlopez » Sun Jun 02, 2019 11:54 am

In the last 24 hrs we have started getting error messages in the Admin panel. When trying to access the log through the Admin panel to view them, we had found that our site is crawling to almost a stop, but page finally loads to read the errors. After reading the errors, we then marked them for delete. After trying to delete them through admin, It executes but the logs are still there, and not deleted. Today we are now up to 132 errors and no longer can we view them. When executing to view them, through the Admin panel, we are timing out.

Code: Select all

There are 132 messages in your error log. You should review these messages and take corrective action if necessary.

TIME OUT PAGE
We are sorry, but the page you are trying to access has experienced an error.

Please contact xxx to report this problem.

I can access the file through the server, file level directory. This is a R2 9476 build, up to date version. I would like to delete this batch of errors on the server (File Level Directory). My question is, can I do this or will it break the site? If I can do this, I would assume, it will just rebuild the error logs file (most recent) in the Logs folder? Your help or feedback would be very appreciated.
Rick L.
https://www.boatingsolutions.com
We make boat repair easy!

jguengerich
Commodore (COMO)
Commodore (COMO)
Posts: 436
Joined: Tue May 07, 2013 1:59 pm

Re: Cannot Access Error Logs Through Admin

Post by jguengerich » Mon Jun 03, 2019 9:35 am

Errors are stored in both the ac_ErrorLogs table in the database and the app.log file in the web site's App_Data\Logs folder. When you view them in the Admin panel, it is reading them from the ac_ErrorLogs table. When you delete them from the Admin panel, they are deleted from the ac_ErrorLogs table, but not the app.log file.

EDITED TO ADD: Therefore you can delete them from the ac_ErrorLogs table without causing any problems. However, I'm not sure what would be causing a timeout when trying to view them.
Jay

rlopez
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 96
Joined: Mon Mar 15, 2004 1:08 pm
Contact:

Re: Cannot Access Error Logs Through Admin

Post by rlopez » Mon Jun 03, 2019 9:08 pm

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.
Rick L.
https://www.boatingsolutions.com
We make boat repair easy!

Post Reply