org.postgresql.util.PSQLException: ERREUR: la valeur d'une cl? dupliqu?e rompt la contrainte unique ? wrequirement_pkey ? Detail: La cl? ? (wrequirement_id)=(43642) ? existe d?j?. Error Code: 0 Call: INSERT INTO WREQUIREMENT (wrequirement_id, COMPLETENESS, wlevel, wlimit, QUALITY, QUANTITY, wwork) VALUES (?, ?, ?, ?, ?, ?, ?) bind => [7 parameters bound] Query: InsertObjectQuery(WRequirement( 43642 ))

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

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via GitHub by fxaeberhard
, 1 year ago
ERREUR: la valeur d'une cl? dupliqu?e rompt la contrainte unique ? wrequirement_pkey ? Detail: La cl? ? (wrequirement_id)=(43642) ? existe d?j?. Error Code: 0 Call: INSERT INTO WREQUIREMENT (wrequirement_id, COMPLETENESS, wlevel, wlimit, QUALITY, QUANTITY, wwork) VALUES (?, ?, ?, ?, ?, ?, ?) bind => [7 parameters bound] Query: InsertObjectQuery(WRequirement( 43642 ))
via GitHub by fxaeberhard
, 1 year ago
ERREUR: la valeur d'une cl? dupliqu?e rompt la contrainte unique ? wrequirement_pkey ? Detail: La cl? ? (wrequirement_id)=(43642) ? existe d?j?. Error Code: 0 Call: INSERT INTO WREQUIREMENT (wrequirement_id, COMPLETENESS, wlevel, wlimit, QUALITY, QUANTITY, wwork) VALUES (?, ?, ?, ?, ?, ?, ?) bind => [7 parameters bound] Query: InsertObjectQuery(WRequirement( 43642 ))
via GitHub by ferrys
, 2 months ago
ERROR: duplicate key value violates unique constraint "one_draft_version_per_dataset" Detail: Key (dataset_id)=(225) already exists. Error Code: 0 Call: INSERT INTO DATASETVERSION (UNF, ARCHIVENOTE, ARCHIVETIME, CREATETIME, DEACCESSIONLINK
via GitHub by scolapasta
, 2 years ago
ERROR: duplicate key value violates unique constraint "unq_authenticateduserlookup_0" Detail: Key (persistentuserid, authenticationproviderid)=(builtin, builtin) already exists. Error Code: 0 Call: INSERT INTO AUTHENTICATEDUSERLOOKUP
via Stack Overflow by Unknown author, 2 years ago
ERROR: null value in column "id" violates not-null constraint Detail: Failing row contains (null, some info). Error Code: 0 Call: INSERT INTO employee_info (info) VALUES (?) bind => [1 parameter bound] Query: InsertObjectQuery(jpatest3.EmployeeInfo[ id=null ])
via GitHub by bencomp
, 1 year ago
ERROR: value too long for type character varying(255) Error Code: 0 Call: INSERT INTO DATAVARIABLE (FILEENDPOSITION, FILEORDER, FILESTARTPOSITION, FORMAT, FORMATCATEGORY, INTERVAL, LABEL, NAME, NUMBEROFDECIMALPOINTS, ORDEREDFACTOR
org.postgresql.util.PSQLException: ERREUR: la valeur d'une cl? dupliqu?e rompt la contrainte unique ? wrequirement_pkey ? Detail: La cl? ? (wrequirement_id)=(43642) ? existe d?j?. Error Code: 0 Call: INSERT INTO WREQUIREMENT (wrequirement_id, COMPLETENESS, wlevel, wlimit, QUALITY, QUANTITY, wwork) VALUES (?, ?, ?, ?, ?, ?, ?) bind => [7 parameters bound] Query: InsertObjectQuery(WRequirement( 43642 ))
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:831)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1494)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:838)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:906)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:592)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:342)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:472)
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287)
at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1449)
at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:224)
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:191)
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:136)
at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3799)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1415)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:636)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1561)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:447)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
22 times, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
102 more bugmates

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