Exception when executing agent pathAnalyzer/mapRebuildStatusCheckerAgent


Description

In Sitecore XP 9.0 Initial Release or later, the deployed Path Analyzer maps are stored in a different format. This might result in errors in log records similar to the following:
ERROR Exception when executing agent pathAnalyzer/mapRebuildStatusCheckerAgent
Exception: System.AggregateException
Message: One or more errors occurred.
Source: mscorlib
   at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
   at Sitecore.PathAnalyzer.Processing.Agents.MapRebuildStatusCheckerAgent.<GetDefinitionsWithUpdatedStatus>d__8.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Sitecore.PathAnalyzer.Processing.Agents.MapRebuildStatusCheckerAgent.Execute()
   at Sitecore.Analytics.Core.BackgroundService.Run()

Solution

To resolve the issue, redeploy the Path Analyzer maps as defined in the Upgrade Guide for your Sitecore XP version, in the Upgrade Path Analyzer (Redeploy the Path Analyzer Maps) section:
  1.  To remove all the data from the TreeDefinitions table, in SQL Server Management Studio, in the Reporting database, run the following command:
    Delete from TreeDefinitions
  2. In Sitecore XP, open the admin page of the Path Analyzer at /sitecore/admin/pathanalyzer.aspx.
  3. In the Maps Manager section, click Deploy all maps that are not deployed.