← Back to team overview

dhis2-devs team mailing list archive

Re: 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 <sumuduw00@xxxxxxxxx>
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 <sumuduw00@xxxxxxxxx>
> wrote:
>
>> Thanks Tran,
>> It is working with that correction.
>>
>> Sumudu
>>
>> On Wed, Sep 17, 2014 at 6:13 AM, Tran Chau <tran.hispvietnam@xxxxxxxxx>
>> 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.hispvietnam@xxxxxxxxx
>>>
>>> On Tue, Sep 16, 2014 at 10:37 PM, sumudu weerasinghe <
>>> sumuduw00@xxxxxxxxx> 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.hispvietnam@xxxxxxxxx>
>>>> 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.hispvietnam@xxxxxxxxx
>>>>>
>>>>> On Tue, Sep 16, 2014 at 8:56 PM, sumudu weerasinghe <
>>>>> sumuduw00@xxxxxxxxx> 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 <
>>>>>> sumuduw00@xxxxxxxxx> 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-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References