dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #18822
Re: [Bug 1044893] [NEW] Data import error between 2 DHIS2 systems - Data value
Dear Bob
Nice to hear from you after quite long time (last was during Shimla
workshop).
Yes you are right. Both databases having same code to two orgunits.
Actually its was same, but DGHS change the 'Name' from "Badiakhali-1 USC"
to "Badiakhali USC".
Now how could we solve these problem during metadata import and data value
import? Is there any process where we can import data excluding these
conflicting orgunits?
Please advice.
Regards
Hannan
On Sun, Sep 2, 2012 at 6:56 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx>
wrote:
> 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 subscribed to the bug
> report.
> 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
>
--
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
References
