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, ?, ?, ?, ?)]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

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 Google Groups by Aaron Daubman, 2 years ago
Unexpected token: ( in statement [INSERT INTO My_Table (My_TableKy) VALUES (?) (?)]
via symmetricds by psi_teck
, 1 year ago
Statement too complex. Try rewriting the query to remove complexity. Eliminating many duplicate expressions or breaking up the query and storing interim results in a temporary table can often help resolve this error.
via GitHub by mikaelvik
, 2 years ago
Prepared or callable statement has more than 2000 parameter markers.
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.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)
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.danann.cernunnos.sql.StatementTask.perform(StatementTask.java:106)
at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 3 months ago
Samebug visitor profile picture
Unknown user
Once, 4 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.