[ https://issues.apache.org/jira/browse/SYNCOPE-1398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrea Patricelli updated SYNCOPE-1398: --------------------------------------- Component/s: core > 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, core > Affects Versions: 2.0.11 > Environment: Apache Syncope muts use Activiti or Flowable BPMN > workflows > Reporter: Andrea Patricelli > Assignee: Andrea Patricelli > Priority: Major > 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)