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 <bobjolli...@gmail.com> 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 <1044...@bugs.launchpad.net> 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@lists.launchpad.net > > 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 _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
