dhis2-devs team mailing list archive

Thread
Date
Re: [Bug 1044893] [NEW] Data import error between 2 DHIS2 systems - Data value

To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
From: Bob Jolliffe <bobjolliffe@xxxxxxxxx>
Date: Sun, 02 Sep 2012 12:56:23 -0000
Reply-to: Bug 1044893 <1044893@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Hi Hannan

This doesn't look like a bug to me.  It looks like you have two
orgunits with the same code : HS_27451657073

Can you check?

Bob

On 2 September 2012 05:34, Hannan Khan <1044893@xxxxxxxxxxxxxxxxxx> wrote:
> Public bug reported:
>
> When we imported data value exported from DGHS (dhis2 2.7) into
> dhis2_h1_2_6 (DHIS2 2.7), we found the following error
>
> * WARN  10:29:15,795 SQL Error: 1062, SQLState: 23000 (JDBCExceptionReporter.jav
> a [Thread-16])
> * ERROR 10:29:15,796 Duplicate entry 'HS_27451657073' for key 3 (JDBCExceptionRe
> porter.java [Thread-16])
> * ERROR 10:29:15,872 Internal process failed (AbstractStatementInternalProcess.j
> ava [Thread-16])
> org.hibernate.exception.ConstraintViolationException: Could not execute JDBC bat
> ch update
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
> ava:96)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
> er.java:66)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
> 275)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
>
>         at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
>
>         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
> ns(AbstractFlushingEventListener.java:321)
>         at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
> aultAutoFlushEventListener.java:64)
>         at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1
> 185)
>         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1709)
>         at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
>         at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
>         at org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGene
> ricStore.java:175)
>         at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGene
> ricStore.java:235)
>         at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga
> nisationUnitByName(DefaultOrganisationUnitService.java:192)
>         at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>         at java.lang.reflect.Method.invoke(Unknown Source)
>         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
> on(AopUtils.java:309)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
> inpoint(ReflectiveMethodInvocation.java:183)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:150)
>         at org.springframework.transaction.interceptor.TransactionInterceptor.in
> voke(TransactionInterceptor.java:110)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:172)
>         at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
> e(ExposeInvocationInterceptor.java:90)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:172)
>         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
> cAopProxy.java:202)
>         at $Proxy17.getOrganisationUnitByName(Unknown Source)
>         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
> ing(OrganisationUnitImporter.java:94)
>         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
> ing(OrganisationUnitImporter.java:44)
>         at org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImp
> orter.java:84)
>         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importOb
> ject(OrganisationUnitImporter.java:64)
>         at org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.re
> ad(OrganisationUnitConverter.java:239)
>         at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
> (DefaultConverterInvoker.java:45)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>         at java.lang.reflect.Method.invoke(Unknown Source)
>         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
> on(AopUtils.java:309)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
> inpoint(ReflectiveMethodInvocation.java:183)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:150)
>         at org.springframework.transaction.interceptor.TransactionInterceptor.in
> voke(TransactionInterceptor.java:110)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:172)
>         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
> cAopProxy.java:202)
>         at $Proxy98.invokeRead(Unknown Source)
>         at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConvert
> er.java:733)
>         at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImp
> ortService.java:201)
>         at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
> portInternalProcess.java:89)
>         at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
> (AbstractStatementInternalProcess.java:103)
>         at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
> (AbstractStatementInternalProcess.java:40)
>         at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
> 25)
>         at java.lang.Thread.run(Unknown Source)
> Caused by: java.sql.BatchUpdateException: Duplicate entry 'HS_27451657073' for k
> ey 3
>         at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
> nt.java:1666)
>         at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
> 1082)
>         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
> oxyPreparedStatement.java:1723)
>         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
> a:70)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
> 268)
>         ... 47 more
> org.hibernate.exception.ConstraintViolationException: Could not execute JDBC bat
> ch update
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
> ava:96)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
> er.java:66)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
> 275)
>         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
>
>         at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
>
>         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
> ns(AbstractFlushingEventListener.java:321)
>         at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
> aultAutoFlushEventListener.java:64)
>         at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1
> 185)
>         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1709)
>         at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
>         at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
>         at org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGene
> ricStore.java:175)
>         at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGene
> ricStore.java:235)
>         at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga
> nisationUnitByName(DefaultOrganisationUnitService.java:192)
>         at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>         at java.lang.reflect.Method.invoke(Unknown Source)
>         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
> on(AopUtils.java:309)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
> inpoint(ReflectiveMethodInvocation.java:183)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:150)
>         at org.springframework.transaction.interceptor.TransactionInterceptor.in
> voke(TransactionInterceptor.java:110)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:172)
>         at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
> e(ExposeInvocationInterceptor.java:90)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:172)
>         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
> cAopProxy.java:202)
>         at $Proxy17.getOrganisationUnitByName(Unknown Source)
>         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
> ing(OrganisationUnitImporter.java:94)
>         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
> ing(OrganisationUnitImporter.java:44)
>         at org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImp
> orter.java:84)
>         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importOb
> ject(OrganisationUnitImporter.java:64)
>         at org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.re
> ad(OrganisationUnitConverter.java:239)
>         at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
> (DefaultConverterInvoker.java:45)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>         at java.lang.reflect.Method.invoke(Unknown Source)
>         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
> on(AopUtils.java:309)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
> inpoint(ReflectiveMethodInvocation.java:183)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:150)
>         at org.springframework.transaction.interceptor.TransactionInterceptor.in
> voke(TransactionInterceptor.java:110)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:172)
>         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
> cAopProxy.java:202)
>         at $Proxy98.invokeRead(Unknown Source)
>         at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConvert
> er.java:733)
>         at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImp
> ortService.java:201)
>         at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
> portInternalProcess.java:89)
>         at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
> (AbstractStatementInternalProcess.java:103)
>         at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
> (AbstractStatementInternalProcess.java:40)
>         at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
> 25)
>         at java.lang.Thread.run(Unknown Source)
> Caused by: java.sql.BatchUpdateException: Duplicate entry 'HS_27451657073' for k
> ey 3
>         at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
> nt.java:1666)
>         at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
> 1082)
>         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
> oxyPreparedStatement.java:1723)
>         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
> a:70)
>         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
> 268)
>         ... 47 more
>
> ** Affects: dhis2
>      Importance: Undecided
>          Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1044893
>
> Title:
>   Data import error between 2 DHIS2 systems - Data value
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   When we imported data value exported from DGHS (dhis2 2.7) into
>   dhis2_h1_2_6 (DHIS2 2.7), we found the following error
>
>   * WARN  10:29:15,795 SQL Error: 1062, SQLState: 23000 (JDBCExceptionReporter.jav
>   a [Thread-16])
>   * ERROR 10:29:15,796 Duplicate entry 'HS_27451657073' for key 3 (JDBCExceptionRe
>   porter.java [Thread-16])
>   * ERROR 10:29:15,872 Internal process failed (AbstractStatementInternalProcess.j
>   ava [Thread-16])
>   org.hibernate.exception.ConstraintViolationException: Could not execute JDBC bat
>   ch update
>           at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
>   ava:96)
>           at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
>   er.java:66)
>           at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
>   275)
>           at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
>
>           at
>   org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
>
>           at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
>   ns(AbstractFlushingEventListener.java:321)
>           at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
>   aultAutoFlushEventListener.java:64)
>           at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1
>   185)
>           at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1709)
>           at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
>           at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
>           at org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGene
>   ricStore.java:175)
>           at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGene
>   ricStore.java:235)
>           at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga
>   nisationUnitByName(DefaultOrganisationUnitService.java:192)
>           at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source)
>           at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>           at java.lang.reflect.Method.invoke(Unknown Source)
>           at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
>   on(AopUtils.java:309)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
>   inpoint(ReflectiveMethodInvocation.java:183)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:150)
>           at org.springframework.transaction.interceptor.TransactionInterceptor.in
>   voke(TransactionInterceptor.java:110)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:172)
>           at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
>   e(ExposeInvocationInterceptor.java:90)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:172)
>           at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
>   cAopProxy.java:202)
>           at $Proxy17.getOrganisationUnitByName(Unknown Source)
>           at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
>   ing(OrganisationUnitImporter.java:94)
>           at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
>   ing(OrganisationUnitImporter.java:44)
>           at org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImp
>   orter.java:84)
>           at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importOb
>   ject(OrganisationUnitImporter.java:64)
>           at org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.re
>   ad(OrganisationUnitConverter.java:239)
>           at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
>   (DefaultConverterInvoker.java:45)
>           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>           at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>           at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>           at java.lang.reflect.Method.invoke(Unknown Source)
>           at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
>   on(AopUtils.java:309)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
>   inpoint(ReflectiveMethodInvocation.java:183)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:150)
>           at org.springframework.transaction.interceptor.TransactionInterceptor.in
>   voke(TransactionInterceptor.java:110)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:172)
>           at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
>   cAopProxy.java:202)
>           at $Proxy98.invokeRead(Unknown Source)
>           at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConvert
>   er.java:733)
>           at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImp
>   ortService.java:201)
>           at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
>   portInternalProcess.java:89)
>           at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
>   (AbstractStatementInternalProcess.java:103)
>           at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
>   (AbstractStatementInternalProcess.java:40)
>           at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
>   25)
>           at java.lang.Thread.run(Unknown Source)
>   Caused by: java.sql.BatchUpdateException: Duplicate entry 'HS_27451657073' for k
>   ey 3
>           at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
>   nt.java:1666)
>           at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
>   1082)
>           at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
>   oxyPreparedStatement.java:1723)
>           at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
>   a:70)
>           at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
>   268)
>           ... 47 more
>   org.hibernate.exception.ConstraintViolationException: Could not execute JDBC bat
>   ch update
>           at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
>   ava:96)
>           at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
>   er.java:66)
>           at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
>   275)
>           at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
>
>           at
>   org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
>
>           at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
>   ns(AbstractFlushingEventListener.java:321)
>           at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
>   aultAutoFlushEventListener.java:64)
>           at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1
>   185)
>           at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1709)
>           at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
>           at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
>           at org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGene
>   ricStore.java:175)
>           at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGene
>   ricStore.java:235)
>           at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga
>   nisationUnitByName(DefaultOrganisationUnitService.java:192)
>           at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source)
>           at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>           at java.lang.reflect.Method.invoke(Unknown Source)
>           at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
>   on(AopUtils.java:309)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
>   inpoint(ReflectiveMethodInvocation.java:183)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:150)
>           at org.springframework.transaction.interceptor.TransactionInterceptor.in
>   voke(TransactionInterceptor.java:110)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:172)
>           at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
>   e(ExposeInvocationInterceptor.java:90)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:172)
>           at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
>   cAopProxy.java:202)
>           at $Proxy17.getOrganisationUnitByName(Unknown Source)
>           at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
>   ing(OrganisationUnitImporter.java:94)
>           at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
>   ing(OrganisationUnitImporter.java:44)
>           at org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImp
>   orter.java:84)
>           at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importOb
>   ject(OrganisationUnitImporter.java:64)
>           at org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.re
>   ad(OrganisationUnitConverter.java:239)
>           at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
>   (DefaultConverterInvoker.java:45)
>           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>           at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>           at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>           at java.lang.reflect.Method.invoke(Unknown Source)
>           at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
>   on(AopUtils.java:309)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
>   inpoint(ReflectiveMethodInvocation.java:183)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:150)
>           at org.springframework.transaction.interceptor.TransactionInterceptor.in
>   voke(TransactionInterceptor.java:110)
>           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>   ReflectiveMethodInvocation.java:172)
>           at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
>   cAopProxy.java:202)
>           at $Proxy98.invokeRead(Unknown Source)
>           at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConvert
>   er.java:733)
>           at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImp
>   ortService.java:201)
>           at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
>   portInternalProcess.java:89)
>           at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
>   (AbstractStatementInternalProcess.java:103)
>           at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
>   (AbstractStatementInternalProcess.java:40)
>           at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
>   25)
>           at java.lang.Thread.run(Unknown Source)
>   Caused by: java.sql.BatchUpdateException: Duplicate entry 'HS_27451657073' for k
>   ey 3
>           at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
>   nt.java:1666)
>           at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
>   1082)
>           at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
>   oxyPreparedStatement.java:1723)
>           at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
>   a:70)
>           at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
>   268)
>           ... 47 more
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1044893/+subscriptions
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1044893

Title:
  Data import error between 2 DHIS2 systems - Data value

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  When we imported data value exported from DGHS (dhis2 2.7) into
  dhis2_h1_2_6 (DHIS2 2.7), we found the following error

  * WARN  10:29:15,795 SQL Error: 1062, SQLState: 23000 (JDBCExceptionReporter.jav
  a [Thread-16])
  * ERROR 10:29:15,796 Duplicate entry 'HS_27451657073' for key 3 (JDBCExceptionRe
  porter.java [Thread-16])
  * ERROR 10:29:15,872 Internal process failed (AbstractStatementInternalProcess.j
  ava [Thread-16])
  org.hibernate.exception.ConstraintViolationException: Could not execute JDBC bat
  ch update
          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
  ava:96)
          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
  er.java:66)
          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
  275)
          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)

          at
  org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)

          at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
  ns(AbstractFlushingEventListener.java:321)
          at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
  aultAutoFlushEventListener.java:64)
          at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1
  185)
          at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1709)
          at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
          at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
          at org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGene
  ricStore.java:175)
          at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGene
  ricStore.java:235)
          at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga
  nisationUnitByName(DefaultOrganisationUnitService.java:192)
          at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
  on(AopUtils.java:309)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
  inpoint(ReflectiveMethodInvocation.java:183)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
  ReflectiveMethodInvocation.java:150)
          at org.springframework.transaction.interceptor.TransactionInterceptor.in
  voke(TransactionInterceptor.java:110)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
  ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
  e(ExposeInvocationInterceptor.java:90)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
  ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
  cAopProxy.java:202)
          at $Proxy17.getOrganisationUnitByName(Unknown Source)
          at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
  ing(OrganisationUnitImporter.java:94)
          at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
  ing(OrganisationUnitImporter.java:44)
          at org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImp
  orter.java:84)
          at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importOb
  ject(OrganisationUnitImporter.java:64)
          at org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.re
  ad(OrganisationUnitConverter.java:239)
          at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
  (DefaultConverterInvoker.java:45)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
  on(AopUtils.java:309)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
  inpoint(ReflectiveMethodInvocation.java:183)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
  ReflectiveMethodInvocation.java:150)
          at org.springframework.transaction.interceptor.TransactionInterceptor.in
  voke(TransactionInterceptor.java:110)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
  ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
  cAopProxy.java:202)
          at $Proxy98.invokeRead(Unknown Source)
          at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConvert
  er.java:733)
          at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImp
  ortService.java:201)
          at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
  portInternalProcess.java:89)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
  (AbstractStatementInternalProcess.java:103)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
  (AbstractStatementInternalProcess.java:40)
          at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
  25)
          at java.lang.Thread.run(Unknown Source)
  Caused by: java.sql.BatchUpdateException: Duplicate entry 'HS_27451657073' for k
  ey 3
          at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
  nt.java:1666)
          at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
  1082)
          at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
  oxyPreparedStatement.java:1723)
          at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
  a:70)
          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
  268)
          ... 47 more
  org.hibernate.exception.ConstraintViolationException: Could not execute JDBC bat
  ch update
          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
  ava:96)
          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
  er.java:66)
          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
  275)
          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)

          at
  org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)

          at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
  ns(AbstractFlushingEventListener.java:321)
          at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
  aultAutoFlushEventListener.java:64)
          at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1
  185)
          at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1709)
          at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
          at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
          at org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGene
  ricStore.java:175)
          at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGene
  ricStore.java:235)
          at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga
  nisationUnitByName(DefaultOrganisationUnitService.java:192)
          at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
  on(AopUtils.java:309)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
  inpoint(ReflectiveMethodInvocation.java:183)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
  ReflectiveMethodInvocation.java:150)
          at org.springframework.transaction.interceptor.TransactionInterceptor.in
  voke(TransactionInterceptor.java:110)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
  ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
  e(ExposeInvocationInterceptor.java:90)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
  ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
  cAopProxy.java:202)
          at $Proxy17.getOrganisationUnitByName(Unknown Source)
          at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
  ing(OrganisationUnitImporter.java:94)
          at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
  ing(OrganisationUnitImporter.java:44)
          at org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImp
  orter.java:84)
          at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importOb
  ject(OrganisationUnitImporter.java:64)
          at org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.re
  ad(OrganisationUnitConverter.java:239)
          at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
  (DefaultConverterInvoker.java:45)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
  on(AopUtils.java:309)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
  inpoint(ReflectiveMethodInvocation.java:183)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
  ReflectiveMethodInvocation.java:150)
          at org.springframework.transaction.interceptor.TransactionInterceptor.in
  voke(TransactionInterceptor.java:110)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
  ReflectiveMethodInvocation.java:172)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
  cAopProxy.java:202)
          at $Proxy98.invokeRead(Unknown Source)
          at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConvert
  er.java:733)
          at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImp
  ortService.java:201)
          at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
  portInternalProcess.java:89)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
  (AbstractStatementInternalProcess.java:103)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
  (AbstractStatementInternalProcess.java:40)
          at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
  25)
          at java.lang.Thread.run(Unknown Source)
  Caused by: java.sql.BatchUpdateException: Duplicate entry 'HS_27451657073' for k
  ey 3
          at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
  nt.java:1666)
          at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
  1082)
          at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
  oxyPreparedStatement.java:1723)
          at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
  a:70)
          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
  268)
          ... 47 more

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1044893/+subscriptions
Follow ups

Re: [Bug 1044893] [NEW] Data import error between 2 DHIS2 systems - Data value
From: Hannan Khan, 2012-09-03
References

[Bug 1044893] [NEW] Data import error between 2 DHIS2 systems - Data value
From: Hannan Khan, 2012-09-02