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 <[email protected]> wrote: > Hello > > Can you try, to do the something on the another browser ??? > > AHIAGNO Aanyo > HISP WA > 0022890962285 > > > ------------------------------ > Date: Sun, 16 Aug 2015 08:41:13 +0200 > From: [email protected] > To: [email protected] > CC: [email protected]; [email protected] > Subject: Re: [Dhis2-users] Data Integrity Checks > > 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 <[email protected]> > wrote: > > 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 <[email protected]> wrote: > > Dear All, > > DHIS2 vesrion 2.20 snapshot, build 19527 > > The data integrity checks showed some "orphaned" org units which should > not have been on the system. > > So I wrote scripts to clean out the org units and checked all 37 tables > that either reference organisationunitid or sourceid and cleaned out all > those tables. I also checked the "reporttable_organisationunits" table and > it was not necessary to renumber as the org units were never in that table > (I checked before doing any deletes and by the way thanks Jason Pickering > for the script you shared with Ferdie). > > After that I cleared analytics, re-generated resource tables, cleared > cache and cache statistics and re-ran integrity checks....those org unit > uids are still appearing as "orphaned organisation units". > > From which table(s) is the integrity check picking these org units up > from? > > Thanks > > *Ant Snyman* > > *Cell: 0824910449* > > *Landline: 028 2713242* > > > Health Information Systems Program - SA > > *This message and any attachments are subject to a disclaimer published at > http://www.hisp.org/policies.html#comms_disclaimer > <http://www.hisp.org/policies.html#comms_disclaimer>. Please read the > disclaimer before opening any attachment or taking any other action in > terms of this electronic transmission. If you cannot access the > disclaimer, kindly send an email to [email protected] > <[email protected]> and a copy will be provided to you. By replying to > this e-mail or opening any attachment you agree to be bound by the > provisions of the disclaimer.* > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > 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> > > > > > -- > > *Ant Snyman* > > *Cell: 0824910449* > > *Landline: 028 2713242* > > > Health Information Systems Program - SA > > *This message and any attachments are subject to a disclaimer published at > http://www.hisp.org/policies.html#comms_disclaimer > <http://www.hisp.org/policies.html#comms_disclaimer>. Please read the > disclaimer before opening any attachment or taking any other action in > terms of this electronic transmission. If you cannot access the > disclaimer, kindly send an email to [email protected] > <[email protected]> and a copy will be provided to you. By replying to > this e-mail or opening any attachment you agree to be bound by the > provisions of the disclaimer.* > > _______________________________________________ Mailing list: > https://launchpad.net/~dhis2-users Post to : > [email protected] Unsubscribe : > https://launchpad.net/~dhis2-users More help : > https://help.launchpad.net/ListHelp > -- *Ant Snyman* *Cell: 0824910449* *Landline: 028 2713242* Health Information Systems Program - SA -- *This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer <http://www.hisp.org/policies.html#comms_disclaimer>. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to [email protected] <[email protected]> and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.*
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
