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 ))

GitHub | fxaeberhard | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    PMG - Unable to duplicate Task

    GitHub | 4 years ago | fxaeberhard
    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 ))
  2. 0

    GitHub comment 225#23790468

    GitHub | 4 years ago | fxaeberhard
    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 ))
  3. 0

    Indexing: index all causes org.postgresql.util.PSQLException: ERROR: deadlock detected

    GitHub | 2 years ago | pdurbin
    org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 26300 waits for ShareLock on transaction 79290; blocked by process 26299. Process 26299 waits for ShareLock on transaction 79289; blocked by process 26300. Hint: See server log for query details. Error Code: 0 Call: UPDATE DVOBJECT SET PERMISSIONINDEXTIME = ? WHERE (ID = ?) bind => [2 parameters bound] Query: UpdateObjectQuery([Dataset id:9 ])
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    The Cyclos users forum • View topic - Cyclos 4.3.2 installation problem

    cyclos.org | 1 year ago
    org.postgresql.util.PSQLException: ERROR: relation "application" does not exist Position: 16 Error Code: 0 Call: SELECT ? FROM application LIMIT ? OFFSET ? bind => [3 parameters bound] Query: ReportQuery(referenceClass=Application sql="SELECT ? FROM application LIMIT ? OFFSET ?")
  6. 0

    Postgres Count without groupby (using jpa)

    Stack Overflow | 12 months ago | surajsheikh
    org.postgresql.util.PSQLException: ERROR: column "app_movie_summary.creationdate" must appear in the GROUP BY clause or be used in an aggregate function Position: 55 Error Code: 0 Call: SELECT COUNT(id) FROM mytable ORDER BY CREATIONDATE DESC Query: ReportQuery(name="App_Movie_Summary.findAllByCreationDateCount" referenceClass=App_Movie_Summary sql="SELECT COUNT(Id) FROM mytable ORDER BY CREATIONDATE DESC")

    Root Cause Analysis

    1. 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.eclipse.persistence.internal.jpa.EntityManagerImpl.flush()
    2. EclipseLink (non-OSGi)
      EJBQueryImpl.getSingleResult
      1. org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:786)
      2. org.eclipse.persistence.internal.jpa.EJBQueryImpl.performPreQueryFlush(EJBQueryImpl.java:1298)
      3. org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:434)
      4. org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:773)
      4 frames
    3. com.wegas.core
      VariableDescriptorFacade.duplicate
      1. com.wegas.core.ejb.VariableDescriptorFacade.findByLabel(VariableDescriptorFacade.java:302)
      2. com.wegas.core.ejb.VariableDescriptorFacade.findUniqueLabel(VariableDescriptorFacade.java:214)
      3. com.wegas.core.ejb.VariableDescriptorFacade.createChild(VariableDescriptorFacade.java:101)
      4. com.wegas.core.ejb.VariableDescriptorFacade.duplicate(VariableDescriptorFacade.java:163)
      4 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:601)
      4 frames
    5. Embedded GlassFish Web
      EjbInvocation.proceed
      1. org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1052)
      2. org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1124)
      3. com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:5388)
      4. com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:619)
      5. com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:800)
      6. com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:571)
      6 frames
    6. com.wegas.core
      AbstractFacadeImpl.interceptor
      1. com.wegas.core.ejb.AbstractFacadeImpl.interceptor(AbstractFacadeImpl.java:185)
      1 frame
    7. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor237.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:601)
      3 frames
    8. Embedded GlassFish Web
      EjbInvocation.proceed
      1. com.sun.ejb.containers.interceptors.BeanAroundInvokeInterceptor.intercept(InterceptorManager.java:902)
      2. com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:800)
      3. com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:571)
      3 frames
    9. Weld Implementation
      SessionBeanInterceptor.aroundInvoke
      1. org.jboss.weld.ejb.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:42)
      1 frame
    10. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor231.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:601)
      3 frames
    11. Embedded GlassFish Web
      SystemInterceptorProxy.aroundInvoke
      1. com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:861)
      2. com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:800)
      3. com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:571)
      4. com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doAround(SystemInterceptorProxy.java:162)
      5. com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:144)
      5 frames
    12. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor217.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:601)
      3 frames
    13. Embedded GlassFish Web
      EJBLocalObjectInvocationHandler.invoke
      1. com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:861)
      2. com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:800)
      3. com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:370)
      4. com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:5360)
      5. com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:5348)
      6. com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:214)
      6 frames