[Dhis2-users] No Data Values

[Stanley Kalyati]

Hi all,

I have an instance that was working properly until today when I noticed
that pivot tables and visualizer are saying no data values on some
forms.Yet there is data captured and yesterday I was able to see
data.Another form however i am able to see data when I run pivot tables.

When I run report rate summary,the instance is able to show that I have
indeed completed the data sets.

I am using 2.6 version.

What could be the problem? Please assist

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

Re: [Dhis2-users] [Dhis2-devs] Option sets and data elements

[Nada Ghosn]

Greetings,
than you for the reply,
I have tried the solution to have various data elements with specific
option sets.
Example:
- Data element province with option set for all provinces
- Data element district A with option set for all districts for province A
- Data element district B with option set for all districts for province B.
- Then i created a program rule to hide or show data element district A or
data element district B based on the value of data element province,
It worked for a while than it was instable. The various data element
district A and data element district B appeared at same time.
So i am searching for more stable solution.

Will it be possible with java script to assign different option sets for
one data element based on another data element?

Sincerely
Nada Ghosn


On Tue, Jan 30, 2018 at 12:54 PM, Calle Hedberg 
wrote:

> Hi,
>
> Cascading option sets have been recognised as a need for quite some time -
> see DHIS2-431. We have so far not managed to get this prioritised high
> enough, but I've had some preliminary discussions with Markus on how to do
> it
>
> Regards
> Calle
>
> On 30 January 2018 at 12:30, Knut Staring  wrote:
>
>> Hi Nada,
>>
>> Are you collecting the same data at two levels? Is it a type of survey
>> question regarding the organisational unit?
>>
>> Perhaps you could have two different data elements linked to different
>> data sets, which can then in turn be assigned at different levels?
>>
>> Knut
>>
>> On Mon, Jan 29, 2018 at 12:11 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Nada,
>>>
>>> This sounds like a "cascading drop down". This is not supported directly
>>> in DHIS2, so you will need to implement your own front-end solution for
>>> this.
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>> On Sat, Jan 27, 2018 at 9:49 AM, Nada Ghosn  wrote:
>>>
 Good morning,
 Reference is made to tacker/event capture
 Is it possible to have one data element having different option sets
 based on specific criteria?

 Example:
 data element_province (text)
 data element_district.
 Based on the value of the data element_province, the data
 element_district will show different option sets.

 Sincerely
 NG

 --
 Nada Ghosn, MD
 Head, Epidemiology Surveillance Program (Esumoh)
 Ministry of Public Health
 Beirut, Museum square
 Lebanon
 Tel +961.1.614194 <+961%201%20614%20194>
 Fax +961.1.610920 <+961%201%20610%20920>
 Email esumoh...@gmail.com, esu...@moph.gov.lb
 Website www.moph.gov.lb


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


>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.picker...@gmail.com
>>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Knut Staring
>>
>> Department of Information, Evidence and Research
>> World Health Organization, Geneva, Switzerland
>> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
>> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
>> Skype: knutstar
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
> 
>
> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>
> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>
> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>


-- 
Nada Ghosn, MD
Head, Epidemiology Surveillance Program (Esumoh)
Ministry of Public Health
Beirut, Museum square
Lebanon
Tel +961.1.614194
Fax +961.1.610920
Email esumoh...@gmail.com, esu...@moph.gov.lb
Website www.moph.gov.lb
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Organisation Units repetitive structure

[Calle Hedberg]

Bernard,

I would suggest the following to easily cross-check that your hierarchy is
correctly defined:

1. Go to Data Administration -> Maintenance -> Select "Update Organisation
Unit Paths"

2. In the Data Admin menu, select and run "Generate Resource Tables"

3. Set up and run an SQL VIew (also in Data Admin) like this:
SELECT ou.hierarchylevel, ou.name, ou1.name as Parent from organisationunit
ou
INNER JOIN organisationunit ou1 on ou.parentid = ou1.organisationunitid
order by ou.hierarchylevel, ou.name;

4. Execute that sql view, dump it into CSV or Excel, and scan through to
verify that all organisation units in the database have the correct parent

you can obviously also run the same sql script against the database itself

Best regards
Calle

On 30 January 2018 at 10:21, Knut Staring  wrote:

> Hi Bernard,
>
> Sorry, I'm very busy with a series of meetings this week, and also not in
> the best position to resolve this, so hoping for others on the list to step
> up. Thanks for the detailed explanation of your issue, my guess it is
> likely just some small thing with your database. You could perhaps also try
> to take a look directly at your organsationunit table in the db and scan
> for any anomalies such as 10 digit UIDs or null values (can also be done
> through the DHIS2 GUI with an SQL View (under Data Administration).
>
> Knut
>
> On Tue, Jan 30, 2018 at 9:10 AM, Bernard Sadaka (IM Advisor) <
> lib@pu-ami.org> wrote:
>
>> Hello Again Knut,
>>
>> Any news about this issue?
>>
>> Should I open a ticket for it in Jira? The challenge is I don’t know how
>> to replicate this bug.
>>
>>
>>
>> Here is what happening with my org units:
>>
>> *As you can see bellow, all the org units are there duplicated but in a
>> scrambled order and not under their respective parent. Add to that when I
>> click on one of the values that are supposed to show the underlying org
>> units only of the copies will expand and show that.*
>>
>>
>>
>> *Is this front end related? Backend? Database related?*
>>
>>
>>
>> Here is my org unit structure:
>>
>>1. Lebanon
>>   1. Organisation A
>>
>>i.  Base
>> 1
>>
>> 1.   PHCC 1
>>
>> 2.   PHCC 2
>>
>> 3.   PHCC 3
>>
>>  ii.  Base
>> 2
>>
>> 1.   PHCC 4
>>
>> 2.   PHCC 5
>>
>> 3.   PHCC 6
>>
>> 4.   PHCC 7
>>
>>1. Test Org A
>>
>>i.  Test
>> Base 1
>>
>> 1.   Test PHCC 1
>>
>> 2.   Test PHCC 2
>>
>> 3.   Test PHCC 3
>>
>>  ii.  Test
>> Base 2
>>
>> 1.   Test PHCC 4
>>
>> 2.   Test PHCC 5
>>
>> 3.   Test PHCC 6
>>
>> 4.   Test PHCC 7
>>
>> 5.   Test PHCC 8
>>
>>
>>
>> In some places on my DHIS2 it shows correctly, in other places it shows
>> as per the bellow (in DHIS2 sections such as the “pivot tables” and the
>> “data output and analytics organization units” under new/edit user section)
>> (the pivot tables keep trying to load as mentioned before) :
>>
>> 1.   Base 1
>>
>> 1.   PHCC 1
>>
>> 2.   PHCC 2
>>
>> 3.   PHCC 3
>>
>>1. PHCC 1
>>2. PHCC 4
>>3. PHCC 2
>>4. PHCC 3
>>5. PHCC 5
>>6. PHCC 6
>>7. Lebanon
>>   1. Organisation A
>>
>>i.  Base
>> 1
>>
>>  ii.  Base
>> 2
>>
>> 1.   PHCC 4
>>
>> 2.   PHCC 5
>>
>> 3.   PHCC 6
>>
>> 4.   PHCC 7
>>
>>1. Test Org A
>>
>>i.  Test
>> Base 1
>>
>> 1.   Test PHCC 1
>>
>> 2.   Test PHCC 2
>>
>> 3.   Test PHCC 3
>>
>>  ii.  Test
>> Base 2
>>
>> 1.   Test PHCC 4
>>
>> 2.   Test PHCC 5
>>
>> 3.   Test PHCC 6
>>
>> 4.   Test PHCC 7
>>
>> 5.   Test PHCC 8
>>
>>1. Organisation A
>>2. Base 2
>>3. PHCC 7
>>4. Test Base 1
>>5. Test PHCC 1
>>6. Test PHCC 4
>>7. Test PHCC 2
>>8. Test PHCC 5
>>9. Test PHCC 6
>>10. Test PHCC 7
>>11. Test Org A
>>12. Test Base 2
>>
>>
>>
>> Your help is appreciated.
>>
>>
>>
>> All the best,
>>
>> Bernard
>>
>>
>>
>> [image: cid:image002.png@01D36F50.572585A0]
>>
>> *Bernard Sadaka*
>>
>> *Information Management Advisor*
>>
>> Première Urgence - Aide Médicale Internationale
>>
>> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
>>
>> Ain el Remmaneh, Beirut, Lebanon
>>
>> *E-mail:* lib@pu-ami.org
>>
>> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>>
>> *Skype:* imapuami
>>
>> *Website:* https://www.pu-ami.org
>>
>>
>>
>>
>>
>> *From:* Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org]
>> *Sent:* Monday, January 29, 2018 2:29 PM
>> *To:* 'Knut 

Re: [Dhis2-users] [Dhis2-devs] Option sets and data elements

[Calle Hedberg]

Hi,

Cascading option sets have been recognised as a need for quite some time -
see DHIS2-431. We have so far not managed to get this prioritised high
enough, but I've had some preliminary discussions with Markus on how to do
it

Regards
Calle

On 30 January 2018 at 12:30, Knut Staring  wrote:

> Hi Nada,
>
> Are you collecting the same data at two levels? Is it a type of survey
> question regarding the organisational unit?
>
> Perhaps you could have two different data elements linked to different
> data sets, which can then in turn be assigned at different levels?
>
> Knut
>
> On Mon, Jan 29, 2018 at 12:11 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Nada,
>>
>> This sounds like a "cascading drop down". This is not supported directly
>> in DHIS2, so you will need to implement your own front-end solution for
>> this.
>>
>> Regards,
>> Jason
>>
>>
>> On Sat, Jan 27, 2018 at 9:49 AM, Nada Ghosn  wrote:
>>
>>> Good morning,
>>> Reference is made to tacker/event capture
>>> Is it possible to have one data element having different option sets
>>> based on specific criteria?
>>>
>>> Example:
>>> data element_province (text)
>>> data element_district.
>>> Based on the value of the data element_province, the data
>>> element_district will show different option sets.
>>>
>>> Sincerely
>>> NG
>>>
>>> --
>>> Nada Ghosn, MD
>>> Head, Epidemiology Surveillance Program (Esumoh)
>>> Ministry of Public Health
>>> Beirut, Museum square
>>> Lebanon
>>> Tel +961.1.614194 <+961%201%20614%20194>
>>> Fax +961.1.610920 <+961%201%20610%20920>
>>> Email esumoh...@gmail.com, esu...@moph.gov.lb
>>> Website www.moph.gov.lb
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
>
> Department of Information, Evidence and Research
> World Health Organization, Geneva, Switzerland
> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
> Skype: knutstar
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

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

Re: [Dhis2-users] Option sets and data elements

[Knut Staring]

Hi Nada,

Are you collecting the same data at two levels? Is it a type of survey
question regarding the organisational unit?

Perhaps you could have two different data elements linked to different data
sets, which can then in turn be assigned at different levels?

Knut

On Mon, Jan 29, 2018 at 12:11 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Nada,
>
> This sounds like a "cascading drop down". This is not supported directly
> in DHIS2, so you will need to implement your own front-end solution for
> this.
>
> Regards,
> Jason
>
>
> On Sat, Jan 27, 2018 at 9:49 AM, Nada Ghosn  wrote:
>
>> Good morning,
>> Reference is made to tacker/event capture
>> Is it possible to have one data element having different option sets
>> based on specific criteria?
>>
>> Example:
>> data element_province (text)
>> data element_district.
>> Based on the value of the data element_province, the data
>> element_district will show different option sets.
>>
>> Sincerely
>> NG
>>
>> --
>> Nada Ghosn, MD
>> Head, Epidemiology Surveillance Program (Esumoh)
>> Ministry of Public Health
>> Beirut, Museum square
>> Lebanon
>> Tel +961.1.614194 <+961%201%20614%20194>
>> Fax +961.1.610920 <+961%201%20610%20920>
>> Email esumoh...@gmail.com, esu...@moph.gov.lb
>> Website www.moph.gov.lb
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46%2076%20414%2070%2049>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Program indicators export to another system

[Elmarie Claasen]

Hi all,



We create Programme Indicators and would like to export those to other
systems with different data element UIDs than the created Programme
Indicator UID.

If adding a code to the Programme Indicator which is same as the Data
Element code will this allow matching on import?



Regards,



*Elmarie Claasen*

[image: Hisp logo]

Project Manager

Health Information Systems Program

Tel:  041-367 1027

Cell: 082 374 2209

E-mail: elma...@hisp.org

Skype:  elmarie.claasen52

-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Get Program Indicator throught value analytics Tables

[Djibril Dione]

Dear DHIS Community,
I am trying to understand how Program Indicators values are stored in the
database and I thought of the analytics tables.
I have read on the analytics API documentation that the dx dimension can be
used to query on Data elements, indicators, and Program Indicators. I tried
to use the same approach using dx dimension on Analytics table through the
backend to retrieve the PI value and I noticed that the PI values are not
stored.

Its there any other way to retrieve the Program indicator value through the
backend table?

-- 

Kind Regards


Djibril Dione

Database Specialist

Health Information Systems Program – SA

Cell: +27 71 711 5421

Skype: dione.djibril

Address: 66 Rigel Ave North, Waterkloof Ridge, Pretoria, 0181
Web: www.hisp.org
NPR Reg No: 2003/005786/08

-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Organisation Units repetitive structure

[Bernard Sadaka (IM Advisor)]

Thank you Knut,

Will look into that.

All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org





From: Knut Staring [mailto:knu...@gmail.com]
Sent: Tuesday, January 30, 2018 10:21 AM
To: Bernard Sadaka (IM Advisor) 
Cc: DHIS 2 Users list ; DHIS 2 developers 

Subject: Re: [Dhis2-users] Organisation Units repetitive structure



Hi Bernard,



Sorry, I'm very busy with a series of meetings this week, and also not in the 
best position to resolve this, so hoping for others on the list to step up. 
Thanks for the detailed explanation of your issue, my guess it is likely just 
some small thing with your database. You could perhaps also try to take a look 
directly at your organsationunit table in the db and scan for any anomalies 
such as 10 digit UIDs or null values (can also be done through the DHIS2 GUI 
with an SQL View (under Data Administration).



Knut



On Tue, Jan 30, 2018 at 9:10 AM, Bernard Sadaka (IM Advisor) 
 > wrote:

Hello Again Knut,

Any news about this issue?

Should I open a ticket for it in Jira? The challenge is I don’t know how to 
replicate this bug.



Here is what happening with my org units:

As you can see bellow, all the org units are there duplicated but in a 
scrambled order and not under their respective parent. Add to that when I click 
on one of the values that are supposed to show the underlying org units only of 
the copies will expand and show that.



Is this front end related? Backend? Database related?



Here is my org unit structure:

1.  Lebanon

a.  Organisation A

   i.  Base 1

1.   PHCC 1

2.   PHCC 2

3.   PHCC 3

 ii.  Base 2

1.   PHCC 4

2.   PHCC 5

3.   PHCC 6

4.   PHCC 7

b.  Test Org A

   i.  Test 
Base 1

1.   Test PHCC 1

2.   Test PHCC 2

3.   Test PHCC 3

 ii.  Test Base 
2

1.   Test PHCC 4

2.   Test PHCC 5

3.   Test PHCC 6

4.   Test PHCC 7

5.   Test PHCC 8



In some places on my DHIS2 it shows correctly, in other places it shows as per 
the bellow (in DHIS2 sections such as the “pivot tables” and the “data output 
and analytics organization units” under new/edit user section) (the pivot 
tables keep trying to load as mentioned before) :

1.   Base 1

1.   PHCC 1

2.   PHCC 2

3.   PHCC 3

2.  PHCC 1
3.  PHCC 4
4.  PHCC 2
5.  PHCC 3
6.  PHCC 5
7.  PHCC 6
8.  Lebanon

a.  Organisation A

   i.  Base 1

 ii.  Base 2

1.   PHCC 4

2.   PHCC 5

3.   PHCC 6

4.   PHCC 7

b.  Test Org A

   i.  Test 
Base 1

1.   Test PHCC 1

2.   Test PHCC 2

3.   Test PHCC 3

 ii.  Test Base 
2

1.   Test PHCC 4

2.   Test PHCC 5

3.   Test PHCC 6

4.   Test PHCC 7

5.   Test PHCC 8

9.  Organisation A
10. Base 2
11. PHCC 7
12. Test Base 1
13. Test PHCC 1
14. Test PHCC 4
15. Test PHCC 2
16. Test PHCC 5
17. Test PHCC 6
18. Test PHCC 7
19. Test Org A
20. Test Base 2



Your help is appreciated.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881   (208)

Skype: imapuami

Website:   https://www.pu-ami.org





From: Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org 
 ]
Sent: Monday, January 29, 2018 2:29 PM
To: 'Knut Staring'  >
Cc: 'DHIS 2 Users list'  >; 'DHIS 2 developers' 
 >
Subject: RE: [Dhis2-users] Organisation Units repetitive structure



Thank you Knut,

The console error while at the pivot table and viewing the org units is “Cannot 
read property ‘internalId’ of undefined ” as per the 

Re: [Dhis2-users] Organisation Units repetitive structure

[Knut Staring]

Hi Bernard,

Sorry, I'm very busy with a series of meetings this week, and also not in
the best position to resolve this, so hoping for others on the list to step
up. Thanks for the detailed explanation of your issue, my guess it is
likely just some small thing with your database. You could perhaps also try
to take a look directly at your organsationunit table in the db and scan
for any anomalies such as 10 digit UIDs or null values (can also be done
through the DHIS2 GUI with an SQL View (under Data Administration).

Knut

On Tue, Jan 30, 2018 at 9:10 AM, Bernard Sadaka (IM Advisor) <
lib@pu-ami.org> wrote:

> Hello Again Knut,
>
> Any news about this issue?
>
> Should I open a ticket for it in Jira? The challenge is I don’t know how
> to replicate this bug.
>
>
>
> Here is what happening with my org units:
>
> *As you can see bellow, all the org units are there duplicated but in a
> scrambled order and not under their respective parent. Add to that when I
> click on one of the values that are supposed to show the underlying org
> units only of the copies will expand and show that.*
>
>
>
> *Is this front end related? Backend? Database related?*
>
>
>
> Here is my org unit structure:
>
>1. Lebanon
>   1. Organisation A
>
>i.  Base
> 1
>
> 1.   PHCC 1
>
> 2.   PHCC 2
>
> 3.   PHCC 3
>
>  ii.  Base
> 2
>
> 1.   PHCC 4
>
> 2.   PHCC 5
>
> 3.   PHCC 6
>
> 4.   PHCC 7
>
>1. Test Org A
>
>i.  Test
> Base 1
>
> 1.   Test PHCC 1
>
> 2.   Test PHCC 2
>
> 3.   Test PHCC 3
>
>  ii.  Test
> Base 2
>
> 1.   Test PHCC 4
>
> 2.   Test PHCC 5
>
> 3.   Test PHCC 6
>
> 4.   Test PHCC 7
>
> 5.   Test PHCC 8
>
>
>
> In some places on my DHIS2 it shows correctly, in other places it shows as
> per the bellow (in DHIS2 sections such as the “pivot tables” and the “data
> output and analytics organization units” under new/edit user section) (the
> pivot tables keep trying to load as mentioned before) :
>
> 1.   Base 1
>
> 1.   PHCC 1
>
> 2.   PHCC 2
>
> 3.   PHCC 3
>
>1. PHCC 1
>2. PHCC 4
>3. PHCC 2
>4. PHCC 3
>5. PHCC 5
>6. PHCC 6
>7. Lebanon
>   1. Organisation A
>
>i.  Base
> 1
>
>  ii.  Base
> 2
>
> 1.   PHCC 4
>
> 2.   PHCC 5
>
> 3.   PHCC 6
>
> 4.   PHCC 7
>
>1. Test Org A
>
>i.  Test
> Base 1
>
> 1.   Test PHCC 1
>
> 2.   Test PHCC 2
>
> 3.   Test PHCC 3
>
>  ii.  Test
> Base 2
>
> 1.   Test PHCC 4
>
> 2.   Test PHCC 5
>
> 3.   Test PHCC 6
>
> 4.   Test PHCC 7
>
> 5.   Test PHCC 8
>
>1. Organisation A
>2. Base 2
>3. PHCC 7
>4. Test Base 1
>5. Test PHCC 1
>6. Test PHCC 4
>7. Test PHCC 2
>8. Test PHCC 5
>9. Test PHCC 6
>10. Test PHCC 7
>11. Test Org A
>12. Test Base 2
>
>
>
> Your help is appreciated.
>
>
>
> All the best,
>
> Bernard
>
>
>
> [image: cid:image002.png@01D36F50.572585A0]
>
> *Bernard Sadaka*
>
> *Information Management Advisor*
>
> Première Urgence - Aide Médicale Internationale
>
> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
>
> Ain el Remmaneh, Beirut, Lebanon
>
> *E-mail:* lib@pu-ami.org
>
> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>
> *Skype:* imapuami
>
> *Website:* https://www.pu-ami.org
>
>
>
>
>
> *From:* Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org]
> *Sent:* Monday, January 29, 2018 2:29 PM
> *To:* 'Knut Staring' 
> *Cc:* 'DHIS 2 Users list' ; 'DHIS 2
> developers' 
> *Subject:* RE: [Dhis2-users] Organisation Units repetitive structure
>
>
>
> Thank you Knut,
>
> The console error while at the pivot table and viewing the org units is
> “Cannot read property ‘internalId’ of undefined ” as per the bellow
> screenshot:
>
>
>
> My setup is Tomcat+ postgres+ Ubuntu 16.04.3LTS+ Certbot (for SSL)+nginx
> (for reverse proxy)
>
>
>
> As for the catalina.out, what should I be looking exactly for in there?
> Because when I go to the pivot table section while monitoring catalina.out
> there’s no exception thrown/shown using “tail –f catalina.out” (even after
> cleaning the browser cache)
>
>
>
> Thank you in advance for your invaluable help.
>
>
>
> Looking forward to hearing from you.
>
>
>
> All the best,
>
> Bernard
>
>
>
> [image: cid:image002.png@01D36F50.572585A0]
>
> *Bernard Sadaka*
>
> *Information Management Advisor*
>
> Première Urgence - Aide 

Re: [Dhis2-users] Organisation Units repetitive structure

[Bernard Sadaka (IM Advisor)]

Hello Again Knut,

Any news about this issue?

Should I open a ticket for it in Jira? The challenge is I don’t know how to 
replicate this bug.



Here is what happening with my org units:

As you can see bellow, all the org units are there duplicated but in a 
scrambled order and not under their respective parent. Add to that when I click 
on one of the values that are supposed to show the underlying org units only of 
the copies will expand and show that.



Is this front end related? Backend? Database related?



Here is my org unit structure:

1.  Lebanon

a.  Organisation A

   i.  Base 1

1.   PHCC 1

2.   PHCC 2

3.   PHCC 3

 ii.  Base 2

1.   PHCC 4

2.   PHCC 5

3.   PHCC 6

4.   PHCC 7

b.  Test Org A

   i.  Test 
Base 1

1.   Test PHCC 1

2.   Test PHCC 2

3.   Test PHCC 3

 ii.  Test Base 
2

1.   Test PHCC 4

2.   Test PHCC 5

3.   Test PHCC 6

4.   Test PHCC 7

5.   Test PHCC 8



In some places on my DHIS2 it shows correctly, in other places it shows as per 
the bellow (in DHIS2 sections such as the “pivot tables” and the “data output 
and analytics organization units” under new/edit user section) (the pivot 
tables keep trying to load as mentioned before) :

1.   Base 1

1.   PHCC 1

2.   PHCC 2

3.   PHCC 3

2.  PHCC 1
3.  PHCC 4
4.  PHCC 2
5.  PHCC 3
6.  PHCC 5
7.  PHCC 6
8.  Lebanon

a.  Organisation A

   i.  Base 1

 ii.  Base 2

1.   PHCC 4

2.   PHCC 5

3.   PHCC 6

4.   PHCC 7

b.  Test Org A

   i.  Test 
Base 1

1.   Test PHCC 1

2.   Test PHCC 2

3.   Test PHCC 3

 ii.  Test Base 
2

1.   Test PHCC 4

2.   Test PHCC 5

3.   Test PHCC 6

4.   Test PHCC 7

5.   Test PHCC 8

9.  Organisation A
10. Base 2
11. PHCC 7
12. Test Base 1
13. Test PHCC 1
14. Test PHCC 4
15. Test PHCC 2
16. Test PHCC 5
17. Test PHCC 6
18. Test PHCC 7
19. Test Org A
20. Test Base 2



Your help is appreciated.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org





From: Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org]
Sent: Monday, January 29, 2018 2:29 PM
To: 'Knut Staring' 
Cc: 'DHIS 2 Users list' ; 'DHIS 2 developers' 

Subject: RE: [Dhis2-users] Organisation Units repetitive structure



Thank you Knut,

The console error while at the pivot table and viewing the org units is “Cannot 
read property ‘internalId’ of undefined ” as per the bellow screenshot:





My setup is Tomcat+ postgres+ Ubuntu 16.04.3LTS+ Certbot (for SSL)+nginx (for 
reverse proxy)



As for the catalina.out, what should I be looking exactly for in there? Because 
when I go to the pivot table section while monitoring catalina.out there’s no 
exception thrown/shown using “tail –f catalina.out” (even after cleaning the 
browser cache)



Thank you in advance for your invaluable help.



Looking forward to hearing from you.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org





From: Knut Staring [mailto:knu...@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor)  
>
Cc: DHIS 2 Users list  >; DHIS 2 developers 
 >
Subject: Re: [Dhis2-users] Organisation Units repetitive structure



Hi Bernard,



In order to elucidate what is going on, the next places to check are the 
browser console and the server log.



1) In Chrome, click on Ctrl+Shit+I to open the console window and look for 
error messages in RED.



2) For the server, look for catalina.out in the logs folder (What