Posted: 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 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. |
|
Hi there,
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? |
|
I am viewing registrations, then filtering by a specific month. I can download the “All registrations CSV Report” but it takes ages because we have thousands of results going back several years. |
|
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? |
|
Nope, straight to error page |
|
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. |
|
The one that works uses batch processing as per your screen shot. |
|
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. |
|
Ah ha. Ok, am going to chat with our server hosts then. Thanks for the insight, that gives us something to work with. |
|
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.