Try to remove login from Global user, get hibernate error

If you get a hibernate error when clearing a login in global then make sure there are no alarms adopted by the user.

1- Select user_id from personinfo.users where person_id=xxxxx
2- Select * from transient_alarms where owner_id=<user_id>
3- Delete from  transient_alarms where owner_id=<user_id>