Copied to clipboard

Flag this post as spam?

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


  • Benjamin Myers 1 post 71 karma points
    7 days ago
    Benjamin Myers
    0

    We are using Umbraco 7.4.2 and have it in 4 environments. In our test and staging environments the URL Tracker tab loads completely fine but in QA and Production the window comes up and a spinner just sits there and never loads.

    Has anyone else seen this behavior?

    How can I fix this?

  • Marc Goodson 781 posts 5137 karma points MVP 3x c-trib
    6 days ago
    Marc Goodson
    0

    Hi Benjamin

    Have a look in the icUrlTracker database table on production... how many rows have you got?

    if you have UrlTracker setup to track every 404 requests to the site, this can build up over time, in the order of millions, and then the backoffice dashboard times out over the connection string trying to read them.

    You can turn off this functionality in the config

    <add key="urlTracker:404UrlsToIgnore" value="wp-login.php" />
    <add key="urlTracker:notFoundTrackingDisabled" value="true" />
    

    and delete any existing 404 tracked entries if you are not actually making use of them, you can use iis logs if you have interest in which pages 404, or run a Xenu link checker etc to hunt for 404s

    If this is the case, and you do end up deleting millions of rows in the table, it will be worth checking for any fragmented indexes in the db table: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-2017

    regards

    Marc

Please Sign in or register to post replies

Write your reply to:

Draft