Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Vineeth 71 posts 291 karma points
    Oct 20, 2020 @ 11:19
    Vineeth
    0

    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

  • Matt Brailsford 2848 posts 14796 karma points MVP 7x c-trib
    Oct 20, 2020 @ 12:09
    Matt Brailsford
    0

    Hi Vineeth.

    Can you please provide details of the actual error? Stack trace etc? Otherwise we have nothing to go off.

    Many thanks

    Matt

  • Vineeth 71 posts 291 karma points
    Oct 20, 2020 @ 12:46
    Vineeth
    0

    This the screenshot from client. Any license issue? enter image description here

  • Matt Brailsford 2848 posts 14796 karma points MVP 7x c-trib
    Oct 20, 2020 @ 13:02
    Matt Brailsford
    0

    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

  • Vineeth 71 posts 291 karma points
    Oct 20, 2020 @ 13:19
    Vineeth
    0

    Upon checking the TC order table. We had 348880 orders :(

  • Matt Brailsford 2848 posts 14796 karma points MVP 7x c-trib
    Oct 20, 2020 @ 13:28
    Matt Brailsford
    101

    Yea, that's quite a lot of orders.

    You could run a SQL script like

    DELETE FROM TeaCommerce_Order WHERE DateFinalized IS NULL AND DateModified < DATEADD(y, -1, GETDATE())
    

    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

  • Vineeth 71 posts 291 karma points
    Oct 20, 2020 @ 13:30
    Vineeth
    0

    Thanks a lot, Matt appreciates the support

Please Sign in or register to post replies

Write your reply to:

Draft