Sitecore Analytics Issues and Troubleshooting

After migrating an application from the SharePoint platform to Sitecore, observed that Marketing Applications such as Experience Analytics, Experience Profile, and Path Analyzer do not display data or an error.

Experience Profile:

Experience Analytics:

Path Analyzer:

There can be multiple reasons behind this issue. Any one of these reasons could be the cause, or several might apply to your situation. In this blog post, I will discuss all the possible reasons and provide troubleshooting steps to help you capture and view the Analytics data in Sitecore.

1. Certification Issue:

For a deeper exploration of this topic, I have written a separate blog post that addresses this issue in detail. You can find the blog post here: Sitecore Analytics: The Certificate was not Found

2. Experience Profile does not display Data:

After addressing the Certification Issue, I can see the analytics data in my Shard0 and Shard1 databases but contact is not displaying in the Experience Profile.

I have checked the log files again and AI (Application Insight) on Azure PaaS and found the following exception:

To resolve this issue, see the blog post: Sitecore xDB Sync token is no longer valid for the [Contacts] Table.

3. Rebuild Reporting Database:

Go to the Dashboard, select Control Panel, choose Administration Tool under the Administration section, and click on Rebuild Reporting Databases:

Or browse the URL https://{your-sitecore-instance}/sitecore/admin/RebuildReportingDB.aspx and if you find any error and issue like below:

I am getting an issue "Could not load file or assembly 'System.Data.SqlClient, Version=4.6.1.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies." error on opening RebuildReportingDB.aspx admin page.

Solution:

Considering these points, I suspected an issue with the Processing server. My examination of the error logs revealed numerous exceptions, as detailed below:

This error points to why the processing agents have failed to process the data, leading to an increase in the processing pool numbers. Since the RebuildReportingDB.aspx admin page relies on data from the PRC server.

I inspected the 'bin' directory on my Azure Sitecore processing app service and found that the current version of System.Data.SqlClient.dll in use is 4.6.1.5.

However, the dependency bindings in the processing server's web.config file are set to version 4.6.1.1:

To address this, I have updated the dependency binding version for System.Data.SqlClient.dll on the PRC server to 4.6.1.5 in its web.config. The updated binding should look like the following:

The System.Data.SqlClient.dll assembly used seemed to be the correct version, and the <dependencyBinding>  configuration also seemed to be correct.

4. Experience Analytics and Path Analyzer do not display Data:

In regard to the above issues, you need to use the "Deploy Marketing Definitions" feature in the Control Pane and redeploy the marketing definition again.

Click Control Panel, navigate to the ANALYTICS section, and click Deploy marketing definitions. In the Deploy marketing definitions dialog box, select all the checkboxes and click Deploy.

See the documentation for more information: Deploy all marketing definitions

5. Other Blog Post Reference: 

• Display Anonymous Contacts in Sitecore Experience Profile
• Monitoring the Sitecore xDB Index Rebuild Process

Happy Sitecoreing 😊