Organisation Units repetitive structure

Bernard_Sadaka_IM_Ad · 29 January 2018 10:47

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

cid:image002.png@01D36F50.572585A0

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

Knut_Staring · 29 January 2018 11:04

Hi Bernard,

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

In Chrome, click on Ctrl+Shit+I to open the console window and look for error messages in RED.
For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

···

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

Bernard_Sadaka_IM_Ad · 29 January 2018 12:29

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

cid:image002.png@01D36F50.572585A0

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

···

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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.

In Chrome, click on Ctrl+Shit+I to open the console window and look for error messages in RED.
For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

Bernard_Sadaka_IM_Ad · 30 January 2018 08:10

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:

Lebanon

Organisation A

                                                        i.      Base 1

```
  PHCC 1
```
```
  PHCC 2
```

  PHCC 3

                                                      ii.      Base 2

```
  PHCC 4
```
```
  PHCC 5
```
```
  PHCC 6
```
```
  PHCC 7
```

Test Org A

                                                        i.      Test Base 1

```
  Test PHCC 1
```
```
  Test PHCC 2
```

  Test PHCC 3

                                                      ii.      Test Base 2

```
  Test PHCC 4
```
```
  Test PHCC 5
```
```
  Test PHCC 6
```
```
  Test PHCC 7
```
```
  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) :

```
  Base 1
```
```
  PHCC 1
```
```
  PHCC 2
```
```
  PHCC 3
```
PHCC 1
PHCC 4
PHCC 2
PHCC 3
PHCC 5
PHCC 6
Lebanon

Organisation A

                                                        i.      Base 1

                                                      ii.      Base 2

```
  PHCC 4
```
```
  PHCC 5
```
```
  PHCC 6
```
```
  PHCC 7
```

Test Org A

                                                        i.      Test Base 1

```
  Test PHCC 1
```
```
  Test PHCC 2
```

  Test PHCC 3

                                                      ii.      Test Base 2

```
  Test PHCC 4
```
```
  Test PHCC 5
```
```
  Test PHCC 6
```
```
  Test PHCC 7
```
```
  Test PHCC 8
```
Organisation A
Base 2
PHCC 7
Test Base 1
Test PHCC 1
Test PHCC 4
Test PHCC 2
Test PHCC 5
Test PHCC 6
Test PHCC 7
Test Org A
Test Base 2

Your help is appreciated.

All the best,

Bernard

cid:image002.png@01D36F50.572585A0

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

···

From: Bernard Sadaka (IM Advisor) [mailto:lib.ima@pu-ami.org]
Sent: Monday, January 29, 2018 2:29 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net
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

cid:image002.png@01D36F50.572585A0

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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.

In Chrome, click on Ctrl+Shit+I to open the console window and look for error messages in RED.
For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

Knut_Staring · 30 January 2018 08:21

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.ima@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:

Lebanon

Organisation A
i. Base 1

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A
i. Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  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) :

```
  Base 1
```

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

PHCC 1

PHCC 4

PHCC 2

PHCC 3

PHCC 5

PHCC 6

Lebanon

Organisation A
i. Base 1

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A
i. Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  Test PHCC 8
```

Organisation A

Base 2

PHCC 7

Test Base 1

Test PHCC 1

Test PHCC 4

Test PHCC 2

Test PHCC 5

Test PHCC 6

Test PHCC 7

Test Org A

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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Bernard Sadaka (IM Advisor) [mailto:lib.ima@pu-ami.org]
Sent: Monday, January 29, 2018 2:29 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net
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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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.

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

For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

–

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

Bernard_Sadaka_IM_Ad · 30 January 2018 08:24

Thank you Knut,

Will look into that.

All the best,

Bernard

cid:image002.png@01D36F50.572585A0

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

···

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Tuesday, January 30, 2018 10:21 AM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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) lib.ima@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:

Lebanon

Organisation A

                                                           i.      Base 1

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A

                                                           i.      Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  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) :

```
  Base 1
```

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

PHCC 1

PHCC 4

PHCC 2

PHCC 3

PHCC 5

PHCC 6

Lebanon

Organisation A

                                                           i.      Base 1

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A

                                                           i.      Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  Test PHCC 8
```

Organisation A

Base 2

PHCC 7

Test Base 1

Test PHCC 1

Test PHCC 4

Test PHCC 2

Test PHCC 5

Test PHCC 6

Test PHCC 7

Test Org A

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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Bernard Sadaka (IM Advisor) [mailto:lib.ima@pu-ami.org]
Sent: Monday, January 29, 2018 2:29 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net
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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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.

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

For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

–

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

Calle_Hedberg · 30 January 2018 11:11

Bernard,

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

Go to Data Administration → Maintenance → Select “Update Organisation Unit Paths”
In the Data Admin menu, select and run “Generate Resource Tables”
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;

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 knutst@gmail.com 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

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–

On Tue, Jan 30, 2018 at 9:10 AM, Bernard Sadaka (IM Advisor) lib.ima@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:

Lebanon

Organisation A
i. Base 1

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A
i. Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  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) :

```
  Base 1
```

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

PHCC 1

PHCC 4

PHCC 2

PHCC 3

PHCC 5

PHCC 6

Lebanon

Organisation A
i. Base 1

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A
i. Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  Test PHCC 8
```

Organisation A

Base 2

PHCC 7

Test Base 1

Test PHCC 1

Test PHCC 4

Test PHCC 2

Test PHCC 5

Test PHCC 6

Test PHCC 7

Test Org A

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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Bernard Sadaka (IM Advisor) [mailto:lib.ima@pu-ami.org]
Sent: Monday, January 29, 2018 2:29 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net
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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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.

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

For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

–
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

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.hedberg@gmail.com

Skype: calle_hedberg

Bernard_Sadaka_IM_Ad · 30 January 2018 11:27

Thank you Calle,

I have verified the mentioned query and followed the mentioned steps. The org units hierarchy in the db are correct.

I think this is more of a front end error related to extjs because the error is only showing in specific places of my DHIS2 instance and not all of them (e.g. the data entry and tracker capture show the correct org unit structure)

Please advise?

Thank you again for your invaluable help.

All the best,

Bernard

cid:image002.png@01D36F50.572585A0

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

···

From: Calle Hedberg [mailto:calle.hedberg@gmail.com]
Sent: Tuesday, January 30, 2018 1:11 PM
To: Knut Staring knutst@gmail.com
Cc: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] [Dhis2-users] Organisation Units repetitive structure

Bernard,

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

Go to Data Administration → Maintenance → Select “Update Organisation Unit Paths”
In the Data Admin menu, select and run “Generate Resource Tables”
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;

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 knutst@gmail.com 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.ima@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:

Lebanon

Organisation A

                                                           i.      Base 1

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A

                                                           i.      Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  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) :

```
  Base 1
```

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

PHCC 1

PHCC 4

PHCC 2

PHCC 3

PHCC 5

PHCC 6

Lebanon

Organisation A

                                                           i.      Base 1

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A

                                                           i.      Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  Test PHCC 8
```

Organisation A

Base 2

PHCC 7

Test Base 1

Test PHCC 1

Test PHCC 4

Test PHCC 2

Test PHCC 5

Test PHCC 6

Test PHCC 7

Test Org A

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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Bernard Sadaka (IM Advisor) [mailto:lib.ima@pu-ami.org]
Sent: Monday, January 29, 2018 2:29 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net
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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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.

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

For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

–

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-devs
Post to : dhis2-devs@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.hedberg@gmail.com

Skype: calle_hedberg

Calle_Hedberg · 30 January 2018 13:23

Bernard,

if your db hierarchy is correct, then I can confirm that the “replicated” orgunits you are seeing in some contexts are definitely a bug or bugs - I noted the same thing a few days ago, but I did not have the time then to report it as a JIRA issue.

since it is fresher in your mind, would you please create a JIRA bug report it?

Regards

Calle

···

On 30 January 2018 at 13:27, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Thank you Calle,

I have verified the mentioned query and followed the mentioned steps. The org units hierarchy in the db are correct.

I think this is more of a front end error related to extjs because the error is only showing in specific places of my DHIS2 instance and not all of them (e.g. the data entry and tracker capture show the correct org unit structure)

Please advise?

Thank you again for your invaluable help.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Calle Hedberg [mailto:calle.hedberg@gmail.com]
Sent: Tuesday, January 30, 2018 1:11 PM
To: Knut Staring knutst@gmail.com
Cc: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] [Dhis2-users] Organisation Units repetitive structure

Bernard,

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

Go to Data Administration → Maintenance → Select “Update Organisation Unit Paths”

In the Data Admin menu, select and run “Generate Resource Tables”

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;

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 knutst@gmail.com 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.ima@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:

Lebanon

Organisation A
i. Base 1

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A
i. Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  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) :

```
  Base 1
```

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

PHCC 1

PHCC 4

PHCC 2

PHCC 3

PHCC 5

PHCC 6

Lebanon

Organisation A
i. Base 1

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A
i. Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  Test PHCC 8
```

Organisation A

Base 2

PHCC 7

Test Base 1

Test PHCC 1

Test PHCC 4

Test PHCC 2

Test PHCC 5

Test PHCC 6

Test PHCC 7

Test Org A

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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Bernard Sadaka (IM Advisor) [mailto:lib.ima@pu-ami.org]
Sent: Monday, January 29, 2018 2:29 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net
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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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.

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

For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

–

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-devs
Post to : dhis2-devs@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.hedberg@gmail.com

Skype: calle_hedberg

–

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.hedberg@gmail.com

Skype: calle_hedberg

Bernard_Sadaka_IM_Ad · 30 January 2018 14:42

Thank You Calle,

Yes indeed I issued a JIRA issue: https://jira.dhis2.org/browse/DHIS2-2761

It has rendered my pivot tables section unusable and this is very bad.

I hope that it could/would be solved soon.

All the best,

Bernard

cid:image002.png@01D36F50.572585A0

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

···

From: Calle Hedberg [mailto:calle.hedberg@gmail.com]
Sent: Tuesday, January 30, 2018 3:24 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: Knut Staring knutst@gmail.com; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] [Dhis2-users] Organisation Units repetitive structure

Bernard,

if your db hierarchy is correct, then I can confirm that the “replicated” orgunits you are seeing in some contexts are definitely a bug or bugs - I noted the same thing a few days ago, but I did not have the time then to report it as a JIRA issue.

since it is fresher in your mind, would you please create a JIRA bug report it?

Regards

Calle

On 30 January 2018 at 13:27, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Thank you Calle,

I have verified the mentioned query and followed the mentioned steps. The org units hierarchy in the db are correct.

I think this is more of a front end error related to extjs because the error is only showing in specific places of my DHIS2 instance and not all of them (e.g. the data entry and tracker capture show the correct org unit structure)

Please advise?

Thank you again for your invaluable help.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Calle Hedberg [mailto:calle.hedberg@gmail.com]
Sent: Tuesday, January 30, 2018 1:11 PM
To: Knut Staring knutst@gmail.com
Cc: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] [Dhis2-users] Organisation Units repetitive structure

Bernard,

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

Go to Data Administration → Maintenance → Select “Update Organisation Unit Paths”

In the Data Admin menu, select and run “Generate Resource Tables”

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;

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 knutst@gmail.com 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.ima@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:

Lebanon

Organisation A

                                                           i.      Base 1

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A

                                                           i.      Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  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) :

```
  Base 1
```

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

PHCC 1

PHCC 4

PHCC 2

PHCC 3

PHCC 5

PHCC 6

Lebanon

Organisation A

                                                           i.      Base 1

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A

                                                           i.      Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  Test PHCC 8
```

Organisation A

Base 2

PHCC 7

Test Base 1

Test PHCC 1

Test PHCC 4

Test PHCC 2

Test PHCC 5

Test PHCC 6

Test PHCC 7

Test Org A

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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Bernard Sadaka (IM Advisor) [mailto:lib.ima@pu-ami.org]
Sent: Monday, January 29, 2018 2:29 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net
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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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.

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

For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

–

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-devs
Post to : dhis2-devs@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.hedberg@gmail.com

Skype: calle_hedberg

–

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.hedberg@gmail.com

Skype: calle_hedberg

Mamadou_Tafsir_Diall · 30 January 2018 14:59

Good evening,

I think the problem comes from the fact that by creating the user on the " Data output and analytic organisation units

" section you have probably selected at the same time an organisation unit and its subcategories.

Excuse my english.

Regards,

···

2018-01-30 14:42 GMT+00:00 Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org:

Thank You Calle,

Yes indeed I issued a JIRA issue: https://jira.dhis2.org/browse/DHIS2-2761

It has rendered my pivot tables section unusable and this is very bad.

I hope that it could/would be solved soon.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Calle Hedberg [mailto:calle.hedberg@gmail.com]
Sent: Tuesday, January 30, 2018 3:24 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: Knut Staring knutst@gmail.com; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net

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

Bernard,

if your db hierarchy is correct, then I can confirm that the “replicated” orgunits you are seeing in some contexts are definitely a bug or bugs - I noted the same thing a few days ago, but I did not have the time then to report it as a JIRA issue.

since it is fresher in your mind, would you please create a JIRA bug report it?

Regards

Calle

On 30 January 2018 at 13:27, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Thank you Calle,

I have verified the mentioned query and followed the mentioned steps. The org units hierarchy in the db are correct.

I think this is more of a front end error related to extjs because the error is only showing in specific places of my DHIS2 instance and not all of them (e.g. the data entry and tracker capture show the correct org unit structure)

Please advise?

Thank you again for your invaluable help.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Calle Hedberg [mailto:calle.hedberg@gmail.com]
Sent: Tuesday, January 30, 2018 1:11 PM
To: Knut Staring knutst@gmail.com
Cc: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] [Dhis2-users] Organisation Units repetitive structure

Bernard,

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

Go to Data Administration → Maintenance → Select “Update Organisation Unit Paths”

In the Data Admin menu, select and run “Generate Resource Tables”

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;

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 knutst@gmail.com 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.ima@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:

Lebanon

Organisation A
i. Base 1

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A
i. Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  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) :

```
  Base 1
```

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

PHCC 1

PHCC 4

PHCC 2

PHCC 3

PHCC 5

PHCC 6

Lebanon

Organisation A
i. Base 1

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A
i. Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  Test PHCC 8
```

Organisation A

Base 2

PHCC 7

Test Base 1

Test PHCC 1

Test PHCC 4

Test PHCC 2

Test PHCC 5

Test PHCC 6

Test PHCC 7

Test Org A

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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Bernard Sadaka (IM Advisor) [mailto:lib.ima@pu-ami.org]
Sent: Monday, January 29, 2018 2:29 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net
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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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.

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

For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

–

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-devs
Post to : dhis2-devs@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.hedberg@gmail.com

Skype: calle_hedberg

–

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.hedberg@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

Bernard_Sadaka_IM_Ad · 31 January 2018 09:12

Thank you Mamadou!

Yes indeed that was the problem.

I will update the JIRA issue accordingly.

Thank you again… now I can use the pivot tables again.

All the best,

Bernard

cid:image002.png@01D36F50.572585A0

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

···

From: Mamadou Tafsir Diallo [mailto:diallotafsir52@gmail.com]
Sent: Tuesday, January 30, 2018 4:59 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: calle.hedberg@gmail.com; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-users] [Dhis2-devs] Organisation Units repetitive structure

Good evening,

I think the problem comes from the fact that by creating the user on the " Data output and analytic organisation units " section you have probably selected at the same time an organisation unit and its subcategories.

Excuse my english.

Regards,

2018-01-30 14:42 GMT+00:00 Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org:

Thank You Calle,

Yes indeed I issued a JIRA issue: https://jira.dhis2.org/browse/DHIS2-2761

It has rendered my pivot tables section unusable and this is very bad.

I hope that it could/would be solved soon.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Calle Hedberg [mailto:calle.hedberg@gmail.com]
Sent: Tuesday, January 30, 2018 3:24 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: Knut Staring knutst@gmail.com; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net

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

Bernard,

if your db hierarchy is correct, then I can confirm that the “replicated” orgunits you are seeing in some contexts are definitely a bug or bugs - I noted the same thing a few days ago, but I did not have the time then to report it as a JIRA issue.

since it is fresher in your mind, would you please create a JIRA bug report it?

Regards

Calle

On 30 January 2018 at 13:27, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Thank you Calle,

I have verified the mentioned query and followed the mentioned steps. The org units hierarchy in the db are correct.

I think this is more of a front end error related to extjs because the error is only showing in specific places of my DHIS2 instance and not all of them (e.g. the data entry and tracker capture show the correct org unit structure)

Please advise?

Thank you again for your invaluable help.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Calle Hedberg [mailto:calle.hedberg@gmail.com]
Sent: Tuesday, January 30, 2018 1:11 PM
To: Knut Staring knutst@gmail.com
Cc: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] [Dhis2-users] Organisation Units repetitive structure

Bernard,

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

Go to Data Administration → Maintenance → Select “Update Organisation Unit Paths”

In the Data Admin menu, select and run “Generate Resource Tables”

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;

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 knutst@gmail.com 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.ima@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:

Lebanon

Organisation A

                                                           i.      Base 1

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A

                                                           i.      Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  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) :

```
  Base 1
```

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

PHCC 1

PHCC 4

PHCC 2

PHCC 3

PHCC 5

PHCC 6

Lebanon

Organisation A

                                                           i.      Base 1

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A

                                                           i.      Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  Test PHCC 8
```

Organisation A

Base 2

PHCC 7

Test Base 1

Test PHCC 1

Test PHCC 4

Test PHCC 2

Test PHCC 5

Test PHCC 6

Test PHCC 7

Test Org A

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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Bernard Sadaka (IM Advisor) [mailto:lib.ima@pu-ami.org]
Sent: Monday, January 29, 2018 2:29 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net
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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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.

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

For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

–

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-devs
Post to : dhis2-devs@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.hedberg@gmail.com

Skype: calle_hedberg

–

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.hedberg@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

Bernard_Sadaka_IM_Ad · 31 January 2018 09:20

Dear Knut and Calle,

Following the bellow feedback I was able to replicate the error and updated the JIRA issue accordingly (https://jira.dhis2.org/browse/DHIS2-2761) in the hope for a possible bug fix.

Thank you for your support on the matter.

All the best,

Bernard

cid:image002.png@01D36F50.572585A0

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

···

From: Dhis2-users [mailto:dhis2-users-bounces+lib.ima=pu-ami.org@lists.launchpad.net] On Behalf Of Bernard Sadaka (IM Advisor)
Sent: Wednesday, January 31, 2018 11:13 AM
To: ‘Mamadou Tafsir Diallo’ diallotafsir52@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; calle.hedberg@gmail.com; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-users] [Dhis2-devs] Organisation Units repetitive structure

Thank you Mamadou!

Yes indeed that was the problem.

I will update the JIRA issue accordingly.

Thank you again… now I can use the pivot tables again.

All the best,

Bernard

cid:image002.png@01D36F50.572585A0

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Mamadou Tafsir Diallo [mailto:diallotafsir52@gmail.com]
Sent: Tuesday, January 30, 2018 4:59 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: calle.hedberg@gmail.com; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-users] [Dhis2-devs] Organisation Units repetitive structure

Good evening,

I think the problem comes from the fact that by creating the user on the " Data output and analytic organisation units " section you have probably selected at the same time an organisation unit and its subcategories.

Excuse my english.

Regards,

2018-01-30 14:42 GMT+00:00 Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org:

Thank You Calle,

Yes indeed I issued a JIRA issue: https://jira.dhis2.org/browse/DHIS2-2761

It has rendered my pivot tables section unusable and this is very bad.

I hope that it could/would be solved soon.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Calle Hedberg [mailto:calle.hedberg@gmail.com]
Sent: Tuesday, January 30, 2018 3:24 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: Knut Staring knutst@gmail.com; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net

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

Bernard,

if your db hierarchy is correct, then I can confirm that the “replicated” orgunits you are seeing in some contexts are definitely a bug or bugs - I noted the same thing a few days ago, but I did not have the time then to report it as a JIRA issue.

since it is fresher in your mind, would you please create a JIRA bug report it?

Regards

Calle

On 30 January 2018 at 13:27, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Thank you Calle,

I have verified the mentioned query and followed the mentioned steps. The org units hierarchy in the db are correct.

I think this is more of a front end error related to extjs because the error is only showing in specific places of my DHIS2 instance and not all of them (e.g. the data entry and tracker capture show the correct org unit structure)

Please advise?

Thank you again for your invaluable help.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Calle Hedberg [mailto:calle.hedberg@gmail.com]
Sent: Tuesday, January 30, 2018 1:11 PM
To: Knut Staring knutst@gmail.com
Cc: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] [Dhis2-users] Organisation Units repetitive structure

Bernard,

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

Go to Data Administration → Maintenance → Select “Update Organisation Unit Paths”

In the Data Admin menu, select and run “Generate Resource Tables”

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;

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 knutst@gmail.com 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.ima@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:

Lebanon

Organisation A

                                                           i.      Base 1

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A

                                                           i.      Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  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) :

```
  Base 1
```

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

PHCC 1

PHCC 4

PHCC 2

PHCC 3

PHCC 5

PHCC 6

Lebanon

Organisation A

                                                           i.      Base 1

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A

                                                           i.      Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  Test PHCC 8
```

Organisation A

Base 2

PHCC 7

Test Base 1

Test PHCC 1

Test PHCC 4

Test PHCC 2

Test PHCC 5

Test PHCC 6

Test PHCC 7

Test Org A

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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Bernard Sadaka (IM Advisor) [mailto:lib.ima@pu-ami.org]
Sent: Monday, January 29, 2018 2:29 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net
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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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.

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

For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

–

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-devs
Post to : dhis2-devs@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.hedberg@gmail.com

Skype: calle_hedberg

–

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.hedberg@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

Knut_Staring · 31 January 2018 09:38

Thanks Bernard and Mamadou,

I know it used to be a problem to select more than one OU in the left hand tree (not sure if it is still there). It was a very irritating and unintuitive thing that was there for a long time.

But was not aware of this similar issue on the right hand OU tree.

Knut

···

On Wed, Jan 31, 2018 at 10:20 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Dear Knut and Calle,

Following the bellow feedback I was able to replicate the error and updated the JIRA issue accordingly (https://jira.dhis2.org/browse/DHIS2-2761) in the hope for a possible bug fix.

Thank you for your support on the matter.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Dhis2-users [mailto:dhis2-users-bounces+lib.ima=pu-ami.org@lists.launchpad.net] On Behalf Of Bernard Sadaka (IM Advisor)
Sent: Wednesday, January 31, 2018 11:13 AM
To: ‘Mamadou Tafsir Diallo’ diallotafsir52@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; calle.hedberg@gmail.com; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net

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

Thank you Mamadou!

Yes indeed that was the problem.

I will update the JIRA issue accordingly.

Thank you again… now I can use the pivot tables again.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Mamadou Tafsir Diallo [mailto:diallotafsir52@gmail.com]
Sent: Tuesday, January 30, 2018 4:59 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: calle.hedberg@gmail.com; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-users] [Dhis2-devs] Organisation Units repetitive structure

Good evening,

I think the problem comes from the fact that by creating the user on the " Data output and analytic organisation units " section you have probably selected at the same time an organisation unit and its subcategories.

Excuse my english.

Regards,

2018-01-30 14:42 GMT+00:00 Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org:

Thank You Calle,

Yes indeed I issued a JIRA issue: https://jira.dhis2.org/browse/DHIS2-2761

It has rendered my pivot tables section unusable and this is very bad.

I hope that it could/would be solved soon.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Calle Hedberg [mailto:calle.hedberg@gmail.com]
Sent: Tuesday, January 30, 2018 3:24 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: Knut Staring knutst@gmail.com; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net

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

Bernard,

if your db hierarchy is correct, then I can confirm that the “replicated” orgunits you are seeing in some contexts are definitely a bug or bugs - I noted the same thing a few days ago, but I did not have the time then to report it as a JIRA issue.

since it is fresher in your mind, would you please create a JIRA bug report it?

Regards

Calle

On 30 January 2018 at 13:27, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Thank you Calle,

I have verified the mentioned query and followed the mentioned steps. The org units hierarchy in the db are correct.

I think this is more of a front end error related to extjs because the error is only showing in specific places of my DHIS2 instance and not all of them (e.g. the data entry and tracker capture show the correct org unit structure)

Please advise?

Thank you again for your invaluable help.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Calle Hedberg [mailto:calle.hedberg@gmail.com]
Sent: Tuesday, January 30, 2018 1:11 PM
To: Knut Staring knutst@gmail.com
Cc: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org; DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] [Dhis2-users] Organisation Units repetitive structure

Bernard,

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

Go to Data Administration → Maintenance → Select “Update Organisation Unit Paths”

In the Data Admin menu, select and run “Generate Resource Tables”

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;

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 knutst@gmail.com 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.ima@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:

Lebanon

Organisation A
i. Base 1

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A
i. Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  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) :

```
  Base 1
```

```
  PHCC 1
```

```
  PHCC 2
```

```
  PHCC 3
```

PHCC 1

PHCC 4

PHCC 2

PHCC 3

PHCC 5

PHCC 6

Lebanon

Organisation A
i. Base 1

                                                         ii.      Base 2

```
  PHCC 4
```

```
  PHCC 5
```

```
  PHCC 6
```

```
  PHCC 7
```

Test Org A
i. Test Base 1

```
  Test PHCC 1
```

```
  Test PHCC 2
```

```
  Test PHCC 3
```

                                                         ii.      Test Base 2

```
  Test PHCC 4
```

```
  Test PHCC 5
```

```
  Test PHCC 6
```

```
  Test PHCC 7
```

```
  Test PHCC 8
```

Organisation A

Base 2

PHCC 7

Test Base 1

Test PHCC 1

Test PHCC 4

Test PHCC 2

Test PHCC 5

Test PHCC 6

Test PHCC 7

Test Org A

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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Bernard Sadaka (IM Advisor) [mailto:lib.ima@pu-ami.org]
Sent: Monday, January 29, 2018 2:29 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net; ‘DHIS 2 developers’ dhis2-devs@lists.launchpad.net
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, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net
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.

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

For the server, look for catalina.out in the logs folder (What is your setup? Tomcat or DHIS Live?. Operating system?)

Regards,

Knut

On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive organization unit structure in the pivot tables section as well as user management and others:

· The same org units are showing under their respective org unit and alone multiple times.

· The org units in pivot tables keep trying to load each of their data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito browsing… nothing worked.

Is there a script or database queries I can run to fix this?

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3^rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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

Virus-free. www.avast.com

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

–

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-devs
Post to : dhis2-devs@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.hedberg@gmail.com

Skype: calle_hedberg

–

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.hedberg@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

–

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