dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Hi Hannan, do you have any idea what this code refers to? Could it be some
kind of ID number in your database? Any idea why it would appear twice?

HS_27451657073

Knut


On Sun, Sep 2, 2012 at 6:29 AM, Hannan Khan <1044890@xxxxxxxxxxxxxxxxxx>wrote:

> Public bug reported:
>
> When we imported meta data exported from DGHS into dhis2_h1_2_6, I found
> the following error
> * WARN  10:24:44,589 SQL Error: 1062, SQLState: 23000
> (JDBCExceptionReporter.jav
> a [Thread-16])
> * ERROR 10:24:44,590 Duplicate entry 'HS_27451657073' for key 3
> (JDBCExceptionRe
> porter.java [Thread-16])
> * ERROR 10:24:44,623 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.GeneratedMethodAccessor333.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.GeneratedMethodAccessor284.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)
>         ... 46 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.GeneratedMethodAccessor333.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.GeneratedMethodAccessor284.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)
>         ... 46 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/1044890
>
> Title:
>   Data import error between 2 DHIS2 systems
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   When we imported meta data exported from DGHS into dhis2_h1_2_6, I found
> the following error
>   * WARN  10:24:44,589 SQL Error: 1062, SQLState: 23000
> (JDBCExceptionReporter.jav
>   a [Thread-16])
>   * ERROR 10:24:44,590 Duplicate entry 'HS_27451657073' for key 3
> (JDBCExceptionRe
>   porter.java [Thread-16])
>   * ERROR 10:24:44,623 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.GeneratedMethodAccessor333.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.GeneratedMethodAccessor284.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)
>           ... 46 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.GeneratedMethodAccessor333.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.GeneratedMethodAccessor284.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)
>           ... 46 more
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1044890/+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
>



-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org