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