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)
