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.
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.
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
URL Tracker
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?
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
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
Thanks, Marc! This worked like a charm!
is working on a reply...