Uploaded image for project: 'Syncope'
  1. Syncope
  2. SYNCOPE-1398

Console stucks on update with unique key constraint violation

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.11
    • Fix Version/s: 2.0.12
    • Component/s: console, core
    • Labels:
      None
    • Environment:
      Apache Syncope muts use Activiti or Flowable BPMN workflows

      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]

        Attachments

          Activity

            People

            • Assignee:
              andrea.patricelli Andrea Patricelli
              Reporter:
              andrea.patricelli Andrea Patricelli
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: