Path Analyzer 8.1 will rebuild data on startup

  • During the initial launch of Sitecore XP 8.1 instance, Path Analyzer will attempt to rebuild data for all maps approximately 1 minute after the startup.

    While this does not cause any issues on clean installation, since XDB is empty, it may cause unnecessary rebuild if you modify the ConnectionStrings.config file just in time before the initial startup.

  • Execute the following SELECT statement on the TreeDefinitions table to see if any records have status 0 ('New'):

    select * from [TreeDefinitions] where [Status] = 0

    If you get results, please follow the steps in Solution 1 below.

    If the query returns no results, then check the following:

    select * from [TreeDefinitions]

    If you see any records with the value in the Status column '1' or '2', that means that it's too late to apply the Solution 1
    below, as the rebuild process already started.

    If you have a lot of data in xDB, this may not be desired, and you may want to stop this process. Follow Solution 2 instead.

  • Please run the following SQL script on any reporting database connected to your Sitecore XP 8.1 instance (in case if you have primary and secondary reporting databases configured) prior to the initial startup of the application:

    update [TreeDefinitions] set [Status] = 3 WHERE [Status] = 0

  • Follow these steps:

    1. Perform iisreset on the Sitecore instance that's doing processing.
    2. Execute the following statement:

      update [TreeDefinitions] set [Status] = 3

    3. In MongoDb, locate tracking_live database and delete everything from the TaskQueue collection, if it exists.
    4. In MongoDb, locate tracking_live database and delete everything from the TaskQueue collection, if it exists.
    5. If after a while, some records in the TreeDefinitions table get updated with status "-1", re-run step #2.

Applies to:

CMS 8.1

October 20, 2015
October 20, 2015