Re: [Dhis2-devs] Analytics taking too much time for tracker

[Hannan Khan]

Dear Calle

Thank you for your information. 127 GB Databases size is including
analytics. Yes disks are in RAID 5.

Do you have tracker on that instances? Possible to share tomcat and DB
tuning parameters?

Please suggest.

Regards

Hannan

On Tue, May 1, 2018 at 3:36 AM, Calle Hedberg <calle.hedb...@gmail.com>
wrote:

> Hannan,
>
> Out of interest: how do you measure your DB size? "127GB" does not really
> say much - is it with or without analytics tables etc. Are you just using
> pg_database_size?
>
> I just ran that on my local instance of the South African "national" HMIS
> instance - it is 202 GB (NOTE: that includes analytics), and running
> analytics takes around 1-1.5 hours. So 12-13 hours on your side seems
> excessive (I presume you are using either high-speed RAID rust platters or
> else SSD).
>
> Regards
> calle
>
>
>
> On 30 April 2018 at 19:24, Hannan Khan <hann...@gmail.com> wrote:
>
>> Thanks Bob.
>>
>> I remembered that. 1st step I takes was upgrade postgres to 9.6 and
>> tuning parameters which reduced time from 58 to 13 hour. And after that I
>> removed/update the data types of the aggregated data set what was
>> changed/amended that reduce the time to 8 hour.
>>
>> 1. this time it is gradually increased from 8 hour to 2/13 hour now. This
>> time it seems that tracker contribute to the delays.
>>
>> * INFO  2018-04-30 03:24:56,323 Populated table in 8717.87 seconds:
>> analytics_enrollment_temp_xggeyhhpmkp (AbstractJdbcTableManager.java
>> [taskScheduler-25])
>> * INFO  2018-04-30 04:01:53,261 Populated table in 10919.99 seconds:
>> analytics_enrollment_temp_knjmf7ttlad (AbstractJdbcTableManager.java
>> [taskScheduler-9])
>> * INFO  2018-04-30 07:03:46,687 Populated table in 10913.42 seconds:
>> analytics_enrollment_temp_fokn0tj7lmi (AbstractJdbcTableManager.java
>> [taskScheduler-9])
>> * INFO  2018-04-30 08:18:49,534 Populated table in 26237.16 seconds:
>> analytics_enrollment_temp_oo3ormkzucj (AbstractJdbcTableManager.java
>> [taskScheduler-22])
>> * INFO  2018-04-30 09:02:22,728 Populated table in 7116.00 seconds:
>> analytics_enrollment_temp_vu0q0uahxxx (AbstractJdbcTableManager.java
>> [taskScheduler-9])
>> * INFO  2018-04-30 12:22:26,364 Populated table in 32250.03 seconds:
>> analytics_enrollment_temp_swqlgvqvifa (AbstractJdbcTableManager.java
>> [taskScheduler-25])
>>
>> 2. Yes! Good suggestion. This maintenance work_mem is low compared to
>> these trackers. I am changing now.
>>
>> automated procedures are not causing so much problem.
>>
>> Lets see the progress tomorrow. I will get back to you all.
>>
>> Regards
>>
>> Hannan
>>
>>
>>
>> On Mon, Apr 30, 2018 at 7:48 PM, Bob Jolliffe <bobjolli...@gmail.com>
>> wrote:
>>
>>> Hi Hannan
>>>
>>> I recall you had a similar request which I responded to back in Jan 11.
>>> Maybe worth re-reading that thread as some of it seems still to be
>>> relevant.  In particular:
>>>
>>> 1.  The first question, as always, is has this suddenly happened or has
>>> something recently changed?  Back then there had been some new datasets
>>> created by UNICEF which you were suspecting.  I recall at the time you said
>>> that analytics then was taking 13 hours.  So 12 hours is an improvement?
>>> Is this a sudden problem, like from a recent system upgrade or some changes
>>> to datasets,  or just the way it has been for some time .. unacceptably
>>> slow.
>>>
>>> 2.  A lot of analytics generation time is taken up on CREATE INDEX.  You
>>> might try to increase maintenance_work_mem.  I think I had suggested back
>>> then pushing as far as 4G on your system.
>>>
>>> 3.  You still have some automated creature (username elmisinterop)
>>> logging into your system at a crazy rate per second after 1am.  As I recall
>>> this user is trying to download all the data on your system which is
>>> probably not a good thing to do during analytics generation.  Whatever it
>>> is, you need to disable that.
>>>
>>> Try 2 and 3 and see where that gets you.
>>>
>>> Any chance you can also try to get access to some faster disk resource?
>>>
>>> Hope this helps.
>>>
>>> Bob
>>>
>>> On 30 April 2018 at 12:36, Hannan Khan <hann...@gmail.com> wrote:
>>>
>>>> Dear Experts
>>>>
>>>> I am drawing your attention to one problem and need your kind
>>>> attention. In o

Re: [Dhis2-devs] Analytics taking too much time for tracker

[Hannan Khan]

Thanks Bob.

I remembered that. 1st step I takes was upgrade postgres to 9.6 and tuning
parameters which reduced time from 58 to 13 hour. And after that I
removed/update the data types of the aggregated data set what was
changed/amended that reduce the time to 8 hour.

1. this time it is gradually increased from 8 hour to 2/13 hour now. This
time it seems that tracker contribute to the delays.

* INFO  2018-04-30 03:24:56,323 Populated table in 8717.87 seconds:
analytics_enrollment_temp_xggeyhhpmkp (AbstractJdbcTableManager.java
[taskScheduler-25])
* INFO  2018-04-30 04:01:53,261 Populated table in 10919.99 seconds:
analytics_enrollment_temp_knjmf7ttlad (AbstractJdbcTableManager.java
[taskScheduler-9])
* INFO  2018-04-30 07:03:46,687 Populated table in 10913.42 seconds:
analytics_enrollment_temp_fokn0tj7lmi (AbstractJdbcTableManager.java
[taskScheduler-9])
* INFO  2018-04-30 08:18:49,534 Populated table in 26237.16 seconds:
analytics_enrollment_temp_oo3ormkzucj (AbstractJdbcTableManager.java
[taskScheduler-22])
* INFO  2018-04-30 09:02:22,728 Populated table in 7116.00 seconds:
analytics_enrollment_temp_vu0q0uahxxx (AbstractJdbcTableManager.java
[taskScheduler-9])
* INFO  2018-04-30 12:22:26,364 Populated table in 32250.03 seconds:
analytics_enrollment_temp_swqlgvqvifa (AbstractJdbcTableManager.java
[taskScheduler-25])

2. Yes! Good suggestion. This maintenance work_mem is low compared to these
trackers. I am changing now.

automated procedures are not causing so much problem.

Lets see the progress tomorrow. I will get back to you all.

Regards

Hannan



On Mon, Apr 30, 2018 at 7:48 PM, Bob Jolliffe <bobjolli...@gmail.com> wrote:

> Hi Hannan
>
> I recall you had a similar request which I responded to back in Jan 11.
> Maybe worth re-reading that thread as some of it seems still to be
> relevant.  In particular:
>
> 1.  The first question, as always, is has this suddenly happened or has
> something recently changed?  Back then there had been some new datasets
> created by UNICEF which you were suspecting.  I recall at the time you said
> that analytics then was taking 13 hours.  So 12 hours is an improvement?
> Is this a sudden problem, like from a recent system upgrade or some changes
> to datasets,  or just the way it has been for some time .. unacceptably
> slow.
>
> 2.  A lot of analytics generation time is taken up on CREATE INDEX.  You
> might try to increase maintenance_work_mem.  I think I had suggested back
> then pushing as far as 4G on your system.
>
> 3.  You still have some automated creature (username elmisinterop) logging
> into your system at a crazy rate per second after 1am.  As I recall this
> user is trying to download all the data on your system which is probably
> not a good thing to do during analytics generation.  Whatever it is, you
> need to disable that.
>
> Try 2 and 3 and see where that gets you.
>
> Any chance you can also try to get access to some faster disk resource?
>
> Hope this helps.
>
> Bob
>
> On 30 April 2018 at 12:36, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear Experts
>>
>> I am drawing your attention to one problem and need your kind attention.
>> In one of our DHIS2 instances, 'Central Server' analytics generation taking
>> too much time  12 h, 22 m, 34 s. DB size is 127 GB and have aggregated and
>> trackers as. During analytics run-time the processor utilization and RAM
>> utilization is normal. But from the log it is clear that the trackers are
>> taking too much time though they are not having much data. "EPI Cold Chain"
>> tracker taking near about 9 hour, "Cause of death (MCCOD)"tracker taking 3
>> hour and "Cervical and Breast Cancer Screening Program" tracker taking 7
>> hour. What seems to be the reason? Is something wrong with the tracker
>> system?
>>
>> We are using DHIS2 version 2.28 release 533e983.
>>
>> Need immediate help.
>>
>> Regards
>>
>> Muhammad Abdul Hannan Khan
>> Team Leader
>> Support to the National HMIS
>> MIS, Directorate General of Health Services
>> Ministry of Health and Family Welfare
>>
>> T +880-2- 58816459, 58816412 ext 118
>> F +88 02 58813 875
>> M+88 01819 239 241
>> M+88 01534 312 066
>> E hann...@gmail.com
>> S hannan.khan.dhaka
>> B hannan-tech.blogspot.com
>> L https://bd.linkedin.com/in/hannankhan
>>
>>
>>
>>
>


-- 
Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Directorate General of Health Services
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

[Dhis2-devs] Analytics taking too much time for tracker

[Hannan Khan]

Dear Experts

I am drawing your attention to one problem and need your kind attention. In
one of our DHIS2 instances, 'Central Server' analytics generation taking
too much time  12 h, 22 m, 34 s. DB size is 127 GB and have aggregated and
trackers as. During analytics run-time the processor utilization and RAM
utilization is normal. But from the log it is clear that the trackers are
taking too much time though they are not having much data. "EPI Cold Chain"
tracker taking near about 9 hour, "Cause of death (MCCOD)"tracker taking 3
hour and "Cervical and Breast Cancer Screening Program" tracker taking 7
hour. What seems to be the reason? Is something wrong with the tracker
system?

We are using DHIS2 version 2.28 release 533e983.

Need immediate help.

Regards

Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Directorate General of Health Services
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

[Dhis2-devs] Web Portal demo is not working

[Hannan Khan]

Dear Experts

The Web portal demo is not working. The given links are not correct; it
should be play.dhis2.org/demo/api/reports/qYVNH1wkZR0/data  instead of
apps.dhis2.org/demo/api/reports/qYVNH1wkZR0/data .

Can you please take initiative to correct.

Regads

Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

[Dhis2-devs] User password reset through API

[Hannan Khan]

Hello Experts

Hope you are all enjoying Easter.

I am trying to reset/update password through API. Is it possible to send
PUT request with jason payload with only ID, username and password? I use

curl -X PUT -u user:pass -d @u.json -H "Content-Type: application/json"
https://server/api/26/users/ID

 I am getting following error:

{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"org.hisp.dhis.user.User
does not exist: ID"}

Please advice.

Regards
-- 
Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] Please add Maldives flag

[Hannan Khan]

Hi Jason.

The WAR build yesterday (from ci.dhis2.org) does not have this flag. Also
today's latest build, I dint see it in the changes list. Please help me to
get it done as early as possible.

Regards

Hannan

On Fri, Nov 24, 2017 at 4:55 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Hannan,
> Great news!
>
> I have added it here
> <https://github.com/dhis2/dhis2-core/commit/5989c518b400a113af3f533d78cf6fcd541492b6>
>  .
> Give the CI server about an hour and it should be ready in the latest
> development version.
>
> Regards,
> Jason
>
>
>
>
> On Fri, Nov 24, 2017 at 5:05 AM, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear Lars & Devs
>>
>> Thank you all for your kind help.
>>
>> HISP Bangladesh are now helping Maldives to start using DHIS2 as national
>> HMIS system.
>>
>> Can you please add Maldives flag in the DHIS2 war.
>>
>> Regards
>>
>> Muhammad Abdul Hannan Khan
>> Team Leader
>> Support to the National HMIS
>> MIS, Director General of Health Service
>> Ministry of Health and Family Welfare
>>
>> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118
>> F +88 02 58813 875
>> M+88 01819 239 241
>> M+88 01534 312 066
>> E hann...@gmail.com
>> S hannan.khan.dhaka
>> B hannan-tech.blogspot.com
>> L https://bd.linkedin.com/in/hannankhan
>>
>>
>>
>>
>> ___
>> 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
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46%2076%20414%2070%2049>
>



-- 
Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] Please add Maldives flag

[Hannan Khan]

Dear Jason

Thanks a lot for quick response.

Regards

Hannan



On Fri, Nov 24, 2017 at 4:55 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Hannan,
> Great news!
>
> I have added it here
> <https://github.com/dhis2/dhis2-core/commit/5989c518b400a113af3f533d78cf6fcd541492b6>
>  .
> Give the CI server about an hour and it should be ready in the latest
> development version.
>
> Regards,
> Jason
>
>
>
>
> On Fri, Nov 24, 2017 at 5:05 AM, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear Lars & Devs
>>
>> Thank you all for your kind help.
>>
>> HISP Bangladesh are now helping Maldives to start using DHIS2 as national
>> HMIS system.
>>
>> Can you please add Maldives flag in the DHIS2 war.
>>
>> Regards
>>
>> Muhammad Abdul Hannan Khan
>> Team Leader
>> Support to the National HMIS
>> MIS, Director General of Health Service
>> Ministry of Health and Family Welfare
>>
>> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118
>> F +88 02 58813 875
>> M+88 01819 239 241
>> M+88 01534 312 066
>> E hann...@gmail.com
>> S hannan.khan.dhaka
>> B hannan-tech.blogspot.com
>> L https://bd.linkedin.com/in/hannankhan
>>
>>
>>
>>
>> ___
>> 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
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46%2076%20414%2070%2049>
>



-- 
Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

[Dhis2-devs] Please add Maldives flag

[Hannan Khan]

Dear Lars & Devs

Thank you all for your kind help.

HISP Bangladesh are now helping Maldives to start using DHIS2 as national
HMIS system.

Can you please add Maldives flag in the DHIS2 war.

Regards

Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] [Dhis2-users] DHIS 2 to support PostgreSQL only?

[Hannan Khan]

Hi Lars

Fully agreed. To concentrate one one DB platforms will not only saves time
and effort, also being efficiency to the system and can make more use of
advance functionality of the PostgreSQL & PostGIS.

You will have our full support.

Hannan

On Fri, Sep 8, 2017 at 2:26 PM, Lars Helge Øverland <l...@dhis2.org> wrote:

> Hi all,
>
> I want to bring up the idea of solely support PostgreSQL for DHIS 2 for
> production use to get feedback from the community.
>
> The DHIS 2 team is seeing clear benefits of moving to PostgreSQL-only. The
> main ones are:
>
> 1. Supporting and testing for more than one database platform is
> time-consuming. The majority of DHIS 2 implementations is using PostgreSQL
> already.
>
> 2. PostgreSQL supports advanced geospatial features through PostGIS. We
> are already depending on these for the GIS module to work optimally (i.e.
> for event clustering in GIS). There are no direct equivalent in e.g. MySQL.
> We are also considering using PostGIS data types in main data model.
>
> 3. PostgreSQL will provide some impressive features which will become very
> useful for us in version 10
> <https://wiki.postgresql.org/wiki/New_in_postgres_10> and 11. E.g. native
> partitioning, parallel queries, logical replication, foreign tables and
> improved query performance will be useful and allow us to develop the next
> DHIS 2 analytics solution.
>
>
> We are aware this will be inconvenient for users of other databases such
> as MySQL, but there is the option of migrating your database through the
> DHIS 2 metadata and data value import-export feature.
>
> On a technical note, we will keep the Hibernate development framework and
> keep supporting the H2 database for unit testing purposes.
>
> Please let us know your thoughts on this.
>
> regards,
>
> Lars
>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] Tracker data are not saving in the custom registration form after upgraded from 22 to 26.

[Hannan Khan]

Thanks Abyot.

I solved the issue this morning. But find a new one. When we try to delete
a tracked entity jut registered, there is an error message.

The event could not be deleted because it contains an audit log.
ERROR: null value in column "programinstanceid" violates not-null
constraint Detail: Failing row contains (185366337, null, 18, 2017-08-27
00:00:00, 2017-08-03 00:00:00, 60020752, ACTIVE, null, kfHSQMY4tx9,
2017-08-03 09:46:51.034, 2017-08-03 09:46:51.497, null, null, 1, null,
null, f).

Also a server log is also generated. Any idea how to fix?

Regards

Hannan

On Thu, Aug 3, 2017 at 11:28 AM, Abyot Gizaw <aby...@gmail.com> wrote:

> Hi Hannan,
>
> Not sure how your custom script look like... but it needs to access
> angular scope... manipulate values and send back to angular scope.
>
> Can you share your script?
>
> Here is a sample to access/manipulate from custom registration form
>
> var appElement = document.querySelector('d2-custom-form'); // access
> custom form
> var $scope = angular.element(appElement).scope();//get
> scopes from custom form
>
> //get tei scope
> var attValue = $scope.selectedTei[ATTRIBUTE_ID];
>
>
> //assign attribute value
> $scope.$apply(function(){
>$scope.selectedTei[ATTRIBUTE_ID]= my_attribute_value;
> });
>
>
> ---
> Thank you,
> Abyot.
>
> On Wed, Aug 2, 2017 at 12:53 PM, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear Experts
>>
>> Yesterday upgraded our tracker server from 22 to 26 and now fixing the
>> scripting errors. After fixing the few issues the tracker data are not
>> saving from the custom registration form. No log are being generated in the
>> server end and no scripting error in the front end either. Please check the
>> screenshots.
>>
>> We need urgent help.
>>
>> Regards
>>
>> Muhammad Abdul Hannan Khan
>> Team Leader
>> Support to the National HMIS
>> MIS, Director General of Health Service
>> Ministry of Health and Family Welfare
>>
>> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118
>> <58%2081%2064%2012>
>> F +88 02 58813 875
>> M+88 01819 239 241
>> M+88 01534 312 066
>> E hann...@gmail.com
>> S hannan.khan.dhaka
>> B hannan-tech.blogspot.com
>> L https://bd.linkedin.com/in/hannankhan
>>
>>
>>
>>
>


-- 
Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

[Dhis2-devs] Attribute data type 'TIME'

[Hannan Khan]

Dear all expert

I just added an attribute to an exiting program and find that there is an
error on the screen. The data type is TIME but during entry the error
message is showing error message 'Unsupported value type: TIME'; also there
is no error message showing in the log. we are using DHIS2 version 26 build
8f9dc62.

What is the cause? how could I get read of it.

Regards

Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] Server processor use 100%

[Hannan Khan]

Thanks Bob.

On Thu, Jul 13, 2017 at 10:13 PM, Bob Jolliffe <bobjolli...@gmail.com>
wrote:

> Yes, Hannan that is similar to what I have seen a number of times this
> year.  The attacker makes use of atd and/or crontab to execute malicious
> code.  The good thing is that your tomcat was not running as root which
> would be potentially more damaging.
>
> Obviously with access to the tomcat user then access to the database
> itself has been exposed.  There is no indication that the database was the
> target of previous exploits so probably (hopefully) that is your case too.
> It is a really good illustration though of why, when you have multiple
> instances attaching to a database server, you should always use a separate
> database role/user for each.  So when one database is exposed (through
> access to dhis.conf), at least they are not all exposed.
>
> Enjoy your holiday.  I am hoping to get off as well soon :-)
>
> Regards
> Bob
>
> On 13 July 2017 at 16:01, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear Bob
>>
>> Sorry for replaying late. I quite busy to complete few incomplete tasks
>> before I am going on holiday tomorrow for a week.
>>
>> I have checked for few day with various options and my conclusion is that
>> the security hole might be created by our old war file (version 16) with
>> Stuart vulnerability which Lars warn all of us earlier. We upgraded all our
>> servers and applications except this server. No suspicious files in the tmp
>> folders.
>>
>> It took control of Tomcat8 user and run SSHD and occupies 100% of 2
>> processors. When we kill the process and remove all war files and stop
>> tomcat8 service it stared ATD command and it also occupy 100% of 2
>> processors. The data seems intact (through query and size). As our all DB
>> servers have similar IP structure we immediately remove tomcat8 service,
>> package and user. The VM server will also be decommissioned and will setup
>> a new server with new cardinals. I will start upgrade work after I return.
>>
>> Thank you for your valuable advice and kind concern.
>>
>> Best regards
>>
>> Hannan
>>
>> On Mon, Jul 10, 2017 at 8:21 PM, Bob Jolliffe <bobjolli...@gmail.com>
>> wrote:
>>
>>> Sorry that should have been 'ls -la /tmp'
>>>
>>> On 10 July 2017 at 10:50, Bob Jolliffe <bobjolli...@gmail.com> wrote:
>>>
>>>> Hi Hannan
>>>>
>>>> There is no circumstance that tomcat user should be running the sshd
>>>> command.  It could be this machine has been compromised.  Unless you have
>>>> some strange setup that you are logging in as tomcat user.
>>>>
>>>> Please contact me directly if you want me to check.
>>>>
>>>> Meanwhile you might want to have a look in /tmp directory and tomcat8
>>>> home directory to see if there are any strange files there:
>>>>
>>>> ls -ls /tmp
>>>>
>>>> You might find that there is a rogue sshd program that has been
>>>> installed there.  Note that if you are running a very old war file your
>>>> risk of compromise is very high.
>>>>
>>>> Bob
>>>>
>>>> On 10 July 2017 at 05:09, Hannan Khan <hann...@gmail.com> wrote:
>>>>
>>>>> Dear Experts
>>>>>
>>>>> I have an wired situation. one of our DHIS2 server running older war
>>>>> files (version 16), the OS was outdated and we have to upgrade the OS.
>>>>> After installing new OS Ubuntu 16.04 LTS all necessary component Java 8 
>>>>> and
>>>>> Tomcat 7 was installed by after running war file (version 16) after few
>>>>> minutes the tomcat7 is not operational as the processor use is 100%. there
>>>>> is only 1 user logged in and the application server using 2 processor and
>>>>> DB server is separate.
>>>>>
>>>>> After trying several times I remove tomcat7 and install tomcat 8 with
>>>>> same war file, but situation is same. I called it wired as the db size is
>>>>> quite small, user is only few and the listing showing SSHD command by
>>>>> tomcat8 user is using 100% processor.
>>>>>
>>>>> Any idea about the under line reason? need urgent help. Thank you all
>>>>> in advance.
>>>>>
>>>>> Regards
>>>>>
>>>>> Muhammad Abdul Hannan Khan
>>>>> Team Leader
>>>>> Support to the National 

Re: [Dhis2-devs] Server processor use 100%

[Hannan Khan]

Dear Bob

Sorry for replaying late. I quite busy to complete few incomplete tasks
before I am going on holiday tomorrow for a week.

I have checked for few day with various options and my conclusion is that
the security hole might be created by our old war file (version 16) with
Stuart vulnerability which Lars warn all of us earlier. We upgraded all our
servers and applications except this server. No suspicious files in the tmp
folders.

It took control of Tomcat8 user and run SSHD and occupies 100% of 2
processors. When we kill the process and remove all war files and stop
tomcat8 service it stared ATD command and it also occupy 100% of 2
processors. The data seems intact (through query and size). As our all DB
servers have similar IP structure we immediately remove tomcat8 service,
package and user. The VM server will also be decommissioned and will setup
a new server with new cardinals. I will start upgrade work after I return.

Thank you for your valuable advice and kind concern.

Best regards

Hannan

On Mon, Jul 10, 2017 at 8:21 PM, Bob Jolliffe <bobjolli...@gmail.com> wrote:

> Sorry that should have been 'ls -la /tmp'
>
> On 10 July 2017 at 10:50, Bob Jolliffe <bobjolli...@gmail.com> wrote:
>
>> Hi Hannan
>>
>> There is no circumstance that tomcat user should be running the sshd
>> command.  It could be this machine has been compromised.  Unless you have
>> some strange setup that you are logging in as tomcat user.
>>
>> Please contact me directly if you want me to check.
>>
>> Meanwhile you might want to have a look in /tmp directory and tomcat8
>> home directory to see if there are any strange files there:
>>
>> ls -ls /tmp
>>
>> You might find that there is a rogue sshd program that has been installed
>> there.  Note that if you are running a very old war file your risk of
>> compromise is very high.
>>
>> Bob
>>
>> On 10 July 2017 at 05:09, Hannan Khan <hann...@gmail.com> wrote:
>>
>>> Dear Experts
>>>
>>> I have an wired situation. one of our DHIS2 server running older war
>>> files (version 16), the OS was outdated and we have to upgrade the OS.
>>> After installing new OS Ubuntu 16.04 LTS all necessary component Java 8 and
>>> Tomcat 7 was installed by after running war file (version 16) after few
>>> minutes the tomcat7 is not operational as the processor use is 100%. there
>>> is only 1 user logged in and the application server using 2 processor and
>>> DB server is separate.
>>>
>>> After trying several times I remove tomcat7 and install tomcat 8 with
>>> same war file, but situation is same. I called it wired as the db size is
>>> quite small, user is only few and the listing showing SSHD command by
>>> tomcat8 user is using 100% processor.
>>>
>>> Any idea about the under line reason? need urgent help. Thank you all in
>>> advance.
>>>
>>> Regards
>>>
>>> Muhammad Abdul Hannan Khan
>>> Team Leader
>>> Support to the National HMIS
>>> MIS, Director General of Health Service
>>> Ministry of Health and Family Welfare
>>>
>>> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118
>>> F +88 02 58813 875
>>> M+88 01819 239 241
>>> M+88 01534 312 066
>>> E hann...@gmail.com
>>> S hannan.khan.dhaka
>>> B hannan-tech.blogspot.com
>>> L https://bd.linkedin.com/in/hannankhan
>>>
>>>
>>>
>>>
>>
>


-- 
Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] [Dhis2-users] Older war files

[Hannan Khan]

Thanks Mukulu for valuable suggestions.

Regards

Hannan

On Mon, Jul 10, 2017 at 12:25 PM, John Mukulu <john.f.muk...@gmail.com>
wrote:

> You should be able to get as far back as 2.18 going forward with these URL
>
> https://www.dhis2.org/download/releases/2.18/dhis.war
>
> Just change version number in url.
>
> Though upgrade from version to version used to have upgrade notes on bunch
> of things to be done first.
> https://www.dhis2.org/217-upgrade
>
> Change url for different versions too
>
> I would suggest(if things don't workout well) use of tomcat6 for older war
> files. Before 2.23 and switch to tomcat7 after. There's compatibility
> issues because of java upgrades between some of those older war files.
>
>
> John Francis Mukulu
> Lead Developer, HISPTZ
> University of Dar es salaam
> http://hisptanzania.org/
>
> On Jul 10, 2017 09:01, "Hannan Khan" <hann...@gmail.com> wrote:
>
>> Dear all
>>
>> I need earlier war files from 16 on ward; from where I can download?
>>
>> Regards
>>
>> Muhammad Abdul Hannan Khan
>> Team Leader
>> Support to the National HMIS
>> MIS, Director General of Health Service
>> Ministry of Health and Family Welfare
>>
>> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118
>> F +88 02 58813 875
>> M+88 01819 239 241
>> M+88 01534 312 066
>> E hann...@gmail.com
>> S hannan.khan.dhaka
>> B hannan-tech.blogspot.com
>> L https://bd.linkedin.com/in/hannankhan
>>
>>
>>
>>
>> _______
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>


-- 
Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] Older war files

[Hannan Khan]

Thanks Knut.

Yes I find version 18 onward, but can get 16, 17. Need upgraded war file.
Can you please explore.

Regards

Hannan

On Mon, Jul 10, 2017 at 12:22 PM, Knut Staring <knu...@gmail.com> wrote:

> Not sure about 16 and 17 - might have to build them (I will take a look).
>
> From 2.18, this works;
>
> https://www.dhis2.org/download/releases/2.18/dhis.war
>
> On Jul 10, 2017 08:02, "Hannan Khan" <hann...@gmail.com> wrote:
>
>> Dear all
>>
>> I need earlier war files from 16 on ward; from where I can download?
>>
>> Regards
>>
>> Muhammad Abdul Hannan Khan
>> Team Leader
>> Support to the National HMIS
>> MIS, Director General of Health Service
>> Ministry of Health and Family Welfare
>>
>> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118
>> F +88 02 58813 875
>> M+88 01819 239 241
>> M+88 01534 312 066
>> E hann...@gmail.com
>> S hannan.khan.dhaka
>> B hannan-tech.blogspot.com
>> L https://bd.linkedin.com/in/hannankhan
>>
>>
>>
>>
>> ___
>> 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
>>
>>


-- 
Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

[Dhis2-devs] Older war files

[Hannan Khan]

Dear all

I need earlier war files from 16 on ward; from where I can download?

Regards

Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] Version 26 - Issue; cannot update organisationunit

[Hannan Khan]

Thanks Viet.

I think this was the problem. After update, the problem is resolved.

Regards

Hannan

On Fri, Jun 9, 2017 at 9:43 AM, Viet Nguyen <v...@dhis2.org> wrote:

> Hi Hannan,
>
> Currently we don't support property = 'comment' , I think it has the same
> meaning as 'description' ?
> If that is the case, can you run a query to update all of those records as
> below
>
> update objecttranslation set property = 'DESCRIPTION' where property = '
>> comment';
>
>
>
> On Fri, Jun 9, 2017 at 10:35 AM, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear Viet
>>
>> The first query output is 0.
>> second query output is in the attached. there are 3457 rows. I noticed
>> that in the 'organisationunit' table this 'type' has the same value. But
>> note that there are 19385 rows have null values in the 'type' column.
>>
>> Thank you for your kind effort.
>>
>> Regards
>>
>> Hannan
>>
>> On Fri, Jun 9, 2017 at 9:06 AM, Viet Nguyen <v...@dhis2.org> wrote:
>>
>>> Hi Hannan,
>>>
>>> As discussed yesterday, I need more info to investigate this issue.
>>>
>>> Can you run the below queries in your upgraded database and send over
>>> the result.
>>>
>>> select count(*)  from objecttranslation where property is null;
>>>
>>> select * from objecttranslation where value like 'UH & FWC/Union Sub
>>> Centers(New)';
>>>
>>>
>>> On Thu, Jun 8, 2017 at 9:42 AM, Hannan Khan <hann...@gmail.com> wrote:
>>>
>>>> Thanks Viet.
>>>>
>>>> But there is no record in 'translation' with null value. II run the
>>>> query and outcome is null.
>>>>
>>>> But the problem persists.
>>>>
>>>> Need urgent help.
>>>>
>>>> Regards
>>>>
>>>> Hannan
>>>>
>>>> On Wed, Jun 7, 2017 at 3:10 PM, Viet Nguyen <v...@dhis2.org> wrote:
>>>>
>>>>> Hi Hannan,
>>>>>
>>>>> I think this is caused by some invalid translation records in your
>>>>> database.
>>>>>
>>>>> Can you try to run the below query with the old database and then run
>>>>> the upgrade procedures again. Meanwhile I will try to add some null check
>>>>> conditions to the upgrade query to make sure this issue won't happen 
>>>>> again.
>>>>>
>>>>> delete from translation where objectproperty is null;
>>>>>
>>>>>
>>>>> Regards,
>>>>>
>>>>> On Wed, Jun 7, 2017 at 9:58 AM, Hannan Khan <hann...@gmail.com> wrote:
>>>>>
>>>>>> Thanks a lot Calle and Morten. But how can I solve this.
>>>>>>
>>>>>> I got some clue form your mail, will check and get back to you within
>>>>>> few hours (stupid meetings!!).
>>>>>>
>>>>>> Regards
>>>>>>
>>>>>> Hannan
>>>>>>
>>>>>>
>>>>>> On Tue, Jun 6, 2017 at 1:25 PM, Calle Hedberg <
>>>>>> calle.hedb...@gmail.com> wrote:
>>>>>>
>>>>>>> Hannan,
>>>>>>>
>>>>>>> That looks very much like the bug I picked up just before the Goa
>>>>>>> academy - it's caused by the fact that you have OrgUnit attributes with
>>>>>>> null values (if you have any other meta-data object with attribute 
>>>>>>> records
>>>>>>> with null values it would be the same). I worked with Morten to track it
>>>>>>> down and fix it. If this is the same, it could be that update was lost,
>>>>>>> somehow (assuming your build is from ~30th April or later).
>>>>>>>
>>>>>>> Build version don't tell me anything - what is the DATE of the 2.26
>>>>>>> build you are using? Have you tried to update to the latest 2.26 build?
>>>>>>>
>>>>>>> Regards
>>>>>>> Calle
>>>>>>>
>>>>>>> On 6 June 2017 at 05:34, Hannan Khan <hann...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Dear All
>>>>>>>>
>>>>>>>> We just upgrade nation instance form 22 to 26. Now we are facing an
>>>>>>>> issue.
&

Re: [Dhis2-devs] Version 26 - Issue; cannot update organisationunit

[Hannan Khan]

Thanks Viet.

But there is no record in 'translation' with null value. II run the query
and outcome is null.

But the problem persists.

Need urgent help.

Regards

Hannan

On Wed, Jun 7, 2017 at 3:10 PM, Viet Nguyen <v...@dhis2.org> wrote:

> Hi Hannan,
>
> I think this is caused by some invalid translation records in your
> database.
>
> Can you try to run the below query with the old database and then run the
> upgrade procedures again. Meanwhile I will try to add some null check
> conditions to the upgrade query to make sure this issue won't happen again.
>
> delete from translation where objectproperty is null;
>
>
> Regards,
>
> On Wed, Jun 7, 2017 at 9:58 AM, Hannan Khan <hann...@gmail.com> wrote:
>
>> Thanks a lot Calle and Morten. But how can I solve this.
>>
>> I got some clue form your mail, will check and get back to you within few
>> hours (stupid meetings!!).
>>
>> Regards
>>
>> Hannan
>>
>>
>> On Tue, Jun 6, 2017 at 1:25 PM, Calle Hedberg <calle.hedb...@gmail.com>
>> wrote:
>>
>>> Hannan,
>>>
>>> That looks very much like the bug I picked up just before the Goa
>>> academy - it's caused by the fact that you have OrgUnit attributes with
>>> null values (if you have any other meta-data object with attribute records
>>> with null values it would be the same). I worked with Morten to track it
>>> down and fix it. If this is the same, it could be that update was lost,
>>> somehow (assuming your build is from ~30th April or later).
>>>
>>> Build version don't tell me anything - what is the DATE of the 2.26
>>> build you are using? Have you tried to update to the latest 2.26 build?
>>>
>>> Regards
>>> Calle
>>>
>>> On 6 June 2017 at 05:34, Hannan Khan <hann...@gmail.com> wrote:
>>>
>>>> Dear All
>>>>
>>>> We just upgrade nation instance form 22 to 26. Now we are facing an
>>>> issue.
>>>>
>>>> When we trying to update a organization unit it cannot be saved. Log is
>>>>  as follows. The build we are using is 8f9dc62
>>>>
>>>> * WARN  2017-06-06 08:56:27,127 SQL Error: 0, SQLState: 23502
>>>> (SqlExceptionHelper.java [http-nio-8080-exec-205])
>>>> * ERROR 2017-06-06 08:56:27,128 ERROR: null value in column "property"
>>>> violates not-null constraint
>>>>   Detail: Failing row contains (44356689, en_GB, null, UH & FWC/Union
>>>> Sub Centers(New)). (SqlExceptionHelper.java [http-nio-8080-exec-205])
>>>> org.hibernate.exception.ConstraintViolationException: could not
>>>> execute statement
>>>> at org.hibernate.exception.internal.SQLStateConversionDelegate.
>>>> convert(SQLStateConversionDelegate.java:112)
>>>> at org.hibernate.exception.internal.StandardSQLExceptionConvert
>>>> er.convert(StandardSQLExceptionConverter.java:42)
>>>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>>>> ExceptionHelper.java:111)
>>>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>>>> ExceptionHelper.java:97)
>>>> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.execu
>>>> teUpdate(ResultSetReturnImpl.java:207)
>>>> at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.ad
>>>> dToBatch(NonBatchingBatch.java:45)
>>>> at org.hibernate.persister.entity.AbstractEntityPersister.inser
>>>> t(AbstractEntityPersister.java:2947)
>>>> at org.hibernate.persister.entity.AbstractEntityPersister.inser
>>>> t(AbstractEntityPersister.java:3447)
>>>> at org.hibernate.action.internal.EntityInsertAction.execute(Ent
>>>> ityInsertAction.java:89)
>>>> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu
>>>> eue.java:582)
>>>> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu
>>>> eue.java:456)
>>>> at org.hibernate.event.internal.AbstractFlushingEventListener.p
>>>> erformExecutions(AbstractFlushingEventListener.java:337)
>>>> at org.hibernate.event.internal.DefaultFlushEventListener.onFlu
>>>> sh(DefaultFlushEventListener.java:39)
>>>> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
>>>> at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundle
>>>> Service.commit(DefaultObjectBundleService.java:167)
>>>> at sun.reflect.GeneratedMethodAccessor2719.invoke(Unknown Source)
>>

Re: [Dhis2-devs] Version 26 - Issue; cannot update organisationunit

[Hannan Khan]

Thanks a lot Calle and Morten. But how can I solve this.

I got some clue form your mail, will check and get back to you within few
hours (stupid meetings!!).

Regards

Hannan


On Tue, Jun 6, 2017 at 1:25 PM, Calle Hedberg <calle.hedb...@gmail.com>
wrote:

> Hannan,
>
> That looks very much like the bug I picked up just before the Goa academy
> - it's caused by the fact that you have OrgUnit attributes with null values
> (if you have any other meta-data object with attribute records with null
> values it would be the same). I worked with Morten to track it down and fix
> it. If this is the same, it could be that update was lost, somehow
> (assuming your build is from ~30th April or later).
>
> Build version don't tell me anything - what is the DATE of the 2.26 build
> you are using? Have you tried to update to the latest 2.26 build?
>
> Regards
> Calle
>
> On 6 June 2017 at 05:34, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear All
>>
>> We just upgrade nation instance form 22 to 26. Now we are facing an
>> issue.
>>
>> When we trying to update a organization unit it cannot be saved. Log is
>>  as follows. The build we are using is 8f9dc62
>>
>> * WARN  2017-06-06 08:56:27,127 SQL Error: 0, SQLState: 23502
>> (SqlExceptionHelper.java [http-nio-8080-exec-205])
>> * ERROR 2017-06-06 08:56:27,128 ERROR: null value in column "property"
>> violates not-null constraint
>>   Detail: Failing row contains (44356689, en_GB, null, UH & FWC/Union Sub
>> Centers(New)). (SqlExceptionHelper.java [http-nio-8080-exec-205])
>> org.hibernate.exception.ConstraintViolationException: could not execute
>> statement
>> at org.hibernate.exception.internal.SQLStateConversionDelegate.
>> convert(SQLStateConversionDelegate.java:112)
>> at org.hibernate.exception.internal.StandardSQLExceptionConvert
>> er.convert(StandardSQLExceptionConverter.java:42)
>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>> ExceptionHelper.java:111)
>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>> ExceptionHelper.java:97)
>> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.execu
>> teUpdate(ResultSetReturnImpl.java:207)
>> at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.
>> addToBatch(NonBatchingBatch.java:45)
>> at org.hibernate.persister.entity.AbstractEntityPersister.inser
>> t(AbstractEntityPersister.java:2947)
>> at org.hibernate.persister.entity.AbstractEntityPersister.inser
>> t(AbstractEntityPersister.java:3447)
>> at org.hibernate.action.internal.EntityInsertAction.execute(Ent
>> ityInsertAction.java:89)
>> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu
>> eue.java:582)
>> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu
>> eue.java:456)
>> at org.hibernate.event.internal.AbstractFlushingEventListener.p
>> erformExecutions(AbstractFlushingEventListener.java:337)
>> at org.hibernate.event.internal.DefaultFlushEventListener.onFlu
>> sh(DefaultFlushEventListener.java:39)
>> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
>> at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundle
>> Service.commit(DefaultObjectBundleService.java:167)
>> at sun.reflect.GeneratedMethodAccessor2719.invoke(Unknown Source)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>> thodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:498)
>> at org.springframework.aop.support.AopUtils.invokeJoinpointUsin
>> gReflection(AopUtils.java:333)
>> at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .invokeJoinpoint(ReflectiveMethodInvocation.java:190)
>> at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:157)
>> at org.springframework.transaction.interceptor.TransactionInter
>> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>> at org.springframework.transaction.interceptor.TransactionAspec
>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
>> at org.springframework.transaction.interceptor.TransactionInter
>> ceptor.invoke(TransactionInterceptor.java:96)
>> at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:179)
>> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>> JdkDynamicAopProxy.java:213)
>> at com.sun.proxy.$Proxy175.commit(Unknown Source)
>> at org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.imp
>> ortMetada

[Dhis2-devs] Version 26 - Issue; cannot update organisationunit

[Hannan Khan]

e(QueryExecutorImpl.java:288)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
at
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
at
org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:135)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
... 133 more

Need urgent help.

Regards

Muhammad Abdul Hannan Khan
Team Leader
Support to the National HMIS
MIS, Director General of Health Service
Ministry of Health and Family Welfare

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] [Dhis2-users] Org unit lists

[Hannan Khan]

Dear Alvin

The one shared by John Mukulu is a central repository for all.

But my proposal is if you are interested for setting up one specifically
for AeHIN.

Regards

Hannan

On Wed, Apr 12, 2017 at 8:00 PM, Alvin Marcelo <admarc...@up.edu.ph> wrote:

> Dear Hannan,
>
> That would be helpful but is there a central repository for all?
>
>
>
> On Tue, Apr 11, 2017 at 1:49 PM, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear Alvin
>>
>> John Mukulu also shared the metadata app though which any one can browse
>> through those metadata; https://play.dhis2.o
>> rg/demo/api/apps/metabase2/index.html#/.
>>
>> If there is interest, me and my team can help to setup an repository for
>> AeHIN.
>>
>> Regards
>>
>> Hannan
>>
>> On Tue, Apr 11, 2017 at 4:44 AM, Saptarshi Purkayastha <sun...@gmail.com>
>> wrote:
>>
>>> Hi Alvin,
>>> John Mukulu shared the link to metadata in his first email -
>>> https://github.com/dhis2/dhis2-metadata-repo
>>>
>>> ---
>>> Regards,
>>> Saptarshi PURKAYASTHA, Ph.D.
>>> Assistant Professor of Health Informatics,
>>> Indiana University - Purdue University Indianapolis.
>>>
>>> On 9 April 2017 at 08:21, Alvin Marcelo <admarc...@up.edu.ph> wrote:
>>>
>>>> PLs share link to the metadata on the github thanks --
>>>>
>>>>
>>>>
>>>> On Fri, Apr 7, 2017 at 1:51 PM, John Mukulu <john.f.muk...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hello again,
>>>>> Thanks for the feedback.
>>>>>
>>>>> Yes, the github repository is meant to be the core repository for all
>>>>> publicly shared repositories. If you have metadata you would like to
>>>>> contribute, you're warmly welcome to do so.
>>>>>
>>>>> I will get back to you soon with a fully fledged app with full
>>>>> detailed import preview.
>>>>>
>>>>> For metadata sharing within networks, which isn't soo public, we're
>>>>> also looking into supporting external repositories, but that is in the 
>>>>> very
>>>>> long term plan.
>>>>>
>>>>> I recommend we use the github dhis2 repository for Sharing metadata at
>>>>> this point.
>>>>>
>>>>> Cheers.
>>>>>
>>>>> John Francis Mukulu
>>>>> Lead Developer, HISPTZ
>>>>> University of Dar es salaam
>>>>> http://hisptanzania.org/
>>>>>
>>>>> On Apr 7, 2017 03:41, "Saptarshi Purkayastha" <sun...@gmail.com>
>>>>> wrote:
>>>>>
>>>>> Thank you John for sharing that metabase2 app. The UX is great! I
>>>>> assume its getting the repository data from the github repo. What would be
>>>>> nice is to "preview the system" with the imported metadata and you could
>>>>> rollback to your metadata. But the dhis2-live is a better way to deploy
>>>>> "previewing of system" with a different metadata.
>>>>>
>>>>> Alvin, thank you for sharing that there is interest in AeHIN network
>>>>> countries... I had assumed with so many implementations of DHIS2 across 
>>>>> the
>>>>> globe, there would be "real" metadata, than whats in the demo or training
>>>>> databases. Would be great if repository of medicines is also available, in
>>>>> something like the NDF
>>>>> <https://www.nlm.nih.gov/research/umls/sourcereleasedocs/current/NDFRT/index.html>
>>>>> at least for a region. Even in DHIS2 metadata format would be a good place
>>>>> to be.
>>>>>
>>>>> ---
>>>>> Regards,
>>>>> Saptarshi PURKAYASTHA, Ph.D.
>>>>> Assistant Professor of Health Informatics,
>>>>> Indiana University - Purdue University Indianapolis.
>>>>>
>>>>> On 6 April 2017 at 20:13, Alvin Marcelo <admarc...@up.edu.ph> wrote:
>>>>>
>>>>>> Hi Saptarshi,
>>>>>>
>>>>>> Offhand, no we dont have a repository of metadata -- but yes we
>>>>>> (AeHIN) is interested if there is going to be one.
>>>>>>
>>>>>> There are 12 DHIS2-implementing countries in AeHIN and they have been
>>>>>> meeting annually at ou

Re: [Dhis2-devs] [Dhis2-users] Org unit lists

[Hannan Khan]

;
>>>>> wrote:
>>>>>
>>>>>> Hi devs and users,
>>>>>> Is there a metadata sharing repository, where implementers can get a
>>>>>> list of metadata that is used by different implementers? The org units 
>>>>>> list
>>>>>> would be a useful starting place that many implementers in a country 
>>>>>> could
>>>>>> share. But there is probably a whole list of indicators, tracker program
>>>>>> forms (for standardized global programs) that could also be shared.
>>>>>>
>>>>>> Is there a repository some place? or plan for such a repository? May
>>>>>> be it could simply be on the mailing list and people could share the
>>>>>> metadata export files here.
>>>>>>
>>>>>> ---
>>>>>> Regards,
>>>>>> Saptarshi PURKAYASTHA, Ph.D.
>>>>>> Assistant Professor of Health Informatics,
>>>>>> Indiana University - Purdue University Indianapolis.
>>>>>>
>>>>>
>>>>>
>>>>> ___
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to : dhis2-us...@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Dr. Alvin B. Marcelo www.alvinmarcelo.com
>>>> <http://www.alvinmarcelo.com/cv.html>
>>>>
>>>>
>>>>
>>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>>
>>
>>
>> --
>> Dr. Alvin B. Marcelo www.alvinmarcelo.com
>> <http://www.alvinmarcelo.com/cv.html>
>>
>>
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Muhammad Abdul Hannan Khan
DHIS2 Country coordinator & Secretary
HISP Bangladesh

T +880-2- 58816459, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] [Dhis2-users] critical security vulnerability found - immediate dhis upgrade required

[Hannan Khan]

Dear Lars

I find problem downloading from https://ci.dhis2.org/. The download was
very slow and interrupted.

Is the links https://www.dhis2.org/download/releases/2.22/dhis.war has
updated war files?

Regards

Hannan

On Tue, Mar 14, 2017 at 12:10 AM, Lars Helge Øverland <l...@dhis2.org>
wrote:

> Hi all,
>
> a critical vulnerability has been detected in one of the software
> libraries used by DHIS 2. This vulnerability allows an attacker to run
> remote commands on the server as the user running Tomcat/DHIS 2.
>
> We have patched all DHIS 2 versions from 2.21 to 2.26 / master. You can
> find new WAR file builds here:
>
> https://www.dhis2.org/downloads
>
> We strongly recommend all DHIS 2 server admins to *upgrade immediately*
> to a patched version.
>
> Keep in mind that your server might already be compromised. As a result
> one should look for suspicious activity on the server (bandwidth usage, tmp
> folders, etc). If you run Tomcat as a user with sudo privileges (not
> recommended) this means that your server might be fully compromised. To be
> on the absolute safe side it might be necessary to do a full wipe and
> re-install of your server environment.
>
> More info on the exploit:
>
> - https://arstechnica.com/security/2017/03/critical-
> vulnerability-under-massive-attack-imperils-high-impact-sites/
>
> - http://www.javaworld.com/article/3179215/security/
> hackers-exploit-apache-struts-vulnerability-to-compromise-
> corporate-web-servers.html#tk.rss_all
>
>
> We are sorry about this. The vulnerable library is the Struts2 web
> framework, which we are in the process of writing out of the system.
>
> regards,
>
> Lars
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Muhammad Abdul Hannan Khan
DHIS2 Country coordinator & Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] [Dhis2-users] critical security vulnerability found - immediate dhis upgrade required

[Hannan Khan]

Thanks Lars.

On Tue, Mar 14, 2017 at 12:10 AM, Lars Helge Øverland <l...@dhis2.org>
wrote:

> Hi all,
>
> a critical vulnerability has been detected in one of the software
> libraries used by DHIS 2. This vulnerability allows an attacker to run
> remote commands on the server as the user running Tomcat/DHIS 2.
>
> We have patched all DHIS 2 versions from 2.21 to 2.26 / master. You can
> find new WAR file builds here:
>
> https://www.dhis2.org/downloads
>
> We strongly recommend all DHIS 2 server admins to *upgrade immediately*
> to a patched version.
>
> Keep in mind that your server might already be compromised. As a result
> one should look for suspicious activity on the server (bandwidth usage, tmp
> folders, etc). If you run Tomcat as a user with sudo privileges (not
> recommended) this means that your server might be fully compromised. To be
> on the absolute safe side it might be necessary to do a full wipe and
> re-install of your server environment.
>
> More info on the exploit:
>
> - https://arstechnica.com/security/2017/03/critical-
> vulnerability-under-massive-attack-imperils-high-impact-sites/
>
> - http://www.javaworld.com/article/3179215/security/
> hackers-exploit-apache-struts-vulnerability-to-compromise-
> corporate-web-servers.html#tk.rss_all
>
>
> We are sorry about this. The vulnerable library is the Struts2 web
> framework, which we are in the process of writing out of the system.
>
> regards,
>
> Lars
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Muhammad Abdul Hannan Khan
DHIS2 Country coordinator & Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] WAR file cannot deploy in tomcat 8

[Hannan Khan]

Thanks guys problem resolved.

The reason was corrupt war file. But it is quite odd I download twice (with
two hour difference), both are corrupt.

The third one is OK, but all thre showing same size.

Regards

Hannan

On Thu, Mar 2, 2017 at 2:57 PM, Calle Hedberg <calle.hedb...@gmail.com>
wrote:

> Hannan
>
> I've been running all versions from 2.17 to 2.27 on the same platform
> (java 8 build 121, tomcat 8.0.33 and 36) - no problems. So I agree with Bob
> - looks like a damaged war file.
>
> Regards
> Calle
>
> On 2 March 2017 at 08:09, Bob Jolliffe <bobjolli...@gmail.com> wrote:
>
>> Looks like a damaged war file (hence the zip exceptions when it tries to
>> extract).
>>
>> Please try and download again or try with a known good war file.
>>
>> On 2 March 2017 at 11:35, Hannan Khan <hann...@gmail.com> wrote:
>>
>>> Thanks bob for quick response.
>>>
>>> Java:
>>> java version "1.8.0_121"
>>> Java(TM) SE Runtime Environment (build 1.8.0_121-b13)
>>> Java HotSpot(TM) 64-Bit Server VM (build 25.121-b13, mixed mode)
>>>
>>> And log:
>>>
>>> 02-Mar-2017 11:29:07.031 INFO [localhost-startStop-2]
>>> org.apache.catalina.startup.HostConfig.deployWAR Deploying web
>>> application archive /opt/tomcat/webapps/dhis.war
>>> 02-Mar-2017 11:29:07.604 SEVERE [localhost-startStop-2]
>>> org.apache.catalina.startup.ContextConfig.beforeStart Exception fixing
>>> docBase for context [/dhis]
>>>  java.util.zip.ZipException: invalid literal/lengths set
>>> at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:164)
>>> at java.io.FilterInputStream.read(FilterInputStream.java:107)
>>> at org.apache.catalina.startup.ExpandWar.expand(ExpandWar.java:381)
>>> at org.apache.catalina.startup.ExpandWar.expand(ExpandWar.java:165)
>>> at org.apache.catalina.startup.ContextConfig.fixDocBase(Context
>>> Config.java:619)
>>> at org.apache.catalina.startup.ContextConfig.beforeStart(Contex
>>> tConfig.java:752)
>>> at org.apache.catalina.startup.ContextConfig.lifecycleEvent(Con
>>> textConfig.java:308)
>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent
>>> (LifecycleSupport.java:95)
>>> at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(Li
>>> fecycleBase.java:90)
>>> at org.apache.catalina.util.LifecycleBase.setStateInternal(Life
>>> cycleBase.java:394)
>>> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:144)
>>> at org.apache.catalina.core.ContainerBase.addChildInternal(Cont
>>> ainerBase.java:725)
>>> at org.apache.catalina.core.ContainerBase.addChild(ContainerBas
>>> e.java:701)
>>> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
>>> at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:940)
>>> at org.apache.catalina.startup.HostConfig$DeployWar.run(HostCon
>>> fig.java:1816)
>>> at java.util.concurrent.Executors$RunnableAdapter.call(Executor
>>> s.java:511)
>>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
>>> Executor.java:1142)
>>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
>>> lExecutor.java:617)
>>> at java.lang.Thread.run(Thread.java:745)
>>>
>>> 02-Mar-2017 11:29:08.147 SEVERE [localhost-startStop-2]
>>> org.apache.catalina.core.ContainerBase.addChildInternal
>>> ContainerBase.addChild: start:
>>>  org.apache.catalina.LifecycleException: Failed to start component
>>> [StandardEngine[Catalina].StandardHost[localhost].StandardCo
>>> ntext[/dhis]]
>>> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:153)
>>> at org.apache.catalina.core.ContainerBase.addChildInternal(Cont
>>> ainerBase.java:725)
>>> at org.apache.catalina.core.ContainerBase.addChild(ContainerBas
>>> e.java:701)
>>> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
>>> at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:940)
>>> at org.apache.catalina.startup.HostConfig$DeployWar.run(HostCon
>>> fig.java:1816)
>>> at java.util.concurrent.Executors$RunnableAdapter.call(Executor
>>> s.java:511)
>>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
>>> Executor.java:1142)
>>> at java.util.concurrent.Thread

[Dhis2-devs] WAR file cannot deploy in tomcat 8

[Hannan Khan]

Dear All

I just update one server to tomcat8 (version 8.0.36) but not able to deploy
war file (dhis2 version 23) the error message is following. I never have
this message before. I need immediate help.

FAIL - Encountered exception org.apache.catalina.LifecycleException: Failed
to start component
[StandardEngine[Catalina].StandardHost[localhost].StandardContext[/dhis]]

Regards

Muhammad Abdul Hannan Khan
DHIS2 Country coordinator & Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] [Dhis2-users] Integration of Electronic Tuberculosis Management (eTBM) with DHIS2

[Hannan Khan]

Thanks Adolphe.

Our plan is to implement DHIS2 tracker as well. We are gradually moving
towards DHIS2 TB Tracker, so your experience will be helpful for us.
Hopefully in the next financial year we can move towards DHIS2 TB tracker.

Regards

Hannan

On Mon, Feb 27, 2017 at 8:14 PM, Kamugunga Adolphe <kaa...@gmail.com> wrote:

> Dear Sujan,
> Here in Rwanda, we have implemented TB and MDR TB tracking systems in
> DHIS2, collecting  summarized patient level data to generate quarterly
> forms but when it comes to delete records for different reasons into this
> multi-stages system we re also having hard time to delete recorded data.
> dhis2.25 has an option of deleting cases reported and through Data
> administration-Maintenance  you can "Permanently remove soft deleted data
> values" , for some case it works  and if i am not mistaken you delete
> records one by one, you can't select a list of records  and delete them once
>
> Regards,
>
>
> *Adolphe Kamugunga*
> *MIS Technical Advisor*
> Mobile: +250 788 740 578 <+250%20788%20740%20578>
> Email:kaa...@gmail.com
> Skype: ka.adolphe
>  RWANDA
>
>
> On 27 February 2017 at 13:43, Julhas Sujan <julhaspust...@gmail.com>
> wrote:
>
>> Dear All,
>>
>> Good evening!
>>
>> We are working on DHIS2 TB-10,11 and 12 forms (for Bangladesh) to
>> integrate with external eTB manager application
>> <http://etbmanagerbd.org/>. The TB forms have developed in DHIS2 for
>> collecting TB -10,11 and 12 data from Upazila level in Bangladesh but we
>> have a local level application(eTBM) that is using to collect individual
>> case record and generate aggregated TB-10,11 and 12 reports. Now  our goal
>> is to integrate eTMB with DHIS2 TB forms.
>>
>> Already we have tested the integration that is working fine. But we are
>> facing a problem with deleting existing records of these forms. I have a
>> question on it:
>>
>> *Is there any way of requesting DHIS2 to clear or delete the whole TB 10
>> form for a specific orgunit and period before sending the external data?*
>>
>>
>> Thank you very much for your co-operations.
>>
>>
>> *If you have any questions or concerns, don’t hesitate to let me know.*
>>
>> *Best Regards*
>> *Julhas Sujan*
>> Senior Java Programmer
>> Management Science for Health(MSH)
>> Dhaka, Bangladesh
>> Cell: +8801989 442856
>> Skype: julhas08
>> ​
>> www.msh.org http://siapsprogram.org/wherewework/bangladesh/
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@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-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Muhammad Abdul Hannan Khan
DHIS2 Country coordinator & Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] [Dhis2-users] Integration of Electronic Tuberculosis Management (eTBM) with DHIS2

[Hannan Khan]

Dear Julhas

Please be note that, for security reason we are not allowing 'data delete'
from any data set through API externally if it is not exclusive (data only
enter through API). So audit log is monitored. If identifies the user could
be blocked. As your eTB system suppose to be send aggregated data to
national country wide DHIS2, make sure that, it is tested properly,
reviewed by us and only then you could have access to the live production
system.

API from external source are only allowed 'insert' and 'update'. System
security will not be compromised.

Regards

On Mon, Feb 27, 2017 at 8:59 PM, Lars Helge Øverland <l...@dhis2.org> wrote:

> Hi Julhas,
>
> that's an interesting problem. We could certainly implement support for
> deletion per org unit/period.
>
> I would however recommend another approach: For each aggregate report you
> send from eTBM, make sure you send a value, including 0, for* each field*
> in the aggregate TB form. This will make your information more explicit,
> ie. you communicate that for all data element + category option combos
> exactly how many cases you have. The benefit then is that if cases are
> deleted in the upstream system (eTBM), it will be correctly reflected in
> the aggregate form in DHIS 2.
>
> This will be semantically more correct than simply dropping all data
> values first. I.e. when you look at the audit logs for each data element,
> you will see that a value changed from a positive value, then potentially
> to a 0 value. This will look better compared to audit logs showing that all
> values were deleted every day. This will improve auditability and data
> validation.
>
> Of course this might lead to the aggregate export payload becoming a bit
> bigger, but I think that can be justified. You can also make sure that the
> TB data elements are set to "zero not significant", which will delete or
> not store 0 values on the DHIS 2 side.
>
> Let me know if this sounds reasonable.
>
> best,
>
> Lars
>
>
>
>
>
>
>
>
>
>
> On Mon, Feb 27, 2017 at 12:43 PM, Julhas Sujan <julhaspust...@gmail.com>
> wrote:
>
>> Dear All,
>>
>> Good evening!
>>
>> We are working on DHIS2 TB-10,11 and 12 forms (for Bangladesh) to
>> integrate with external eTB manager application
>> <http://etbmanagerbd.org/>. The TB forms have developed in DHIS2 for
>> collecting TB -10,11 and 12 data from Upazila level in Bangladesh but we
>> have a local level application(eTBM) that is using to collect individual
>> case record and generate aggregated TB-10,11 and 12 reports. Now  our goal
>> is to integrate eTMB with DHIS2 TB forms.
>>
>> Already we have tested the integration that is working fine. But we are
>> facing a problem with deleting existing records of these forms. I have a
>> question on it:
>>
>> *Is there any way of requesting DHIS2 to clear or delete the whole TB 10
>> form for a specific orgunit and period before sending the external data?*
>>
>>
>> Thank you very much for your co-operations.
>>
>>
>> *If you have any questions or concerns, don’t hesitate to let me know.*
>>
>> *Best Regards*
>> *Julhas Sujan*
>> Senior Java Programmer
>> Management Science for Health(MSH)
>> Dhaka, Bangladesh
>> Cell: +8801989 442856
>> Skype: julhas08
>> ​
>> www.msh.org http://siapsprogram.org/wherewework/bangladesh/
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Muhammad Abdul Hannan Khan
DHIS2 Country coordinator & Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] [Dhis2-users] Integration of Electronic Tuberculosis Management (eTBM) with DHIS2

[Hannan Khan]

We are not allowing '0' in the data until and unless it is essential. In
your case '0' will be you significant amount; so we cant allow that.

On Mon, Feb 27, 2017 at 9:25 PM, Julhas Sujan <julhaspust...@gmail.com>
wrote:

> Hi Lars,
>
> Thank you very much. Yes this is possible to set zero for each field. I
> will follow your recommendation and share with you the update.
>
>
> *Best Regards*
>
> *Julhas *
>
> On Mon, Feb 27, 2017 at 8:59 PM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>> Hi Julhas,
>>
>> that's an interesting problem. We could certainly implement support for
>> deletion per org unit/period.
>>
>> I would however recommend another approach: For each aggregate report you
>> send from eTBM, make sure you send a value, including 0, for* each field*
>> in the aggregate TB form. This will make your information more explicit,
>> ie. you communicate that for all data element + category option combos
>> exactly how many cases you have. The benefit then is that if cases are
>> deleted in the upstream system (eTBM), it will be correctly reflected in
>> the aggregate form in DHIS 2.
>>
>> This will be semantically more correct than simply dropping all data
>> values first. I.e. when you look at the audit logs for each data element,
>> you will see that a value changed from a positive value, then potentially
>> to a 0 value. This will look better compared to audit logs showing that all
>> values were deleted every day. This will improve auditability and data
>> validation.
>>
>> Of course this might lead to the aggregate export payload becoming a bit
>> bigger, but I think that can be justified. You can also make sure that the
>> TB data elements are set to "zero not significant", which will delete or
>> not store 0 values on the DHIS 2 side.
>>
>> Let me know if this sounds reasonable.
>>
>> best,
>>
>> Lars
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Mon, Feb 27, 2017 at 12:43 PM, Julhas Sujan <julhaspust...@gmail.com>
>> wrote:
>>
>>> Dear All,
>>>
>>> Good evening!
>>>
>>> We are working on DHIS2 TB-10,11 and 12 forms (for Bangladesh) to
>>> integrate with external eTB manager application
>>> <http://etbmanagerbd.org/>. The TB forms have developed in DHIS2 for
>>> collecting TB -10,11 and 12 data from Upazila level in Bangladesh but we
>>> have a local level application(eTBM) that is using to collect individual
>>> case record and generate aggregated TB-10,11 and 12 reports. Now  our goal
>>> is to integrate eTMB with DHIS2 TB forms.
>>>
>>> Already we have tested the integration that is working fine. But we are
>>> facing a problem with deleting existing records of these forms. I have a
>>> question on it:
>>>
>>> *Is there any way of requesting DHIS2 to clear or delete the whole TB 10
>>> form for a specific orgunit and period before sending the external data?*
>>>
>>>
>>> Thank you very much for your co-operations.
>>>
>>>
>>> *If you have any questions or concerns, don’t hesitate to let me know.*
>>>
>>> *Best Regards*
>>> *Julhas Sujan*
>>> Senior Java Programmer
>>> Management Science for Health(MSH)
>>> Dhaka, Bangladesh
>>> Cell: +8801989 442856
>>> Skype: julhas08
>>> ​
>>> www.msh.org http://siapsprogram.org/wherewework/bangladesh/
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Muhammad Abdul Hannan Khan
DHIS2 Country coordinator & Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] [Dhis2-users] Error on GIS

[Hannan Khan]

Dear Mahbub

Google Map change there policy, as Bjørn already mentioned, upgrade to
upper version version.

As our Director General Health is instructed we are in process to work
together with IEDCR and we are in process to meet your director and
relevant person soon.

Also we can help you to upgrade your system. Please keep in touch.

Regards

On Tue, Jan 10, 2017 at 2:58 PM, Mahbubul Alam <alam12...@gmail.com> wrote:

>
> Dear Team,
> Hope you doing well. we facing some problem with GIS on DHIS2 version 2.21
> please see the attached screenshot for error details.
>
> Plz help..
>
>
>
> --
> [image: http://iedcr.gov.bd/images/stories/logo_new.jpg]
> Thanks
> *Mahbubul Alam* | "*IT Consultant*" (GHSA Project)
> Msc in CSE, Bsc in CSc. Associate Member of BCS.
>
> *Institute of Epidemiology Disease Control & Research (IEDCR)*
> www.iedcr.gov.bd
> Mohakhali Dhaka.
>
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Muhammad Abdul Hannan Khan
Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

Re: [Dhis2-devs] Event Capture is not loading

[Hannan Khan]

Thanks Abyot.

I tried several times clearing cache and using incognito mode as well.

Tried several version  including the new release, version 2.22 release
d031d6c.

I am not sure if any metadata changed. But meta data changed how could we
solve the problem?

Regards

Hannan

On Tue, Sep 27, 2016 at 6:09 PM, Abyot Asalefew Gizaw <ab...@dhis2.org>
wrote:

> Hi Hannan,
>
> Which version are you using?
>
> Seems you have had metadata change. Check if all your programs have
> program stage and for the program stages to have data elements assigned to
> them.
>
> Also, can you clear your browser cache and try one more time?
>
> --
> Abyot A. Gizaw.
> Senior Engineer, DHIS2
> University of Oslo
> http://www.dhis2.org
>
> On Tue, Sep 27, 2016 at 8:36 AM, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear All
>>
>> Suddenly from few days ago out event capture is not loading. Only country
>> Orgunit loaded and showing 'Loading meta-data'.
>>
>> [image: Inline image 1]
>>
>> There is no error log in the tomcat but I find error in the script which
>> is
>>
>> Uncaught TypeError: Cannot read property 'programStageDataElements' of
>> undefined
>> at http://103.247.238.82:8080/dhismohfw/dhis-web-event-capture/
>> scripts/event-capture.js:239:61
>> at Array.forEach (native)
>> at Function.j.each.j.forEach (http://103.247.238.82:8080/dh
>> ismohfw/dhis-web-commons/javascripts/underscore.min.js:5:599)
>> at Object.filterMissingPrograms (http://103.247.238.82:8080/dh
>> ismohfw/dhis-web-event-capture/scripts/event-capture.js:238:7)
>> at Object. (http://103.247.238.82:8080/dh
>> ismohfw/dhis-web-commons/javascripts/jQuery/jquery.min.js:2:18263)
>> at k (http://103.247.238.82:8080/dhismohfw/dhis-web-commons/javas
>> cripts/jQuery/jquery.min.js:2:16920)
>> at Object.fireWith (http://103.247.238.82:8080/dh
>> ismohfw/dhis-web-commons/javascripts/jQuery/jquery.min.js:2:17707)
>> at Object.fire (http://103.247.238.82:8080/dh
>> ismohfw/dhis-web-commons/javascripts/jQuery/jquery.min.js:2:17744)
>> at k (http://103.247.238.82:8080/dhismohfw/dhis-web-commons/javas
>> cripts/jQuery/jquery.min.js:2:16920)
>> at Object.fireWith (http://103.247.238.82:8080/dh
>> ismohfw/dhis-web-commons/javascripts/jQuery/jquery.min.js:2:17707)
>>
>> Please help me to resolve the problem.
>>
>> Muhammad Abdul Hannan Khan
>> Secretary
>> HISP Bangladesh
>>
>> T +880-2- 8816459, 8816412 ext 118
>> F +88 02 8813 875
>> M+88 01819 239 241
>> M+88 01534 312 066
>> E hann...@gmail.com
>> S hannan.khan.dhaka
>> B hannan-tech.blogspot.com
>> L https://bd.linkedin.com/in/hannankhan
>>
>>
>> ___
>> 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
>>
>>
>


-- 
Muhammad Abdul Hannan Khan
Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

[Dhis2-devs] Event Capture is not loading

[Hannan Khan]

Dear All

Suddenly from few days ago out event capture is not loading. Only country
Orgunit loaded and showing 'Loading meta-data'.

[image: Inline image 1]

There is no error log in the tomcat but I find error in the script which is

Uncaught TypeError: Cannot read property 'programStageDataElements' of
undefined
at
http://103.247.238.82:8080/dhismohfw/dhis-web-event-capture/scripts/event-capture.js:239:61
at Array.forEach (native)
at Function.j.each.j.forEach (
http://103.247.238.82:8080/dhismohfw/dhis-web-commons/javascripts/underscore.min.js:5:599
)
at Object.filterMissingPrograms (
http://103.247.238.82:8080/dhismohfw/dhis-web-event-capture/scripts/event-capture.js:238:7
)
at Object. (
http://103.247.238.82:8080/dhismohfw/dhis-web-commons/javascripts/jQuery/jquery.min.js:2:18263
)
at k (
http://103.247.238.82:8080/dhismohfw/dhis-web-commons/javascripts/jQuery/jquery.min.js:2:16920
)
at Object.fireWith (
http://103.247.238.82:8080/dhismohfw/dhis-web-commons/javascripts/jQuery/jquery.min.js:2:17707
)
at Object.fire (
http://103.247.238.82:8080/dhismohfw/dhis-web-commons/javascripts/jQuery/jquery.min.js:2:17744
)
at k (
http://103.247.238.82:8080/dhismohfw/dhis-web-commons/javascripts/jQuery/jquery.min.js:2:16920
)
at Object.fireWith (
http://103.247.238.82:8080/dhismohfw/dhis-web-commons/javascripts/jQuery/jquery.min.js:2:17707)


Please help me to resolve the problem.

Muhammad Abdul Hannan Khan
Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan
___
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

[Dhis2-devs] e-TB data in DHIS2 tracker

[Hannan Khan]

Dear Experts

Anybody have any information of linking between e-TB manager and DHIS2
tracker? Any country example? can you all please share.

Regards

-- 
Muhammad Abdul Hannan Khan
Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
___
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

[Dhis2-devs] Reporting rates are not available: DHIS2 data synchronization

[Hannan Khan]

Dear Experts

I am using DHIS2 data synchronization for synchronizing transaction server
with reporting server which is feeding several reporting options. But the
'reporting rates' are not available in Pivot Tables of the synchronized
reporting server. Is there any reason for that? how can I get that
reporting rates?

Regards

-- 
Muhammad Abdul Hannan Khan
Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
___
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

Re: [Dhis2-devs] [Dhis2-users] Assign program to organization group

[Hannan Khan]

Aha!

I think I get your point. In version 2.13 there is additional one tab named
'Organization Unit Group' (as attached). But functionally it is same as
'Select in group' of 'Organisation Unit Selection'.

Did you find any specific difference? I find that due to large number of
organisation unit in the orgunit tree, it took some time to load otherwise
it is same.

Regards


On Wed, Jun 22, 2016 at 10:12 AM, Nayeem Al Mifthah <n.mift...@gmail.com>
wrote:

> Dear Hannan vai
> Sorry for can't make the question as I want.
>
> Let me formulate the question again.
>
> in 2.13 version there is a option in program assignment to select a
> organizationunit group. Later the program will automatically assigned if
> any organization created with that organizationunit group.
>
> I can't find that functionality in 2.22.
>
> *Nayeem Al Mifthah*
> Consultant (Team Leader of HMIS)
> Management Information System
> Directorate General of Health Services (DGHS), Bangladesh
> Supported by: UNICEF-Bangladesh
> Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
> Cell:+8801914030574
> Skype: nayeem.a.m
>
> On Wed, Jun 22, 2016 at 9:11 AM, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear Nayeem
>>
>> It is possible to assign Organisation Unit by group to a Program and it
>> is already in this version. Please see the attached.
>>
>> Is there any specific issue?
>>
>> On Wed, Jun 22, 2016 at 8:10 AM, Nayeem Al Mifthah <n.mift...@gmail.com>
>> wrote:
>>
>>> I am using 2.22 version. Build version: 21827
>>>
>>> *Nayeem Al Mifthah*
>>> Consultant (Team Leader of HMIS)
>>> Management Information System
>>> Directorate General of Health Services (DGHS), Bangladesh
>>> Supported by: UNICEF-Bangladesh
>>> Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
>>> Cell:+8801914030574
>>> Skype: nayeem.a.m
>>>
>>> On Wed, Jun 22, 2016 at 8:01 AM, Nayeem Al Mifthah <n.mift...@gmail.com>
>>> wrote:
>>>
>>>> Dear All
>>>> Is it possible to assaign program to selected organization group
>>>> without selecting organization one by one manually.
>>>>
>>>>
>>>> *Nayeem Al Mifthah*
>>>> Consultant (Team Leader of HMIS)
>>>> Management Information System
>>>> Directorate General of Health Services (DGHS), Bangladesh
>>>> Supported by: UNICEF-Bangladesh
>>>> Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
>>>> Cell:+8801914030574
>>>> Skype: nayeem.a.m
>>>>
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Muhammad Abdul Hannan Khan
>> Secretary
>> HISP Bangladesh
>>
>> T +880-2- 8816459, 8816412 ext 118
>> F +88 02 8813 875
>> M+88 01819 239 241
>> M+88 01534 312 066
>> E hann...@gmail.com
>> S hannan.khan.dhaka
>> B hannan-tech.blogspot.com
>>
>>
>


-- 
Muhammad Abdul Hannan Khan
Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
___
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

Re: [Dhis2-devs] [Dhis2-users] thomas lindsjørn joins as android developer

[Hannan Khan]

Welcome Thomas!!

On Wed, May 25, 2016 at 1:09 AM, Lars Helge Øverland <l...@dhis2.org> wrote:

> Hi all,
>
> Thomas Lindsjørn has joined the DHIS 2 team as Android developer. Thomas
> has 4 years of experience developing Android applications within public
> transport, sports and finance. He has been involved with architecture, UX
> design, programming and testing.
>
> We with him a warm welcome to the team.
>
>
> best regards,
>
> Lars
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Muhammad Abdul Hannan Khan
Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
___
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

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

[Hannan Khan]

Supporting Jim and Ola on implementation wide settings to configure a
default system-wide separator with provision to override for each pivot
table. For Bangladesh the default separator is 'Comma'.

Regards

Hannan
HISP Bangladesh

On Wed, May 4, 2016 at 1:32 AM, Ola Hodne Titlestad <ol...@ifi.uio.no>
wrote:

> Supporting Jim's suggestion on a system/implementation setting to
> configure a default system-wide separator in addition to the possibility of
> overriding this for each pivot table or other type of report with display
> options. I guess the result of the vote could still be what the default
> value for this system setting should be
>
> Ola
> --
>
> --
> Ola Hodne Titlestad (Mr)
> HISP
> Department of Informatics
> University of Oslo
>
> Mobile: +47 48069736
> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
> <https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge=en=UTF8=59.893855,10.785116=0.222842,0.585709=eftas%C3%A5sen+68,+0687+Oslo,+=h=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway=16>
>
> On 3 May 2016 at 21:12, Jim Grace <j...@dhis2.org> wrote:
>
>> To me the most important way to address this is to allow an
>> implementation-wide default. The space character is in many ways the
>> "correct" separator according to international norms, and is even making
>> inroads into countries such as the US that traditionally use the comma. I
>> think the space is probably the best "factory" default for DHIS 2, so that
>> large numbers are readable on demonstration systems, and so we follow
>> international and emerging standards.
>>
>> However, an implementation should be able to override this with an
>> implementation-wide default of comma, where a preponderance of users for
>> that implementation are more used to this, and/or where exporting to Excel
>> is a concern.
>>
>> Expecting users to override the default every time they create a pivot
>> table is not very user-friendly.
>>
>>
>> On Tue, May 3, 2016 at 1:46 PM, Prosper BT <ptb3...@gmail.com> wrote:
>>
>>> I vote for having none as default (1432) then one can choose what they
>>> want in options
>>>
>>>
>>> On Tue, May 3, 2016 at 7:36 PM, Lars Helge Øverland <l...@dhis2.org>
>>> wrote:
>>>
>>>> Hi there,
>>>>
>>>> we are getting many (conflicting) requests for what the default value
>>>> should be for the "digit group separator" in the pivot table app.
>>>>
>>>> So lets decide with a poll.. Cast your vote here before Friday 6th!
>>>>
>>>> http://doodle.com/poll/vtyzgts226aqihev
>>>>
>>>>
>>>> The digit group separator controls how large numbers are being split
>>>> up, e.g.
>>>>
>>>> 1 432
>>>> 1,432
>>>> 1432
>>>>
>>>> The digit group separator can be controlled from Options.
>>>>
>>>> [image: Inline image 1]
>>>>
>>>> regards,
>>>>
>>>> Lars
>>>>
>>>>
>>>>
>>>> --
>>>> Lars Helge Øverland
>>>> Lead developer, DHIS 2
>>>> University of Oslo
>>>> Skype: larshelgeoverland
>>>> l...@dhis2.org
>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Prosper Behumbiize, MPH
>>> Global HISP| University Of Oslo/HISP Uganda
>>> +256 752 751 776 | +256 776 139 139
>>> pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | Skype:
>>> prospertb
>>>
>>> _______
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jim Grace
>> Core developer, DHIS 2
>> HISP US Inc.
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>> ___
>> 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
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Muhammad Abdul Hannan Khan
Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
___
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

[Dhis2-devs] [Bug 1565716] Re: Drill Down not possible in GIS module

[Hannan Khan]

** Description changed:

- In the GIS module drill down is not possible. It showing 'Loadin' but
- hat never ends. Chrome debug report says "Uncaught type error: can not
- read property 'objectName' of undefined".
+ In the current GIS module drill down is not possible. It showing
+ 'Loading' but that never ends. Chrome debug report says "Uncaught type
+ error: can not read property 'objectName' of undefined".
  
  But interesting thing is when I save this map as favorites and added to
- dashboard; then from dashboard (not use explore) drill down is possible.
+ dashboard; then from dashboard (not using explore) drill down is
+ possible. I am using DHIS2 version 2.22 build 21962. Chrome version
+ 50.0.2661.57.

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1565716

Title:
  Drill Down not possible in GIS module

Status in DHIS:
  New

Bug description:
  In the current GIS module drill down is not possible. It showing
  'Loading' but that never ends. Chrome debug report says "Uncaught type
  error: can not read property 'objectName' of undefined".

  But interesting thing is when I save this map as favorites and added
  to dashboard; then from dashboard (not using explore) drill down is
  possible. I am using DHIS2 version 2.22 build 21962. Chrome version
  50.0.2661.57.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1565716/+subscriptions

___
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

[Dhis2-devs] [Bug 1565716] [NEW] Drill Down not possible in GIS module

[Hannan Khan]

Public bug reported:

In the GIS module drill down is not possible. It showing 'Loadin' but
hat never ends. Chrome debug report says "Uncaught type error: can not
read property 'objectName' of undefined".

But interesting thing is when I save this map as favorites and added to
dashboard; then from dashboard (not use explore) drill down is possible.

** Affects: dhis2
 Importance: Undecided
 Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1565716

Title:
  Drill Down not possible in GIS module

Status in DHIS:
  New

Bug description:
  In the GIS module drill down is not possible. It showing 'Loadin' but
  hat never ends. Chrome debug report says "Uncaught type error: can not
  read property 'objectName' of undefined".

  But interesting thing is when I save this map as favorites and added
  to dashboard; then from dashboard (not use explore) drill down is
  possible.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1565716/+subscriptions

___
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

[Dhis2-devs] Bug in GIS Module DHIS2 Version 22

[Hannan Khan]

Dear Experts

In the current GIS module drill down is not possible. It showing 'Loading'
but that never ends. Chrome debug report says "Uncaught type error: can not
read property 'objectName' of undefined".

But interesting thing is when I save this map as favorites and added to
dashboard; then from dashboard (not using explore) drill down is possible.


I am using DHIS2 version 2.22 build 21962.
Chrome version 50.0.2661.57

Please find a solution as soon as possible.

Regards

Hannan Khan
HISP Bangladesh
___
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

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Hannan Khan]

Ok. But can it be solved? It will appear in the next leap-year.

DHIS2 is an excellent work done by all of you (and us) and we are hesitant
to say all users that it's DHIS2's fault.

Regards

Hannan

On Tue, Mar 29, 2016 at 3:58 PM, Lars Helge Øverland <l...@dhis2.org> wrote:

> Hi Hannan,
>
> is this for February 2016? If so I suspect this is a leap-year issue (and
> not an issue for other periods). We can look into it but this might not be
> critical..
>
> regards,
>
> Lars
>
> On Sun, Mar 27, 2016 at 8:56 AM, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear Lars
>>
>> The problem in this thread arise again. That problem was fixed in the
>> trunk and suppose to reflect in the later versions. Can you please check
>> this issue and find a solution as soon as possible.
>>
>> We using version 2.22 build 21827.
>>
>> Regards
>>
>> Hannan Khan
>> HISP Bangladesh
>>
>>
>> On Sat, Jul 4, 2015 at 4:55 PM, Uddin Fatema <fatema...@gmail.com> wrote:
>>
>>> Dear Lars,
>>>
>>> Thank you very much. I am really happy that 2.19 is working fine. Time
>>> zone problem solved and aggregated data problem also solved.
>>>
>>> Again thanks a lot for you and core teams hard work.
>>>
>>> Best Regards
>>>
>>> Fatema
>>>
>>> On Wed, Jun 24, 2015 at 4:11 PM, Uddin Fatema <fatema...@gmail.com>
>>> wrote:
>>>
>>>> Dear Lars,
>>>>
>>>> Here I attached the Error Log file
>>>>
>>>> Thanks in advance
>>>>
>>>> On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema <fatema...@gmail.com>
>>>> wrote:
>>>>
>>>>> Dear Lars,
>>>>>
>>>>> Thanks a lot
>>>>>
>>>>> I just download 2.18 branch code and build the war file. Now i am
>>>>> running my database with this war file with UTC +6 Dhaka time zone  but
>>>>> still shows same error.
>>>>>
>>>>> Is it cash problem or anything else.
>>>>>
>>>>> On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland <
>>>>> larshe...@gmail.com> wrote:
>>>>>
>>>>>> Hi Fatema,
>>>>>>
>>>>>> we have made a fix to prevent time zone issues for resource table
>>>>>> generation in 2.18 and 2.19 now.
>>>>>>
>>>>>> regards,
>>>>>>
>>>>>> Lars
>>>>>>
>>>>>>
>>>>>> On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema <fatema...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Yes Lars i found same error in 2.18 too.
>>>>>>>
>>>>>>> Actually I updated version in 2.18 in test server but still time
>>>>>>> zone error remains for  (UTC+60 )Dhaka . You know that some time zone 
>>>>>>> has
>>>>>>> time zone problem in resource table generation. So I Changes time zone
>>>>>>> UTC+6:30) Yaangoon) and update resource table and analytic.
>>>>>>>
>>>>>>> And still I found same error which is described me and Nayeem Al
>>>>>>> Miftah.
>>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>>> On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah <
>>>>>>> n.mift...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Dear Lars
>>>>>>>> There are monthly datasets on which a data entry operator input 50
>>>>>>>> in a cell. Analytic shows that same number as 51.7 in those months 
>>>>>>>> which
>>>>>>>> have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less 
>>>>>>>> value
>>>>>>>> in February as it have 28 days.
>>>>>>>>
>>>>>>>> It has happened as the analytic table calculate the data as Ms.
>>>>>>>> Fatema has described.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Nayeem Al Mifthah
>>>>>>>> HMIS Consultant
>>>>>>>> Management Information System
>>>>>>>> Directorate General of Health Services (DGHS), Bangladesh
>>>>

Re: [Dhis2-devs] [Dhis2-users] Aggregation query builder details

[Hannan Khan]

Dear Lars

I am agreed with Dipali and like her we are using aggregated query builder
to populate aggregated data sets.

So, please consider to keep this in future releases until and unless we
find a suitable alternative.

Regards

Hannan Khan
HISP Bangladesh

On Tue, Mar 15, 2016 at 12:43 AM, Dipali Sahu <dipali.s...@gmail.com> wrote:

> Hi Lars
>
> If not further work on the Aggregation query builder feature, *please
> don't remove it*. We actually find it very useful and is critical to our
> workflow. For example, we need to get Total patients seen in a facility.
> Now with queries the user can see total figures, plus when needed segregate
> them by age, gender, visit type (new,follow up etc.) and many more
> categories in Pivot tables which provides a easy interface to suffice all
> this.
>
> Although it is possible to get these values through Program indicators,
> there is no flexibility to see data by a certain category like with the
> features that pivot table allow.
>
> I have read other emails on the group that Aggregation query builder's
> behavior is a bit unpredictable, but I haven't been able to produce any
> errors yet, given we have heavy database and complicated queries.
>
> Is it not possible to keep the Aggregation query feature as it is.
>
> Thank you
> Deepali
>
>
>
>
>
>
> On Mon, Mar 14, 2016 at 10:10 PM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>> Hi there,
>>
>> in fact, aggregation query builder is already scheduled to be removed in
>> version 2.23 and will be replaced by program indicators. Admittedly there
>> are a few cases where persisted aggregate event data could be useful,
>> however we think that generating the aggregate values "on the fly" will
>> provide more flexibility and be less of a load on the server by avoiding
>> large, nightly batch jobs.
>>
>> The current aggregation query builder was not up to scratch and could
>> have unpredictable behavior. At some point, we might use the program
>> indicator engine as basis for supporting persistence of aggregated event
>> data, but that is not top priority currently.
>>
>> We encourage you to try out the program indicators and provide feedback
>> to the dev team.
>>
>> regards,
>>
>> Lars
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Sun, Mar 13, 2016 at 1:28 PM, Uddin Fatema <fatema...@gmail.com>
>> wrote:
>>
>>> Dear All,
>>>
>>> We are facing same problem create an Aggregation query builder details
>>> as sum of data element value I put everything but it comes to Data
>>> element forsum/average/min/max ** **and try to select I can’t find
>>> anything and this field is*
>>>
>>>
>>>
>>> mandatory and the data aggregation data element and tracker data element 
>>> both
>>> has sum aggregation
>>>
>>>
>>> *Actually we cant to count Total Number of live birth from tracker
>>> capture patient type data element.*
>>>
>>>
>>> *How can I do it in program indicator ?*
>>>
>>>
>>> *Thanks*
>>>
>>>
>>> *Regards*
>>>
>>>
>>> *Fatema*
>>>
>>> On Tue, Jan 5, 2016 at 5:21 PM, Ese Egerega <e...@cis.com.ng> wrote:
>>>
>>>> Dear All,
>>>>
>>>> Am riding on Nami's question on aggregate query builder.
>>>>
>>>> I would like to know if there is a work around since the dropdown for
>>>> "Data element for sum/average/min/max*" is not working in dhis2.21*
>>>>
>>>> We have a data element in tracker which records the quantity of drugs
>>>> dispensed to patients during ANC visits. We would like to aggregate the
>>>> total drug dispensed to a dataset so as to calculate things like maximum
>>>> stock or quantity of drugs to order.
>>>>
>>>> Right now, am able to aggregate only the number of visits but not the
>>>> actual drugs dispensed.
>>>>
>>>> I will appreciated any suggestions.
>>>>
>>>> Thanks,
>>>> Ese
>>>>
>>>> On Fri, Nov 27, 2015 at 8:22 AM, Olav Poppe <olav.po...@me.com> wrote:
>>>>
>>>>> Hi,
>>>>> just wanted to add my voice in support for improving (e.g. making it
>>>>> faster and more reliable, supporting cohort analysis etc), rather than
>>>>> removing the aggregation query builder. While I think the program

Re: [Dhis2-devs] The "Organisation unit merge" function

[Hannan Khan]

Dear Jason

Than you for quick feedback.

I already have a try with your functions and faced some issues earlier. I
identified the issues and will tray again.

Regards

Hannan

On Wed, Feb 24, 2016 at 7:56 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Hannan,
>
> There were  issues with the implementation in DHIS2, and it could have
> caused major havoc with the data, depending on the situation, thus there
> was a decision to remove this for now. I think the devs are working on a
> more permanent fix, but in the time being, I created two Postgresql
> functions (if you are using MySQL..these will not work).
>
> The first, is to delete sites with data.
>
>
> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_site_with_data.sql
>
> and then to merge them (which depends on the first function)
>
>
> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/merge_orgunits.sql
>
> Absolutely no warranty on this, so be sure to test very thoroughly your
> self!  The merge function accepts different strategies (MIN, MAX, SUM, AVG,
> LATEST, FIRST) for numeric data. Non-aggregatable data (option sets, text,
> etc) will use the "latest" data in case of conflicts. You can of course
> tweak this to your needs.
>
>
> Good luck!
>
> Regards,
> Jason
>
>
> On Wed, Feb 24, 2016 at 11:43 AM, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear Experts
>>
>> From version 2.21 the "Organisation unit merge" function are
>> discontinued. In some context this was very useful. Can it be added back
>> again?
>>
>> Or I have to write SQL query to manually merge that.
>>
>> Regards
>>
>> Hannan Khan
>> HISP Bangladesh
>>
>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>
___
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

[Dhis2-devs] The "Organisation unit merge" function

[Hannan Khan]

Dear Experts

>From version 2.21 the "Organisation unit merge" function are discontinued.
In some context this was very useful. Can it be added back again?

Or I have to write SQL query to manually merge that.

Regards

Hannan Khan
HISP Bangladesh
___
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

[Dhis2-devs] Tracker user limitation

[Hannan Khan]

Dear All experts and system users

Is there any official limitation of tracker user per tomcat instance?
Postgres limitation?

Please let me know if you know. Or can refer to a related resource.

Regards

Hannan Khan
HISP Bangladesh
___
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

Re: [Dhis2-devs] [Dhis2-users] Bangladesh web portal using dhis2 plugins

[Hannan Khan]

Dear Ekani

It seems that you are using API not DHIS2 web plugins. Our portal is
designed with plugins which is easy to use.

However if you want to use API you shod pass the authentication as well.
First, try the API request with curl command from the terminal to sure that
it is working and then incorporate in the scripts. Check for CORS issue and
add requesting server with port in the 'White list' of your DHIS2 instance
from where you requesting the data.

If your objectve is to show maps, chart, pivot table in the web portal then
use plugins as described in the DHIS2 developers manual and Mohammad
Ullah's mail in this thread. Using plugin you can generate those items on
the fly as well.

Regards

Hannan Khan
HISP Bangladesh

On Mon, Jan 25, 2016 at 10:50 PM, Guy Ekani <constyek...@yahoo.fr> wrote:

> Thank u all,
>
> Here is the chrome debug report :
>
> Failed to load resource: the server responded with a status of 404 (Not
> Found)
> portal.html:1 XMLHttpRequest cannot load
> http://www.dhis-instance.org/api/me/user-account.json. Response for
> preflight is invalid (redirect)
> portal.html:1 XMLHttpRequest cannot load
> http://www.dhis-instance.org/api/organisationUnits.json?userOnly=true=id,name,children[id,name]=false.
> Response for preflight is invalid (redirect)
> portal.html:1 XMLHttpRequest cannot load
> http://www.dhis-instance.org/api/dimensions.json?fields=id,name=false.
> Response for preflight is invalid (redirect)
> portal.html:1 XMLHttpRequest cannot load
> http://www.dhis-instance.org/api/me/user-account.json. Response for
> preflight is invalid (redirect)
> portal.html:1 XMLHttpRequest cannot load
> http://www.dhis-instance.org/api/organisationUnits.json?userOnly=true=id,name,children[id,name]=false.
> Response for preflight is invalid (redirect)
> portal.html:1 XMLHttpRequest cannot load
> http://www.dhis-instance.org/api/dimensions.json?fields=id,name=false.
> Response for preflight is invalid (redirect)
> portal.html:1 XMLHttpRequest cannot load
> http://www.dhis-instance.org/api/legendSets.json?fields=id,name,legends[id,name,startValue,endValue,color]=false&_dc=1453740235773.
> Response for preflight is invalid (redirect)
> http://www.web-site.cm/portal_sample/css/images/favicon.ico Failed to
> load resource: the server responded with a status of 404 (Not Found)
> portal.html:1 Refused to execute script from '
> http://www.dhis-instance.org/api/systemSettings.jsonp?key=keyCalendar=keyDateFormat=Ext.data.JsonP.callback1&_dc=1453740235766'
> because its MIME type ('text/html') is not executable, and strict MIME type
> checking is enabled.
> portal.html:1 Refused to execute script from '
> http://www.dhis-instance.org/api/dimensions.jsonp?links=false=false=Ext.data.JsonP.callback3&_dc=1453740235768'
> because its MIME type ('text/html') is not executable, and strict MIME type
> checking is enabled.
> portal.html:1 Refused to execute script from '
> http://www.dhis-instance.org/api/organisationUnits.jsonp?userOnly=true…[id,name]=false=Ext.data.JsonP.callback2&_dc=1453740235768'
> because its MIME type ('text/html') is not executable, and strict MIME type
> checking is enabled.
> http://maps.googleapis.com/maps/api/js/AuthenticationService.Authenticate?1…cm%2Fportal_sample%2Fportal.html=_xdc_._673sju=124169
> Failed to load resource: the server responded with a status of 403
> (Forbidden)
> http://www.web-site.cm/portal_sample/carousel-1.css Failed to load
> resource: the server responded with a status of 404 (Not Found)
>
> Sincerely
>
> =
> EKANI Guy
>
>
>
>
>
>
> Le Lundi 25 janvier 2016 17h29, Hannan Khan <hann...@gmail.com> a écrit :
>
>
> Dear Ekani
>
> Sorry for late reply.
>
> I think the problem is authentication; did you pass user name inside get
> function? Like
>
> DHIS.getChart({ crossDomain: true, username: 'xx', password:
> '*', uid: 'yyy', el: 'chartName', url: base });
>
> CORS might be another issue. can you please check Chrome debug report and
> let me know the exact error.
>
> Regards
>
> Hannan Khan
> HISP Bangladesh
>
> On Sat, Jan 23, 2016 at 8:49 PM, Guy Ekani <constyek...@yahoo.fr> wrote:
>
> hello Muhammad and community
>
> In our case we have 2 Server (one for DHIS and one for our Portal), and
> it's also working when the user "view" is connected on the dhis2 instance.
> When the user "view" is disconnected to Dhis2 nothing appear on the portal.
>
> Please could you help ?
>
> Sincerely,
>
> DHIS 2.21
>
> =
> EKANI Guy
>
>
>
>
>
>
>
> Le Mercredi 23 décembre 2015 11h25, Lars Helge Øverland <
> larshe...@gmail.com> a écrit :

Re: [Dhis2-devs] [Dhis2-users] Bangladesh web portal using dhis2 plugins

[Hannan Khan]

Dear Ekani

Sorry for late reply.

I think the problem is authentication; did you pass user name inside get
function? Like

DHIS.getChart({ crossDomain: true, username: 'xx', password:
'*', uid: 'yyy', el: 'chartName', url: base });

CORS might be another issue. can you please check Chrome debug report and
let me know the exact error.

Regards

Hannan Khan
HISP Bangladesh

On Sat, Jan 23, 2016 at 8:49 PM, Guy Ekani <constyek...@yahoo.fr> wrote:

> hello Muhammad and community
>
> In our case we have 2 Server (one for DHIS and one for our Portal), and
> it's also working when the user "view" is connected on the dhis2 instance.
> When the user "view" is disconnected to Dhis2 nothing appear on the portal.
>
> Please could you help ?
>
> Sincerely,
>
> DHIS 2.21
>
> =
> EKANI Guy
>
>
>
>
>
>
>
> Le Mercredi 23 décembre 2015 11h25, Lars Helge Øverland <
> larshe...@gmail.com> a écrit :
>
>
> Hi Muhammad,
>
> this looks great! Thanks for sharing.
>
> You can expect improvements in the plugins in terms of improved load-time
> and extra features in 2.23.
>
> best regards,
>
> Lars
>
>
> On Wed, Dec 23, 2015 at 11:07 AM, Pamod Amarakoon <pam...@gmail.com>
> wrote:
>
> Dear Munna,
>
> Thank you very much for sharing.
>
> On Wed, Dec 23, 2015 at 12:49 PM, Julhas Sujan <julhaspust...@gmail.com>
> wrote:
>
> Dear Munna Viyya,
>
> It will be helpful for us. Thank you very much.
>
> *Best Regards*
> *Julhas Sujan*
> Java Consultant
> Management Science for Health(MSH)
> USAID, Dhaka, Bangladesh
> Cell: +8801989 442856
> Skype: julhas08
> Web: www.julhas.info
> ​
> www.msh.org http://siapsprogram.org/wherewework/bangladesh/
>
> On Wed, Dec 23, 2015 at 12:33 PM, Mohammad Ullah <munnab...@gmail.com>
> wrote:
>
> Dear all,
>
> I am pleased to share with you the Bangladesh portal which we have created
> based on the live data from dhis2 using dhis2 plugins. Please visit the
> following link to see the portal,
> http://103.247.238.81:8080/portal/index.html
>
> We highly appreciate the help from the community. We have got quick
> support from the community during the development.
>
> I would like to share my knowledge and experience of the development
> process, i believe this will be helpful for others,
>
> Solution
> ---
> 1) Please add the full address in the CORS whitelist,
> [image: Inline image 3]
>
> 2) Its better to download the plugins and attach those from local folder.
>
> 3) I have used the following version of the plugins,
>
>  rel="stylesheet" type="text/css" 
> href="//apps.dhis2.org/demo/dhis-web-commons/javascripts/ext-ux/carousel/css/carousel.css"
>  /> src="js/plugins/v17/v217_openlayers_OpenLayers.js"> src="js/plugins/Carousel.js"> src="js/plugins/v21/v221_plugin_chart.js"> src="js/plugins/v21/v221_plugin_table.js"> src="js/plugins/v17/v217_plugin_map.js">
>
> 4) Please use the username and password inside the get method (see the
> examples),
>
> DHIS.getChart({ crossDomain: true, username: 'view', password: 'DGHS1234', 
> uid: 'oSNtDZNZGIp', el: 'chartA1', url: base });
>
> 5) We have created a reporting server where all the live data sync
> everyday in one instance of DHIS2. We have hosted the portal in the same
> reporting server.
>
> Please let me know if i can provide any support regarding this issue.
>
> --
> Regards,
>
> *Mohammad Ullah*
>
> -
> Technical Advisor (HIS) – Health Sector
> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
> German House
> House 10/A-2, Road 90
> Gulshan 2, Dhaka 1212, Bangladesh
>
> T+880 9666701000
> F+880 28823099
> M+880 196 31 56 988
> Webhttp://lnkd.in/gQrxXz
> Skypemohammad_ullah_giz
>
> Office Location:
> Room # 304, Shahid Dr. Milan Bhavan,
> MIS, DGHS of MoHFW, Mohakhali, Dhaka.
>
> T02 8816412 (ex:118)
>
>
> ___
> 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
>
>
>
> ___
> 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
>
>
>

[Dhis2-devs] Meta data export import

[Hannan Khan]

Dear DHIS2 Expert

I am trying to export selected metadata item e.g. Chart, Event Chart, Map,
Map View etc from one server and want to import in another server with same
data. Don't get anything in the UI, but log showing error

Can you please advise how can solve this problem and /or how to chart, map,
pivot tables from one system to another?

Regards

Hannan Khan
HISP Bangladesh
___
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

Re: [Dhis2-devs] Meta data export import

[Hannan Khan]

sorry don't attach the log. Here it is.

* INFO  2016-01-07 15:55:04,923 User 'admin' started import at Thu Jan 07
15:55:04 BDT 2016 (DefaultImportService.java [taskScheduler-10])
* INFO  2016-01-07 15:55:04,924 [Level: INFO, category: METADATA_IMPORT,
time: Thu Jan 07 15:55:04 BDT 2016, message: Importing meta-data]
(InMemoryNotifier.java [taskScheduler-10])
* INFO  2016-01-07 15:55:04,924 Building object-bridge maps (preheatCache:
true). (DefaultObjectBridge.java [taskScheduler-10])
* ERROR 2016-01-07 15:55:28,801 Unexpected error occurred in scheduled
task. (TaskUtils.java [taskScheduler-10])
org.hibernate.HibernateException: More than one row with the given
identifier was found: 1153390, for class:
org.hisp.dhis.organisationunit.OrganisationUnitGroup
at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:104)



On Thu, Jan 7, 2016 at 4:01 PM, Hannan Khan <hann...@gmail.com> wrote:

> Dear DHIS2 Expert
>
> I am trying to export selected metadata item e.g. Chart, Event Chart, Map,
> Map View etc from one server and want to import in another server with same
> data. Don't get anything in the UI, but log showing error
>
> Can you please advise how can solve this problem and /or how to chart,
> map, pivot tables from one system to another?
>
> Regards
>
> Hannan Khan
> HISP Bangladesh
>
___
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

Re: [Dhis2-devs] [Dhis2-users] Org unit is being unassigned after edit

[Hannan Khan]

Dear Lars

Thank you very much for your prompt action. It is working well.

Please update the 20 and 21 war as well.

Best regards

Hannan Khan
HISP Bangladesh

On Tue, Jan 5, 2016 at 6:33 PM, Lars Helge Øverland <larshe...@gmail.com>
wrote:

> Hi Hannah and Uwe,
>
> this should be fixed now in 2.19 > trunk. New builds are triggered on ci.
> Thanks for reporting.
>
> regards,
>
> Lars
>
>
> On Mon, Jan 4, 2016 at 8:58 PM, uwe wahser <u...@wahser.de> wrote:
>
>> Just to support: I saw the same in 2.21
>>
>>
>>
>> Am 31.12.2015 um 07:31 schrieb Hannan Khan:
>>
>> Dear All
>>
>> Happy new year.
>>
>> Sorry to disturb you all during this holidays, but this is urgent.
>>
>> When ever we are editing orgunit, correct the spelling, code etc., all it
>> data sets are become unassigned. so we have to reassigned all data sets
>> again which is quite cumbersome.
>>
>> Fatima earlier reported this issue with build 19273. I waited and try
>> with new build.
>>
>> we are using version 19 build 19285.  how we resolve this? need urgent
>> help.
>>
>> Regards
>>
>> Hannan
>> HISP Bangladesh
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org>
>
>
___
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

[Dhis2-devs] Org unit is being unassigned after edit

[Hannan Khan]

Dear All

Happy new year.

Sorry to disturb you all during this holidays, but this is urgent.

When ever we are editing orgunit, correct the spelling, code etc., all it
data sets are become unassigned. so we have to reassigned all data sets
again which is quite cumbersome.

Fatima earlier reported this issue with build 19273. I waited and try with
new build.

we are using version 19 build 19285.  how we resolve this? need urgent help.

Regards

Hannan
HISP Bangladesh
___
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

Re: [Dhis2-devs] [Dhis2-users] Bangladesh web portal using dhis2 plugins

[Hannan Khan]

Dear Lars

Thanks to all DHIS2 experts specially Jan and you. After our earlier failed
attempt you all update the plugin and other libraries and make our effort
is possible.

Still we are facing some issues, which I will discuss later.

Regards

Hannan Khan
HISP Bangladesh

On Wed, Dec 23, 2015 at 4:25 PM, Lars Helge Øverland <larshe...@gmail.com>
wrote:

> Hi Muhammad,
>
> this looks great! Thanks for sharing.
>
> You can expect improvements in the plugins in terms of improved load-time
> and extra features in 2.23.
>
> best regards,
>
> Lars
>
>
> On Wed, Dec 23, 2015 at 11:07 AM, Pamod Amarakoon <pam...@gmail.com>
> wrote:
>
>> Dear Munna,
>>
>> Thank you very much for sharing.
>>
>> On Wed, Dec 23, 2015 at 12:49 PM, Julhas Sujan <julhaspust...@gmail.com>
>> wrote:
>>
>>> Dear Munna Viyya,
>>>
>>> It will be helpful for us. Thank you very much.
>>>
>>> *Best Regards*
>>> *Julhas Sujan*
>>> Java Consultant
>>> Management Science for Health(MSH)
>>> USAID, Dhaka, Bangladesh
>>> Cell: +8801989 442856
>>> Skype: julhas08
>>> Web: www.julhas.info
>>> ​
>>> www.msh.org http://siapsprogram.org/wherewework/bangladesh/
>>>
>>> On Wed, Dec 23, 2015 at 12:33 PM, Mohammad Ullah <munnab...@gmail.com>
>>> wrote:
>>>
>>>> Dear all,
>>>>
>>>> I am pleased to share with you the Bangladesh portal which we have
>>>> created based on the live data from dhis2 using dhis2 plugins. Please visit
>>>> the following link to see the portal,
>>>> http://103.247.238.81:8080/portal/index.html
>>>>
>>>> We highly appreciate the help from the community. We have got quick
>>>> support from the community during the development.
>>>>
>>>> I would like to share my knowledge and experience of the development
>>>> process, i believe this will be helpful for others,
>>>>
>>>> Solution
>>>> ---
>>>> 1) Please add the full address in the CORS whitelist,
>>>> [image: Inline image 3]
>>>>
>>>> 2) Its better to download the plugins and attach those from local
>>>> folder.
>>>>
>>>> 3) I have used the following version of the plugins,
>>>>
>>>> >>> rel="stylesheet" type="text/css" 
>>>> href="//apps.dhis2.org/demo/dhis-web-commons/javascripts/ext-ux/carousel/css/carousel.css"
>>>>  />>>> src="js/plugins/v17/v217_openlayers_OpenLayers.js">>>> src="js/plugins/Carousel.js">>>> src="js/plugins/v21/v221_plugin_chart.js">>>> src="js/plugins/v21/v221_plugin_table.js">>>> src="js/plugins/v17/v217_plugin_map.js">
>>>>
>>>> 4) Please use the username and password inside the get method (see the
>>>> examples),
>>>>
>>>> DHIS.getChart({ crossDomain: true, username: 'view', password: 'DGHS1234', 
>>>> uid: 'oSNtDZNZGIp', el: 'chartA1', url: base });
>>>>
>>>> 5) We have created a reporting server where all the live data sync
>>>> everyday in one instance of DHIS2. We have hosted the portal in the same
>>>> reporting server.
>>>>
>>>> Please let me know if i can provide any support regarding this issue.
>>>>
>>>> --
>>>> Regards,
>>>>
>>>> *Mohammad Ullah*
>>>>
>>>> -
>>>> Technical Advisor (HIS) – Health Sector
>>>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
>>>> German House
>>>> House 10/A-2, Road 90
>>>> Gulshan 2, Dhaka 1212, Bangladesh
>>>>
>>>> T+880 9666701000
>>>> F+880 28823099
>>>> M+880 196 31 56 988
>>>> Webhttp://lnkd.in/gQrxXz
>>>> Skypemohammad_ullah_giz
>>>>
>>>> Office Location:
>>>> Room # 304, Shahid Dr. Milan Bhavan,
>>>> MIS, DGHS of MoHFW, Mohakhali, Dhaka.
>>>>
>>>> T02 8816412 (ex:118)
>>>>
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to : dhis2-devs@lists.launchpad.net
>>>> Unsubscrib

Re: [Dhis2-devs] [Dhis2-users] Web API : Get Indicator Value

[Hannan Khan]

Dear Pamod

To get a indicator through web API is by calling using uid of the
indicator. for example:

https://play.dhis2.org/demo/api/indicators/ReUHfIn0pTQ will give you 'ANC
1-3 Dropout Rate'; the last 11 digit is the uid of the indicator.

Indicator values are not saved in tables, DHIS2 calculate indicators on the
fly from analytics.

Currently DHIS2 data visualizer, Pivot Table and GIS doesn't provide
previous day reporting, but programatically you can call.

Regards

Hannan
HISP Bangladesh

On Sun, Sep 20, 2015 at 1:22 PM, Pamod Amarakoon  wrote:

> Dear All,
>
> 1. what is the format to get a value of an aggregated indicator of a
> particular data set using web - API. Is it stored in database or calculated
> in real time
>
> 2. is the relative period available for Previous Day (yesterday).
>
> Thank you
>
> --
> Regards,
> Pamod Amarakoon
>
> Confidentiality Notice: the information contained in this email and any
> attachments may be legally privileged and confidential. If you are not an
> intended recipient, you are hereby notified that any dissemination,
> distribution, or copying of this e-mail is strictly prohibited. If you have
> received this e-mail in error, please notify the sender and permanently
> delete the e-mail and any attachments immediately. You should not retain,
> copy or use this e-mail or any attachments for any purpose, nor disclose
> all or any part of the contents to any other person.
>
> [image: http://ehealthasia.org] 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
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

Re: [Dhis2-devs] [Dhis2-users] Resource table generation error

[Hannan Khan]

Dear Sumudu

Did you check the period table for duplicate period? If you removed all
duplicates and still the problem persists, then can try this:

Take a backup of your database.
Manually delete _periodstructure table.
Generate resource table again.

Hopefully your problem will be resolved.

Regards

Hannan Khan
HISP Bangladesh

On Thu, Nov 5, 2015 at 10:12 AM, sumudu weerasinghe <sumudu...@gmail.com>
wrote:

> Hi Lars,
>
> I upgraded it to 2.20 but it gives same error,  unable to generate
> resource tables.
> e
> Do i need to delete period 2015.01 from table contents?
> ​
>
> On Thu, Nov 5, 2015 at 6:59 AM, sumudu weerasinghe <sumudu...@gmail.com>
> wrote:
>
>> Thanks Lars,
>>  I will try to upgrade it today .
>>
>>-   Do i need to do the changes on "period" table before upgrade or
>>just upgrade my database according to upgrade note ?
>>-   Actually i want to upgrade up to 2.21 , is there issue in upgrade
>>in to 2.21
>>
>> regards
>> Sumudu
>>
>> On Thu, Nov 5, 2015 at 1:38 AM, Lars Helge Øverland <larshe...@gmail.com>
>> wrote:
>>
>>> Hi Sumudu,
>>>
>>> this weakness was fixed in version 2.20 and later. Are you able to
>>> upgrade your instance?
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>> On Thu, Oct 29, 2015 at 3:15 AM, sumudu weerasinghe <sumudu...@gmail.com
>>> > wrote:
>>>
>>>> Yes Morten,
>>>>
>>>> I tried it before and after deletion of period but still not work and
>>>> giving same error.
>>>> as in second error massage.
>>>>
>>>>
>>>>
>>>>
>>>> On Thu, Oct 29, 2015 at 9:37 AM, Morten Olav Hansen <morte...@gmail.com
>>>> > wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> Did you try and prune your periods? it should be under data admin ->
>>>>> maintainence
>>>>>
>>>>> --
>>>>> Morten
>>>>>
>>>>> On Thu, Oct 29, 2015 at 10:50 AM, sumudu weerasinghe <
>>>>> sumudu...@gmail.com> wrote:
>>>>>
>>>>>> Dear all,
>>>>>>
>>>>>>
>>>>>> We use dhis 2.19 , tracker for Nutrition registry.
>>>>>> I had problem with resource table generation. error came as follows,
>>>>>>
>>>>>> ​
>>>>>> then according to previous discussion i delete the duplicate 01.2015
>>>>>> value from period table and their fk constrain from eventchart_ periods
>>>>>> table.
>>>>>>
>>>>>> Following above changes i got second error massage as follows,
>>>>>>
>>>>>>
>>>>>> ​
>>>>>> Can any one help on this matter?
>>>>>>
>>>>>>
>>>>>> Best Regards,
>>>>>>
>>>>>> Sumudu Weerasinghe
>>>>>> Teaching hospital Ragama,
>>>>>> Sri Lanka
>>>>>>
>>>>>>
>>>>>> ___
>>>>>> 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
>>>>>>
>>>>>>
>>>>>
>>>>
>>>> ___
>>>> 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
>>>>
>>>>
>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> http://www.dhis2.org <https://www.dhis2.org>
>>>
>>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
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

Re: [Dhis2-devs] [Dhis2-users] Web Portal with DHIS2

[Hannan Khan]

Ok Jan.

I will upgrade to 2.20 and check. Will get back to you all.

Regards

Hannan

On Wed, Oct 7, 2015 at 5:29 PM, Jan Henrik Øverland <
janhenrik.overl...@gmail.com> wrote:

> Hi Hannan,
>
> You need to use version 2.20.
>
> On Mon, Oct 5, 2015 at 1:43 PM, Hannan Khan <hann...@gmail.com> wrote:
>
>> I am facing the same problem: One script following the manual is:
>>
>> 
>> 
>> 
>>   http://dhis2-cdn.org/v219/ext/resources/css/ext-plugin-gray.css; />
>>   http://dhis2-cdn.org/v219/ext/ext-all.js&quot</a>;>
>>   http://dhis2-cdn.org/v219/plugin/chart.js&quot</a>;>
>>
>>   
>> var base = "<a  rel="nofollow" href="http://103.247.238.82:8080/dhismohfw/&quot">http://103.247.238.82:8080/dhismohfw/&quot</a>;;
>>
>> // Login - if OK, call the setLinks function
>>
>> Ext.onReady( function() {
>>   Ext.Ajax.request({
>> url: base + "dhis-web-commons-security/login.action",
>> method: "POST",
>> params: { j_username: "view", j_password: "DGHS1234" },
>> crossDomain: true,
>> success: setLinks
>>   });
>> });
>>
>> function setLinks() {
>>
>>   // Referring to an existing chart through the id parameter, render
>> to "chart1" div
>>
>>   DHIS.getChart({ url: base, el: "chart1", id: "SYELB2ltOpL" });
>>
>>   // Full chart configuration, render to "chart2" div
>>
>>   DHIS.getChart({
>> url: base,
>> el: "chart2",
>> type: "stackedBar",
>> columns: [ // Chart series
>>   {dimension: "de", items: [{id: "Fnsa8A43USl"}, {id:
>> "CRZkTTALRSb"}]}
>> ],
>> rows: [ // Chart categories
>>   {dimension: "pe", items: [{id: "LAST_12_MONTHS"}]}
>> ],
>> filters: [
>>   {dimension: "ou", items: [{id: "USER_ORGUNIT"}]}
>> ],
>> // All following options are optional
>> crossDomain: true,
>> showData: false,
>> targetLineValue: 70,
>> baseLineValue: 20,
>> showTrendLine: true,
>> hideLegend: true,
>> title: "My chart title",
>> domainAxisTitle: "Periods",
>> rangeAxisTitle: "Percent"
>>   });
>> }
>>   
>> 
>>
>> 
>>   
>>   
>> 
>> 
>>
>> generating the error "XMLHttpRequest cannot load
>> http://103.247.238.82:8080/dhismohfw/dhis-web-commons-security/login.action.
>> Response for preflight is invalid (redirect)"
>>
>> If i use code as Jan suggests:
>>
>> 
>> 
>> 
>>   http://dhis2-cdn.org/v219/ext/resources/css/ext-plugin-gray.css; />
>>   http://dhis2-cdn.org/v219/ext/ext-all.js&quot</a>;>
>>   http://dhis2-cdn.org/v219/plugin/chart.js&quot</a>;>
>> 
>> 
>> 
>> 
>> var url = "<a  rel="nofollow" href="http://103.248.238.82:8080/dhismohfw/&quot">http://103.248.238.82:8080/dhismohfw/&quot</a>;,
>> username = "view",
>> password = "DGHS1234";
>>
>> Ext.onReady(function() {
>>
>> DHIS.getChart({
>> url: url,
>> el: "chart1",
>> id: "SYELB2ltOpL",
>> crossDomain: true,
>> username: username,
>> password: password
>> });
>>
>> });
>>   
>>
>> 
>> 
>>
>> then the following error occurs.
>>
>> GET
>> http://103.248.238.82:8080/dhismohfw/api/me/user-account.jsonp?callback=Ext.data.JsonP.callback1&_dc=1444041788222
>> net::ERR_CONNECTION_TIMED_OUTExt.Element.addMethods.appendTo @
>> ext-all.js:15Ext.Element.addMethods.appendChild @
>> ext-all.js:15Ext.define.request @ ext-all.js:15a @
>> chart.js:1DV.plugin.getChart @ chart.js:1(anonymous function) @
>> testchart1.html:16(anonymous function) @ ext-all.js:15b @ ext-all.js:15
>> ext-all.js:15 GET
>> http://103.248.238.82:8080/dhismohfw/api/organisationUnits.jsonp?userOnly=t…[id,name]=false=Ext.data.JsonP.callback2&_dc=1444041788230
>> net::ERR_CONNECTION_TIMED_OUTExt.Element.addMethods.appen

Re: [Dhis2-devs] Bangladesh Tracker data conversion

[Hannan Khan]

Two screenshot.

On Mon, Oct 5, 2015 at 2:59 PM, Hannan Khan <hann...@gmail.com> wrote:

> Dear Experts
>
> We are converting dhis2 tracker application from 2.13 to 2.19. and need
> your help on a crucial issues.
>
> In absence of a common identifier like Nation ID, Birth ID or mobile no.
> we are tracking the patients with system generated 16 digit identifier
> (version 13). Our health workers written down that number in the patient
> register. So when those patients return back to any clinic, the Health
> workers can find out that patient by using that patient identifier number.
> Additionally, few health workers are hand written / print that patient name
> and patient identifier number on card (some cases with barcode) and those
> patients come back again to clinics with those paper cards.
>
> But latest versions does not have any system generated identifier, instead
> they have uid (Tracked entity instance uid) which is not displayed in
> patient profile. It does have an option for registration number but that
> need to be manually entered and manually maintain uniqueness across the
> system is not possible.
> One Solution is we can create an attribute with this numbers and can call
> that trackerID or HelathID from converting the previous data. But how we
> continue this ID for new data? We are now staked in this position. Now
> please suggests us a solution as soon as possible.
>
> Regards
>
> Hannan Khan
> HISP Bangladesh
>
___
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

[Dhis2-devs] Bangladesh Tracker data conversion

[Hannan Khan]

Dear Experts

We are converting dhis2 tracker application from 2.13 to 2.19. and need
your help on a crucial issues.

In absence of a common identifier like Nation ID, Birth ID or mobile no. we
are tracking the patients with system generated 16 digit identifier
(version 13). Our health workers written down that number in the patient
register. So when those patients return back to any clinic, the Health
workers can find out that patient by using that patient identifier number.
Additionally, few health workers are hand written / print that patient name
and patient identifier number on card (some cases with barcode) and those
patients come back again to clinics with those paper cards.

But latest versions does not have any system generated identifier, instead
they have uid (Tracked entity instance uid) which is not displayed in
patient profile. It does have an option for registration number but that
need to be manually entered and manually maintain uniqueness across the
system is not possible.
One Solution is we can create an attribute with this numbers and can call
that trackerID or HelathID from converting the previous data. But how we
continue this ID for new data? We are now staked in this position. Now
please suggests us a solution as soon as possible.

Regards

Hannan Khan
HISP Bangladesh
___
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

Re: [Dhis2-devs] [Dhis2-users] Web Portal with DHIS2

[Hannan Khan]

I am facing the same problem: One script following the manual is:




  http://dhis2-cdn.org/v219/ext/resources/css/ext-plugin-gray.css; />
  http://dhis2-cdn.org/v219/ext/ext-all.js";>
  http://dhis2-cdn.org/v219/plugin/chart.js";>

  
var base = "http://103.247.238.82:8080/dhismohfw/";;

// Login - if OK, call the setLinks function

Ext.onReady( function() {
  Ext.Ajax.request({
url: base + "dhis-web-commons-security/login.action",
method: "POST",
params: { j_username: "view", j_password: "DGHS1234" },
crossDomain: true,
success: setLinks
  });
});

function setLinks() {

  // Referring to an existing chart through the id parameter, render to
"chart1" div

  DHIS.getChart({ url: base, el: "chart1", id: "SYELB2ltOpL" });

  // Full chart configuration, render to "chart2" div

  DHIS.getChart({
url: base,
el: "chart2",
type: "stackedBar",
columns: [ // Chart series
  {dimension: "de", items: [{id: "Fnsa8A43USl"}, {id:
"CRZkTTALRSb"}]}
],
rows: [ // Chart categories
  {dimension: "pe", items: [{id: "LAST_12_MONTHS"}]}
],
filters: [
  {dimension: "ou", items: [{id: "USER_ORGUNIT"}]}
],
// All following options are optional
crossDomain: true,
showData: false,
targetLineValue: 70,
baseLineValue: 20,
showTrendLine: true,
hideLegend: true,
title: "My chart title",
domainAxisTitle: "Periods",
rangeAxisTitle: "Percent"
  });
}
  



  
  



generating the error "XMLHttpRequest cannot load
http://103.247.238.82:8080/dhismohfw/dhis-web-commons-security/login.action.
Response for preflight is invalid (redirect)"

If i use code as Jan suggests:




  http://dhis2-cdn.org/v219/ext/resources/css/ext-plugin-gray.css; />
  http://dhis2-cdn.org/v219/ext/ext-all.js";>
  http://dhis2-cdn.org/v219/plugin/chart.js";>




var url = "http://103.248.238.82:8080/dhismohfw/";,
username = "view",
password = "DGHS1234";

Ext.onReady(function() {

DHIS.getChart({
url: url,
el: "chart1",
id: "SYELB2ltOpL",
crossDomain: true,
username: username,
password: password
});

});
  




then the following error occurs.

GET
http://103.248.238.82:8080/dhismohfw/api/me/user-account.jsonp?callback=Ext.data.JsonP.callback1&_dc=1444041788222
net::ERR_CONNECTION_TIMED_OUTExt.Element.addMethods.appendTo @
ext-all.js:15Ext.Element.addMethods.appendChild @
ext-all.js:15Ext.define.request @ ext-all.js:15a @
chart.js:1DV.plugin.getChart @ chart.js:1(anonymous function) @
testchart1.html:16(anonymous function) @ ext-all.js:15b @ ext-all.js:15
ext-all.js:15 GET
http://103.248.238.82:8080/dhismohfw/api/organisationUnits.jsonp?userOnly=t…[id,name]=false=Ext.data.JsonP.callback2&_dc=1444041788230
net::ERR_CONNECTION_TIMED_OUTExt.Element.addMethods.appendTo @
ext-all.js:15Ext.Element.addMethods.appendChild @
ext-all.js:15Ext.define.request @ ext-all.js:15a @
chart.js:1DV.plugin.getChart @ chart.js:1(anonymous function) @
testchart1.html:16(anonymous function) @ ext-all.js:15b @ ext-all.js:15
ext-all.js:15 GET
http://103.248.238.82:8080/dhismohfw/api/dimensions.jsonp?links=false=false=Ext.data.JsonP.callback3&_dc=1444041788231
net::ERR_CONNECTION_TIMED_OUTExt.Element.addMethods.appendTo @
ext-all.js:15Ext.Element.addMethods.appendChild @
ext-all.js:15Ext.define.request @ ext-all.js:15a @
chart.js:1DV.plugin.getChart @ chart.js:1(anonymous function) @
testchart1.html:16(anonymous function) @ ext-all.js:15b @ ext-all.js:15

Please help me to solve this.

On Fri, Oct 2, 2015 at 8:18 PM, Guy Ekani  wrote:

> Thank's Jan !
>
> It's working with https://dhis2-cdn.org/v217/plugin/table.js on Google
> Chrome,
>
> But not Displaying in Mozilla Firefox !
>
> May God Bless you all
>
> =
> EKANI Guy
>
>
>
>
>
>
>
>
> Le Vendredi 2 octobre 2015 15h08, Jan Henrik Øverland <
> janhenrik.overl...@gmail.com> a écrit :
>
>
> You need to add exactly
>
> http://localhost:8082
>
> (without the final /) to the CORS whitelist.
>
> On Fri, Oct 2, 2015 at 4:50 PM, Guy Ekani  wrote:
>
> Now I have the following errors in DHIS-Live 2.20(19682)/PosgreSQL :
>
> Table.html:1 XMLHttpRequest cannot load
> http://localhost:8082/api/me/user-account.json. The request was
> redirected to '
> http://localhost:8082/dhis-web-commons/security/login.action;jsessionid=pz57xiqk2xlcc1jy8sjv8pm7',
> which is disallowed for cross-origin requests that require preflight.
>
> Table.html:1 XMLHttpRequest cannot load
> 

Re: [Dhis2-devs] [Bug 1044893] Re: Data import error between 2 DHIS2 systems - Data value

[Hannan Khan]

Thank you everyone.

But the bug was reported 2 years ago.

By this time we solve the problem manually and upgraded the version to
19.

Regards

Hannan

On Fri, Sep 18, 2015 at 3:40 PM, jason.p.pickering <
1044...@bugs.launchpad.net> wrote:

> Looks like a legacy issue when OU code was not unique. This is no longer
> supported, so should be fixed.
>
> ** Changed in: dhis2
>Status: New => Fix Released
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1044893
>
> Title:
>   Data import error between 2 DHIS2 systems - Data value
>
> Status in DHIS:
>   Fix Released
>
> Bug description:
>   When we imported data value exported from DGHS (dhis2 2.7) into
>   dhis2_h1_2_6 (DHIS2 2.7), we found the following error
>
>   * WARN  10:29:15,795 SQL Error: 1062, SQLState: 23000
> (JDBCExceptionReporter.jav
>   a [Thread-16])
>   * ERROR 10:29:15,796 Duplicate entry 'HS_27451657073' for key 3
> (JDBCExceptionRe
>   porter.java [Thread-16])
>   * ERROR 10:29:15,872 Internal process failed
> (AbstractStatementInternalProcess.j
>   ava [Thread-16])
>   org.hibernate.exception.ConstraintViolationException: Could not execute
> JDBC bat
>   ch update
>   at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
>   ava:96)
>   at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
>   er.java:66)
>   at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
>   275)
>   at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
>
>   at
>   org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
>
>   at
> org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
>   ns(AbstractFlushingEventListener.java:321)
>   at
> org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
>   aultAutoFlushEventListener.java:64)
>   at
> org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1
>   185)
>   at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1709)
>   at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
>   at
> org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
>   at
> org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGene
>   ricStore.java:175)
>   at
> org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGene
>   ricStore.java:235)
>   at
> org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga
>   nisationUnitByName(DefaultOrganisationUnitService.java:192)
>   at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source)
>   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
>   at java.lang.reflect.Method.invoke(Unknown Source)
>   at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
>   on(AopUtils.java:309)
>   at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
>   inpoint(ReflectiveMethodInvocation.java:183)
>   at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:150)
>   at
> org.springframework.transaction.interceptor.TransactionInterceptor.in
>   voke(TransactionInterceptor.java:110)
>   at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:172)
>   at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
>   e(ExposeInvocationInterceptor.java:90)
>   at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:172)
>   at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
>   cAopProxy.java:202)
>   at $Proxy17.getOrganisationUnitByName(Unknown Source)
>   at
> org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
>   ing(OrganisationUnitImporter.java:94)
>   at
> org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
>   ing(OrganisationUnitImporter.java:44)
>   at
> org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImp
>   orter.java:84)
>   at
> org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importOb
>   ject(OrganisationUnitImporter.java:64)
>   at
> org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.re
>   ad(OrganisationUnitConverter.java:239)
>   at
> org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
>   (DefaultConverterInvoker.java:45)
>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
>   at java.lang.reflect.Method.invoke(Unknown 

Re: [Dhis2-devs] [Dhis2-users] individual records will be phased out

[Hannan Khan]

Dear Lars

Thank you for informing us.

My Issues exactly as Ese Egerega. The 'Active Program' section of patient
dashboard is important where we can see the existing programs the patient
enroll with. So please include in the new tracker Dashboard. Also please
think about improving the look of the existing tracker dashboard.

Thank you again for your continuous initiative to improve DHIS2.

Best regards

Hannan
HISP Bangladesh

On Thu, Sep 10, 2015 at 4:10 PM, Lars Helge Øverland 
wrote:

> Hi,
>
> we will remove the "Individual records" web module for version 2.21. This
> module has been replaced by the "Tracker capture" app. If you are still
> using the individual records module we recommend that you move over to
> Tracker capture, and that you report potentially missing features in
> Tracker capture to the DHIS 2 developer list.
>
> regards,
>
> Lars
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
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

Re: [Dhis2-devs] Fwd: [Dhis2-users] Event capture Future date is not allowed problem

[Hannan Khan]

Dear Abyot and Markus

Thank you for your suggestion. We cleared the cache and check the date
settings. The calendar setting ISO8601 and the date format is dd-MM-.
And the problem persists.

But when I change the date settings to -MM-dd then it is working OK. So
this is a bug associated with date format. Please fix it.

Regards

Hannan Khan
HISP Bangladesh

On Mon, Sep 7, 2015 at 2:04 PM, Abyot Gizaw <aby...@gmail.com> wrote:

> Hi,
>
> Yes checking the date format is the first thing to do. Also make sure to
> have your browser cache properly cleared once you have made changes to your
> calendar setting.
>
> Also to note is: though we have future date support for data elements, we
> don't have support for execution date of events.
>
>
> ---
> Thank you,
> Abyot.
>
> On Mon, Sep 7, 2015 at 9:26 AM, Markus Bekken <markus.bek...@gmail.com>
> wrote:
>
>> Dear Hanan,
>> It looks like there is a mixup between 7/9 and 9/7 somewhere - possibly a
>> bug. What is the date format in your calendar settings?
>> (Apps->Settings->Calendar Settings)
>>
>> Markus
>>
>> 7. sep. 2015 kl. 07.55 skrev Hannan Khan <hann...@gmail.com>:
>>
>> Dear Experts
>>
>> Thank you for your continuous support. We are also feeding you new
>> problems from one largest implementation.
>>
>> We are upgraded to version 2.19 and having this problem. The tracker
>> system identifies current date 7th September and dates after 9 July 2015 as
>> future date having message ' Future date is not allowed'.
>>
>> I checked the log and there is no error log in tomcat so the error is
>> from the front-end.I also check the server date and they are ok as user
>> computer.
>>
>> Please help us to solve this issue. We are stuck with this technical
>> issues. Please respond as soon as possible.
>>
>> Regards
>>
>> Hannan Khan
>> HISP Bangladesh
>>
>>
>> -- Forwarded message --
>> From: Uddin Fatema <fatema...@gmail.com>
>> Date: Sun, Sep 6, 2015 at 3:00 PM
>> Subject: [Dhis2-users] Event capture Future date is not allowed problem
>> To: "dhis2-us...@lists.launchpad.net" <dhis2-us...@lists.launchpad.net>
>>
>>
>> Dear All,
>> I am running  dhis2 2.19 build version 19275 in my server. and my server
>> date is today's date and time
>>
>> But when I am entering event date today's date it shows error "Future
>> date is not allowed"
>>
>> 
>>
>> But if I give 1st June It shows right
>>
>> Anyone, Please help me how can i solve it.
>>
>> Thanks
>> Regards,
>> *Fatema Uddin*
>>
>> Technical Advisor (HIS)-Support to the Health Sector Program II
>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
>> German House
>> House 10/A-2, Road 90
>> Gulshan 2, Dhaka 1212, Bangladesh
>>
>> T  +880 9666701000
>> F  +880 28823099
>> M +880 19 6206 4721
>> I   www.giz.de
>> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.=http%3a%2f%2fwww.giz.de%2f>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>> ___
>> 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
>>
>>
>>
>
___
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

[Dhis2-devs] [Bug 1492967] [NEW] When registering an Event, current date service/event date is issuing warning as future date if date format is used as ‘dd-MM-yyyy’

[Hannan Khan]

Public bug reported:

When registering an Event, current date service/event date is issuing
warning as future date if date format is used as ‘dd-MM-’. But same
date is ok if we use ‘-MM-dd’ format.

Using version 2.19 build 19271

** Affects: dhis2
 Importance: Undecided
 Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1492967

Title:
  When registering an Event, current date service/event date is issuing
  warning as future date if date format is used as ‘dd-MM-’

Status in DHIS:
  New

Bug description:
  When registering an Event, current date service/event date is issuing
  warning as future date if date format is used as ‘dd-MM-’. But
  same date is ok if we use ‘-MM-dd’ format.

  Using version 2.19 build 19271

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1492967/+subscriptions

___
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

Re: [Dhis2-devs] Web portal CORS/preflight problem

[Hannan Khan]

Dear Jan

Thanks. Delight to know that; I am waiting.
We already upgraded to version 2.19. We are also upgrading tracker system
to 2.19. I will than do the portal and integration of servers and
synchronization of reporting server. I will be in touch.

Best regards

Hannan

On Mon, Sep 7, 2015 at 5:38 PM, Jan Henrik Øverland <
janhenrik.overl...@gmail.com> wrote:

> Hi Hannan,
>
> I am working on a fix for this. Any chance you can upgrade from 2.17?
>
> On Sat, Aug 29, 2015 at 4:59 AM, Hannan Khan <hann...@gmail.com> wrote:
>
>> Dear Jan
>>
>> I think cross domain problem is solved but more problem arise. I added
>> the jquery js script line but there is no chart. I think as i use
>> https://code.jquery.com/jquery-2.1.4.min.js' the calling of chart might
>> changed. the source I used is as :
>>
>> 
>> DHIS2 Web Portal
>>
>> 
>> > rel="stylesheet" type="text/css" />
>>
>> 
>> 
>> 
>> https://code.jquery.com/jquery-2.1.4.min.js&quot</a>;>
>>
>> 
>>
>> 
>> li {
>> float: left;
>> }
>>
>> .chart {
>> border: 1px solid #ddd;
>> margin: 10px;
>> }
>> .chart.wide {
>> width: 800px;
>> height: 450px;
>> }
>> .chart.tall {
>> width: 600px;
>> height: 920px;
>> }
>> 
>>
>> 
>>
>> 
>> var base = '<a  rel="nofollow" href="http://localhost:8080/dhismohfw19/">http://localhost:8080/dhismohfw19/</a>';
>>
>> $.ready(function() {
>>   $.Ajax.request({
>> crossDomain: true,
>> url: base + "dhis-web-commons-security/login.action?authOnly=true",
>> method: 'POST',
>> params: { j_username: "view", j_password: "DGHS1234" },
>> success: setLinks
>>   });
>> });
>>
>> function setLinks() {
>>   DV.plugin.getChart({ url: base, el: 'chartA1', id: 'LjfRM4pSC0h' });
>>
>>   DV.plugin.getChart({ url: base, el: 'chartA2', id: 'aR9w2QFpfW7' });
>>
>>   DV.plugin.getChart({ url: base, el: 'chartA3', id: 'Pck5tyxraa3' });
>> }
>> 
>>
>> 
>>
>> 
>>
>> 
>>   Data Visualizer Chart Plugin
>> 
>>
>> 
>>
>> This page illustrates the use of the Data Visualizer plugin which can
>> be used to embed dynamic ExtJS charts into a Web page. You can embed charts
>> pointing to pre-defined charts in DHIS, or select custom indicators,
>> periods and org units to create dynamic charts. View the source of
>> this page to see how it is done.
>> 
>>
>> 
>>
>> Predefined charts
>>
>> 
>>   
>>   
>>   
>> 
>>
>> 
>>
>> 
>>
>> 
>> 
>>
>>
>> On Thu, Aug 27, 2015 at 4:24 PM, Jan Henrik Øverland <
>> janhenrik.overl...@gmail.com> wrote:
>>
>>> You need to do this part
>>>
>>> Ext.onReady( function() {
>>>   Ext.Ajax.request({
>>> crossDomain: true,
>>> url: base + "dhis-web-commons-security/login.action?authOnly=true",
>>> method: 'POST'
>>>  
>>>
>>> with jquery instead of Ext.
>>>
>>> See the code that Morten posted.
>>>
>>> On Thu, Aug 27, 2015 at 12:19 PM, Hannan Khan <hann...@gmail.com> wrote:
>>>
>>>> Thanks Jan.
>>>>
>>>> I added http://code.jquery.com/jquery-2.1.4.min.js</a>>"> in the 
>>>> but still I get the error. What did I do wrong?
>>>>
>>>> Regards
>>>>
>>>> Hannan
>>>>
>>>> On Thu, Aug 27, 2015 at 2:49 PM, Jan Henrik Øverland <
>>>> janhenrik.overl...@gmail.com> wrote:
>>>>
>>>>> Hi Hannan,
>>>>>
>>>>> I have done some testing and it seems the bundled Ext version is
>>>>> getting old. CORS is not working well with it.
>>>>>
>>>>> We need to look at this, but for now just include
>>>>> https://code.jquery.com/jquery-2.1.4.min.js (minified, only 84k) and
>>>>> do the authentication with jquery.
>>>>>
>>>>> The good thing about CORS is that you can simply do a normal ajax
>>>>> request and the browser will take care of the rest.
>>>>>
>>>>> On Thu, Aug 27, 2015 at 10:37 AM, Hannan Khan <hann...@gmail.com>
>>>&

[Dhis2-devs] Problem loading event capture in CHROME

[Hannan Khan]

Dear Experts

We just upgrade our One server (the biggest one) to version 19 (Build
19273).

When we select event capture and find that 'Orgunit' are loading OK, but
'Loading Meta data..' message are dis playing for ever. This happens in
CHROME browser (I am using 45.0.2454.78 beta-m (64-bit)). But when I use
Firefox (40.0.3) it is not taking almost immediately. In our filed CHROME
browser are used and changing the browser is not a good option. So far I
don't find anything in tomcat log.

What find in Chrome is

'Uncaught TypeError: Cannot read property 'objectStore' of undefined' in
http://103.247.238.82:8080/dhismohfw/dhis-web-commons/javascripts/dhis2/dhis2.storage.idb.js
.

Can you please check and suggest me the solution?

Regards

Hannan
HISP Bangladesh
___
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

Re: [Dhis2-devs] Problem loading event capture in CHROME

[Hannan Khan]

Yes it is. We have lot of complain from field on this issue.

On Wednesday, September 2, 2015, Knut Staring <knu...@gmail.com> wrote:

> Hi Hannan,
>
> Is this problem pervasive across different laptops? Just to make sure it
> is not only one particular Chrome installation that has the issue.
>
> Knut
>
> On Wed, Sep 2, 2015 at 12:31 PM, Hannan Khan <hann...@gmail.com
> <javascript:_e(%7B%7D,'cvml','hann...@gmail.com');>> wrote:
>
>> Dear Experts
>>
>> We just upgrade our One server (the biggest one) to version 19 (Build
>> 19273).
>>
>> When we select event capture and find that 'Orgunit' are loading OK, but
>> 'Loading Meta data..' message are dis playing for ever. This happens in
>> CHROME browser (I am using 45.0.2454.78 beta-m (64-bit)). But when I use
>> Firefox (40.0.3) it is not taking almost immediately. In our filed CHROME
>> browser are used and changing the browser is not a good option. So far I
>> don't find anything in tomcat log.
>>
>> What find in Chrome is
>>
>> 'Uncaught TypeError: Cannot read property 'objectStore' of undefined' in
>> http://103.247.238.82:8080/dhismohfw/dhis-web-commons/javascripts/dhis2/dhis2.storage.idb.js
>> .
>>
>> Can you please check and suggest me the solution?
>>
>> Regards
>>
>> Hannan
>> HISP Bangladesh
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> <javascript:_e(%7B%7D,'cvml','dhis2-devs@lists.launchpad.net');>
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>


-- 
Sent from Gmail iPhone
___
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

Re: [Dhis2-devs] Web portal CORS/preflight problem

[Hannan Khan]

Dear Jan

I think cross domain problem is solved but more problem arise. I added the
jquery js script line but there is no chart. I think as i use
https://code.jquery.com/jquery-2.1.4.min.js' the calling of chart might
changed. the source I used is as :

head
titleDHIS2 Web Portal/title

link href=style.css rel=stylesheet type=text/css /
link href=//fonts.googleapis.com/css?family=Lato:400,700
rel=stylesheet type=text/css /

link rel=stylesheet href=//
dhis2-cdn.org/v217/ext/resources/css/ext-plugin-gray.css /
script src=//dhis2-cdn.org/v217/ext/ext-all.js/script
script src=//dhis2-cdn.org/v217/plugin/chart.js/script
script src=https://code.jquery.com/jquery-2.1.4.min.js;/script

!-- Custom CSS --

style type=text/css
li {
float: left;
}

.chart {
border: 1px solid #ddd;
margin: 10px;
}
.chart.wide {
width: 800px;
height: 450px;
}
.chart.tall {
width: 600px;
height: 920px;
}
/style

!-- Login and initialize charts --

script
var base = 'http://localhost:8080/dhismohfw19/';

$.ready(function() {
  $.Ajax.request({
crossDomain: true,
url: base + dhis-web-commons-security/login.action?authOnly=true,
method: 'POST',
params: { j_username: view, j_password: DGHS1234 },
success: setLinks
  });
});

function setLinks() {
  DV.plugin.getChart({ url: base, el: 'chartA1', id: 'LjfRM4pSC0h' });

  DV.plugin.getChart({ url: base, el: 'chartA2', id: 'aR9w2QFpfW7' });

  DV.plugin.getChart({ url: base, el: 'chartA3', id: 'Pck5tyxraa3' });
}
/script

/head

body

header
  h1Data Visualizer Chart Plugin/h1
/header

menu

pThis page illustrates the use of the Data Visualizer plugin which can be
used to embed dynamic ExtJS charts into a Web page. You can embed charts
pointing to pre-defined charts in DHIS, or select custom indicators,
periods and org units to create dynamic charts. View the source of
this page to see how it is done./p
/menu

section

h3Predefined charts/h3

ul
  lidiv id=chartA1 class=chart tall/div/li
  lidiv id=chartA2 class=chart wide/div/li
  lidiv id=chartA3 class=chart wide/div/li
/ul

p style=clear:both/p

/section

/body
/html


On Thu, Aug 27, 2015 at 4:24 PM, Jan Henrik Øverland 
janhenrik.overl...@gmail.com wrote:

 You need to do this part

 Ext.onReady( function() {
   Ext.Ajax.request({
 crossDomain: true,
 url: base + dhis-web-commons-security/login.action?authOnly=true,
 method: 'POST'
  

 with jquery instead of Ext.

 See the code that Morten posted.

 On Thu, Aug 27, 2015 at 12:19 PM, Hannan Khan hann...@gmail.com wrote:

 Thanks Jan.

 I added script src=//code.jquery.com/jquery-2.1.4.min.js
 http://code.jquery.com/jquery-2.1.4.min.js/script in the head
 but still I get the error. What did I do wrong?

 Regards

 Hannan

 On Thu, Aug 27, 2015 at 2:49 PM, Jan Henrik Øverland 
 janhenrik.overl...@gmail.com wrote:

 Hi Hannan,

 I have done some testing and it seems the bundled Ext version is getting
 old. CORS is not working well with it.

 We need to look at this, but for now just include
 https://code.jquery.com/jquery-2.1.4.min.js (minified, only 84k) and do
 the authentication with jquery.

 The good thing about CORS is that you can simply do a normal ajax
 request and the browser will take care of the rest.

 On Thu, Aug 27, 2015 at 10:37 AM, Hannan Khan hann...@gmail.com wrote:

 Dear Alex

 Thank you for sharing the resources. but the problem still persists. i
 write as following:

 Ext.onReady( function() {
   Ext.Ajax.request({
 crossDomain: true,
 url: base + dhis-web-commons-security/login.action?authOnly=true,
 method: 'POST',

 Please check.

 Regards

 Hannan

 On Thu, Aug 27, 2015 at 1:00 PM, Alex Tumwesigye atumwesi...@gmail.com
  wrote:

 Dear Khan,

 Look at this
 http://api.jquery.com/jquery.ajax/
 Read about crossDomain, by default it set to false so you may need to
 set it to true.

 Ideally, in your ajax request, add crossDomain:true

 Alex



 On Thu, Aug 27, 2015 at 9:53 AM, Mark Polak mar...@ifi.uio.no wrote:

 Hello Hanna,

 Did you add http:// (or https:// if you use a secure line) in front
 of the IP address?

 On the demo instance this is a bit confusing as the examples do not
 show that but it is required for it to work correctly.

 Regards,

 Mark
 
 From: Dhis2-devs [dhis2-devs-bounces+markpo=
 ifi.uio...@lists.launchpad.net] on behalf of Hannan Khan [
 hann...@gmail.com]
 Sent: 27 August 2015 08:29
 To: DHIS 2 developers
 Subject: [Dhis2-devs] Web portal CORS/preflight problem

 Dear Experts

 I am facing problem to creating Web Portal, facing problem CORS.
 First I try portal from 103.247.238.68 not working and then put this
 address in the white list of the dhis2 server at 103.247.238.68:8080
 http://103.247.238.68:8080. But but still having the same problem
 the error message is 'which is disallowed for cross-origin requests that
 require preflight'.

 Now how I resolve this? The script is similar as on the developer
 guide, page 49.

 Please

Re: [Dhis2-devs] Web portal CORS/preflight problem

[Hannan Khan]

Thanks Jan.

I added script src=//code.jquery.com/jquery-2.1.4.min.js
http://code.jquery.com/jquery-2.1.4.min.js/script in the head but
still I get the error. What did I do wrong?

Regards

Hannan

On Thu, Aug 27, 2015 at 2:49 PM, Jan Henrik Øverland 
janhenrik.overl...@gmail.com wrote:

 Hi Hannan,

 I have done some testing and it seems the bundled Ext version is getting
 old. CORS is not working well with it.

 We need to look at this, but for now just include
 https://code.jquery.com/jquery-2.1.4.min.js (minified, only 84k) and do
 the authentication with jquery.

 The good thing about CORS is that you can simply do a normal ajax request
 and the browser will take care of the rest.

 On Thu, Aug 27, 2015 at 10:37 AM, Hannan Khan hann...@gmail.com wrote:

 Dear Alex

 Thank you for sharing the resources. but the problem still persists. i
 write as following:

 Ext.onReady( function() {
   Ext.Ajax.request({
 crossDomain: true,
 url: base + dhis-web-commons-security/login.action?authOnly=true,
 method: 'POST',

 Please check.

 Regards

 Hannan

 On Thu, Aug 27, 2015 at 1:00 PM, Alex Tumwesigye atumwesi...@gmail.com
 wrote:

 Dear Khan,

 Look at this
 http://api.jquery.com/jquery.ajax/
 Read about crossDomain, by default it set to false so you may need to
 set it to true.

 Ideally, in your ajax request, add crossDomain:true

 Alex



 On Thu, Aug 27, 2015 at 9:53 AM, Mark Polak mar...@ifi.uio.no wrote:

 Hello Hanna,

 Did you add http:// (or https:// if you use a secure line) in front of
 the IP address?

 On the demo instance this is a bit confusing as the examples do not
 show that but it is required for it to work correctly.

 Regards,

 Mark
 
 From: Dhis2-devs [dhis2-devs-bounces+markpo=
 ifi.uio...@lists.launchpad.net] on behalf of Hannan Khan [
 hann...@gmail.com]
 Sent: 27 August 2015 08:29
 To: DHIS 2 developers
 Subject: [Dhis2-devs] Web portal CORS/preflight problem

 Dear Experts

 I am facing problem to creating Web Portal, facing problem CORS.
 First I try portal from 103.247.238.68 not working and then put this
 address in the white list of the dhis2 server at 103.247.238.68:8080
 http://103.247.238.68:8080. But but still having the same problem the
 error message is 'which is disallowed for cross-origin requests that
 require preflight'.

 Now how I resolve this? The script is similar as on the developer
 guide, page 49.

 Please advice.

 Regards

 Hannan

 ___
 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




 --
 Alex Tumwesigye

 Technical Advisor - DHIS2 (Consultant),
 Ministry of Health/AFENET
 Kampala
 Uganda

 IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

 IT Specialist (Servers, Networks and Security, Health Information
 Systems - DHIS2 )  Solar Consultant

 +256 774149 775, + 256 759 800161

 I don't want to be anything other than what I have been - one tree hill
 



 ___
 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



___
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

[Dhis2-devs] Web portal CORS/preflight problem

[Hannan Khan]

Dear Experts


I am facing problem to creating Web Portal, facing problem CORS.
First I try portal from 103.247.238.68 not working and then put this
address in the white list of the dhis2 server at 103.247.238.68:8080. But
but still having the same problem the error message is 'which is disallowed
for cross-origin requests that require preflight'.

Now how I resolve this? The script is similar as on the developer guide,
page 49.

Please advice.

Regards

Hannan
___
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

Re: [Dhis2-devs] [Dhis2-users] data mart deprecation - 2.21

[Hannan Khan]

In Bangladesh we are not using Data Mart; instead we are using paralytics.
So no problem from our end.

Regards

Hannan Khan
HISP Bangladesh


On Wed, Aug 26, 2015 at 5:27 PM, Lars Helge Øverland larshe...@gmail.com
wrote:

 Hi,

 we are thinking of removing the data mart functionality in DHIS 2. This
 refers to the ability to populate the aggregateddatavalue and
 aggregatedindicatorvalue tables with pre-aggregated data.

 The data mart is no longer in use by DHIS 2. There might be third-party
 report tools out there that connects directly to the data mart tables.

 We recommend that you connect reporting tools to the analytics web api
 https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s26.html for
 the sake of  performance, accessibility and security. If you need to
 connect with JDBC it is possible to create a SQL view to combine all
 analytics partitions and perform aggregation using group by statements.

 If we do not hear strong objections within a week we will remove data mart
 for version 2.21.


 regards,

 Lars




 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org https://www.dhis2.org


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp


___
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

Re: [Dhis2-devs] Web portal CORS/preflight problem

[Hannan Khan]

Dear Alex

Thank you for sharing the resources. but the problem still persists. i
write as following:

Ext.onReady( function() {
  Ext.Ajax.request({
crossDomain: true,
url: base + dhis-web-commons-security/login.action?authOnly=true,
method: 'POST',

Please check.

Regards

Hannan

On Thu, Aug 27, 2015 at 1:00 PM, Alex Tumwesigye atumwesi...@gmail.com
wrote:

 Dear Khan,

 Look at this
 http://api.jquery.com/jquery.ajax/
 Read about crossDomain, by default it set to false so you may need to set
 it to true.

 Ideally, in your ajax request, add crossDomain:true

 Alex



 On Thu, Aug 27, 2015 at 9:53 AM, Mark Polak mar...@ifi.uio.no wrote:

 Hello Hanna,

 Did you add http:// (or https:// if you use a secure line) in front of
 the IP address?

 On the demo instance this is a bit confusing as the examples do not show
 that but it is required for it to work correctly.

 Regards,

 Mark
 
 From: Dhis2-devs [dhis2-devs-bounces+markpo=
 ifi.uio...@lists.launchpad.net] on behalf of Hannan Khan [
 hann...@gmail.com]
 Sent: 27 August 2015 08:29
 To: DHIS 2 developers
 Subject: [Dhis2-devs] Web portal CORS/preflight problem

 Dear Experts

 I am facing problem to creating Web Portal, facing problem CORS.
 First I try portal from 103.247.238.68 not working and then put this
 address in the white list of the dhis2 server at 103.247.238.68:8080
 http://103.247.238.68:8080. But but still having the same problem the
 error message is 'which is disallowed for cross-origin requests that
 require preflight'.

 Now how I resolve this? The script is similar as on the developer guide,
 page 49.

 Please advice.

 Regards

 Hannan

 ___
 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




 --
 Alex Tumwesigye

 Technical Advisor - DHIS2 (Consultant),
 Ministry of Health/AFENET
 Kampala
 Uganda

 IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

 IT Specialist (Servers, Networks and Security, Health Information Systems
 - DHIS2 )  Solar Consultant

 +256 774149 775, + 256 759 800161

 I don't want to be anything other than what I have been - one tree hill 

___
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

[Dhis2-devs] TB tracker

[Hannan Khan]

Dear all

We are trying to include TB patient tracking in our national dhis2 system.
If any of you are using similar system please help me to design our system.

Regards

Hannan Khan
Bangladesh DHIS2 coordinator


-- 
Sent from Gmail iPhone
___
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

[Dhis2-devs] DHIS2 tracker for logistics

[Hannan Khan]

Dear Experts

We all know that DHIS2 tracker can be used for tracking any entities,
so it can be used as asset tracker.

We already implemented DHIS2 in Bangladesh at the national level and
scaled down to the community level and still expanding. Our Health
sector now wants to track asset of all facilities. SO far I learn that
UNCOLSC are using DHIS2 for logistics; can any body please share with
me the detail of that implementation. Any one have a demo of 'asset
tracking' using DHIS2?

Please response as soon as possible.

Hannan Khan

___
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

Re: [Dhis2-devs] [Dhis2-users] Creation of bulk user.

[Hannan Khan]

Hi Lars

Thanks. Yes restarting tomcat can generate the blank UID.

UID is a indexed field so I cannot create more than one user in one go. Is
there any solution?

Regards

Hannan


On Wed, May 7, 2014 at 2:38 PM, Lars Helge Øverland larshe...@gmail.comwrote:

 Hi,

 it is correct that missing UIDs will be generated on system startup.

 I think what is being referred to here is dhis UID and not an UUID. There
 are ways to generate dhis UIDs through the web api but it's just much
 simpler to restart tomcat.

 regards,

 Lars



 On Wed, May 7, 2014 at 10:19 AM, Knut Staring knu...@gmail.com wrote:

 The easiest is to restart DHIS2 (Tomcat)


 On Wed, May 7, 2014 at 10:14 AM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 If it is blank then the database will regenerate it automatically when
 you restart (I think. This is what happens with other objects which have a
 uuid). That is the easiest way.

 If you are preparing SQL for injection of the users and you want to
 pregenerate them, you can use which ever tool you are using to generate the
 SQL to provide you UUIDs as well. Postgresql's uuid-ossp package, R's
 uuid package, or the system command uuid on Linux are all ways of
 getting them. I am sure they can be done easily in Java or other languages.
 So, it really depends on which tools you are using to prepare the SQL for
 inserting them into the DHIS2 database.

 Regards,
 Jason



 On Wed, May 7, 2014 at 10:07 AM, Hannan Khan hann...@gmail.com wrote:

 No. It seems that uuid is not automatically generated. Please suggest.

 Regards

 Hannan
 On May 7, 2014 1:34 PM, Jason Pickering jason.p.picker...@gmail.com
 wrote:

 The UUID will be generated automatically, so no need to worry about
 it.

 Regards,
 Jason



 On Wed, May 7, 2014 at 9:29 AM, Hannan Khan hann...@gmail.com wrote:

 Thanks Jason. Password issues are there and we are trying with that
 but what about the UUID?

  Regards

 Hannan


 On Wed, May 7, 2014 at 12:14 PM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Hi Hannan,
 This has been discussed (again) recently on this list.


 http://dhis-developers-list.1563109.n2.nabble.com/Password-Generation-td7590749.html#a7590750


 http://dhis-developers-list.1563109.n2.nabble.com/USERS-Password-td7591703.html#a7591704

 There are a few more as well in the archives if you dig a bit.

 Regards,
 Jason



  On Wed, May 7, 2014 at 8:10 AM, Hannan Khan hann...@gmail.comwrote:

  Dear Experts

 We are in a need of creating bulk users (8000) and org unit
 assignment. I created script for testing but facing problem populating
 password and UUID. Please advice how can I do that?

 I try to update password using crypt function and gen_salt function
 but the length of the password are different and doesn't working. 
 Please
 advise.

 Regards

  *Hannan Khan*

 --

 Senior Technical Advisor - Health Information Systems

 Health Sector

 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh



 T +880-2- 8816459, 8816412 ext 118
 F +88 02 8813 875

 M+88 01819 239 241

 M+88 01534 312 066
 E hannan.k...@giz.de

 I   www.giz.de

 S hannan.khan.dhaka

 B hannan-tech.blogspot.com

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp








 --
 Knut Staring
 Dept. of Informatics, University of Oslo
 +4791880522
 http://dhis2.org



___
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

Re: [Dhis2-devs] [Dhis2-users] Creation of bulk user.

[Hannan Khan]

Thanks Randy

We are trying with Kenneth's Java application; if we have the sample csv
file it will be very help full for us.

Dear Kenneth

Can you please send me a sample CSV file.

Regards

Hannan


On Thu, May 8, 2014 at 6:58 PM, Wilson,Randy rwil...@msh.org wrote:

  Hi Hannan,



 I think you should try Kenneth’s java application.  We created 40,000
 users (community health workers with their phone numbers and orgunit link)
 and assigned them all passwords using the app.  I think Kenneth has put in
 a User interface that lets you specify the server address, DHIS-2 instance
 or database, etc…



 Kenneth could you send Hannan a sample csv file (just 10 records or so)
 along with your application, so he can test it out.  I think it is
 sufficiently generic.



 He sent a link to it in an earlier response.  This file is quite big – 54
 meg - Kenneth, can it be shrunk a bit more?



 If you have java on your Windows computer you should be able to run it as
 follows:



 Java –jar user_importer.jar



 Randy



 *From:* Dhis2-users [mailto:dhis2-users-bounces+rwilson=
 msh@lists.launchpad.net] *On Behalf Of *Hannan Khan
 *Sent:* Thursday, May 08, 2014 1:09 PM
 *To:* Lars Helge Øverland
 *Cc:* dhis2-us...@lists.launchpad.net; DHIS 2 developers
 *Subject:* Re: [Dhis2-users] Creation of bulk user.



 Hi Lars



 Thanks. Yes restarting tomcat can generate the blank UID.



 UID is a indexed field so I cannot create more than one user in one go. Is
 there any solution?



 Regards



 Hannan



 On Wed, May 7, 2014 at 2:38 PM, Lars Helge Øverland larshe...@gmail.com
 wrote:

 Hi,



 it is correct that missing UIDs will be generated on system startup.



 I think what is being referred to here is dhis UID and not an UUID. There
 are ways to generate dhis UIDs through the web api but it's just much
 simpler to restart tomcat.



 regards,



 Lars





 On Wed, May 7, 2014 at 10:19 AM, Knut Staring knu...@gmail.com wrote:

 The easiest is to restart DHIS2 (Tomcat)



 On Wed, May 7, 2014 at 10:14 AM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 If it is blank then the database will regenerate it automatically when you
 restart (I think. This is what happens with other objects which have a
 uuid). That is the easiest way.



 If you are preparing SQL for injection of the users and you want to
 pregenerate them, you can use which ever tool you are using to generate the
 SQL to provide you UUIDs as well. Postgresql's uuid-ossp package, R's
 uuid package, or the system command uuid on Linux are all ways of
 getting them. I am sure they can be done easily in Java or other languages.
 So, it really depends on which tools you are using to prepare the SQL for
 inserting them into the DHIS2 database.



 Regards,

 Jason





 On Wed, May 7, 2014 at 10:07 AM, Hannan Khan hann...@gmail.com wrote:

 No. It seems that uuid is not automatically generated. Please suggest.

 Regards

 Hannan

 On May 7, 2014 1:34 PM, Jason Pickering jason.p.picker...@gmail.com
 wrote:

 The UUID will be generated automatically, so no need to worry about it.


 Regards,

 Jason





 On Wed, May 7, 2014 at 9:29 AM, Hannan Khan hann...@gmail.com wrote:

 Thanks Jason. Password issues are there and we are trying with that but
 what about the UUID?



 Regards



 Hannan



 On Wed, May 7, 2014 at 12:14 PM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Hi Hannan,

 This has been discussed (again) recently on this list.




 http://dhis-developers-list.1563109.n2.nabble.com/Password-Generation-td7590749.html#a7590750




 http://dhis-developers-list.1563109.n2.nabble.com/USERS-Password-td7591703.html#a7591704



 There are a few more as well in the archives if you dig a bit.



 Regards,

 Jason





 On Wed, May 7, 2014 at 8:10 AM, Hannan Khan hann...@gmail.com wrote:

   Dear Experts



 We are in a need of creating bulk users (8000) and org unit assignment. I
 created script for testing but facing problem populating password and UUID.
 Please advice how can I do that?



 I try to update password using crypt function and gen_salt function but
 the length of the password are different and doesn't working. Please advise.



 Regards



 *Hannan Khan*

 --

 Senior Technical Advisor - Health Information Systems

 Health Sector

 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh



 T +880-2- 8816459, 8816412 ext 118
 F +88 02 8813 875

 M+88 01819 239 241

 M+88 01534 312 066
 E hannan.k...@giz.de

 I   www.giz.de

 S hannan.khan.dhaka

 B hannan-tech.blogspot.com



 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp













 --

 Knut Staring

 Dept. of Informatics, University of Oslo

 +4791880522

 http

[Dhis2-devs] Creation of bulk user.

[Hannan Khan]

Dear Experts

We are in a need of creating bulk users (8000) and org unit assignment. I
created script for testing but facing problem populating password and UUID.
Please advice how can I do that?

I try to update password using crypt function and gen_salt function but the
length of the password are different and doesn't working. Please advise.

Regards

*Hannan Khan*

--

Senior Technical Advisor - Health Information Systems

Health Sector

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh



T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875

M+88 01819 239 241

M+88 01534 312 066
E hannan.k...@giz.de

I   www.giz.de

S hannan.khan.dhaka

B hannan-tech.blogspot.com
___
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

Re: [Dhis2-devs] [Dhis2-users] Creation of bulk user.

[Hannan Khan]

Thanks Jason. Password issues are there and we are trying with that but
what about the UUID?

Regards

Hannan


On Wed, May 7, 2014 at 12:14 PM, Jason Pickering 
jason.p.picker...@gmail.com wrote:

 Hi Hannan,
 This has been discussed (again) recently on this list.


 http://dhis-developers-list.1563109.n2.nabble.com/Password-Generation-td7590749.html#a7590750


 http://dhis-developers-list.1563109.n2.nabble.com/USERS-Password-td7591703.html#a7591704

 There are a few more as well in the archives if you dig a bit.

 Regards,
 Jason



 On Wed, May 7, 2014 at 8:10 AM, Hannan Khan hann...@gmail.com wrote:

 Dear Experts

 We are in a need of creating bulk users (8000) and org unit assignment. I
 created script for testing but facing problem populating password and UUID.
 Please advice how can I do that?

 I try to update password using crypt function and gen_salt function but
 the length of the password are different and doesn't working. Please advise.

 Regards

  *Hannan Khan*

 --

 Senior Technical Advisor - Health Information Systems

 Health Sector

 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh



 T +880-2- 8816459, 8816412 ext 118
 F +88 02 8813 875

 M+88 01819 239 241

 M+88 01534 312 066
 E hannan.k...@giz.de

 I   www.giz.de

 S hannan.khan.dhaka

 B hannan-tech.blogspot.com

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp



___
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

Re: [Dhis2-devs] [Dhis2-users] Creation of bulk user.

[Hannan Khan]

No. It seems that uuid is not automatically generated. Please suggest.

Regards

Hannan
On May 7, 2014 1:34 PM, Jason Pickering jason.p.picker...@gmail.com
wrote:

 The UUID will be generated automatically, so no need to worry about it.

 Regards,
 Jason



 On Wed, May 7, 2014 at 9:29 AM, Hannan Khan hann...@gmail.com wrote:

 Thanks Jason. Password issues are there and we are trying with that but
 what about the UUID?

 Regards

 Hannan


 On Wed, May 7, 2014 at 12:14 PM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Hi Hannan,
 This has been discussed (again) recently on this list.


 http://dhis-developers-list.1563109.n2.nabble.com/Password-Generation-td7590749.html#a7590750


 http://dhis-developers-list.1563109.n2.nabble.com/USERS-Password-td7591703.html#a7591704

 There are a few more as well in the archives if you dig a bit.

 Regards,
 Jason



  On Wed, May 7, 2014 at 8:10 AM, Hannan Khan hann...@gmail.com wrote:

  Dear Experts

 We are in a need of creating bulk users (8000) and org unit assignment.
 I created script for testing but facing problem populating password and
 UUID. Please advice how can I do that?

 I try to update password using crypt function and gen_salt function but
 the length of the password are different and doesn't working. Please 
 advise.

 Regards

  *Hannan Khan*

 --

 Senior Technical Advisor - Health Information Systems

 Health Sector

 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh



 T +880-2- 8816459, 8816412 ext 118
 F +88 02 8813 875

 M+88 01819 239 241

 M+88 01534 312 066
 E hannan.k...@giz.de

 I   www.giz.de

 S hannan.khan.dhaka

 B hannan-tech.blogspot.com

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp





___
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

Re: [Dhis2-devs] Bangladesh's main DHIS2 installation hacked and solved

[Hannan Khan]

Thanks Bob.

My earlier attempt to configure nginx failed. I will try again this month.

Regards

Hannan


On Thu, Feb 6, 2014 at 10:09 PM, Bob Jolliffe bobjolli...@gmail.com wrote:

 Hi Hannan

 I agree with Lars that what you describe (uploading of malicious files)
 sounds like an exploitation of the vulnerability in struts fixed around
 Christmas.

 I also agree that you don't want to run tomcat on port 80.  The
 recommended configuration is to run a web proxy such as nginx or apache2 on
 port 80 and 443.  Then tomcat can listen on port 8080 on localhost only.


 On 6 February 2014 14:54, Hannan Khan hann...@gmail.com wrote:

 Thanks Jason for your comprehensive advice.

 I tried to identify problem roots and I believe I find those files. And
 there is no problem so far.
 From the beginning I am running tomcat service as user who cannot login
 to the system.
 Point 2 and 3 I have to do. But earlier our another serer running on port
 80 severely damaged by hacker attack (web server). I will be keep in-touch
 on this.
 Any firewall you suggests? Also consider we have very narrow bandwidth;
 only 10 Mbps for 9 dhis2 systems with near about 12000 users average 300
 concurrent user in top three systems;
 Updates we are run weekly basis.
 Point 6 and 7 I will do. How that will effect the system performance?

 Regards

 Hannan



 On Thu, Feb 6, 2014 at 1:18 PM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Hi Hannan,
 I had several servers (4 to be exact) which were compromised due to a
 vulnerability in Struts. Lars sent out an email a few weeks ago, that
 informed everyone they needed to upgrade immediately. I know of other
 server which have also been compromised. One was running Tomcat as root (an
 exceptionally bad idea). Because of the compromise, a full reinstallation
 of the server software would be required.

 In your case, it does seem to be a bit more serious, and not consistent
 with the previous compromises I have seen. These compromises were limited
 to the machine sending out a huge amount of traffic, but otherwise, there
 did not seem to be any further issues.

 A few tips, you may want to consider

 0) A complete reinstall of the system might be in order, given the
 extent of the attack.
 1) Be sure that the Tomcat process is not running as root, and that the
 user which can execute Tomcat cannot login to the system directly (i.e. has
 their shell set to /bin/false)
 2) Close port 8080 and remove the Tomcat manager. Instead, only have
 port 80/443  on the machine open. Additionally, do not run SSH on port 22,
 and be sure that you can only login to the server with a key, which is
 protected itself by a strong password.
 3) Consider attempting to look for vulnerabilities your self, with tools
 such as Nessus and Nmap
 4) Ensure that you are running a firewall on the server itself, i.e. do
 not trust your upstream providers firewall.
 5) Ensure that all Tomcat installs, Java,DHIS2 and the system software
 itself is fully up to date
 6) Consider running an IDS such as OSSEC on your machine to look for
 unauthorized intrusions.
 7) Use tools such as monit to monitor for spurious processes or
 suspicious file activity.

 Hope this helps.

 Best regards,
 Jason





 On Thu, Feb 6, 2014 at 8:36 AM, Hannan Khan hann...@gmail.com wrote:

 Yes Morten, I installed through the package manager.

 The tomcat version is Apache Tomcat/7.0.26.

 Regards

 Hannan


 On Thu, Feb 6, 2014 at 12:07 PM, Morten Olav Hansen morte...@gmail.com
  wrote:

 Also make sure that your tomcat is up to date.. there exists several
 vulnerabilities in older versions

 (not sure how you installed it, but if you are using a linux
 distribution, its wise to install it through the package manager)

 --
 Morten


 On Thu, Feb 6, 2014 at 1:00 PM, Knut Staring knu...@gmail.com wrote:

 Hannan, which build of DHIS2 ? Which Java version? Ubuntu?

 Sent from my mobile
 On Feb 6, 2014 6:29 AM, Hannan Khan hann...@gmail.com wrote:

 Dear experts

 Our main DHIS2 implementation (mishealth) for the health sector was
 hacked yesterday evening, around 4:30 PM local time. After login by any
 user it showing the attached message. We immediately stop the tomact7
 service and check the database. We find the database is intact.

 After investigation I find that the hacker inserted three files to
 do this.

 First file index.html contain an alert alert(Admin, You Are
 Hacked by Malaysia Hacker!)  and a body text h1Hacked by 
 BadCat/h1.
 Which was placed in the application folder /tomcat7/webapps/mishealth/.

 Second files index.html contain another script which redirects to 
 pastebin.com/raw.php?i=LZEdbBz6 was placed in
 the /tomcat7/webapps/mishealth/dhis-web-commons/security/.

 Third file guige.jsp is contain a script was placed in
 the /tomcat7/webapps/mishealth/dhis-web-commons/security/.

 For our server, it seems that only first file is executing after
 login. I find few more suspicious files which I am investigating

Re: [Dhis2-devs] Bangladesh's main DHIS2 installation hacked and solved

[Hannan Khan]

Thanks Lars.

Today we update DHIS2 to version 13 build 12864.

Regards

Hannan


On Thu, Feb 6, 2014 at 5:50 PM, Lars Helge Øverland larshe...@gmail.comwrote:

 Hi Hannan,

 I think this attack might also be related to the Struts exploit. We did
 see random jsp files being uploaded at one occasion.

 The fix for the Struts exploit was done in 2.12 at revision 11341, so it
 means that you must upgrade your DHIS version (from 11312) in order to
 get protection.

 regards,

 Lars



 On Thu, Feb 6, 2014 at 9:18 AM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Hi Hannan,
 I had several servers (4 to be exact) which were compromised due to a
 vulnerability in Struts. Lars sent out an email a few weeks ago, that
 informed everyone they needed to upgrade immediately. I know of other
 server which have also been compromised. One was running Tomcat as root (an
 exceptionally bad idea). Because of the compromise, a full reinstallation
 of the server software would be required.

 In your case, it does seem to be a bit more serious, and not consistent
 with the previous compromises I have seen. These compromises were limited
 to the machine sending out a huge amount of traffic, but otherwise, there
 did not seem to be any further issues.

 A few tips, you may want to consider

 0) A complete reinstall of the system might be in order, given the extent
 of the attack.
 1) Be sure that the Tomcat process is not running as root, and that the
 user which can execute Tomcat cannot login to the system directly (i.e. has
 their shell set to /bin/false)
 2) Close port 8080 and remove the Tomcat manager. Instead, only have port
 80/443  on the machine open. Additionally, do not run SSH on port 22, and
 be sure that you can only login to the server with a key, which is
 protected itself by a strong password.
 3) Consider attempting to look for vulnerabilities your self, with tools
 such as Nessus and Nmap
 4) Ensure that you are running a firewall on the server itself, i.e. do
 not trust your upstream providers firewall.
 5) Ensure that all Tomcat installs, Java,DHIS2 and the system software
 itself is fully up to date
 6) Consider running an IDS such as OSSEC on your machine to look for
 unauthorized intrusions.
 7) Use tools such as monit to monitor for spurious processes or
 suspicious file activity.

 Hope this helps.

 Best regards,
 Jason





 On Thu, Feb 6, 2014 at 8:36 AM, Hannan Khan hann...@gmail.com wrote:

 Yes Morten, I installed through the package manager.

 The tomcat version is Apache Tomcat/7.0.26.

 Regards

 Hannan


 On Thu, Feb 6, 2014 at 12:07 PM, Morten Olav Hansen 
 morte...@gmail.comwrote:

 Also make sure that your tomcat is up to date.. there exists several
 vulnerabilities in older versions

 (not sure how you installed it, but if you are using a linux
 distribution, its wise to install it through the package manager)

 --
 Morten


 On Thu, Feb 6, 2014 at 1:00 PM, Knut Staring knu...@gmail.com wrote:

 Hannan, which build of DHIS2 ? Which Java version? Ubuntu?

 Sent from my mobile
 On Feb 6, 2014 6:29 AM, Hannan Khan hann...@gmail.com wrote:

 Dear experts

 Our main DHIS2 implementation (mishealth) for the health sector was
 hacked yesterday evening, around 4:30 PM local time. After login by any
 user it showing the attached message. We immediately stop the tomact7
 service and check the database. We find the database is intact.

 After investigation I find that the hacker inserted three files to do
 this.

 First file index.html contain an alert alert(Admin, You Are
 Hacked by Malaysia Hacker!)  and a body text h1Hacked by BadCat/h1.
 Which was placed in the application folder /tomcat7/webapps/mishealth/.

 Second files index.html contain another script which redirects to 
 pastebin.com/raw.php?i=LZEdbBz6 was placed in
 the /tomcat7/webapps/mishealth/dhis-web-commons/security/.

 Third file guige.jsp is contain a script was placed in
 the /tomcat7/webapps/mishealth/dhis-web-commons/security/.

 For our server, it seems that only first file is executing after
 login. I find few more suspicious files which I am investigating and will
 share with the experts in next few days.

 I configured the server with only external open port is 8080. Other
 two ports (SSH and WEBMIN) are open for internal IP only. External access
 is possible only through VPN client. According to the firewall 
 maintaining
 vendor, that hacker might access through 8080. How we prevent and secure
 that?

 I configure the database in other server and that server is only
 accessible through one private IP block. The tomcat server, the backup
 servers and our administrator/development team are in that block.

 Now please suggest how can we secure our servers more.

 Regards

 Muhammad Abdul Hannan Khan
 --
 Senior Technical Advisor - HIS
 Priority Area Health
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 House10/A, Road 90, Gulshan 2, Dhaka 1212

Re: [Dhis2-devs] Bangladesh's main DHIS2 installation hacked and solved

[Hannan Khan]

Thanks Jason for your comprehensive advice.

I tried to identify problem roots and I believe I find those files. And
there is no problem so far.
From the beginning I am running tomcat service as user who cannot login to
the system.
Point 2 and 3 I have to do. But earlier our another serer running on port
80 severely damaged by hacker attack (web server). I will be keep in-touch
on this.
Any firewall you suggests? Also consider we have very narrow bandwidth;
only 10 Mbps for 9 dhis2 systems with near about 12000 users average 300
concurrent user in top three systems;
Updates we are run weekly basis.
Point 6 and 7 I will do. How that will effect the system performance?

Regards

Hannan



On Thu, Feb 6, 2014 at 1:18 PM, Jason Pickering jason.p.picker...@gmail.com
 wrote:

 Hi Hannan,
 I had several servers (4 to be exact) which were compromised due to a
 vulnerability in Struts. Lars sent out an email a few weeks ago, that
 informed everyone they needed to upgrade immediately. I know of other
 server which have also been compromised. One was running Tomcat as root (an
 exceptionally bad idea). Because of the compromise, a full reinstallation
 of the server software would be required.

 In your case, it does seem to be a bit more serious, and not consistent
 with the previous compromises I have seen. These compromises were limited
 to the machine sending out a huge amount of traffic, but otherwise, there
 did not seem to be any further issues.

 A few tips, you may want to consider

 0) A complete reinstall of the system might be in order, given the extent
 of the attack.
 1) Be sure that the Tomcat process is not running as root, and that the
 user which can execute Tomcat cannot login to the system directly (i.e. has
 their shell set to /bin/false)
 2) Close port 8080 and remove the Tomcat manager. Instead, only have port
 80/443  on the machine open. Additionally, do not run SSH on port 22, and
 be sure that you can only login to the server with a key, which is
 protected itself by a strong password.
 3) Consider attempting to look for vulnerabilities your self, with tools
 such as Nessus and Nmap
 4) Ensure that you are running a firewall on the server itself, i.e. do
 not trust your upstream providers firewall.
 5) Ensure that all Tomcat installs, Java,DHIS2 and the system software
 itself is fully up to date
 6) Consider running an IDS such as OSSEC on your machine to look for
 unauthorized intrusions.
 7) Use tools such as monit to monitor for spurious processes or suspicious
 file activity.

 Hope this helps.

 Best regards,
 Jason





 On Thu, Feb 6, 2014 at 8:36 AM, Hannan Khan hann...@gmail.com wrote:

 Yes Morten, I installed through the package manager.

 The tomcat version is Apache Tomcat/7.0.26.

 Regards

 Hannan


 On Thu, Feb 6, 2014 at 12:07 PM, Morten Olav Hansen 
 morte...@gmail.comwrote:

 Also make sure that your tomcat is up to date.. there exists several
 vulnerabilities in older versions

 (not sure how you installed it, but if you are using a linux
 distribution, its wise to install it through the package manager)

 --
 Morten


 On Thu, Feb 6, 2014 at 1:00 PM, Knut Staring knu...@gmail.com wrote:

 Hannan, which build of DHIS2 ? Which Java version? Ubuntu?

 Sent from my mobile
 On Feb 6, 2014 6:29 AM, Hannan Khan hann...@gmail.com wrote:

 Dear experts

 Our main DHIS2 implementation (mishealth) for the health sector was
 hacked yesterday evening, around 4:30 PM local time. After login by any
 user it showing the attached message. We immediately stop the tomact7
 service and check the database. We find the database is intact.

 After investigation I find that the hacker inserted three files to do
 this.

 First file index.html contain an alert alert(Admin, You Are Hacked
 by Malaysia Hacker!)  and a body text h1Hacked by BadCat/h1. Which
 was placed in the application folder /tomcat7/webapps/mishealth/.

 Second files index.html contain another script which redirects to 
 pastebin.com/raw.php?i=LZEdbBz6 was placed in
 the /tomcat7/webapps/mishealth/dhis-web-commons/security/.

 Third file guige.jsp is contain a script was placed in
 the /tomcat7/webapps/mishealth/dhis-web-commons/security/.

 For our server, it seems that only first file is executing after
 login. I find few more suspicious files which I am investigating and will
 share with the experts in next few days.

 I configured the server with only external open port is 8080. Other
 two ports (SSH and WEBMIN) are open for internal IP only. External access
 is possible only through VPN client. According to the firewall maintaining
 vendor, that hacker might access through 8080. How we prevent and secure
 that?

 I configure the database in other server and that server is only
 accessible through one private IP block. The tomcat server, the backup
 servers and our administrator/development team are in that block.

 Now please suggest how can we secure our servers more.

 Regards

 Muhammad Abdul Hannan Khan

Re: [Dhis2-devs] Bangladesh's main DHIS2 installation hacked and solved

[Hannan Khan]

For this implementation we are using DHIS2 version 2.12 build 11312. This
version will be upgraded to version 13 this evening.

Java version 1.7.0_25 OpenJDK 64 bit server

Ubuntu 12.04.2.


On Thu, Feb 6, 2014 at 12:00 PM, Knut Staring knu...@gmail.com wrote:

 Hannan, which build of DHIS2 ? Which Java version? Ubuntu?

 Sent from my mobile
 On Feb 6, 2014 6:29 AM, Hannan Khan hann...@gmail.com wrote:

 Dear experts

 Our main DHIS2 implementation (mishealth) for the health sector was
 hacked yesterday evening, around 4:30 PM local time. After login by any
 user it showing the attached message. We immediately stop the tomact7
 service and check the database. We find the database is intact.

 After investigation I find that the hacker inserted three files to do
 this.

 First file index.html contain an alert alert(Admin, You Are Hacked by
 Malaysia Hacker!)  and a body text h1Hacked by BadCat/h1. Which was
 placed in the application folder /tomcat7/webapps/mishealth/.

 Second files index.html contain another script which redirects to 
 pastebin.com/raw.php?i=LZEdbBz6 was placed in
 the /tomcat7/webapps/mishealth/dhis-web-commons/security/.

 Third file guige.jsp is contain a script was placed in
 the /tomcat7/webapps/mishealth/dhis-web-commons/security/.

 For our server, it seems that only first file is executing after login. I
 find few more suspicious files which I am investigating and will share with
 the experts in next few days.

 I configured the server with only external open port is 8080. Other two
 ports (SSH and WEBMIN) are open for internal IP only. External access is
 possible only through VPN client. According to the firewall maintaining
 vendor, that hacker might access through 8080. How we prevent and secure
 that?

 I configure the database in other server and that server is only
 accessible through one private IP block. The tomcat server, the backup
 servers and our administrator/development team are in that block.

 Now please suggest how can we secure our servers more.

 Regards

 Muhammad Abdul Hannan Khan
 --
 Senior Technical Advisor - HIS
 Priority Area Health
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

 T +880-2- 8816459, 8816412 ext 118
 M+88 01819 239 241
 M+88 01534 312 066
 F +88 02 8813 875
 E hannan.k...@giz.de
 S hannan.khan.dhaka
 B hannan-tech.blogspot.com



___
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

Re: [Dhis2-devs] Bangladesh's main DHIS2 installation hacked and solved

[Hannan Khan]

Yes Morten, I installed through the package manager.

The tomcat version is Apache Tomcat/7.0.26.

Regards

Hannan


On Thu, Feb 6, 2014 at 12:07 PM, Morten Olav Hansen morte...@gmail.comwrote:

 Also make sure that your tomcat is up to date.. there exists several
 vulnerabilities in older versions

 (not sure how you installed it, but if you are using a linux distribution,
 its wise to install it through the package manager)

 --
 Morten


 On Thu, Feb 6, 2014 at 1:00 PM, Knut Staring knu...@gmail.com wrote:

 Hannan, which build of DHIS2 ? Which Java version? Ubuntu?

 Sent from my mobile
 On Feb 6, 2014 6:29 AM, Hannan Khan hann...@gmail.com wrote:

 Dear experts

 Our main DHIS2 implementation (mishealth) for the health sector was
 hacked yesterday evening, around 4:30 PM local time. After login by any
 user it showing the attached message. We immediately stop the tomact7
 service and check the database. We find the database is intact.

 After investigation I find that the hacker inserted three files to do
 this.

 First file index.html contain an alert alert(Admin, You Are Hacked
 by Malaysia Hacker!)  and a body text h1Hacked by BadCat/h1. Which
 was placed in the application folder /tomcat7/webapps/mishealth/.

 Second files index.html contain another script which redirects to 
 pastebin.com/raw.php?i=LZEdbBz6 was placed in
 the /tomcat7/webapps/mishealth/dhis-web-commons/security/.

 Third file guige.jsp is contain a script was placed in
 the /tomcat7/webapps/mishealth/dhis-web-commons/security/.

 For our server, it seems that only first file is executing after login.
 I find few more suspicious files which I am investigating and will share
 with the experts in next few days.

 I configured the server with only external open port is 8080. Other two
 ports (SSH and WEBMIN) are open for internal IP only. External access is
 possible only through VPN client. According to the firewall maintaining
 vendor, that hacker might access through 8080. How we prevent and secure
 that?

 I configure the database in other server and that server is only
 accessible through one private IP block. The tomcat server, the backup
 servers and our administrator/development team are in that block.

 Now please suggest how can we secure our servers more.

 Regards

 Muhammad Abdul Hannan Khan
 --
 Senior Technical Advisor - HIS
 Priority Area Health
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

 T +880-2- 8816459, 8816412 ext 118
 M+88 01819 239 241
 M+88 01534 312 066
 F +88 02 8813 875
 E hannan.k...@giz.de
 S hannan.khan.dhaka
 B hannan-tech.blogspot.com




___
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

Re: [Dhis2-devs] GIS on dashboard.

[Hannan Khan]

Thanks a lot Jan.


On Thu, Jan 30, 2014 at 3:29 PM, Jan Henrik Øverland 
janhenrik.overl...@gmail.com wrote:

 Hi Hannan,

 you need to remove the boundary layer from the favorite to make it work
 properly on the dashboard for now, but this is something we should fix. Let
 me have a look at it.

 Jan


 On Thu, Jan 30, 2014 at 9:39 AM, Hannan Khan hann...@gmail.com wrote:

 Dear Experts


 I want to put the level and legend to the GIS item on dash board like
 Sierra Leone. I tried but failed (see attached). Can you please help?


 We are using DHIS2 version 2.13 build 12864.


 Regards


 *Muhammad Abdul Hannan Khan*

 --

 Senior Technical Advisor - HIS

 Priority Area Health

 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh



 T +880-2- 8816459, 8816412 ext 118
 M+88 01819 239 241

 M+88 01534 312 066
 F +88 02 8813 875

 E hannan.k...@giz.de

 S hannan.khan.dhaka

 B hannan-tech.blogspot.com



___
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

[Dhis2-devs] Lock dashboard for update

[Hannan Khan]

Dear Experts

 I am trying to create a dedicated reporting server for public view and
succeeded partially.

 Now I am instructed to create a general dashboard for public view of which
dashboard can be locked so that public user cannot update that. This is not
in-line with the current policy of DHIS2 users.

 Can it be done?

 Regards

 *Muhammad Abdul Hannan Khan*

--

Senior Technical Advisor - HIS

Priority Area Health

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh



T +880-2- 8816459, 8816412 ext 118
M+88 01819 239 241

M+88 01534 312 066
F +88 02 8813 875

E hannan.k...@giz.de

S hannan.khan.dhaka

B hannan-tech.blogspot.com
___
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

Re: [Dhis2-devs] Problem using 'Scheduling' of Data Administration - DHIS2 .13

[Hannan Khan]

Thanks Lars.

I working to make some report automation and now I am testing. Will need
your expert help; I already identify and trying to solve few issues.

Can you please tell me (or where I can find) which tables are updated with
analytics tables besides resource tables and what are the dependency with
the others tables?

Regards

Hannan


On Thu, Jan 2, 2014 at 5:28 PM, Lars Helge Øverland larshe...@gmail.comwrote:

 Hi Hannan,

 the scheduled tasks will start at midnight. There is no way to configure
 the time at the moment (except hacking it by setting the server time). We
 plan to improve on this soon.

 If you need to execute analytics immediately you can go to reports -
 analytics and data mart and click start export.

 Executing analytics + resource tables can be done directly through the web
 api, docs here:

 http://www.dhis2.org/doc/snapshot/en/user/html/ch27s25.html

 So if you have particular requirements you can easily set up a cron job
 for a script that triggers the execution at custom intervals.

 cheers

 Lars



 On Thu, Jan 2, 2014 at 11:51 AM, Hannan Khan hann...@gmail.com wrote:

 Dear All

 Happy new year every one from Bangladesh.

 I am trying to create 'Scheduling' for analytics table. I selected 'Three
 years daily' in the 'Analytics tables task strategy' and press start. The
 screen shot is like the pict. 1 of the attached file.

 My question is when will the schedule will run, when to configure time?

 Again in the manual the screenshot is like the pict. 2 of the attached
 file, which is different from my one. why is different?

 I am using 2.13 version 12931.

 Regards

 Hannan

 ___
 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



___
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

Re: [Dhis2-devs] Problem with GIS: Facility layer

[Hannan Khan]

Dear Jan

I solved this problem by removing the folder created by the WAR file
in the server. I stopped the tomcat7 service, delete the folder and
start the service. It solved the problem. But I want to learn the
reason if possible.

So GIS user name is 'gis' and password is 'Gis123456'. The server IP
is '103.247.238.82:8080/mishealth/'.

I find another problem with GIS. When I want to see a data
element/indicator, in this case by division for ‘Bangladesh’ then it
is showing ok.But when I select a division for drilldown, in this
example, Dhaka, then it shows the border but no data level and no
color legend. But If I use from the ‘layer’ and select ‘Dhaka
Division’ and choose by ‘District and divisional level facility’ then
it is showing ok.

Is not ideally the above drilldown and the below should be the same?

But again when I select float-up it displays similar as drill-down,
which is not good either. Please see the attached file for detail.

Regards

Hannan


On Sun, Sep 15, 2013 at 6:50 PM, Jan Henrik Øverland
janhenrik.overl...@gmail.com wrote:
 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-devs@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-devs
 More help   : https://help.launchpad.net/ListHelp


___
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

[Dhis2-devs] [Bug 1225627] Re: Existing data is not displayed on the form of check box object; single event with out registration

[Hannan Khan]

Sorry I forgot to mention, we are using version 12 revision 11301

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1225627

Title:
   Existing data is not displayed on the form of check box object;
  single event with out registration

Status in DHIS 2:
  New

Bug description:
  Problem is associated with single event without registration.

  We have a custom form having check box object. When we enter data it
  is properly displayed and saved in the table. But when we click ‘edit’
  button the custom form re-appears. But in existing data is not
  displayed on the form of check box objects.

  Please check the attached file for screen shot.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1225627/+subscriptions

___
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

[Dhis2-devs] [Bug 1225627] [NEW] Existing data is not displayed on the form of check box object; single event with out registration

[Hannan Khan]

Public bug reported:

Problem is associated with single event without registration.

We have a custom form having check box object. When we enter data it is
properly displayed and saved in the table. But when we click ‘edit’
button the custom form re-appears. But in existing data is not displayed
on the form of check box objects.

Please check the attached file for screen shot.

** Affects: dhis2
 Importance: Undecided
 Status: New

** Attachment added: single event without regustration custm form checkbox 
problem.docx
   
https://bugs.launchpad.net/bugs/1225627/+attachment/3821770/+files/single%20event%20without%20regustration%20custm%20form%20checkbox%20problem.docx

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1225627

Title:
   Existing data is not displayed on the form of check box object;
  single event with out registration

Status in DHIS 2:
  New

Bug description:
  Problem is associated with single event without registration.

  We have a custom form having check box object. When we enter data it
  is properly displayed and saved in the table. But when we click ‘edit’
  button the custom form re-appears. But in existing data is not
  displayed on the form of check box objects.

  Please check the attached file for screen shot.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1225627/+subscriptions

___
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

Re: [Dhis2-devs] Single event without registration Bug

[Hannan Khan]

Dear All

Another related issue.

Name search option is not working in the individual record.

When we put a name in the filtering with a name it still showing the
same result. In the screen ‘you have active filter’ message are shown
but the names are not filtered.

We are using version DHIS2 Version:2.12 Build revision:11285

Regards

Hannan

On Wed, Sep 4, 2013 at 2:41 PM, Hannan Khan hann...@gmail.com wrote:
 Dear Experts

 As Chau Thu Tran are not available for few weeks can some body can
 take care of this BUG. It is itruppting our largest individual record
 implementation. Please help.

 Regards

 Muhammad Abdul Hannan Khan
 --
 Senior Technical Advisor - HIS
 Priority Area Health
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
 T +880-2- 8816459, 8816412 ext 118
 M+88 01819 239 241
 M+88 01534 312 066
 F +88 02 8813 875
 E hannan.k...@giz.de
 S hannan.khan.dhaka
 B hannan-tech.blogspot.com


 -- Forwarded message --
 From: Uddin Fatema fatema...@gmail.com
 Date: Mon, Sep 2, 2013 at 10:53 AM
 Subject: Fwd: Single event without registration Bug
 To: hannank hann...@gmail.com, Chau Thu Tran cthut...@gmail.com




 -- Forwarded message --
 From: Uddin Fatema fatema...@gmail.com
 Date: Thu, Aug 29, 2013 at 4:59 PM
 Subject: Single event without registration Bug
 To: Chau Thu Tran cthut...@gmail.com


 Dear Tran

 If i edit Single event without registration program
 program-stage.example: if i edit compulsory data element and save.
 After that i will go  Individual Record Single Event Without
 Registration, But i could not able to get Data entry form. Here i
 attached the log files. and screen short and database stored link.

 Database link :
 http://www.mediafire.com/download/1omp1n0mqj0149g/dhis2_290813.rar

 Thanks in advance. If you have any query please ask me anytime.
 --

 Fatema Uddin
 
 Technical Advisor HIS
 Priority Area Health
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
 Office location:
 Room # 304, Shshid Dr.Milan Bhavan,
 Management Information System,
 Directorate General of Health Services of MoHFW,
 Mohakhali, Dhaka-1212, Bangladesh

 Phone: +880 2 881 64 59
 Fax:   +880 2 881 38 75




 --

 Fatema Uddin
 
 Technical Advisor HIS
 Priority Area Health
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
 Office location:
 Room # 304, Shshid Dr.Milan Bhavan,
 Management Information System,
 Directorate General of Health Services of MoHFW,
 Mohakhali, Dhaka-1212, Bangladesh

 Phone: +880 2 881 64 59
 Fax:   +880 2 881 38 75

___
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

Re: [Dhis2-devs] Single event without registration Bug

[Hannan Khan]

Thanks Morten

When we change to 'False' it is working. But again if I made any
change/edit to form (related to data element) it again becomes 'null'.

So what’s the permanent solution?

Regards

Hannan

On Wed, Sep 4, 2013 at 3:01 PM, Morten Olav Hansen morte...@gmail.com wrote:
 Did you try and set it directly to false in the database?
 (capturecoordinates)

 --
 Morten


 On Wed, Sep 4, 2013 at 10:41 AM, Hannan Khan hann...@gmail.com wrote:

 Dear Experts

 As Chau Thu Tran are not available for few weeks can some body can
 take care of this BUG. It is itruppting our largest individual record
 implementation. Please help.

 Regards

 Muhammad Abdul Hannan Khan
 --
 Senior Technical Advisor - HIS
 Priority Area Health
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
 T +880-2- 8816459, 8816412 ext 118
 M+88 01819 239 241
 M+88 01534 312 066
 F +88 02 8813 875
 E hannan.k...@giz.de
 S hannan.khan.dhaka
 B hannan-tech.blogspot.com


 -- Forwarded message --
 From: Uddin Fatema fatema...@gmail.com
 Date: Mon, Sep 2, 2013 at 10:53 AM
 Subject: Fwd: Single event without registration Bug
 To: hannank hann...@gmail.com, Chau Thu Tran cthut...@gmail.com




 -- Forwarded message --
 From: Uddin Fatema fatema...@gmail.com
 Date: Thu, Aug 29, 2013 at 4:59 PM
 Subject: Single event without registration Bug
 To: Chau Thu Tran cthut...@gmail.com


 Dear Tran

 If i edit Single event without registration program
 program-stage.example: if i edit compulsory data element and save.
 After that i will go  Individual Record Single Event Without
 Registration, But i could not able to get Data entry form. Here i
 attached the log files. and screen short and database stored link.

 Database link :
 http://www.mediafire.com/download/1omp1n0mqj0149g/dhis2_290813.rar

 Thanks in advance. If you have any query please ask me anytime.
 --

 Fatema Uddin
 
 Technical Advisor HIS
 Priority Area Health
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
 Office location:
 Room # 304, Shshid Dr.Milan Bhavan,
 Management Information System,
 Directorate General of Health Services of MoHFW,
 Mohakhali, Dhaka-1212, Bangladesh

 Phone: +880 2 881 64 59
 Fax:   +880 2 881 38 75




 --

 Fatema Uddin
 
 Technical Advisor HIS
 Priority Area Health
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
 Office location:
 Room # 304, Shshid Dr.Milan Bhavan,
 Management Information System,
 Directorate General of Health Services of MoHFW,
 Mohakhali, Dhaka-1212, Bangladesh

 Phone: +880 2 881 64 59
 Fax:   +880 2 881 38 75



___
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

Re: [Dhis2-devs] Single event without registration Bug

[Hannan Khan]

In the custom form. Yes I reproduce on other programs (individul record).

Regards

Hannan

On Wed, Sep 4, 2013 at 4:50 PM, Morten Olav Hansen morte...@gmail.com wrote:
 Hi,

 By form, do you mean the programStage meta-data? or do you mean a custom
 form? I was able to set/unset captureCoordinates locally here without any
 problems, when I edit programStages.

 Can you reproduce this on other programs, or is it just this one?

 --
 Morten


 On Wed, Sep 4, 2013 at 12:43 PM, Hannan Khan hann...@gmail.com wrote:

 Thanks Morten

 When we change to 'False' it is working. But again if I made any
 change/edit to form (related to data element) it again becomes 'null'.

 So what’s the permanent solution?

 Regards

 Hannan

 On Wed, Sep 4, 2013 at 3:01 PM, Morten Olav Hansen morte...@gmail.com
 wrote:
  Did you try and set it directly to false in the database?
  (capturecoordinates)
 
  --
  Morten
 
 
  On Wed, Sep 4, 2013 at 10:41 AM, Hannan Khan hann...@gmail.com wrote:
 
  Dear Experts
 
  As Chau Thu Tran are not available for few weeks can some body can
  take care of this BUG. It is itruppting our largest individual record
  implementation. Please help.
 
  Regards
 
  Muhammad Abdul Hannan Khan
  --
  Senior Technical Advisor - HIS
  Priority Area Health
  Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
  House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
  T +880-2- 8816459, 8816412 ext 118
  M+88 01819 239 241
  M+88 01534 312 066
  F +88 02 8813 875
  E hannan.k...@giz.de
  S hannan.khan.dhaka
  B hannan-tech.blogspot.com
 
 
  -- Forwarded message --
  From: Uddin Fatema fatema...@gmail.com
  Date: Mon, Sep 2, 2013 at 10:53 AM
  Subject: Fwd: Single event without registration Bug
  To: hannank hann...@gmail.com, Chau Thu Tran cthut...@gmail.com
 
 
 
 
  -- Forwarded message --
  From: Uddin Fatema fatema...@gmail.com
  Date: Thu, Aug 29, 2013 at 4:59 PM
  Subject: Single event without registration Bug
  To: Chau Thu Tran cthut...@gmail.com
 
 
  Dear Tran
 
  If i edit Single event without registration program
  program-stage.example: if i edit compulsory data element and save.
  After that i will go  Individual Record Single Event Without
  Registration, But i could not able to get Data entry form. Here i
  attached the log files. and screen short and database stored link.
 
  Database link :
  http://www.mediafire.com/download/1omp1n0mqj0149g/dhis2_290813.rar
 
  Thanks in advance. If you have any query please ask me anytime.
  --
 
  Fatema Uddin
  
  Technical Advisor HIS
  Priority Area Health
  Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
  House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
  Office location:
  Room # 304, Shshid Dr.Milan Bhavan,
  Management Information System,
  Directorate General of Health Services of MoHFW,
  Mohakhali, Dhaka-1212, Bangladesh
 
  Phone: +880 2 881 64 59
  Fax:   +880 2 881 38 75
 
 
 
 
  --
 
  Fatema Uddin
  
  Technical Advisor HIS
  Priority Area Health
  Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
  House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
  Office location:
  Room # 304, Shshid Dr.Milan Bhavan,
  Management Information System,
  Directorate General of Health Services of MoHFW,
  Mohakhali, Dhaka-1212, Bangladesh
 
  Phone: +880 2 881 64 59
  Fax:   +880 2 881 38 75
 
 



___
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

Re: [Dhis2-devs] Problem with Individual records – single event without registration

[Hannan Khan]

Thanks.

I will download and check.

Regards

Hannan


On Mon, Aug 12, 2013 at 12:03 PM, Hannan Khan hann...@gmail.com wrote:

 Dear Experts

 We are using version DHIS2 version 12 build 11261.

 *Problem 1.*

 On ‘Single event without registration management page’ first page and
 second page are unique but all remaining pages are  same as page 2 (see
 the attached file).

 *Problem 2*

 ‘Total number of result’ showing 478 in the first page; but the last page
 serial showing 500.  (attached file page 3)

 *Problem 3*

 Search option is not working.

 When we put a name (this case Halima) in the filtering with a name it
 still showing the same result and showing ‘you have active filter’ but the
 name s are not filtered.

 Regards

 Muhammad Abdul Hannan Khan
 --
 Senior Technical Advisor - HIS
 Priority Area Health
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

 T + 88 02 8816459 ext 118
 M+88 01819 239 241
 M+88 01534 312 066
 F +88 02 8813 875
 E hannan.k...@giz.de
 S hannan.khan.dhaka


___
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

[Dhis2-devs] [Bug 1189842] [NEW] Individual record: cannot assigned to a program except 'Death'

[Hannan Khan]

#cleanup, loc
alLoadingCollectionKeys contained [1] entries (CollectionLoadContext.java [http-
bio-8080-exec-5])
   
Whats wrong?

Hannan Khan

** Affects: dhis2
 Importance: Undecided
 Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1189842

Title:
  Individual record: cannot assigned to a program except 'Death'

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  Dear Experts

  We are using DHIS2.11 on Tomcat7, Postgres 9.2, Open JDK7. After
  adding a person in 'individual record' without assigning any program
  and then when we trying to assigning that person to a program there is
  no message. From tomcat we find the following :

  * ERROR 2013-06-11 15:41:42,650 Error while executing action 
(ExceptionIntercept
  or.java [http-bio-8080-exec-5])
  java.lang.RuntimeException: org.hibernate.type.SerializationException: could 
not
   deserialize
  at org.hisp.dhis.program.Program.isValid(Program.java:436)
  at 
org.hisp.dhis.caseentry.action.patient.ValidatePatientProgramEnrollme
  ntAction.execute(ValidatePatientProgramEnrollmentAction.java:107)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
  java:57)
  at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
  sorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:601)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultA
  ctionInvocation.java:453)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Defa
  ultActionInvocation.java:292)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:255)
  at 
org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.interc
  ept(XWorkPortalUserInterceptor.java:87)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.inte
  rcept(XWorkPortalModuleInterceptor.java:90)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.interc
  ept(XWorkPortalMenuInterceptor.java:96)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.inte
  rcept(XWorkPortalParamsInterceptor.java:118)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterce
  ptor.java:81)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettin
  gInterceptor.java:80)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInte
  rceptor.java:84)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(X
  WorkSecurityInterceptor.java:112)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSe
  ttingInterceptor.java:103)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.j
  ava:135)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept
  (ParametersInterceptor.java:211)
  at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
  (MethodFilterInterceptor.java:98)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.inter
  cept(StaticParametersInterceptor.java:190)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInt
  erceptor.java:109)
  at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  nvocation.java:249)
  at 
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.j
  ava:54

Re: [Dhis2-devs] Occasional problem in GIS module

[Hannan Khan]

Usually the following way I found this message (but not always).

First I go to the boundary laye and then I go to the Facility layer to see
the dostribution of facilities; the facility appreas. After that it happens.

I try to trace the log but I can figure it out as it is very busy server. I
will  check tomcat7 log and get back if I find any.

Regards

Hannan


On Sun, May 26, 2013 at 3:47 PM, Jan Henrik Øverland 
janhenrik.overl...@gmail.com wrote:

 Hi Hannan,

 I have never seen this before. Does it happen randomly or is there any
 particular way it can be reproduced?


 On Sun, May 26, 2013 at 10:05 AM, Hannan Khan hann...@gmail.com wrote:

 Dear Experts. One of my implementation running dhis 2.10. When we running
 GIZ some times it pops up the attached problem window.

 What is the reason and how that can be solved without changing the
 version.

 Regards

 Hannan

 ___
 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



___
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

Re: [Dhis2-devs] [Dhis2-users] Migrating from MySQL to PostgreSQL

[Hannan Khan]

Dear Saptarshi



Thank you for helping to convert one of the Bangladesh database from MySQL
to PostgreSQL. But there is still a long way to go.



So far all tables are converted and the metadata are exported from MySQL
and imported into PostgreSQL. What we find that the import has lots of
inconsistency and we are trying to find solution. Few problems we already
solved but I need the reason. We are working on it and within few days I
will write to you all for reason and help. But the man challenge is to
convert 32 million data value and 26000 orgunit and associated tables
because of this metadata conversion problem.

What I find the DHIS2 version 2.11 is not suitable for MySQL which is not
fare. We just tuned our MySQL Server and 5.6 have significant improvement
in performance.* So I am requesting the community to reconsider the use of
MySQL as well.*

Regars

Hannan Khan
On Tue, May 7, 2013 at 6:53 PM, Saptarshi Purkayastha sun...@gmail.comwrote:

 Hello DHIS users and devs,

 Apologies for the long email... Should have probably been multiple
 blogpost to reduce its length...

 I recently encountered a situation with a very large implementation of
 DHIS2 having problems generating data mart.
 Thus no reports were generated and only data entry was being done. I
 thought I'd share some of the experiences to solve these issues, so that it
 might be useful to other implementers.
 Some changes will be needed in the DHIS2 source, so sending this to the
 dev list also, where dev-related discussions can follow-up.

 While PostgreSQL is our recommended database, many implementations have
 also used MySQL.
 My findings clearly highlight that DHIS2 performs much better on
 PostgreSQL and there are also some bugs related to MySQL dialect.
 Total org units - 26303
 Total Monthly datasets - 9
 Total Daily dataset - 1
 Total Yearly dataset - 3

 The implementation has about 34 million datavalues (non-zero)... but I
 pruned it for my benchmarking. I added 1-million datavalues and ran the
 data mart.
 The results are from my fairly good laptop (quad-core i7; 8GB RAM; tuned
 JVM; tuned MySQL 5.5 (4GB RAM); tuned PostgreSQL 9.2 (4GB RAM); 240GB SSD)
 Using DHIS2 2.11. When doing MySQL benchmark turned off all services
 including postgres and vice versa.
 Java Opts:  -Xmx3G -Xms768m -XX:MaxPermSize=512m
 Java version: 1.7.0_21 x64
 Java vendor: Oracle Corporation OS name: WindowsMySQL = datamart
 completed in 3hrs 46min 12sec
 PostgreSQL = datamart completed in 2hrs 5min 16sec

 So, it is obvious that PostgreSQL is doing datamart much faster. The
 advantages might scale better if larger number of datavalues
 One could argue MySQL 5.6 has many performance improvements, I didn't have
 time to explore that.
 The migration to PostgreSQL has some challenges. Following are steps I
 followed:

  - Take the mysqldump
  - replace bit(1) to tinyint(1) in the SQL file
  - You'll see that column names are camelCase. This is an issue because
 postgres will added a double quotes around to get case-sensitivity, which
 MySQL by default nicely excludes.
 So you'll have to make all column names to lowercase and remove the quote
 characters. I did this with a simple java program. There are 150-odd column
 names that need changes.
  - Used Navcat premium (trial version or SQLSquirrel also has this
 feature). Data transfer is the name of the feature that will move data
 from MySQL to Postgres
  - In MySQL non-standard use of boolean (which came only a few yrs back),
 its converted to smallint in Postgres. I wrote a JDBC program to change
 column type from smallint to boolean. A single table example is as follows
 that can be made into a looping procedure as well in pure PSQL.
 ALTER TABLE indicator ALTER COLUMN annualized TYPE boolean
 USING CASE WHEN annualized = 0 THEN FALSE
WHEN annualized = 1 THEN TRUE
ELSE NULL
 END;
  - remove NULL values from minimumvalue column of minmaxdatalement table
 DELETE from minmaxdatalement WHERE minimumvalue=NULL
  - remove NULL values from maximumvalue column of minmaxdatalement table
 DELETE from minmaxdatalement WHERE maximumvalue=NULL
  - remove NULL values from name column of relationshiptype table
 DELETE from relationshiptype WHERE name=NULL
  - blobs to bytea conversion is a mess and I had to truncate. Probably a
 JDBC based connector program will do better conversion, but I just
 truncated it and accepted the data loss to systemsetting and usersetting :-)
 *
 Devs*:
 We need to make all column names lowercase in hbm.xml files in code. This
 will ensure portability and is generally a good practice.
 We should also have a convention of using last_updated instead of
 lastUpdated in column names, as is the common practice.

 ---
 Regards,
 Saptarshi PURKAYASTHA

 My Tech Blog:  http://sunnytalkstech.blogspot.com
 You Live by CHOICE, Not by CHANCE

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us

[Dhis2-devs] [Bug 1161450] [NEW] Three report of Data Analyzer Showing Data element list on the page

[Hannan Khan]

Public bug reported:

Three report of Data Analyzer, 'Graphical Analysis - Annual', 'Graphical
Analysis - DataElement Wise' and 'Tabular Analysis' showing Data element
list  on the option selection page from the begining. This I have seen
from the mid-day today.

Please see the attached.

I am running DHIS2 for four years and never see this error before. How I
resolve this.

For checking I upload the database (from backup) and war file in
diferent server and there is no problem. What's wrong with the live one?

** Affects: dhis2
 Importance: Undecided
 Status: New

** Attachment added: Report screen in Data Analyzer - Annual.doc
   
https://bugs.launchpad.net/bugs/1161450/+attachment/3603798/+files/Report%20screen%20in%20Data%20Analyzer%20-%20Annual.doc

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1161450

Title:
  Three report of Data Analyzer Showing Data element list  on the page

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  Three report of Data Analyzer, 'Graphical Analysis - Annual',
  'Graphical Analysis - DataElement Wise' and 'Tabular Analysis' showing
  Data element list  on the option selection page from the begining.
  This I have seen from the mid-day today.

  Please see the attached.

  I am running DHIS2 for four years and never see this error before. How
  I resolve this.

  For checking I upload the database (from backup) and war file in
  diferent server and there is no problem. What's wrong with the live
  one?

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1161450/+subscriptions

___
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

Re: [Dhis2-devs] Problem creating datamart

[Hannan Khan]

Dear Bob

Thanks for your advice.

I actually put 6GB for Tomcat and and 2 GB for MySQL. My Tomcat and MySQL
are in same server. My JAVA_OPTS is -Xms1024m -Xmx6144m
-XX:MaxPermSize=2048m -XX:PermSize=512m.

We completed our testing and find that for our data volume running datamart
for one year and below is ok. If we run for two year and above it have the
same error.

Also note that there is message in the DHIS2 front end; it is run for  ever
and not completed the process. From the tomcat log I find that there is an
error of Java heap size. So my suggestion is that to convey the error
message through front so that the user know immediately that there is an
error in this module, so he can continue with other works not waiting for
the administrator to check the log.

For your information I configured Director General Health Service (DGHS)
servers (another support to DHIS2nin the health sector) with Tomcat and
MySQL in two different server and it is comfortably.The Server running
Tomcat having two Gigabit network card; one with public IP for accessing
DHIS2 and other card having local IP to accessing MySQL. The server having
MySQL have also a Gigabit card having local IP.

Regards

Hannan

On Tue, Sep 11, 2012 at 7:34 PM, Bob Jolliffe bobjolli...@gmail.com wrote:

 A few extra thoughts on java opts:

 I don't think you want to waste too much memory on permgen space when
 what you really need as much heap as you can get.  Just enough.  I
 find 256M actually suffices.

 So you probably want something like JAVA_OPTS='-Xmx4096m
 -XX:MaxPermSize=256m'

 This might be a bit tight, as Lars says, you may not have that 4096m
 physically available if 3G has gone to mysql.  I think I would try and
 trim a bit from mysql rather than trim dhis2 much below this.  2G to
 mysql should be adequate.

 If its not, think about running dhis and tomcat on separate machines.
 If you have gigabit ethernet between them, the performance cost of
 transport is not too great and you can tune each one optimally to the
 available resources.

 Bob

 On 11 September 2012 13:22, Lars Helge Øverland larshe...@gmail.com
 wrote:
  Hi,
 
  Jason is right, no need to change from mysql. It is also OK to
  aggregate a year at the time to reduce memory usage, hopefully you
  don't need to do this too often. Can you please:
 
  1. Paste the contents of the Help - About page from Java opts and below.
 
  2. Paste the number of data values you have in your database from Data
  administration - Data statistics.
 
  It is also a point not to raise the value of Xmx to more than what is
  actually available to the JVM, it might trick Java to put more objects
  into memory than what is possible, leading to poorer performance/out
  of mem errors. So if you have assigned a lot of memory to mysql or
  other applications running on the server you might need to lower it a
  bit.
 
  Lars
 
  ___
  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

___
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

Re: [Dhis2-devs] Problem creating datamart

[Hannan Khan]

-XX:MaxPermSize=2048m and -XX:PermSize=512m

On Tue, Sep 11, 2012 at 11:27 AM, Jason Pickering 
jason.p.picker...@gmail.com wrote:

 The PergGen space is the important option.  What are you JAVA_OPTS.?

 --
 Sent from my mobile
 On Sep 11, 2012 7:25 AM, Hannan Khan hann...@gmail.com wrote:

 Thanks Jason.

 I put the Java heap space 1GB and Maximum 6GB (Xmx6144m and Xms1024m).
 But still getting 'java.lang.OutOfMemoryError: Java heap space' error. That
 why I asked that whether that is a bug or not.

 I am trying to other options and contact you soon.

 Regards

 Hannan

 On Mon, Sep 10, 2012 at 11:40 AM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Hi Hannan,

 You configuration may have worked previously, but some things were
 changed in the datamart and you will need to allocate more memory to
 it after 2.7.

 The details are here of the server setup are here

 http://dhis2.org/doc/snapshot/en/implementer/html/ch08.html#d5e413

 and the important part is the JAVA_OPTS environment variable, for
 instance...

 export JAVA_OPTS='-Xmx6000m -Xms3000m -XX:MaxPermSize=800m
 -XX:PermSize=400m'

 I am not really sure what your settings are, but you should at least
 specify these options, of course adjusting them for the amount of
 memory which can be allocated to DHIS2 .

 Best regards,
 Jason




 On Mon, Sep 10, 2012 at 10:49 AM, Hannan Khan hann...@gmail.com wrote:
  Dear Jason
 
  Thanks for your advice. We are running dhis2 from 2010. In earlier
 version
  we dont have any problem creating datamart. After updating to version
 2.7 we
  imported a big chuck of data from two data souce and after that we have
  problem creating datamart.
 
  So far I know the configuration is ok, however I will check again and
 get
  back to you.
 
  Regards
 
  Hannan
  from Samsung Galaxy
 
  On Sep 9, 2012 5:39 PM, Jason Pickering jason.p.picker...@gmail.com
 
  wrote:
 
  This is not a bug. You must increase the heap size. Please consult the
  implementation manual for details.
 
  Regards,
  Jason
 
  --
  Sent from my mobile
 
  On Sep 9, 2012 1:12 PM, Hannan Khan hann...@gmail.com wrote:
 
  We are using dhis2 version 2.7. Whenever we generating datamart are
 it
  taking long time and it never ends.The error message is (in the
 tomcat log
  file)
 
 'dhis2-org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor
  processChildren SEVERE: Exception invoking periodic operation:
  java.lang.OutOfMemoryError: Java heap space'.
 
  I attached the log file.
 
  Regards
 
  Hannan Khan
 
  National Data Warehouse
 
 
 
 
  ___
  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
 
 



___
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

Re: [Dhis2-devs] Problem creating datamart

[Hannan Khan]

Hi Morten

Server have 8GB memory and database is 3159MB. We are using MySQL.

Regards

Hannan

On Tue, Sep 11, 2012 at 1:53 PM, Morten Olav Hansen morte...@gmail.comwrote:

 Hi

 How much memory does your server have? and what is the size of your
 database?

 --
 Morten



 On Tue, Sep 11, 2012 at 2:51 PM, Hannan Khan hann...@gmail.com wrote:

 -XX:MaxPermSize=2048m and -XX:PermSize=512m


 On Tue, Sep 11, 2012 at 11:27 AM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 The PergGen space is the important option.  What are you JAVA_OPTS.?

 --
 Sent from my mobile
 On Sep 11, 2012 7:25 AM, Hannan Khan hann...@gmail.com wrote:

 Thanks Jason.

 I put the Java heap space 1GB and Maximum 6GB (Xmx6144m and Xms1024m).
 But still getting 'java.lang.OutOfMemoryError: Java heap space' error. That
 why I asked that whether that is a bug or not.

 I am trying to other options and contact you soon.

 Regards

 Hannan

 On Mon, Sep 10, 2012 at 11:40 AM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Hi Hannan,

 You configuration may have worked previously, but some things were
 changed in the datamart and you will need to allocate more memory to
 it after 2.7.

 The details are here of the server setup are here

 http://dhis2.org/doc/snapshot/en/implementer/html/ch08.html#d5e413

 and the important part is the JAVA_OPTS environment variable, for
 instance...

 export JAVA_OPTS='-Xmx6000m -Xms3000m -XX:MaxPermSize=800m
 -XX:PermSize=400m'

 I am not really sure what your settings are, but you should at least
 specify these options, of course adjusting them for the amount of
 memory which can be allocated to DHIS2 .

 Best regards,
 Jason




 On Mon, Sep 10, 2012 at 10:49 AM, Hannan Khan hann...@gmail.com
 wrote:
  Dear Jason
 
  Thanks for your advice. We are running dhis2 from 2010. In earlier
 version
  we dont have any problem creating datamart. After updating to
 version 2.7 we
  imported a big chuck of data from two data souce and after that we
 have
  problem creating datamart.
 
  So far I know the configuration is ok, however I will check again
 and get
  back to you.
 
  Regards
 
  Hannan
  from Samsung Galaxy
 
  On Sep 9, 2012 5:39 PM, Jason Pickering 
 jason.p.picker...@gmail.com
  wrote:
 
  This is not a bug. You must increase the heap size. Please consult
 the
  implementation manual for details.
 
  Regards,
  Jason
 
  --
  Sent from my mobile
 
  On Sep 9, 2012 1:12 PM, Hannan Khan hann...@gmail.com wrote:
 
  We are using dhis2 version 2.7. Whenever we generating datamart
 are it
  taking long time and it never ends.The error message is (in the
 tomcat log
  file)
 
 'dhis2-org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor
  processChildren SEVERE: Exception invoking periodic operation:
  java.lang.OutOfMemoryError: Java heap space'.
 
  I attached the log file.
 
  Regards
 
  Hannan Khan
 
  National Data Warehouse
 
 
 
 
  ___
  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
 
 




 ___
 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



___
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

Re: [Dhis2-devs] Problem creating datamart

[Hannan Khan]

I might found an alternative solution. Yesterday we run data mart for 9
month and it was completed successfully but when we run for 5 years, the
errors arrived.

Today and trying with again and get back to you all with the result. But
when we run datamart for 9 moth it takes 34 minutes, which is long is not
it?

Regards

Hannan

On Tue, Sep 11, 2012 at 2:01 PM, Morten Olav Hansen morte...@gmail.comwrote:

 That's a really big database... I think maybe Lars should answer if the
 memory of the server is large enough (I'm sure he can compare it with what
 he has been doing to tune the Kenya server).

 --
 Morten



 On Tue, Sep 11, 2012 at 2:59 PM, Hannan Khan hann...@gmail.com wrote:

 Hi Morten

 Server have 8GB memory and database is 3159MB. We are using MySQL.

 Regards

 Hannan


 On Tue, Sep 11, 2012 at 1:53 PM, Morten Olav Hansen 
 morte...@gmail.comwrote:

 Hi

 How much memory does your server have? and what is the size of your
 database?

 --
 Morten



 On Tue, Sep 11, 2012 at 2:51 PM, Hannan Khan hann...@gmail.com wrote:

 -XX:MaxPermSize=2048m and -XX:PermSize=512m


 On Tue, Sep 11, 2012 at 11:27 AM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 The PergGen space is the important option.  What are you JAVA_OPTS.?

 --
 Sent from my mobile
 On Sep 11, 2012 7:25 AM, Hannan Khan hann...@gmail.com wrote:

 Thanks Jason.

 I put the Java heap space 1GB and Maximum 6GB (Xmx6144m and
 Xms1024m). But still getting 'java.lang.OutOfMemoryError: Java heap 
 space'
 error. That why I asked that whether that is a bug or not.

 I am trying to other options and contact you soon.

 Regards

 Hannan

 On Mon, Sep 10, 2012 at 11:40 AM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Hi Hannan,

 You configuration may have worked previously, but some things were
 changed in the datamart and you will need to allocate more memory to
 it after 2.7.

 The details are here of the server setup are here

 http://dhis2.org/doc/snapshot/en/implementer/html/ch08.html#d5e413

 and the important part is the JAVA_OPTS environment variable, for
 instance...

 export JAVA_OPTS='-Xmx6000m -Xms3000m -XX:MaxPermSize=800m
 -XX:PermSize=400m'

 I am not really sure what your settings are, but you should at least
 specify these options, of course adjusting them for the amount of
 memory which can be allocated to DHIS2 .

 Best regards,
 Jason




 On Mon, Sep 10, 2012 at 10:49 AM, Hannan Khan hann...@gmail.com
 wrote:
  Dear Jason
 
  Thanks for your advice. We are running dhis2 from 2010. In earlier
 version
  we dont have any problem creating datamart. After updating to
 version 2.7 we
  imported a big chuck of data from two data souce and after that we
 have
  problem creating datamart.
 
  So far I know the configuration is ok, however I will check again
 and get
  back to you.
 
  Regards
 
  Hannan
  from Samsung Galaxy
 
  On Sep 9, 2012 5:39 PM, Jason Pickering 
 jason.p.picker...@gmail.com
  wrote:
 
  This is not a bug. You must increase the heap size. Please
 consult the
  implementation manual for details.
 
  Regards,
  Jason
 
  --
  Sent from my mobile
 
  On Sep 9, 2012 1:12 PM, Hannan Khan hann...@gmail.com wrote:
 
  We are using dhis2 version 2.7. Whenever we generating datamart
 are it
  taking long time and it never ends.The error message is (in the
 tomcat log
  file)
 
 'dhis2-org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor
  processChildren SEVERE: Exception invoking periodic operation:
  java.lang.OutOfMemoryError: Java heap space'.
 
  I attached the log file.
 
  Regards
 
  Hannan Khan
 
  National Data Warehouse
 
 
 
 
  ___
  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
 
 




 ___
 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





___
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