You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@syncope.apache.org by "Andrea Patricelli (JIRA)" <ji...@apache.org> on 2018/11/19 15:20:00 UTC
[jira] [Updated] (SYNCOPE-1398) Console stucks on update with
unique key constraint violation
[ https://issues.apache.org/jira/browse/SYNCOPE-1398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrea Patricelli updated SYNCOPE-1398:
---------------------------------------
Description:
# 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]}}
was:
# 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]}}
> 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
> 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)