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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.