Openemm 2015 R2 Recipient Overview Empty

[dwhitehead]

We have a large recipient table, and up until a recent import, it has always shown up and paged appropriately. Now, we are noticing two problems:

1. The text at the top of the Recipients Overview is not updating with the max recipients value in the properties file.
2. We get no recipients shown, regardless of the list (or any other criteria) we select. We have even done an advanced search with just email address to test and it still returns no records.

Screenshot

[dwhitehead]

Update: It doesn't look like the recipient overview page is not even making a request to the database.

[maschoff]

Your screenshot is not accessable.

[dwhitehead]

http://www.donaldwhitehead.com/images/2 ... erview.png

I fixed #1, but #2 is still broken.

[maschoff]

Am I right that you increased the max value of an selection from 10,000 to 100,000? In this case the query for the selection may take a very long time (especially if you miss the right indices) and you will run into a timeout, so that no data is displayed at all.

[dwhitehead]

I would normally agree, but I was watching the MySQL DB and it doesn't appear that the query is even being called. I do not see a spike on the server consistent with a query timeout.