1

This is a follow up on this question Experience Analytics fails on Sitecore 9.0.1 that does not appear to have a solution.

The issue at hand is:

Exception: System.InvalidOperationException Message: The certificate was not found. Source: Sitecore.Xdb.Common.Web

I find several articles articles on troubleshooting that have not really assisted me. In the articles, it appears that other developers like myself are spending hours troubleshooting this and probably also like me are taking guesses as to why it fails.

Does anyone have a reliable set of troubleshooting steps for this issue? Or a reliable way of setting this up?

7

Check the following possible areas to figure this out

  1. Make sure thumbprint on the key xconnect.collection.certificate in connection string config file matches with the thumbprint found in corresponding xconnect site App config(C:\inetpub\wwwroot\site.xconnect\App_Config).
  2. Verify the thumbprint of xconnect client matches with the thumbprint provided in connection string of the site and app config(path provided in step 1) of xConnect site. enter image description here

  3. Verfiy that the xConnect site works and navigating to xConnect site using https does not shw any error.(valid https certificate is shown?).

  4. Verify if connection string(connectionstring.config) key xconnect.collection and all other xconnect related keys are pointed to correct xConnect site.
  • I had the same problem. The thumbprint that was in the config file was incorrect. I would also add that if the thumbprint is wrong in the appsettings for the xconnect website, that it might also be wrong in the config files for the services located under C:\inetpub\wwwroot\site.xconnect\app_data\jobs. The services will fail to start if the the specified certificate is invalid. – Mikeyp Jan 30 at 19:23
  • I ended up cleaning my machine and doing an install from scratch. This got me past the certificate not found, but I was stopped at step 3 in the answer. Turned out the certificate was not on site binding. I added that which got me further, but then I ran into Forbidden Source: Sitecore.Xdb.Common.Web. I used this article sitecorecorner.com/2017/10/25/… to get through that. – Jonathan Folland Jan 31 at 0:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.