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-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
