← Back to team overview

dhis2-devs team mailing list archive

Re: User Module - Error deleting user

 

Hi Paulo

I have made a few changes to trunk and 2.23 which might help you. That
said, there are still a few cases where deletion will not be allowed.

You could also try to simple disable the user, so they are not allowed to
login.

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Mon, Jun 13, 2016 at 11:32 PM, Paulo Grácio <paulogracio@xxxxxxxxx>
wrote:

> Hi Lars,
>
> you can find the server.log in attach. The test case is also available here
>
> https://github.com/pgracio/dhis2-api-system-test/blob/master/modules/users.js
>
> BR,
> Paulo
>
> On Mon, Jun 13, 2016 at 10:01 AM Lars Helge Øverland <lars@xxxxxxxxx>
> wrote:
>
>> Hi Paulo,
>>
>> can you check the tomcat log on the server side?
>>
>> What likely is going on here is the user being associated with multiple
>> objects through sharing (e.g. data elements), or as owner (e.g. favorites).
>> The deletion handling of users is not fully in place, simply because almost
>> all of our tables potentially can be linked to the user table.
>>
>> regards,
>>
>> Lars
>>
>>
>>
>>
>> On Sat, Jun 11, 2016 at 6:54 PM, Paulo Grácio <paulogracio@xxxxxxxxx>
>> wrote:
>>
>>> Hi all,
>>>
>>> when trying to delete an user using API, DELETE -
>>> http://localhost:8085/api/users/zTsuPZnHqaO I'm getting a 500 -
>>> Internal Error with
>>>
>>> Request processing failed; nested exception is
>>> org.springframework.dao.DataIntegrityViolationException: could not execute
>>> statement; SQL [n/a]; constraint [fk6a68e08f19893da]; nested exception is
>>> org.hibernate.exception.ConstraintViolationException: could not execute
>>> statement
>>>
>>> is this expected? Should I make a different call before delete the User?
>>> It works fine when deleting in Web UI.
>>>
>>> Best regards,
>>> Paulo
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> lars@xxxxxxxxx
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References