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 | 3 years ago
  1. 0

    PMG - Unable to duplicate Task

    GitHub | 3 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 | 3 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 | 11 months 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 | 7 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")

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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