dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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@xxxxxxxxxx> 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
>
>
>
> [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.ima@xxxxxxxxxx
>
> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (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@xxxxxxxxx>
> *Cc:* 'DHIS 2 Users list' <dhis2-users@xxxxxxxxxxxxxxxxxxx>;
> calle.hedberg@xxxxxxxxx; '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
>
>
>
> [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.ima@xxxxxxxxxx
>
> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>
> *Skype:* imapuami
>
> *Website:* https://www.pu-ami.org
>
>
>
>
>
> *From:* Mamadou Tafsir Diallo [mailto:diallotafsir52@xxxxxxxxx
> <diallotafsir52@xxxxxxxxx>]
> *Sent:* Tuesday, January 30, 2018 4:59 PM
> *To:* Bernard Sadaka (IM Advisor) <lib.ima@xxxxxxxxxx>
> *Cc:* calle.hedberg@xxxxxxxxx; DHIS 2 Users list <
> dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 developers <
> dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> *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@xxxxxxxxxx
> >:
>
> 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
>
>
>
> [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.ima@xxxxxxxxxx
>
> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>
> *Skype:* imapuami
>
> *Website:* https://www.pu-ami.org
>
>
>
>
>
> *From:* Calle Hedberg [mailto:calle.hedberg@xxxxxxxxx]
> *Sent:* Tuesday, January 30, 2018 3:24 PM
> *To:* Bernard Sadaka (IM Advisor) <lib.ima@xxxxxxxxxx>
> *Cc:* Knut Staring <knutst@xxxxxxxxx>; DHIS 2 Users list <
> dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 developers <
> dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>
>
> *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@xxxxxxxxxx> 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
>
>
>
> [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.ima@xxxxxxxxxx
>
> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>
> *Skype:* imapuami
>
> *Website:* https://www.pu-ami.org
>
>
>
>
>
> *From:* Calle Hedberg [mailto:calle.hedberg@xxxxxxxxx]
> *Sent:* Tuesday, January 30, 2018 1:11 PM
> *To:* Knut Staring <knutst@xxxxxxxxx>
> *Cc:* Bernard Sadaka (IM Advisor) <lib.ima@xxxxxxxxxx>; DHIS 2 Users list
> <dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 developers <
> dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> *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:
>
>
>
> 1. Go to Data Administration -> Maintenance -> Select "Update Organisation
> Unit Paths"
>
>
>
> 2. In the Data Admin menu, select and run "Generate Resource Tables"
>
>
>
> 3. Set up and run an SQL VIew (also in Data Admin) like this:
>
> SELECT ou.hierarchylevel, ou.name, ou1.name as Parent from
> organisationunit ou
>
> INNER JOIN organisationunit ou1 on ou.parentid = ou1.organisationunitid
>
> order by ou.hierarchylevel, ou.name;
>
>
>
> 4. Execute that sql view, dump it into CSV or Excel, and scan through to
> verify that all organisation units in the database have the correct parent
>
>
>
> you can obviously also run the same sql script against the database itself
>
>
>
> Best regards
>
> Calle
>
>
>
> On 30 January 2018 at 10:21, Knut Staring <knutst@xxxxxxxxx> 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@xxxxxxxxxx> 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.ima@xxxxxxxxxx
>
> *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.ima@xxxxxxxxxx]
> *Sent:* Monday, January 29, 2018 2:29 PM
> *To:* 'Knut Staring' <knutst@xxxxxxxxx>
> *Cc:* 'DHIS 2 Users list' <dhis2-users@xxxxxxxxxxxxxxxxxxx>; 'DHIS 2
> developers' <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> *Subject:* RE: [Dhis2-users] Organisation Units repetitive structure
>
>
>
> Thank you Knut,
>
> The console error while at the pivot table and viewing the org units is
> “Cannot read property ‘internalId’ of undefined ” as per the bellow
> screenshot:
>
>
>
> My setup is Tomcat+ postgres+ Ubuntu 16.04.3LTS+ Certbot (for SSL)+nginx
> (for reverse proxy)
>
>
>
> As for the catalina.out, what should I be looking exactly for in there?
> Because when I go to the pivot table section while monitoring catalina.out
> there’s no exception thrown/shown using “tail –f catalina.out” (even after
> cleaning the browser cache)
>
>
>
> Thank you in advance for your invaluable help.
>
>
>
> Looking forward to hearing from you.
>
>
>
> All the best,
>
> Bernard
>
>
>
> [image: cid:image002.png@01D36F50.572585A0]
>
> *Bernard Sadaka*
>
> *Information Management Advisor*
>
> Première Urgence - Aide Médicale Internationale
>
> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
>
> Ain el Remmaneh, Beirut, Lebanon
>
> *E-mail:* lib.ima@xxxxxxxxxx
>
> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>
> *Skype:* imapuami
>
> *Website:* https://www.pu-ami.org
>
>
>
>
>
> *From:* Knut Staring [mailto:knutst@xxxxxxxxx <knutst@xxxxxxxxx>]
> *Sent:* Monday, January 29, 2018 1:04 PM
> *To:* Bernard Sadaka (IM Advisor) <lib.ima@xxxxxxxxxx>
> *Cc:* DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2
> developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> *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.ima@xxxxxxxxxx> 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.ima@xxxxxxxxxx
>
> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>
> *Skype:* imapuami
>
> *Website:* https://www.pu-ami.org
>
>
>
>
>
>
>
>
>
> [image: Image removed by sender.]
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon>
>
> Virus-free. www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>
> --
>
> Knut Staring
>
> Department of Information, Evidence and Research
> World Health Organization, Geneva, Switzerland
> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
> Skype:     knutstar
>
>
>
>
>
> --
>
> Knut Staring
>
> Department of Information, Evidence and Research
> World Health Organization, Geneva, Switzerland
> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
> Skype:     knutstar
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
> <https://maps.google.com/?q=46D+Alma+Road,+7700+Rosebank,+SOUTH+AFRICA&entry=gmail&source=g>
>
> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>
> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>
> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>
>
>
>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
> <https://maps.google.com/?q=46D+Alma+Road,+7700+Rosebank,+SOUTH+AFRICA&entry=gmail&source=g>
>
> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>
> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>
> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> 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