Re: [Dhis2-devs] [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 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 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 >> 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-us...@lists.launchpad.net >>> 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 ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] [Dhis2-users] UNABLE TO DELETE AN OU
Thank you Knut But does this affected program indicators when run? Thank you On Mon, Mar 5, 2018 at 1:18 PM, Knut Staring 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 > 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-us...@lists.launchpad.net >> 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522 > Skype: knutstar > ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] [Dhis2-users] UNABLE TO DELETE AN OU
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 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-us...@lists.launchpad.net > 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522 Skype: knutstar ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
