Analytics Error
ASP.NET

Sitecore 9 – Error While Displaying Experience Analytics Data

Issue

Unable to display the Experience Analytics data in sitecore9. Having tried rebuilding the reporting database, this blog helped me find the root cause and solution for the issue which is Xdb refuses to connect with 403 status code.

Error in Experience Analytics
Error in Experience Analytics
Error in Experience Profile
Error in Experience Profile

Logs

Sitecore Logs Experience Analytics
Sitecore Logs Experience Analytics

Reason

IIS logs of Xconnect site show a 403.16 status code which is a client certificate trust issue due to the Presence of Non Self Signed Certificates in Trusted Root certificates.

XConnect IIS Logs
XConnect IIS Logs

Solution

Move the non Self signed certificates from Trusted Root Certificate Authorities using the following powershell command into Intermediate Certification Authorities.

 

Alternatively you can delete the Non-SSL certificate from root using the following powershell command

 

Note: No information is logged about this error in the Xconnect logs, the error is logged in the IIS logs of Xconnect.

IIS Xconnect logs after removal of non SSL certificates from Trsuted Root Certificates
IIS Xconnect logs after removal of non SSL certificates from Trsuted Root Certificates
Experience Analytics dashboard after removal of Non SSL Certificates from Trusted Root Certificates
Experience Analytics dashboard after removal of Non SSL Certificates from Trusted Root Certificates

About The Author

Leave a Reply

*