We're getting an internal server error while accessing the tea commerce backend store in Umbraco.Not every time but can see sometimes.
Any idea on why this is happening. Please do let me know
It looks like your SQL connection is timing out. It may be worth profiling the database to see if you have any long running queries and whether any new DB index's might be required to optimize queries.
How many orders do you have in your database? If it's a lot, it could be worth deleting old orders that were never completed (TC creates and keeps orders for all cart sessions).
Teacommerce backend error
We're getting an internal server error while accessing the tea commerce backend store in Umbraco.Not every time but can see sometimes. Any idea on why this is happening. Please do let me know
Hi Vineeth.
Can you please provide details of the actual error? Stack trace etc? Otherwise we have nothing to go off.
Many thanks
Matt
This the screenshot from client. Any license issue?
Hi Vineeth,
It looks like your SQL connection is timing out. It may be worth profiling the database to see if you have any long running queries and whether any new DB index's might be required to optimize queries.
How many orders do you have in your database? If it's a lot, it could be worth deleting old orders that were never completed (TC creates and keeps orders for all cart sessions).
Hope this helps
Matt
Upon checking the TC order table. We had 348880 orders :(
Yea, that's quite a lot of orders.
You could run a SQL script like
Which should delete all non finalized orders that we not modified in the last year.
Of course, always take a backup before performing such a task.
Matt
Thanks a lot, Matt appreciates the support
is working on a reply...