I'm using Sitecore 9.0.1 and I'm following the Troubleshooting xDB data issues guide. My scenario is #2 where data is being collected but I see nothing on the Experience Analytics reports (there's some old data from months ago but not current data).

Scenario 2 Step 3 asks us to "Ensure that the Segments table of the reporting SQL database is not empty" and my Segments table is empty. To populate this table I read that I should run the Control Panel > Analytics > Deploy marketing definitions option, but after running this and checking the table it's still empty :(

Why is it that the Segments table is not being populated? Anyone has any workaround for this? I'm out of options and without data on this table I've read that the reports will not show up. I get no error on the CM logs or on the PROC logs.

Sitecore.NET 9.0.1 (rev. 171219)
December 19, 2017
.NET Framework 4.0.30319.42000
  • I'd recommend rebuilding your reporting db. Jan 20, 2019 at 2:38
  • Hello Mark, I've tried that but for some reason rebuilding the reporting db always gets stuck somewhere and slows down to few items per second. Jan 25, 2019 at 0:05
  • You definitely need to fix that. There is a known issue in 9.0.1 with CES service causing slow down. Patch available on kb website. Jan 25, 2019 at 22:18
  • I'm facing the same problem here and tried deploying marketing definitions and rebuild the reporting database and it doesn't work, same sitecore version 9.0.1 (rev. 171219) any update what to do else here? Jan 31, 2019 at 6:23
  • Hello there, I was informed by Sitecore that the table for version 9.0.1 is on the ReferenceData database and it's now called 'Definitions' Feb 6, 2019 at 12:19

1 Answer 1


I was informed by Sitecore that the table for version 9.0.1 is now on the ReferenceData database and it's called Definitions.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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