dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Devs,
This popped up this morning, and caused big problems after this error. Any
idea what the root cause might be? Using

Version:2.14Build revision:13740
Regards
Jason
* INFO  2014-02-25 11:00:43,174 GTW: Clickatell CLTS: HTTP POST:
http://api.clickatell.com/http/ping (HTTPGateway.java [KeepAlive
[Clickatell CLTS]])
* INFO  2014-02-25 11:00:57,065 importing data values
(DefaultDataValueSetService.java [http-bio-8080-exec-93])
* WARN  2014-02-25 11:01:12,156 SQL Error: 0, SQLState: 23505
(SqlExceptionHelper.java [http-bio-8080-exec-114])
* ERROR 2014-02-25 11:01:12,157 ERROR: duplicate key value violates unique
constraint "completedatasetregistration_pkey"
  Detail: Key (datasetid, periodid, sourceid)=(10937, 21368, 12692) already
exists. (SqlExceptionHelper.java [http-bio-8080-exec-114])
* ERROR 2014-02-25 11:01:18,348
org.springframework.dao.DataIntegrityViolationException: could not execute
statement; SQL [n/a]; constraint [completedatasetre
gistration_pkey]; nested exception is
org.hibernate.exception.ConstraintViolationException: could not execute
statement
        at
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:138)
        at
org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:680)
        at
org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:562)
        at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755)
        at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)
        at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:475)
        at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:270)
        at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at com.sun.proxy.$Proxy57.saveCompleteDataSetRegistration(Unknown
Source)
        at
org.hisp.dhis.dxf2.datavalueset.DefaultDataValueSetService.handleComplete(DefaultDataValueSetService.java:490)
        at
org.hisp.dhis.dxf2.datavalueset.DefaultDataValueSetService.saveDataValueSet(DefaultDataValueSetService.java:307)
        at
org.hisp.dhis.dxf2.datavalueset.DefaultDataValueSetService.saveDataValueSetJson(DefaultDataValueSetService.java:228)
        at
org.hisp.dhis.dxf2.datavalueset.DefaultDataValueSetService.saveDataValueSetJson(DefaultDataValueSetService.java:205)
        at
org.hisp.dhis.api.controller.DataValueSetController.postJsonDataValueSet(DataValueSetController.java:194)
        at
org.hisp.dhis.api.controller.DataValueSetController$$FastClassByCGLIB$$1929d95b.invoke(<generated>)
        at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:701)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at
org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:634)
        at
org.hisp.dhis.api.controller.DataValueSetController$$EnhancerByCGLIB$$fd92c331.postJsonDataValueSet(<generated>)
        at sun.reflect.GeneratedMethodAccessor819.invoke(Unknown Source)