7

I'm running Sitecore 8.1 Update 1 and am trying to get the basic built in Experience Analytics working. However I am getting an error on all the graphs such as

The OnlineInteractionsByVisitsAndValuePerVisit graph cannot be displayed due to a server error. Contact you system administrator

After looking at the logs, I am getting errors such as the ones below:

15196 12:00:55 ERROR [Experience Analytics]: Could not find segment '786fba3a-4573-445e-a745-04e3ca5e48c1'
15196 12:00:55 ERROR [Experience Analytics]: Failed to construct segment from data row - Sitecore.ExperienceAnalytics.Api.NotFoundException: Could not find segment '786fba3a-4573-445e-a745-04e3ca5e48c1'
   at Sitecore.ExperienceAnalytics.Core.Repositories.LocalSegmentDefinitionService.GetSegmentTitle(Guid segmentId)
   at Sitecore.ExperienceAnalytics.Core.Repositories.LocalSegmentDefinitionService.CreateEntityFromReader(IDataRecord reader)
15196 12:00:55 ERROR [Experience Analytics]: Could not find segment 'dc0db760-b0f5-4690-b9eb-1bbf7a4f7bd1'
15196 12:00:55 ERROR [Experience Analytics]: Failed to construct segment from data row - Sitecore.ExperienceAnalytics.Api.NotFoundException: Could not find segment 'dc0db760-b0f5-4690-b9eb-1bbf7a4f7bd1'
   at Sitecore.ExperienceAnalytics.Core.Repositories.LocalSegmentDefinitionService.GetSegmentTitle(Guid segmentId)
   at Sitecore.ExperienceAnalytics.Core.Repositories.LocalSegmentDefinitionService.CreateEntityFromReader(IDataRecord reader)
15196 12:17:56 INFO  [Experience Analytics]: Reduce agent found zero segments to process

I have tried to follow the common steps, such as the ones below and I also tried the ones suggested by Sitecore (https://kb.sitecore.net/articles/977445) but nothing resolved the problem. The only thing, I can think of is may be MongoDB doesn't have access to the reporting DB in SQL, but I didn't see anything called out that it needed special permissions.

  • redeploy segments setting the deploy date to a much earlier time (a year ago)
  • rebuilding the reporting database
  • cleared browser cache
  • checked the mongodb shows data (and it correctly showing page visits in interactions collection)
  • checked that my reporting db does contain segments
  • Can you find the items dc0db760-b0f5-4690-b9eb-1bbf7a4f7bd1 and 786fba3a-4573-445e-a745-04e3ca5e48c1 in the master database? – Hishaam Namooya Jun 11 '17 at 19:44
  • Seems like the marketing segments that are in the analytics dB are somehow not the right ones (as in, matching with master), or are not accessible perhaps. I realise you said you checked this, but that is what the error indicates. – Richard Hauer Jun 11 '17 at 22:11
  • Is it possible for you to rebuild reporting database using /sitecore/admin/RebuildReportingDB.aspx? – grg Jun 12 '17 at 13:30
  • Yes, those two segments show up in the reporting database segments table and I am able to rebuiling the reporting database. – Chris Jun 13 '17 at 3:16
  • @Chris Were you able to get past this? – Pete Navarra Dec 6 '17 at 4:53

Your Answer

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

Browse other questions tagged or ask your own question.