syncope-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrea Patricelli (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SYNCOPE-1398) Console stucks on update with unique key constraint violation
Date Mon, 19 Nov 2018 15:34:00 GMT

     [ https://issues.apache.org/jira/browse/SYNCOPE-1398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Andrea Patricelli updated SYNCOPE-1398:
---------------------------------------
    Environment: Apache Syncope muts use Activiti or Flowable BPMN workflows

> 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
>         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)

Mime
View raw message