Errors on Sitecore Experience Analytics Dashboard

The purpose of this blog is to consolidate the analysis made to understand and fix the below errors which occur while accessing the Sitecore Experience Analytics Dashboard.

 

 

1. Xconnect certificates are the most important to communicate with the xconnect site for analytics data. First thing is to check if the certificates are present and valid in the server. If it is invalid or expired, we need to generate those and assign it to the site bindings.

2. Check if the xconnect site is accessible through HTTPS. In my case, it failed and hence I generated the xconnect cert.

3. Check for any errors in console. If there are server errors while connecting to the xconnect services this would be a client certificate trust issue due to the presence of Non self signed certificates in Trusted Root certificates. In this case, identify the untrusted certificates and move them to Immediate Certification Authorities. Alternatively, delete the Non-SSL certificate from Root.

4. Check if the following sitecore services are running
a. {siteprefix}.xconnect-IndexWorker
b. {siteprefix}.xconnect-MarketingAutomationService
Tried restarting these services and make sure there is no issue while running.

5. Check if xDB is enabled in the configuration file in the path
C:\inetpub\wwwroot\{site}\App_Config\Sitecore\Marketing.xDB\Sitecore.Xdb.config
Check if the value assigned to the setting Xdb.Enabled is true. If not, change the value to true.

6. Try changing the Application Pool Identity of the xconnect site to Network Service in IIS-> Application Pools-> corresponding xconnect->Advanced settings->App Pool Identity

7. Assign Read permission to Network Service in the self-signed certificates.

8. Check the ConnectionStrings.config and verified the xconnect site url for the below settings
xconnect.collection
xdb.referencedata.client
xdb.marketingautomation.reporting.client
xdb.marketingautomation.operations.client settings

9. Verify the thumbprint value for all the client certificate references configured in ConnectionStrings.config file and it should match the certificate found in MMC.

10. Experience Analytics relies on the Reporting Server of Sitecore and the Reference Data service of xConnect. Check if these are accessible and if the reporting and collection databases are accessible via sitecore shell.

11. Examine the xConnect Reference Data service logs.

12. Verify the IIS access logs to identify server issues if any.

13. Make sure if the collectionuser have required rights on Shard databases.

I hope these investigations will help you to fix the issues on Experience Analytics Dashboard.

Thanks for reading.. Let's TRAVEL WITH SITECORE...