dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Maybe this as well

SELECT organisationunitid,name FROM organisationunit where name ~('\r|\n');


Also, looks like i missed a back slash in the first query.

SELECT * from
(SELECT organisationunitid,encode(coordinates::bytea, 'escape') as unicode
FROM organisationunit) as a
where a.unicode ~('\\');


On Fri, Mar 11, 2016 at 8:50 AM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> Try and run this statement
>
> SELECT * from
> (SELECT organisationunitid,encode(coordinates::bytea, 'escape') as unicode
> FROM organisationunit) as a
> where a.unicode ~('\');
>
> and see if you get any results?
>
>
>
> On Fri, Mar 11, 2016 at 8:43 AM, Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
> wrote:
>
>> Dears,
>>
>>
>>
>> It seems that my problem still exists regarding loading tracker capture
>> and I can’t find a way to fix this issue
>>
>>
>>
>> I have a lot of org unit, and I can’t find the error (newline) in org
>> unit name
>>
>>
>>
>> Can some body help please?
>>
>>
>>
>> Thanks in advance
>>
>>
>>
>> *From:* Pamod Amarakoon [mailto:pamodm@xxxxxxxxx]
>> *Sent:* Thursday, March 10, 2016 7:16 PM
>> *To:* Abyot Asalefew Gizaw <abyot@xxxxxxxxx>
>> *Cc:* Nami Ghadri <nami_ghadri@xxxxxxxxxxx>; DHIS 2 Users list <
>> dhis2-users@xxxxxxxxxxxxxxxxxxx>; Lars Helge Øverland <lars@xxxxxxxxx>
>> *Subject:* Re: [Dhis2-users] tracker capture keeps loading
>>
>>
>>
>> Thanx Abyot. Will fix them.
>>
>> But just fixing the org unit offline levels solved the original issue of
>> tracker capture not loading.
>>
>>
>>
>> On Thu, Mar 10, 2016 at 5:42 PM, Abyot Asalefew Gizaw <abyot@xxxxxxxxx>
>> wrote:
>>
>> Perfect :)
>>
>>
>>
>> @ Pamod
>>
>>
>>
>> See the screenshot below - you have lots of similar errors. Because of
>> these errors orgunit tree was not loaded. Because tree was not loaded,
>> tracker app was not able to start. You need to fix these errors.
>>
>>
>>
>> [image: Inline image 1]
>>
>>
>> ---
>>
>> Thank you,
>>
>> Abyot.
>>
>>
>>
>> On Thu, Mar 10, 2016 at 1:10 PM, Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
>> wrote:
>>
>> Dears,
>>
>>
>>
>> I checked my organisationunit table I found one of my org unites that has
>> featuretype ‘NONE’ with no coordinates I fixed that and the tracker capture
>> loaded
>>
>>
>>
>> Thanks for helping
>>
>>
>>
>> *From:* Dhis2-users [mailto:dhis2-users-bounces+nami_ghadri=
>> hotmail.com@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Nami Ghadri
>> *Sent:* Thursday, March 10, 2016 1:43 PM
>> *To:* 'Abyot Asalefew Gizaw' <abyot@xxxxxxxxx>; 'Pamod Amarakoon' <
>> pamodm@xxxxxxxxx>
>> *Cc:* 'DHIS 2 Users list' <dhis2-users@xxxxxxxxxxxxxxxxxxx>; 'Lars Helge
>> Øverland' <lars@xxxxxxxxx>
>>
>>
>> *Subject:* Re: [Dhis2-users] tracker capture keeps loading
>>
>>
>>
>> Can you suggest how to fix that?
>>
>>
>>
>> Because I have a lot of org units
>>
>>
>>
>> Regards,
>>
>>
>>
>>
>>
>>
>>
>> *From:* Abyot Asalefew Gizaw [mailto:abyot@xxxxxxxxx <abyot@xxxxxxxxx>]
>> *Sent:* Thursday, March 10, 2016 1:26 PM
>> *To:* Pamod Amarakoon <pamodm@xxxxxxxxx>
>> *Cc:* Nami Ghadri <nami_ghadri@xxxxxxxxxxx>; DHIS 2 Users list <
>> dhis2-users@xxxxxxxxxxxxxxxxxxx>; Lars Helge Øverland <lars@xxxxxxxxx>
>> *Subject:* Re: [Dhis2-users] tracker capture keeps loading
>>
>>
>>
>> Hi Pamod, Nami,
>>
>>
>>
>> @Pamod, two issues:
>>
>>
>>
>> 1. Seems you have a problem with your organisation unit --- there are
>> orgunit names with newline character at the end. And that is breaking the
>> json format when loading orgunit names.
>>
>>
>>
>> 2. You have no cache level defined (see here
>> http://148.251.224.242:9081/leprosy/dhis-web-maintenance-organisationunit/organisationUnitLevel.action)
>> - I just set to 2 and that helped in loading orgunits. Tracker app is now
>> working. This is probably because with the cache level set, we avoided
>> loading those problematic orgunits.
>>
>>
>>
>> @Nami,
>>
>>
>>
>> I can't really tell the problem with your system. Some questions
>>
>>    - How is your orgunit tree - is it big?
>>    - Can you also set cache levels?
>>    - What do you see under developer tools -> Resources -> IndexedDB - >
>>    dhis2ou -> ou & developer tools -> Resources -> IndexedDB - > dhis2ou ->
>>    ouPartial?
>>
>>
>>
>>
>> ---
>>
>> Thank you,
>>
>> Abyot.
>>
>>
>>
>> On Thu, Mar 10, 2016 at 11:53 AM, Pamod Amarakoon <pamodm@xxxxxxxxx>
>> wrote:
>>
>>
>> ​
>>
>>
>>
>> On Thu, Mar 10, 2016 at 4:17 PM, Abyot Asalefew Gizaw <abyot@xxxxxxxxx>
>> wrote:
>>
>> what do you have under:
>>
>>    1. developer tools -> Resources -> IndexedDB - > dhis2ou ?
>>    2. developer tools -> Resources -> IndexedDB - > dhis2tc ?
>>
>>
>> ---
>>
>> Thank you,
>>
>> Abyot.
>>
>>
>>
>> On Thu, Mar 10, 2016 at 11:42 AM, Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
>> wrote:
>>
>> In the other hand on previous versions the same database load normally
>>
>>
>>
>> Thanks
>>
>>
>>
>> *From:* Pamod Amarakoon [mailto:pamodm@xxxxxxxxx]
>> *Sent:* Thursday, March 10, 2016 12:34 PM
>> *To:* Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
>> *Cc:* Abyot Asalefew Gizaw <abyot@xxxxxxxxx>; DHIS 2 Users list <
>> dhis2-users@xxxxxxxxxxxxxxxxxxx>; Lars Helge Øverland <lars@xxxxxxxxx>
>>
>>
>> *Subject:* Re: [Dhis2-users] tracker capture keeps loading
>>
>>
>>
>> I too can confirm. No errors on console or catalina.out after clearing
>> cache. But tracker capture displaying loading meta-data continuously.
>>
>>
>>
>> On Thu, Mar 10, 2016 at 4:00 PM, Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
>> wrote:
>>
>> I did the steps bellow and still same status
>>
>>
>>
>> Please see this print screen
>>
>>
>>
>> Thanks
>>
>>
>>
>>
>>
>> Thanks
>>
>>
>>
>>
>>
>> *From:* Abyot Asalefew Gizaw [mailto:abyot@xxxxxxxxx]
>> *Sent:* Thursday, March 10, 2016 12:11 PM
>> *To:* Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
>> *Cc:* Lars Helge Øverland <lars@xxxxxxxxx>; DHIS 2 Users list <
>> dhis2-users@xxxxxxxxxxxxxxxxxxx>
>>
>>
>> *Subject:* Re: [Dhis2-users] tracker capture keeps loading
>>
>>
>>
>> once you have done full cache cleaning, do the following
>>
>>
>>
>> - open your browser "developer tools"
>>
>> - click on the "Network" tab
>>
>> - run tracker capture app
>>
>>
>>
>> You should see something happening there. Would be nice if you could
>> share us that.
>>
>> ---
>>
>> Thank you,
>>
>> Abyot.
>>
>>
>>
>> On Thu, Mar 10, 2016 at 11:05 AM, Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
>> wrote:
>>
>> I just did that and still the same status
>>
>>
>>
>> Thanks
>>
>>
>>
>>
>>
>> *From:* Lars Helge Øverland [mailto:lars@xxxxxxxxx]
>> *Sent:* Thursday, March 10, 2016 11:58 AM
>> *To:* Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
>> *Cc:* Abyot Asalefew Gizaw <abyot@xxxxxxxxx>; DHIS 2 Users list <
>> dhis2-users@xxxxxxxxxxxxxxxxxxx>
>>
>>
>> *Subject:* Re: [Dhis2-users] tracker capture keeps loading
>>
>>
>>
>> Hi Nami,
>>
>>
>>
>> try this for cache clearing:
>> https://www.dhis2.org/tutorials/how-to-really-clear-browser-cache
>>
>>
>>
>> Lars
>>
>>
>>
>> On Thu, Mar 10, 2016 at 10:57 AM, Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
>> wrote:
>>
>> Thanks for fast replay
>>
>>
>>
>> I forgot to mention that I did that from cash cleaner and from chrome
>> setting also but still the same
>>
>>
>>
>> Thanks
>>
>>
>>
>> *From:* Abyot Asalefew Gizaw [mailto:abyot@xxxxxxxxx]
>> *Sent:* Thursday, March 10, 2016 11:55 AM
>> *To:* Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
>> *Cc:* DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
>> *Subject:* Re: [Dhis2-users] tracker capture keeps loading
>>
>>
>>
>> Hi Nami,
>>
>>
>>
>> Can you do full browser cache cleaning and re-try again?
>>
>>
>> ---
>>
>> Thank you,
>>
>> Abyot.
>>
>>
>>
>> On Thu, Mar 10, 2016 at 10:39 AM, Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
>> wrote:
>>
>> Hello Dears,
>>
>>
>>
>> I have a problem in tracker capture
>>
>>
>>
>> I am using version 2.22 Build revision: 21900
>>
>>
>>
>> The tracker capture keeps loading meta-data but never finish
>>
>>
>>
>> In console  there is no error and I pressed ctr R also status is the same
>>
>>
>>
>> Please see print screen
>>
>>
>>
>> Any advice
>>
>>
>>
>> Thanks
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> 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
>>
>>
>>
>>
>> _______________________________________________
>> 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
>>
>>
>>
>>
>>
>> --
>>
>> Lars Helge Øverland
>>
>> Lead developer, DHIS 2
>>
>> University of Oslo
>>
>> Skype: larshelgeoverland
>>
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>>
>> --
>>
>> Regards,
>> Pamod Amarakoon
>>
>> Confidentiality Notice: the information contained in this email and any
>> attachments may be legally privileged and confidential. If you are not an
>> intended recipient, you are hereby notified that any dissemination,
>> distribution, or copying of this e-mail is strictly prohibited. If you have
>> received this e-mail in error, please notify the sender and permanently
>> delete the e-mail and any attachments immediately. You should not retain,
>> copy or use this e-mail or any attachments for any purpose, nor disclose
>> all or any part of the contents to any other person.
>>
>>
>>
>>
>>
>>
>> --
>>
>> Regards,
>> Pamod Amarakoon
>>
>> Confidentiality Notice: the information contained in this email and any
>> attachments may be legally privileged and confidential. If you are not an
>> intended recipient, you are hereby notified that any dissemination,
>> distribution, or copying of this e-mail is strictly prohibited. If you have
>> received this e-mail in error, please notify the sender and permanently
>> delete the e-mail and any attachments immediately. You should not retain,
>> copy or use this e-mail or any attachments for any purpose, nor disclose
>> all or any part of the contents to any other person.
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>>
>> Regards,
>> Pamod Amarakoon
>>
>> Confidentiality Notice: the information contained in this email and any
>> attachments may be legally privileged and confidential. If you are not an
>> intended recipient, you are hereby notified that any dissemination,
>> distribution, or copying of this e-mail is strictly prohibited. If you have
>> received this e-mail in error, please notify the sender and permanently
>> delete the e-mail and any attachments immediately. You should not retain,
>> copy or use this e-mail or any attachments for any purpose, nor disclose
>> all or any part of the contents to any other person.
>>
>>
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>



-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049