← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] UNABLE TO DELETE AN OU

 

Hi Stanley,

I am just saying that programs are assigned to orgunits, just like datasets
are assigned to orgunits. So you have to remove such assignments before you
can delete the orgunit. The same is the case for ou groupmemberships.

Knut

On Mon, Mar 5, 2018 at 2:56 PM, Stanley Kalyati <skalyati@xxxxxxxxx> wrote:

> Thank you Knut
>
> But does this affected program indicators when run?
>
> Thank you
>
> On Mon, Mar 5, 2018 at 1:18 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> It is very difficult to delete organisation units, because they are
>> linked to so many other things beyond just data.
>>
>> Things to check include datasets, orgunit groups, datavalueaudits,
>> programs, completedatasetregistrations
>>
>> On Mon, Mar 5, 2018 at 11:43 AM, Stanley Kalyati <skalyati@xxxxxxxxx>
>> wrote:
>>
>>> I am failing to delete and an organisation unit.
>>>
>>> I am getting this error:  ERROR: update or delete on table
>>> "organisationunit" violates foreign key constraint
>>>
>>> I have tried to check if there is some data attached but i cant seem to
>>> find any.
>>>
>>> Is there a web api command that i can use either at the server end of UI
>>> within the system?
>>>
>>> Regards
>>>
>>> Stanley
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>>
>> --
>> Knut Staring
>>
>> Department of Information, Evidence and Research
>> World Health Organization, Geneva, Switzerland
>> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
>> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
>> Skype:     knutstar
>>
>
>


-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype:     knutstar

References