java.sql.SQLException

Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID , SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)]

Solutions on the web12463

  • via Apereo Issues by fatlily, 1 year ago
    Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID , SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)]
  • via Apereo Issues by fatlily, 1 year ago
    Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID , SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)]
  • via Atlassian JIRA by Partha Kamal [Atlassian], 11 months ago
    Violation of unique constraint SYS_CT_80: duplicate value(s) for column(s) NAME in statement [insert into PERM_SCHEME (name, PS_ID) values (?, ?)]
  • Stack trace

    • java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID , SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)] at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:619) at org.danann.cernunnos.sql.StatementTask.perform(StatementTask.java:106) at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) Caused by: java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) at org.danann.cernunnos.sql.StatementTask$PhraseParameterPreparedStatementCallback.doInPreparedStatement(StatementTask.java:125) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591) ... 7 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 6 months ago
    Unknown user
    Once, 7 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    2 more bugmates