Gold R6 Similar Product Load time out

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
jonw2m
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 35
Joined: Thu Sep 15, 2011 9:00 pm

Gold R6 Similar Product Load time out

Post by jonw2m » Tue Jan 14, 2014 3:17 pm

GoldR6 (build 6169) - when accessing the "Similar Products" page in Admin it take a very long time to load and sometimes is timing out. There is no specifics on the error log when is timing out.
The ac_RelatedProducts table has less than 200 entries and the files have no customizations.
I see an error on the error log:
2014-01-14 15:56:44,408 WARN e.Engine.ForeignKeys Unable to determine if CommerceBuilder.Products.RelatedProduct with assigned identifier CommerceBuilder.Products.RelatedProductKey is transient or detached; querying the database. Use explicit Save() or Update() in session to prevent this.

Any information will be appreciated.

Thank you,

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: Gold R6 Similar Product Load time out

Post by Naveed » Wed Jan 15, 2014 12:53 am

I see an error on the error log:
2014-01-14 15:56:44,408 WARN e.Engine.ForeignKeys Unable to determine if CommerceBuilder.Products.RelatedProduct with assigned identifier CommerceBuilder.Products.RelatedProductKey is transient or detached; querying the database. Use explicit Save() or Update() in session to prevent this.
This is just a warning message, and can be safely ignored. I will look into the related products issue and will reply back asap.

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: Gold R6 Similar Product Load time out

Post by Naveed » Wed Jan 15, 2014 1:56 am

GoldR6 (build 6169) - when accessing the "Similar Products" page in Admin it take a very long time to load and sometimes is timing out. There is no specifics on the error log when is timing out.
The ac_RelatedProducts table has less than 200 entries and the files have no customizations.
I tested with 200 similar products in database and the similar products page seems working good for me. How many products do you have in catalog?

jonw2m
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 35
Joined: Thu Sep 15, 2011 9:00 pm

Re: Gold R6 Similar Product Load time out

Post by jonw2m » Wed Jan 15, 2014 6:37 am

There are only 2700 products in ac_Products table.

Thank you,

Post Reply