Re: [Dhis2-users] [Dhis2-devs] Problem with GIS: Facility layer
Hi Hannan, can I please have a temporary username/password to your instance? Makes it a lot easier for me to detect the problem. Jan On Sun, Sep 15, 2013 at 1:13 PM, Hannan Khan hann...@gmail.com wrote: Dear Experts In our live server the point layers are not displaying the facilities, instead it gives us the message coordinates could not be loaded. Please check the attached file. The coordinated of the facility layers are in the database (12185 out of 26103). The test server has the same data up to August. But the facility layer is working properly in the test servers. The organisationunit table has the same data. I attached the part of a log file. Can you please suggests how can I solve this problem. Regards Hannan ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Standard iReports cache problem
The nginx server in Rwanda is caching. Another approach might be to clear specific elements from the nginx cache, rather than to clear the entire cache, though this would require some communication between front end users and back end administrators which would probably be too cumbersome in practice. I wonder if it could be possible to automate this ... ie iterate through all reports in the cache and remove them if that report has been updated in the database. And run that every 5 minutes ... On 13 September 2013 14:45, Jason Pickering jason.p.picker...@gmail.comwrote: Hi Lars, I am not sure that completely removing the cache would be required. As Lars points out, it is very helpful to have it, so would try and avoid that if all possible. Of course, if you have not enabled caching, this mail is a bit pointless! I think one solution would be to cache everything, except the report which you do not want to cache. This would require a bit more complex nginx setup, but it should certainly be possible. You could simply define a location with a regular expression corresponding to the report URL, and tell nginx not to cache it. Other reports, which could be cached, might have another location. You can see something like that in the implementation docshttp://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s03.html#d5e591, which specify two different strategies for caching different types of resources. Not sure if it will work. Have not tried, but it might be worth a shot. Regards, Jason On Fri, Sep 13, 2013 at 7:40 PM, Lars Helge Øverland larshe...@gmail.comwrote: Hi Randy, this might be caused by a web server cache, ie. nginx/apache caching content on the server. In that case it does not help to refresh the browser cache. These changes to your report will become available tomorrow morning. Caching for anlaytics/reports is controlled under system settings - general - cache strategy (assuming this is set to 6 am next morning). When developing reports this can be a bit inconvenient. This is a weakness with ireport and developing reports directly on the production server in general. Some fixes: - Disable server side caching. - Disable caching in dhis. - Refresh cache on the server on demand. All of these are bad in the sense that it will make end-users wait longer for reports and the server to get increased load. cheers Lars On Fri, Sep 13, 2013 at 2:47 PM, Wilson,Randy rwil...@msh.org wrote: We’re using a lot of new iReports in the Standard reports and they seem to be working well, but there seems to be a serious caching problem. I have a report listing health facilities that I ran this morning, now I’ve added 10 more facilities and they don’t appear in the list…. Though they do appear in the iReport preview screen. I’ve cleared my local cache and even the cache statistics in Data Administration, but I can’t get the new facilities to display. ** ** Any suggestions about how end users can force a cache refresh before running the report? It is critical that this report shows the most up-to date information as we use it to determine the next health facility ID code to assign when creating new organization units. ** ** *Randy Wilson* ** ** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Standard iReports cache problem
Perhaps, but for this use case five minutes may not be enough. The point is that this report should not be cached at all. How would you propose to write a script to clean out these specific resources from the cache, and leave everything else? Seems not so straightforward to me. Considering it is rather trivial to implement this in nginx by creating a different location which would not be cached, I am not convinced some script to clean up the mess is such a good idea. It would seem some script which would be triggered every X minutes would be quite un-eco-friendly, when these resources should have never been cahced to begin with? Perhaps the real fix would be to allow the report creators to specify whether the report should be cached or not cached? On Sun, Sep 15, 2013 at 5:14 PM, Bob Jolliffe bobjolli...@gmail.com wrote: The nginx server in Rwanda is caching. Another approach might be to clear specific elements from the nginx cache, rather than to clear the entire cache, though this would require some communication between front end users and back end administrators which would probably be too cumbersome in practice. I wonder if it could be possible to automate this ... ie iterate through all reports in the cache and remove them if that report has been updated in the database. And run that every 5 minutes ... On 13 September 2013 14:45, Jason Pickering jason.p.picker...@gmail.comwrote: Hi Lars, I am not sure that completely removing the cache would be required. As Lars points out, it is very helpful to have it, so would try and avoid that if all possible. Of course, if you have not enabled caching, this mail is a bit pointless! I think one solution would be to cache everything, except the report which you do not want to cache. This would require a bit more complex nginx setup, but it should certainly be possible. You could simply define a location with a regular expression corresponding to the report URL, and tell nginx not to cache it. Other reports, which could be cached, might have another location. You can see something like that in the implementation docshttp://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s03.html#d5e591, which specify two different strategies for caching different types of resources. Not sure if it will work. Have not tried, but it might be worth a shot. Regards, Jason On Fri, Sep 13, 2013 at 7:40 PM, Lars Helge Øverland larshe...@gmail.com wrote: Hi Randy, this might be caused by a web server cache, ie. nginx/apache caching content on the server. In that case it does not help to refresh the browser cache. These changes to your report will become available tomorrow morning. Caching for anlaytics/reports is controlled under system settings - general - cache strategy (assuming this is set to 6 am next morning). When developing reports this can be a bit inconvenient. This is a weakness with ireport and developing reports directly on the production server in general. Some fixes: - Disable server side caching. - Disable caching in dhis. - Refresh cache on the server on demand. All of these are bad in the sense that it will make end-users wait longer for reports and the server to get increased load. cheers Lars On Fri, Sep 13, 2013 at 2:47 PM, Wilson,Randy rwil...@msh.org wrote: We’re using a lot of new iReports in the Standard reports and they seem to be working well, but there seems to be a serious caching problem. I have a report listing health facilities that I ran this morning, now I’ve added 10 more facilities and they don’t appear in the list…. Though they do appear in the iReport preview screen. I’ve cleared my local cache and even the cache statistics in Data Administration, but I can’t get the new facilities to display. ** ** Any suggestions about how end users can force a cache refresh before running the report? It is critical that this report shows the most up-to date information as we use it to determine the next health facility ID code to assign when creating new organization units. ** ** *Randy Wilson* ** ** ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post
Re: [Dhis2-users] Standard iReports cache problem
I think the simplest would be if we created a query param disableCache=false|true , which could be appended to the report URL manually during development phase. If true, DHIS would set a no-cache header on the response, disallowing any cache to store it. ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Standard iReports cache problem
Of course that doesn't fix the problem with the constantly updated report (unless you create a Resource and points it to that Report including that query param). If this is a special case for just one report then I guess Jason's suggestion on a special nginx location would be feasible. We could implement a system feature but that will take longer. ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp