Unable to delete an ou

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

1 Like

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@gmail.com 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@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

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@gmail.com 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@gmail.com 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@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

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@gmail.com 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@gmail.com 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@gmail.com 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@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

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