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
log.txt (16.3 KB)
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 sumuduw00@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
Hi Sumudu,
we are migrating the old individual case module to the new “tracker capture” app in 2.16. Could you please try out the new app and see if it meets your needs?
regards,
Lars
On Tue, Sep 16, 2014 at 3:56 PM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Sorry, my system detail as follow
Version: 2.16
Build revision:16414
Database type:MySQLJava version:1.7.0_04
OS name:Windows 7
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
On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe sumuduw00@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
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’;
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Sorry, my system detail as follow
Version: 2.16
Build revision:16414
Database type:MySQLJava version:1.7.0_04
OS name:Windows 7
On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe sumuduw00@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
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: 0
UPDATE programstageinstance SET status=‘ACTIVE’ WHERE status=‘0’;
ERROR 1366 (HY000): Incorrect integer value: ‘ACTIVE’ for column ‘status’ at row
2
UPDATE programstageinstance SET status=‘COMPLETED’ WHERE status=‘1’;
ERROR 1366 (HY000): Incorrect integer value: ‘COMPLETED’ for column ‘status’ at
row 1
UPDATE programstageinstance SET status=‘SKIPPED’ WHERE status=‘5’;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
**
Sumudu
On Tue, Sep 16, 2014 at 7:47 PM, Tran Chau tran.hispvietnam@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’;
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Sorry, my system detail as follow
Version: 2.16
Build revision:16414
Database type:MySQLJava version:1.7.0_04
OS name:Windows 7
On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe sumuduw00@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
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’;
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Sep 16, 2014 at 10:37 PM, sumudu weerasinghe sumuduw00@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
2
mysql> UPDATE programstageinstance SET status=‘COMPLETED’ WHERE status=‘1’;
ERROR 1366 (HY000): Incorrect integer value: ‘COMPLETED’ for column ‘status’ at
row 1
mysql> 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.hispvietnam@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’;
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Sorry, my system detail as follow
Version: 2.16
Build revision:16414
Database type:MySQLJava version:1.7.0_04
OS name:Windows 7
On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe sumuduw00@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
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
Thanks Tran,
It is working with that correction.
Sumudu
On Wed, Sep 17, 2014 at 6:13 AM, Tran Chau tran.hispvietnam@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’;
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Sep 16, 2014 at 10:37 PM, sumudu weerasinghe sumuduw00@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
2
mysql> UPDATE programstageinstance SET status=‘COMPLETED’ WHERE status=‘1’;
ERROR 1366 (HY000): Incorrect integer value: ‘COMPLETED’ for column ‘status’ at
row 1
mysql> 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.hispvietnam@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’;
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Sorry, my system detail as follow
Version: 2.16
Build revision:16414
Database type:MySQLJava version:1.7.0_04
OS name:Windows 7
On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe sumuduw00@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
Thanks Tran,
It is working with that correction.
Sumudu
On Wed, Sep 17, 2014 at 6:13 AM, Tran Chau tran.hispvietnam@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’;
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Sep 16, 2014 at 10:37 PM, sumudu weerasinghe sumuduw00@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
2
mysql> UPDATE programstageinstance SET status=‘COMPLETED’ WHERE status=‘1’;
ERROR 1366 (HY000): Incorrect integer value: ‘COMPLETED’ for column ‘status’ at
row 1
mysql> 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.hispvietnam@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’;
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Sorry, my system detail as follow
Version: 2.16
Build revision:16414
Database type:MySQLJava version:1.7.0_04
OS name:Windows 7
On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe sumuduw00@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
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 martens@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):
Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser.
Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago.
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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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:larshelge@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 martens@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):
Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser.
Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago.
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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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 martens@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:larshelge@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 martens@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):
Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser.
Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago.
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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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:larshelge@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 martens@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:larshelge@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 martens@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):
Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser.
Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago.
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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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, memo
ry.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, 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:34:04 PM com.hazelcast.util.HealthMonitor
Log is attach here.
Regards
Sumudu
log2.txt (22.9 KB)
On Wed, Sep 17, 2014 at 2:07 PM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Thanks Tran,
It is working with that correction.
Sumudu
On Wed, Sep 17, 2014 at 6:13 AM, Tran Chau tran.hispvietnam@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’;
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Sep 16, 2014 at 10:37 PM, sumudu weerasinghe sumuduw00@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
2
mysql> UPDATE programstageinstance SET status=‘COMPLETED’ WHERE status=‘1’;
ERROR 1366 (HY000): Incorrect integer value: ‘COMPLETED’ for column ‘status’ at
row 1
mysql> 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.hispvietnam@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’;
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Sorry, my system detail as follow
Version: 2.16
Build revision:16414
Database type:MySQLJava version:1.7.0_04
OS name:Windows 7
On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe sumuduw00@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
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 sumuduw00@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, memo
ry.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, 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:34:04 PM com.hazelcast.util.HealthMonitor
Log is attach here.
Regards
Sumudu
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
On Wed, Sep 17, 2014 at 2:07 PM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Thanks Tran,
It is working with that correction.
Sumudu
On Wed, Sep 17, 2014 at 6:13 AM, Tran Chau tran.hispvietnam@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’;
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Sep 16, 2014 at 10:37 PM, sumudu weerasinghe sumuduw00@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
2
mysql> UPDATE programstageinstance SET status=‘COMPLETED’ WHERE status=‘1’;
ERROR 1366 (HY000): Incorrect integer value: ‘COMPLETED’ for column ‘status’ at
row 1
mysql> 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.hispvietnam@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’;
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Sorry, my system detail as follow
Version: 2.16
Build revision:16414
Database type:MySQLJava version:1.7.0_04
OS name:Windows 7
On Tue, Sep 16, 2014 at 7:23 PM, sumudu weerasinghe sumuduw00@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
Okay. For the custom forms to update, you need to click “save and close” in the editor.
On Wed, Sep 17, 2014 at 11:42 AM, Robin Martens martens@sher.be wrote:
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:larshelge@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 martens@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:larshelge@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 martens@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):
Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser.
Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago.
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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Hi all,
I upgraded this morning to the last version and had the following error message when trying to save a single event without registration:
"No active event exists for single event no registration program xxx, please check and correct your database".
I read in the mailing list this might be linked to program instances. Does it mean I delete all my program instances?
Regards,
Robin
To add a point (after checking my other programs for event capture): there is one for which my custom data form is invisible in event capture but still there for editing. It’s a different one from the one with the error message below. There’s no error log on this one when loading the template.
How can this happen?
Kind regards,
Robin
From: Robin Martens
Sent: 17 September 2014 13:08
To: DHIS 2 Developers list
Subject: DHIS2 - Event capture error
Hi all,
I upgraded this morning to the last version and had the following error message when trying to save a single event without registration:
“No active event exists for single event no registration program xxx, please check and correct your database”.
I read in the mailing list this might be linked to program instances. Does it mean I delete all my program instances?
Regards,
Robin
Hi,
Yes, that message is displayed only when no program instances are found. From which to which version was the upgrade made?
Thank you,
Abyot.
On Wed, Sep 17, 2014 at 1:07 PM, Robin Martens martens@sher.be wrote:
Hi all,
I upgraded this morning to the last version and had the following error message when trying to save a single event without registration:
“No active event exists for single event no registration program xxx, please check and correct your database”.
I read in the mailing list this might be linked to program instances. Does it mean I delete all my program instances?
Regards,
Robin
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
You mean you custom form is not shown? If you are using chrome, do you see any log by pressing F12?
Thank you,
Abyot.
On Wed, Sep 17, 2014 at 1:13 PM, Robin Martens martens@sher.be wrote:
To add a point (after checking my other programs for event capture): there is one for which my custom data form is invisible in event capture but still there for editing. It’s a different one from the one with the error message below. There’s no error log on this one when loading the template.
How can this happen?
Kind regards,
Robin
From: Robin Martens
Sent: 17 September 2014 13:08
To: DHIS 2 Developers list
Subject: DHIS2 - Event capture error
Hi all,
I upgraded this morning to the last version and had the following error message when trying to save a single event without registration:
“No active event exists for single event no registration program xxx, please check and correct your database”.
I read in the mailing list this might be linked to program instances. Does it mean I delete all my program instances?
Regards,
Robin
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