[SYNCOPE-1398] Console stucks on update with unique key constraint violation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.11
• Fix Version/s: 2.0.12
• Component/s: console, core
• Environment: Apache Syncope muts use Activiti or Flowable BPMN workflows
• Assignee: Andrea Patricelli
• Reporter: Andrea Patricelli
• Created: 19/Nov/18 15:17
• Updated: 17/Jan/19 15:46
• Resolved: 20/Nov/18 08:24

Description

1. Define an unique schema on Syncope, e.g. uniqueValue
2. Create an user with the attribute uniqueValue populated, e.g. user1
3. Create another user with empty uniqueValue, e.g. user2
4. Update user2 assigning to user2.uniqueValue the same value of user1.uniqueValue
5. Click on finish and you'll see the console stuck and the core logging:

Caused by: java.util.concurrent.ExecutionException: org.apache.syncope.common.lib.SyncopeClientException: Workflow [ReportingSQLException: Unique index or primary key violation: "U_PLNTQVL_STRINGVALUE_INDEX_F ON PUBLIC.UPLAINATTRUNIQUEVALUE(STRINGVALUE, SCHEMA_ID) VALUES ('Vincenzo Bellini', 'fullname', 7)"; SQL statement:INSERT INTO UPlainAttrUniqueValue (id, binaryValue, booleanValue, dateValue, doubleValue, longValue, stringValue, ATTRIBUTE_ID, schema_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-197] {prepstmnt 1003500429 INSERT INTO UPlainAttrUniqueValue (id, binaryValue, booleanValue, dateValue, doubleValue, longValue, stringValue, ATTRIBUTE_ID, schema_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=23505, state=23505]