Re: [Dhis2-users] Tracker - Patient dashboard problem

2014-09-17 Thread sumudu weerasinghe
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%,

Re: [Dhis2-users] Tracker - Patient dashboard problem

2014-09-17 Thread sumudu weerasinghe
Thanks Tran, It is working with that correction. Sumudu On Wed, Sep 17, 2014 at 6:13 AM, Tran Chau 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 ? >

Re: [Dhis2-users] Tracker - Patient dashboard problem

2014-09-17 Thread sumudu weerasinghe
Thanks Tran, It is working with that correction. Sumudu On Wed, Sep 17, 2014 at 6:13 AM, Tran Chau 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 ? >

Re: [Dhis2-users] Tracker - Patient dashboard problem

2014-09-16 Thread Tran Chau
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 sta

Re: [Dhis2-users] Tracker - Patient dashboard problem

2014-09-16 Thread sumudu weerasinghe
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

Re: [Dhis2-users] Tracker - Patient dashboard problem

2014-09-16 Thread Tran Chau
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='COM

Re: [Dhis2-users] Tracker - Patient dashboard problem

2014-09-16 Thread Lars Helge Ă˜verland
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 wrote: > Sorry, my system detail as follow > *Version: 2

Re: [Dhis2-users] Tracker - Patient dashboard problem

2014-09-16 Thread sumudu weerasinghe
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 wrote: > Dear all , > I have updated my instance from 2.15 to 2.16 over the old mysql database. > Then i l