Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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?
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
Thanks, Marc! This worked like a charm!
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted