AnswerBun.com

Error occurred while loading Experience Profile

Sitecore Asked by SumitK on October 20, 2020

I am facing an issue where the error is occurring while loading the Experience Profile.

I am working on Sitecore 9.0.2 version.

Error is shown as below:-
enter image description here

When I hit the Sitecore API URL as shown in the console, I found the below error:-

enter image description here

Below is the Sitecore logs for reference

26452 15:16:16 ERROR [Sitecore Services]: HTTP POST
URL https://mysite.local/sitecore/api/ao/v1/contacts/search?&pageSize=20&pageNumber=1&sort=visitCount desc&Match=*&FromDate=15%2F05%2F2019&ToDate=14%2F06%2F2019

Exception System.NullReferenceException: Object reference not set to an instance of an object.
   at Sitecore.Cintel.Endpoint.Plumbing.NegotiateLanguageFilter.OnActionExecuted(HttpActionExecutedContext actionExecutedContext)
   at System.Web.Http.Filters.ActionFilterAttribute.OnActionExecutedAsync(HttpActionExecutedContext actionExecutedContext, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()

Any help is much appreciated.

One Answer

Just ran into this issue. Planning on writing a blog for this. But here is the shorter version.

On CM, the error you see is not super helpful. But, as others mentioned, it is related to the certificate. In my case, the problem is due to the SolrCloud certificate. I have used self-signed for our requirement.

The issue originates from Xconnect-search (if you are using XP0, all XConnect roles will be in the same app, unlike in scaled where you can deploy Xconnect-search as a separate app). Assuming you are using a self-signed certificate for Solr (it is mandatory to run Solr in https mode with SSL certificate), we need to allow that Thumbprint in XConnect search.

In my case, though I entered it in App_Data/jobs/continuous/IndexWorker/App_data/config/sitecore/CollectionSearch/sc.Xdb.Collection.WebClient.SOLR.xml I still kept receiving this error.

<Sitecore>
    <XConnect>
      <CollectionSearch>
        <Services>
            <ISolrWebClientFactory>
                <Type>Sitecore.Xdb.Collection.Search.Solr.SolrWebClientFactory, Sitecore.Xdb.Collection.Search.Solr</Type>
                <As>Sitecore.Xdb.Collection.Search.Solr.IWebClientFactory, Sitecore.Xdb.Collection.Search.Solr</As>
                <LifeTime>Singleton</LifeTime>
                <Options>
                   <AcceptCertificates>
                     <thumbprint1>‎69 3b 2x xx xx xx xx 4e 3a 4d fc 2e 9e 2d 92 8c c7 af 5b 6a</thumbprint1>
                     <SolrCloud>693B2XXXXXXXXXXXX4E3A4DFC2E9E2D928CC7AF5B6A</SolrCloud>                  
                   </AcceptCertificates>
                </Options>
            </ISolrWebClientFactory>
        </Services>
      </CollectionSearch>
    </XConnect>
  </Sitecore>

So, I ended up duplicating the thumbprints in App_Data/Config/Sitecore/CollectionSearch/sc.Xdb.Collection.WebClient.SOLR.xml also. And this resolved the issue.

After spending some time trying to understand how XConnect is loading the XML configuration files, it is still a puzzle to crack why I need to add the thumbprint outside of indexingworker job.

Hope this will help others resolve this issue. By the way, this problem occurs in 9.1 update 1 also.

Answered by phani on October 20, 2020

Add your own answers!

Related Questions

Using WFFM 9.0 rev. 180503 with Sitecore 9.1

1  Asked on August 23, 2021 by david-masters

   

Can not install Sitecore.CLI for Sitecore 10

1  Asked on February 21, 2021 by nikola-kramaric

   

How to become a Sitecore MVP?

3  Asked on February 10, 2021 by tamas-varga-sitecore

   

Azure Deploy of CM + Reporting

2  Asked on February 6, 2021 by dave-g

     

Get Sitecore From submission attempts

1  Asked on January 12, 2021 by mohamed-yaseen

     

Ask a Question

Get help from others!

© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP