Re: [Dhis2-users] Organisation Units repetitive structure

2018-01-30 Thread Bernard Sadaka (IM Advisor) 
Thank you Knut,

Will look into that.

All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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





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

Hello Again Knut,

Any news about this issue?

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



Here is what happening with my org units:

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



Is this front end related? Backend? Database related?



Here is my org unit structure:

1.  Lebanon

a.  Organisation A

   i.  Base 1

1.   PHCC 1

2.   PHCC 2

3.   PHCC 3

 ii.  Base 2

1.   PHCC 4

2.   PHCC 5

3.   PHCC 6

4.   PHCC 7

b.  Test Org A

   i.  Test 
Base 1

1.   Test PHCC 1

2.   Test PHCC 2

3.   Test PHCC 3

 ii.  Test Base 
2

1.   Test PHCC 4

2.   Test PHCC 5

3.   Test PHCC 6

4.   Test PHCC 7

5.   Test PHCC 8



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

1.   Base 1

1.   PHCC 1

2.   PHCC 2

3.   PHCC 3

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

a.  Organisation A

   i.  Base 1

 ii.  Base 2

1.   PHCC 4

2.   PHCC 5

3.   PHCC 6

4.   PHCC 7

b.  Test Org A

   i.  Test 
Base 1

1.   Test PHCC 1

2.   Test PHCC 2

3.   Test PHCC 3

 ii.  Test Base 
2

1.   Test PHCC 4

2.   Test PHCC 5

3.   Test PHCC 6

4.   Test PHCC 7

5.   Test PHCC 8

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



Your help is appreciated.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 <tel:+961%2071%20004%20881>  (208)

Skype: imapuami

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





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



Thank you Knut,

The console error while at

Re: [Dhis2-users] Organisation Units repetitive structure

2018-01-30 Thread Knut Staring 
Hi Bernard,

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

Knut

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

> Hello Again Knut,
>
> Any news about this issue?
>
> Should I open a ticket for it in Jira? The challenge is I don’t know how
> to replicate this bug.
>
>
>
> Here is what happening with my org units:
>
> *As you can see bellow, all the org units are there duplicated but in a
> scrambled order and not under their respective parent. Add to that when I
> click on one of the values that are supposed to show the underlying org
> units only of the copies will expand and show that.*
>
>
>
> *Is this front end related? Backend? Database related?*
>
>
>
> Here is my org unit structure:
>
>1. Lebanon
>   1. Organisation A
>
>i.  Base
> 1
>
> 1.   PHCC 1
>
> 2.   PHCC 2
>
> 3.   PHCC 3
>
>  ii.  Base
> 2
>
> 1.   PHCC 4
>
> 2.   PHCC 5
>
> 3.   PHCC 6
>
> 4.   PHCC 7
>
>1. Test Org A
>
>i.  Test
> Base 1
>
> 1.   Test PHCC 1
>
> 2.   Test PHCC 2
>
> 3.   Test PHCC 3
>
>  ii.  Test
> Base 2
>
> 1.   Test PHCC 4
>
> 2.   Test PHCC 5
>
> 3.   Test PHCC 6
>
> 4.   Test PHCC 7
>
> 5.   Test PHCC 8
>
>
>
> In some places on my DHIS2 it shows correctly, in other places it shows as
> per the bellow (in DHIS2 sections such as the “pivot tables” and the “data
> output and analytics organization units” under new/edit user section) (the
> pivot tables keep trying to load as mentioned before) :
>
> 1.   Base 1
>
> 1.   PHCC 1
>
> 2.   PHCC 2
>
> 3.   PHCC 3
>
>1. PHCC 1
>2. PHCC 4
>3. PHCC 2
>4. PHCC 3
>5. PHCC 5
>6. PHCC 6
>7. Lebanon
>   1. Organisation A
>
>i.  Base
> 1
>
>  ii.  Base
> 2
>
> 1.   PHCC 4
>
> 2.   PHCC 5
>
> 3.   PHCC 6
>
> 4.   PHCC 7
>
>1. Test Org A
>
>i.  Test
> Base 1
>
> 1.   Test PHCC 1
>
> 2.   Test PHCC 2
>
> 3.   Test PHCC 3
>
>  ii.  Test
> Base 2
>
> 1.   Test PHCC 4
>
> 2.   Test PHCC 5
>
> 3.   Test PHCC 6
>
> 4.   Test PHCC 7
>
> 5.   Test PHCC 8
>
>1. Organisation A
>2. Base 2
>3. PHCC 7
>4. Test Base 1
>5. Test PHCC 1
>6. Test PHCC 4
>7. Test PHCC 2
>8. Test PHCC 5
>9. Test PHCC 6
>10. Test PHCC 7
>11. Test Org A
>12. Test Base 2
>
>
>
> Your help is appreciated.
>
>
>
> All the best,
>
> Bernard
>
>
>
> [image: cid:image002.png@01D36F50.572585A0]
>
> *Bernard Sadaka*
>
> *Information Management Advisor*
>
> Première Urgence - Aide Médicale Internationale
>
> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
>
> Ain el Remmaneh, Beirut, Lebanon
>
> *E-mail:* lib@pu-ami.org
>
> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>
> *Skype:* imapuami
>
> *Website:* https://www.pu-ami.org
>
>
>
>
>
> *From:* Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org]
> *Sent:* Monday, January 29, 2018 2:29 PM
> *To:* 'Knut Staring' <knu...@gmail.com>
> *Cc:* 'DHIS 2 Users list' <dhis2-users@lists.launchpad.net>; 'DHIS 2
> developers' <dhis2-d...@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:
>
>
>
>

Re: [Dhis2-users] Organisation Units repetitive structure

2018-01-30 Thread Bernard Sadaka (IM Advisor) 
Hello Again Knut,

Any news about this issue?

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



Here is what happening with my org units:

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



Is this front end related? Backend? Database related?



Here is my org unit structure:

1.  Lebanon

a.  Organisation A

   i.  Base 1

1.   PHCC 1

2.   PHCC 2

3.   PHCC 3

 ii.  Base 2

1.   PHCC 4

2.   PHCC 5

3.   PHCC 6

4.   PHCC 7

b.  Test Org A

   i.  Test 
Base 1

1.   Test PHCC 1

2.   Test PHCC 2

3.   Test PHCC 3

 ii.  Test Base 
2

1.   Test PHCC 4

2.   Test PHCC 5

3.   Test PHCC 6

4.   Test PHCC 7

5.   Test PHCC 8



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

1.   Base 1

1.   PHCC 1

2.   PHCC 2

3.   PHCC 3

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

a.  Organisation A

   i.  Base 1

 ii.  Base 2

1.   PHCC 4

2.   PHCC 5

3.   PHCC 6

4.   PHCC 7

b.  Test Org A

   i.  Test 
Base 1

1.   Test PHCC 1

2.   Test PHCC 2

3.   Test PHCC 3

 ii.  Test Base 
2

1.   Test PHCC 4

2.   Test PHCC 5

3.   Test PHCC 6

4.   Test PHCC 7

5.   Test PHCC 8

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



Your help is appreciated.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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





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

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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





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



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

Re: [Dhis2-users] Organisation Units repetitive structure

2018-01-29 Thread Bernard Sadaka (IM Advisor) 
Thank you Knut,

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





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



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



Thank you in advance for your invaluable help.



Looking forward to hearing from you.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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





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



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



2) For the server, look for catalina.out in the logs folder (What 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@pu-ami.org <mailto:lib@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, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 <tel:+961%2071%20004%20881>  (208)

Skype: imapuami

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












 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=icon>

Virus-free.  
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=link>
 www.avast.com


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net 
<mailto: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



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Organisation Units repetitive structure

2018-01-29 Thread Knut Staring 
Hi Bernard,

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

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

2) For the server, look for catalina.out in the logs folder (What 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@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
>
>
>
> [image: cid:image002.png@01D36F50.572585A0]
>
> *Bernard Sadaka*
>
> *Information Management Advisor*
>
> Première Urgence - Aide Médicale Internationale
>
> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
>
> Ain el Remmaneh, Beirut, Lebanon
>
> *E-mail:* lib@pu-ami.org
>
> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>
> *Skype:* imapuami
>
> *Website:* https://www.pu-ami.org
>
>
>
>
>
>
>
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_4487136394328816772_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring

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

[Dhis2-users] Organisation Units repetitive structure

2018-01-29 Thread Bernard Sadaka (IM Advisor) 
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, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

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











---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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