We are seeing an issue where the majority of a our lists counts now just show counts of "pending". 1 out of 10 refreshes will shows 50% of the lists with counts but with another refresh almost all go back to a count of "Pending". indexer shows no errors, xConnect shows no errors. Any thoughts on what is going on?
This is caused by a combination of a couple of things.
- A large xDB contact database (60+ million).
- The need to execute a segmentation rule against that database.
- The need to execute a lot of segmentation rules at the same time (because you are looking at a list of segmentation lists so the rule has to run for all it is trying to show in the UI).
All this together means the system (SOLR) cannot execute and return the counts of all the lists with their segmentation rules applied fast enough to provide a count to the UI. So far the only answer has been a smaller database or bigger hardware.