Support

Home Forums Event Espresso Premium Filtered Registration Report Error

Filtered Registration Report Error

Posted: October 15, 2019 at 2:50 am


mpurse

October 15, 2019 at 2:50 am

I need to regularly download monthly registration for financial reports. However whenever I try I get an error message “502 Bad Gateway
The server returned an invalid or incomplete response.”

I can successfully download unfiltered reports but as we’ve been using EE for 8 years there are thousands of registrations to filter through after download to get the monthly sales figures.

It’s not a new problem – happened since we started but I really need to streamline our workflow now and find a fix.


Tony

  • Support Staff

October 15, 2019 at 4:24 am

Hi there,

502 Bad Gateway

In short means your server couldn’t handle the request, which is often due to the server being overloaded or the host blocking the request.

May I ask what specific filtered report are you doing?

Can you add the steps you take to get the filtered report that you want right up to clicking the filtered report button. I’ll check the specifics of the request your using and go from there.

Also, when you run an export do you see the report being constructed in batches or do you click the button, the browser takes a little and then starts downloading a file?


mpurse

October 15, 2019 at 6:25 am

I am viewing registrations, then filtering by a specific month.
Then I clicked the “Filtered CSV report”, which is when I get the error.

I can download the “All registrations CSV Report” but it takes ages because we have thousands of results going back several years.


Tony

  • Support Staff

October 15, 2019 at 6:48 am

Also, when you run an export do you see the report being constructed in batches or do you click the button, the browser takes a little and then starts downloading a file?


mpurse

October 15, 2019 at 6:48 am

Nope, straight to error page


Tony

  • Support Staff

October 15, 2019 at 6:58 am

What about the report that works? Does that go to a batch process or download the file on the same request?

I’m trying to work out if your system is using the batch method, so it looks like this: https://monosnap.com/file/WInYnS7r6Nchqab6gE7D58VPWqZyPW

Then the file is sent to the browser (meaning the download starts) after the batch process.

Or when you click the report, does it just download.

Again, I’m referring to the working report here, not the report that throws an error.


mpurse

October 15, 2019 at 7:01 am

The one that works uses batch processing as per your screen shot.


Tony

  • Support Staff

October 15, 2019 at 8:33 am

Ok, so I suspect your host is blocking the request.

I’d recommend checking in with your host and have them confirm this, the main difference between the all registrations report and the filtred registration button is that when you click that button passes over all of the filters on the page, not just the filter(s) set (because the link doesn’t know what filters are set) but all of them, then client code determines what it needs to do from there.

That means that the filtered link is much longer than the ‘normal’ report, for example, the all registration line report on one of my test sites is 1166 chars long.

The filtered registration report link is 2337 chars long and I suspect thats causing an issue here.

Have you checked the servers error logs to see if anything more shows up there? 502 errors are difficult to troubleshoot without the error being thrown.


mpurse

October 15, 2019 at 9:18 am

Ah ha. Ok, am going to chat with our server hosts then. Thanks for the insight, that gives us something to work with.


Tony

  • Support Staff

October 16, 2019 at 4:08 am

You’re most welcome.

Please do keep us updated, I’m interested in what the cause is.

The support post ‘Filtered Registration Report Error’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso