After changing a user's organization I get the following 500 error when trying to change the user's permissions in his new organization.
HTTP Status 500 – Internal Server Error
Type Exception Report
Message Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [uk_5ad8yawbym2uolno93wvhymua]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
While logged into the staging instance under michel.craymer@canada.ca with administrator permissions and all roles enabled, there is a test user called Bob Plumb originally register under the Control Body organization with the Submitter role. I can change his organization by going to the "Users" folder and editing Bob Plumb and changing his organization from Control Body to U.S. National Geodetic Survey. I then go the "Organizations" folder and edit U.S. National Geodetic Survey where Bob Plumb now appears as a user. I select Permissions for Bob Plumb where his membership approval is now off and he has no roles. I am able to approve his membership without assigning any roles and select the Ok button. I can then select the Save button to successfully approve his membership. However, when I select Permissions again for Bob Plumb and change his role to Submitter, I get the above 500 error when I click the Save button. If I then change Bob Plumb's organization back to the Control Body that he was originally registered with, he reappears in that organization with the same permissions & roles he had before I tried to change his organization to U.S. National Geodetic Survey.
After changing a user's organization I get the following 500 error when trying to change the user's permissions in his new organization.
HTTP Status 500 – Internal Server Error Type Exception Report Message Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [uk_5ad8yawbym2uolno93wvhymua]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
While logged into the staging instance under michel.craymer@canada.ca with administrator permissions and all roles enabled, there is a test user called Bob Plumb originally register under the Control Body organization with the Submitter role. I can change his organization by going to the "Users" folder and editing Bob Plumb and changing his organization from Control Body to U.S. National Geodetic Survey. I then go the "Organizations" folder and edit U.S. National Geodetic Survey where Bob Plumb now appears as a user. I select Permissions for Bob Plumb where his membership approval is now off and he has no roles. I am able to approve his membership without assigning any roles and select the Ok button. I can then select the Save button to successfully approve his membership. However, when I select Permissions again for Bob Plumb and change his role to Submitter, I get the above 500 error when I click the Save button. If I then change Bob Plumb's organization back to the Control Body that he was originally registered with, he reappears in that organization with the same permissions & roles he had before I tried to change his organization to U.S. National Geodetic Survey.