Page 1 of 1

Openemm 2015 R2 Recipient Overview Empty

Posted: Wed Sep 16, 2015 2:24 pm
by 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

Re: Openemm 2015 R2 Recipient Overview Empty

Posted: Thu Sep 17, 2015 6:25 pm
by dwhitehead
Update: It doesn't look like the recipient overview page is not even making a request to the database.

Re: Openemm 2015 R2 Recipient Overview Empty

Posted: Fri Sep 18, 2015 12:01 pm
by maschoff
Your screenshot is not accessable.

Re: Openemm 2015 R2 Recipient Overview Empty

Posted: Fri Sep 18, 2015 4:43 pm
by dwhitehead
http://www.donaldwhitehead.com/images/2 ... erview.png

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

Re: Openemm 2015 R2 Recipient Overview Empty

Posted: Fri Sep 18, 2015 4:51 pm
by 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.

Re: Openemm 2015 R2 Recipient Overview Empty

Posted: Fri Sep 18, 2015 5:56 pm
by 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.