504 Gateway timeout for reports

Hi All,

When we are configuring a pivot table, we observed that when there are too many indicators, report times out with a ‘504 Gateway Time-out’ imposed by chrome browser. The time-out limit set by chrome browser is 1 minute. Because of this issue we are unable to configure tables with many indicators.

How can we fix this issue? Is there any workaround ?

PFA the screenshot for the error.


···

ThanksShashank RaghavendraBusiness Analyst
Skype shashank.raghavendra

Telephone
+91 9632802392

ThoughtWorks

Hi Shashank ,

This is an nginx /tomcat timeout, not something intrinsic to the browser. You can try and increase the Nginx timeouts for this with proxy_connect_timeout, proxy_send_timeout, etc. as described in the nginx documentation on your DHIS2 server. You may also need to request less data, or increase the size of your server, optimize the database, etc to speed things up. In general though, this is looks like the usual “asking for too much data” problem which can be a more general problem. Even if you manage to avoid the 504, you may return too much data to the browser, resulting in an “Aww snap” message, or worse, choking the server. The pivot tables are not designed to handle large data sets. By large, its a bit subjective and depends on many things, but if you see these issues, I would try and break down the pivots into smaller, more manageable pieces if possible.

Regards,

Jason

image

···

On Tue, Mar 1, 2016 at 2:51 PM, Shashank Raghavendra shashanr@thoughtworks.com wrote:

Hi All,

When we are configuring a pivot table, we observed that when there are too many indicators, report times out with a ‘504 Gateway Time-out’ imposed by chrome browser. The time-out limit set by chrome browser is 1 minute. Because of this issue we are unable to configure tables with many indicators.

How can we fix this issue? Is there any workaround ?

PFA the screenshot for the error.

ThanksShashank RaghavendraBusiness Analyst
Skype shashank.raghavendra

Telephone
+91 9632802392

ThoughtWorks


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Hello there,

I’m experiencing the same issue, and I can’t track the error on the log files since nothing is logged when I try to load the report.

I’m on running tomcat 9 on a linux server. Which configurations can I tweak with for the report to be printable on the screen?

Hello! Is there any response on the above?

1 Like

Hey @lillian1n2

Please try these suggestions:

Thanks!