Itamar Heim has submitted this change and it was merged. Change subject: core: SQL exception is thrown when assigning a permissions ...................................................................... core: SQL exception is thrown when assigning a permissions The SQL exception occurs as the user (or group) is added to the database, even though it was already added. This happens as webadmin passes the group and user objects with a NULL id (the external ID is the one that represents the "real id" - that is the id in the external directory system). The solution is to check if such a user (or a group) already exists in DB, and if not - add it. Change-Id: Ie518061d081c09a25fe5582899a6105df629ab06 Bug-Url: https://bugzilla.redhat.com/1057147 Signed-off-by: Yair Zaslavsky <yzaslavs(a)redhat.com&gt; --- M backend/manager/modules/bll/src/main/java/org/ovirt/engine/core/bll/AddPermissionCommand.java 1 file changed, 19 insertions(+), 9 deletions(-) Approvals: Eli Mesika: Looks good to me, approved Yair Zaslavsky: Verified -- To view, visit http://gerrit.ovirt.org/23835 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: Ie518061d081c09a25fe5582899a6105df629ab06 Gerrit-PatchSet: 2 Gerrit-Project: ovirt-engine Gerrit-Branch: ovirt-engine-3.4 Gerrit-Owner: Yair Zaslavsky <yzaslavs(a)redhat.com&gt; Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com&gt; Gerrit-Reviewer: Itamar Heim <iheim(a)redhat.com&gt; Gerrit-Reviewer: Yair Zaslavsky <yzaslavs(a)redhat.com&gt; Gerrit-Reviewer: automation(a)ovirt.org Gerrit-Reviewer: oVirt Jenkins CI Server