Re: [Dhis2-devs] [Dhis2-users] Data Integrity Checks

2015-08-17 Thread Ant Snyman
Thank you for your response. I have sorted out the problem and it was neither cache nor browser related. Regards Ant Snyman On 16 August 2015 at 09:15, Aanyo Melo AHIAGNO wrote: > Hello > > Can you try, to do the something on the another browser ??? > > AHIAGNO Aanyo > HISP WA > 0022890962285 >

Re: [Dhis2-devs] [Dhis2-users] Data Integrity Checks

2015-08-17 Thread Aanyo Melo AHIAGNO
Hello Can you try, to do the something on the another browser ??? AHIAGNO Aanyo HISP WA0022890962285 Date: Sun, 16 Aug 2015 08:41:13 +0200 From: a...@hisp.org To: larshe...@gmail.com CC: dhis2-us...@lists.launchpad.net; dhis2-devs@lists.launchpad.net Subject: Re: [Dhis2-users] Data Integrity Che

Re: [Dhis2-devs] [Dhis2-users] Data Integrity Checks

2015-08-17 Thread Ant Snyman
Thanks Lars or your response. Yes I did clear cache statistics as well as browser cache. How does the application determine orphaned organisationunits? Organisationunits without a parentid? Or a parentid that does not exist? Regards Ant On 16 August 2015 at 07:20, Lars Helge Ă˜verland wrote: >

Re: [Dhis2-devs] [Dhis2-users] Data Integrity Checks

2015-08-17 Thread Ant Snyman
LarsI have finally solved the puzzle...I suspect that the person importing these org units misaligned the formatting because the uids were actually loaded in the org unit name column and what I thought were the uids were actually the "org unit names". I should have picked that up straight away

Re: [Dhis2-devs] [Dhis2-users] Data Integrity Checks

2015-08-16 Thread constyekani
Hello, Can you go to Apps>Admin> SQL view and run : SELECT * from organisationunit where parentid is null After you can go on PGadmin and run: Delete from organisationunit where uid= 'x' Sincerely Guy Ekani Moph Cameroon ,. Aanyo Melo AHI

Re: [Dhis2-devs] [Dhis2-users] Data Integrity Checks

2015-08-15 Thread Lars Helge Ă˜verland
Hi Ant, after doing SQL against a running DHIS 2 instance you might want to go to data admin > cache statistics > clear cache. This since the cache might become stale unknowingly as a result of direct SQL queries. regards, Lars On Sat, Aug 15, 2015 at 12:05 PM, Ant Snyman wrote: > Dear All,