[jira] [Created] (SYNCOPE-1398) Console stucks on update with unique key constraint violation

["Andrea Patricelli (JIRA)" <ji...@apache.org>]

Andrea Patricelli created SYNCOPE-1398:
------------------------------------------

             Summary: Console stucks on update with unique key constraint violation
                 Key: SYNCOPE-1398
                 URL: https://issues.apache.org/jira/browse/SYNCOPE-1398
             Project: Syncope
          Issue Type: Bug
          Components: console
    Affects Versions: 2.0.11
            Reporter: Andrea Patricelli
            Assignee: Andrea Patricelli
             Fix For: 2.0.12


# Define an unique schema on Syncope, e.g. uniqueValue
 # Create an user with the attribute uniqueValue populated, e.g. user1
 # Create another user with empty uniqueValue, e.g. user2
 # Update user2 assigning to *user2.uniqueValue* the same value of *user1.uniqueValue*
 # **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]}}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)