dhis2-devs team mailing list archive

[Ant Snyman <ant@xxxxxxxx>]

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.*