[Dhis2-users] DHIS2 - Caching testing
Hi all, I'm currently testing some final adjustments, however there's somewhere a caching preventing me from seeing the last updates right away in my browser. I tried deleting both browser caching and DHIS2 caching (via Maintenance module) and that for Google Chrome, Mozilla, and IE. Generally, this is what I noticed (especially with respect to modifications in data entry templates): 1. Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser. 2. Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago. 3. IE: Idem as Mozilla. From where my question: which browser caching methods do you use for development? Regards, Robin ___ 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] Tracker - Patient dashboard problem
Thanks Tran, It is working with that correction. Sumudu On Wed, Sep 17, 2014 at 6:13 AM, Tran Chau tran.hispviet...@gmail.com wrote: Hi Sumudu, I am sorry I sent wrong statements by mistake. The *status *column should be change to* varchar(25)*. Could you please run the statements below and re-start tomcat ? *ALTER TABLE programstageinstance MODIFY status varchar(25);* *UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';* *UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';* *UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';* Best regards, Châu Thu Trân HISP Viet Nam Email: tran.hispviet...@gmail.com On Tue, Sep 16, 2014 at 10:37 PM, sumudu weerasinghe sumudu...@gmail.com wrote: Hi Tran, I tried it but there is error in some query. My database status is a integer. I got following error? *mysql ALTER TABLE programstageinstance MODIFY status INTEGER;Query OK, 0 rows affected (0.10 sec)Records: 0 Duplicates: 0 Warnings: 0mysql UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';ERROR 1366 (HY000): Incorrect integer value: 'ACTIVE' for column 'status' at row 2mysql UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';ERROR 1366 (HY000): Incorrect integer value: 'COMPLETED' for column 'status' atrow 1mysql UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';Query OK, 0 rows affected (0.00 sec)Rows matched: 0 Changed: 0 Warnings: 0mysql* Sumudu On Tue, Sep 16, 2014 at 7:47 PM, Tran Chau tran.hispviet...@gmail.com wrote: Hi Sumudu, Could you please run these statements below in your database directly to fix this bug ? Then restart tomcat again ? *ALTER TABLE programstageinstance MODIFY status INTEGER;* *UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';* *UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';* *UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';* Best regards, Châu Thu Trân HISP Viet Nam Email: tran.hispviet...@gmail.com On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe sumudu...@gmail.com wrote: Sorry, my system detail as follow *Version: 2.16**Build revision:16414**Database type:MySQL* *Java version:1.7.0_04**OS name:Windows 7* On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe sumudu...@gmail.com wrote: Dear all , I have updated my instance from 2.15 to 2.16 over the old mysql database. Then i list the clinic patient . But it was unable to go for patient dashboard through the list and give error as exception occur (shown in screen shot). Log also show some error. Log and screenshots are attached here. Regards, Sumudu ___ 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] [Dhis2-devs] DHIS2 - Caching testing
Hi Robin, with caching, are you referring to data entry forms? If so, those are stored in indexdb / localstorage to support offline capture, which is not cleared by default when clearing cache in most browsers. For development this chrome extension can be recommended: https://chrome.google.com/webstore/detail/clear-cache/cppjkneekbjaeellbfkmgnhonkkjfpdn Go to options and select everything from beginning of time. Lars On Wed, Sep 17, 2014 at 10:25 AM, Robin Martens mart...@sher.be wrote: Hi all, I'm currently testing some final adjustments, however there's somewhere a caching preventing me from seeing the last updates right away in my browser. I tried deleting both browser caching and DHIS2 caching (via Maintenance module) and that for Google Chrome, Mozilla, and IE. Generally, this is what I noticed (especially with respect to modifications in data entry templates): 1. Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser. 2. Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago. 3. IE: Idem as Mozilla. From where my question: which browser caching methods do you use for development? Regards, Robin ___ 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] [Dhis2-devs] DHIS2 - Caching testing
This works great. Thanks, Lars! If it's not yet in there, might be useful to add it to the implementation or user manuals. Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 17 September 2014 11:19 To: Robin Martens Cc: dhis2-users@lists.launchpad.net; DHIS 2 Developers list Subject: Re: [Dhis2-devs] DHIS2 - Caching testing Hi Robin, with caching, are you referring to data entry forms? If so, those are stored in indexdb / localstorage to support offline capture, which is not cleared by default when clearing cache in most browsers. For development this chrome extension can be recommended: https://chrome.google.com/webstore/detail/clear-cache/cppjkneekbjaeellbfkmgnhonkkjfpdn Go to options and select everything from beginning of time. Lars On Wed, Sep 17, 2014 at 10:25 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi all, I'm currently testing some final adjustments, however there's somewhere a caching preventing me from seeing the last updates right away in my browser. I tried deleting both browser caching and DHIS2 caching (via Maintenance module) and that for Google Chrome, Mozilla, and IE. Generally, this is what I noticed (especially with respect to modifications in data entry templates): 1. Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser. 2. Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago. 3. IE: Idem as Mozilla. From where my question: which browser caching methods do you use for development? Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto: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] [Dhis2-devs] DHIS2 - Caching testing
Actually in production, when you do a change to a data set or sections, the form should automatically be re-downloaded to the browser. So the end user should be unaware of this. During development when you hack away in the db etc it's useful to clear everything from the browser. On Wed, Sep 17, 2014 at 11:34 AM, Robin Martens mart...@sher.be wrote: This works great. Thanks, Lars! If it's not yet in there, might be useful to add it to the implementation or user manuals. Robin *From:* Lars Helge Øverland [mailto:larshe...@gmail.com] *Sent:* 17 September 2014 11:19 *To:* Robin Martens *Cc:* dhis2-users@lists.launchpad.net; DHIS 2 Developers list *Subject:* Re: [Dhis2-devs] DHIS2 - Caching testing Hi Robin, with caching, are you referring to data entry forms? If so, those are stored in indexdb / localstorage to support offline capture, which is not cleared by default when clearing cache in most browsers. For development this chrome extension can be recommended: https://chrome.google.com/webstore/detail/clear-cache/cppjkneekbjaeellbfkmgnhonkkjfpdn Go to options and select everything from beginning of time. Lars On Wed, Sep 17, 2014 at 10:25 AM, Robin Martens mart...@sher.be wrote: Hi all, I'm currently testing some final adjustments, however there's somewhere a caching preventing me from seeing the last updates right away in my browser. I tried deleting both browser caching and DHIS2 caching (via Maintenance module) and that for Google Chrome, Mozilla, and IE. Generally, this is what I noticed (especially with respect to modifications in data entry templates): 1. Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser. 2. Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago. 3. IE: Idem as Mozilla. From where my question: which browser caching methods do you use for development? Regards, Robin ___ 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] [Dhis2-devs] DHIS2 - Caching testing
Hi Lars, I'm not sure what you mean, but in my custom data forms for events (which I modify and test through a browser, no database hacking involved), I had this issue of caching. Is this what you meant that shouldn't be happening? Regards, Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 17 September 2014 11:38 To: Robin Martens Cc: dhis2-users@lists.launchpad.net; DHIS 2 Developers list Subject: Re: [Dhis2-devs] DHIS2 - Caching testing Actually in production, when you do a change to a data set or sections, the form should automatically be re-downloaded to the browser. So the end user should be unaware of this. During development when you hack away in the db etc it's useful to clear everything from the browser. On Wed, Sep 17, 2014 at 11:34 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: This works great. Thanks, Lars! If it's not yet in there, might be useful to add it to the implementation or user manuals. Robin From: Lars Helge Øverland [mailto:larshe...@gmail.commailto:larshe...@gmail.com] Sent: 17 September 2014 11:19 To: Robin Martens Cc: dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net; DHIS 2 Developers list Subject: Re: [Dhis2-devs] DHIS2 - Caching testing Hi Robin, with caching, are you referring to data entry forms? If so, those are stored in indexdb / localstorage to support offline capture, which is not cleared by default when clearing cache in most browsers. For development this chrome extension can be recommended: https://chrome.google.com/webstore/detail/clear-cache/cppjkneekbjaeellbfkmgnhonkkjfpdn Go to options and select everything from beginning of time. Lars On Wed, Sep 17, 2014 at 10:25 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi all, I'm currently testing some final adjustments, however there's somewhere a caching preventing me from seeing the last updates right away in my browser. I tried deleting both browser caching and DHIS2 caching (via Maintenance module) and that for Google Chrome, Mozilla, and IE. Generally, this is what I noticed (especially with respect to modifications in data entry templates): 1. Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser. 2. Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago. 3. IE: Idem as Mozilla. From where my question: which browser caching methods do you use for development? Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto: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] Tracker - Patient dashboard problem
Hi Tran, My problem is settle now, but after few minutes it is giving repeated thread of error on log. What is this error? *INFO: [127.0.0.1]:5701 [dev] [3.2.1] memory.used=404.5M, memory.free=90.4M, memory.total=494.9M, memory.max=494.9M, memory.used/total=81.74%, memory.used/max=81.74%, load.process=-100.00%, load.system=-100.00%, load.systemAverage=-100.00%,thread.count=57, thread.peakCount=59, event.q.size=0, executor.q.async.size=0, executor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, executor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executor.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.size=0, operations.remote.size=0, operations.running.size=0, proxy.count=195,clientEndpoint.count=0, connection.active.count=0, connection.count=0Sep 17, 2014 2:34:04 PM com.hazelcast.util.HealthMonitor* Log is attach here. Regards Sumudu On Wed, Sep 17, 2014 at 2:07 PM, sumudu weerasinghe sumudu...@gmail.com wrote: Thanks Tran, It is working with that correction. Sumudu On Wed, Sep 17, 2014 at 6:13 AM, Tran Chau tran.hispviet...@gmail.com wrote: Hi Sumudu, I am sorry I sent wrong statements by mistake. The *status *column should be change to* varchar(25)*. Could you please run the statements below and re-start tomcat ? *ALTER TABLE programstageinstance MODIFY status varchar(25);* *UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';* *UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';* *UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';* Best regards, Châu Thu Trân HISP Viet Nam Email: tran.hispviet...@gmail.com On Tue, Sep 16, 2014 at 10:37 PM, sumudu weerasinghe sumudu...@gmail.com wrote: Hi Tran, I tried it but there is error in some query. My database status is a integer. I got following error? *mysql ALTER TABLE programstageinstance MODIFY status INTEGER;Query OK, 0 rows affected (0.10 sec)Records: 0 Duplicates: 0 Warnings: 0mysql UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';ERROR 1366 (HY000): Incorrect integer value: 'ACTIVE' for column 'status' at row 2mysql UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';ERROR 1366 (HY000): Incorrect integer value: 'COMPLETED' for column 'status' atrow 1mysql UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';Query OK, 0 rows affected (0.00 sec)Rows matched: 0 Changed: 0 Warnings: 0mysql* Sumudu On Tue, Sep 16, 2014 at 7:47 PM, Tran Chau tran.hispviet...@gmail.com wrote: Hi Sumudu, Could you please run these statements below in your database directly to fix this bug ? Then restart tomcat again ? *ALTER TABLE programstageinstance MODIFY status INTEGER;* *UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';* *UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';* *UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';* Best regards, Châu Thu Trân HISP Viet Nam Email: tran.hispviet...@gmail.com On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe sumudu...@gmail.com wrote: Sorry, my system detail as follow *Version: 2.16**Build revision:16414**Database type:MySQL* *Java version:1.7.0_04**OS name:Windows 7* On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe sumudu...@gmail.com wrote: Dear all , I have updated my instance from 2.15 to 2.16 over the old mysql database. Then i list the clinic patient . But it was unable to go for patient dashboard through the list and give error as exception occur (shown in screen shot). Log also show some error. Log and screenshots are attached here. Regards, Sumudu INFO: [127.0.0.1]:5701 [dev] [3.2.1] memory.used=400.6M, memory.free=94.3M, memo ry.total=494.9M, memory.max=494.9M, memory.used/total=80.94%, memory.used/max=80 .94%, load.process=-100.00%, load.system=-100.00%, load.systemAverage=-100.00%, thread.count=57, thread.peakCount=59, event.q.size=0, executor.q.async.size=0, e xecutor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, e xecutor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, exec utor.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.respons e.size=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, clientEndpoint.count=0, connection.active.count=0, connection.count=0 Sep 17, 2014 2:20:34 PM com.hazelcast.util.HealthMonitor INFO: [127.0.0.1]:5701 [dev] [3.2.1] memory.used=400.8M, memory.free=94.2M, memo ry.total=494.9M, memory.max=494.9M, memory.used/total=80.97%, memory.used/max=80 .97%, load.process=-100.00%, load.system=-100.00%, load.systemAverage=-100.00%, thread.count=57, thread.peakCount=59, event.q.size=0, executor.q.async.size=0, e xecutor.q.client.size=0, executor.q.operation.size=0,
[Dhis2-users] [WebAPI] - How to get list of districts which have data entered in system by webAPI
Dears, I'm going to make a html report to get the list of districts which have data entered in DHIS2 system by webapi. Is there anyway to check/get this? Thank you very much and best regards, -- THAI Chuong YM/Skype : thaichuong159 Phone: (+84) 918776134 / (+856) 2091708927 ___ 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] [Dhis2-devs] Tracker - Patient dashboard problem
Hi, that's not an error message, rather memory monitoring logging, nothing to worry about. Lars On Wed, Sep 17, 2014 at 11:45 AM, sumudu weerasinghe sumudu...@gmail.com wrote: Hi Tran, My problem is settle now, but after few minutes it is giving repeated thread of error on log. What is this error? *INFO: [127.0.0.1]:5701 [dev] [3.2.1] memory.used=404.5M, memory.free=90.4M, memory.total=494.9M, memory.max=494.9M, memory.used/total=81.74%, memory.used/max=81.74%, load.process=-100.00%, load.system=-100.00%, load.systemAverage=-100.00%,thread.count=57, thread.peakCount=59, event.q.size=0, executor.q.async.size=0, executor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, executor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executor.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.size=0, operations.remote.size=0, operations.running.size=0, proxy.count=195,clientEndpoint.count=0, connection.active.count=0, connection.count=0Sep 17, 2014 2:34:04 PM com.hazelcast.util.HealthMonitor* Log is attach here. Regards Sumudu On Wed, Sep 17, 2014 at 2:07 PM, sumudu weerasinghe sumudu...@gmail.com wrote: Thanks Tran, It is working with that correction. Sumudu On Wed, Sep 17, 2014 at 6:13 AM, Tran Chau tran.hispviet...@gmail.com wrote: Hi Sumudu, I am sorry I sent wrong statements by mistake. The *status *column should be change to* varchar(25)*. Could you please run the statements below and re-start tomcat ? *ALTER TABLE programstageinstance MODIFY status varchar(25);* *UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';* *UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';* *UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';* Best regards, Châu Thu Trân HISP Viet Nam Email: tran.hispviet...@gmail.com On Tue, Sep 16, 2014 at 10:37 PM, sumudu weerasinghe sumudu...@gmail.com wrote: Hi Tran, I tried it but there is error in some query. My database status is a integer. I got following error? *mysql ALTER TABLE programstageinstance MODIFY status INTEGER;Query OK, 0 rows affected (0.10 sec)Records: 0 Duplicates: 0 Warnings: 0mysql UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';ERROR 1366 (HY000): Incorrect integer value: 'ACTIVE' for column 'status' at row 2mysql UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';ERROR 1366 (HY000): Incorrect integer value: 'COMPLETED' for column 'status' atrow 1mysql UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';Query OK, 0 rows affected (0.00 sec)Rows matched: 0 Changed: 0 Warnings: 0mysql* Sumudu On Tue, Sep 16, 2014 at 7:47 PM, Tran Chau tran.hispviet...@gmail.com wrote: Hi Sumudu, Could you please run these statements below in your database directly to fix this bug ? Then restart tomcat again ? *ALTER TABLE programstageinstance MODIFY status INTEGER;* *UPDATE programstageinstance SET status='ACTIVE' WHERE status='0';* *UPDATE programstageinstance SET status='COMPLETED' WHERE status='1';* *UPDATE programstageinstance SET status='SKIPPED' WHERE status='5';* Best regards, Châu Thu Trân HISP Viet Nam Email: tran.hispviet...@gmail.com On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe sumudu...@gmail.com wrote: Sorry, my system detail as follow *Version: 2.16**Build revision:16414**Database type:MySQL* *Java version:1.7.0_04**OS name:Windows 7* On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe sumudu...@gmail.com wrote: Dear all , I have updated my instance from 2.15 to 2.16 over the old mysql database. Then i list the clinic patient . But it was unable to go for patient dashboard through the list and give error as exception occur (shown in screen shot). Log also show some error. Log and screenshots are attached here. Regards, Sumudu ___ 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