dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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 <ant@xxxxxxxx> 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 disclaimer@xxxxxxxx
> <disclaimer@xxxxxxxx> 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     : 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>