← Back to team overview

dhis2-devs team mailing list archive

  1. dhis2-devs team
  2. Mailing list archive
  3. Message #26777

[Bug 1044890] Re: Data import error between 2 DHIS2 systems

  Thread Previous • Date Previous • • Thread Next 
** Description changed:

  When we imported meta data exported from DGHS into dhis2_h1_2_6, I found the following error
  * WARN  10:24:44,589 SQL Error: 1062, SQLState: 23000 (JDBCExceptionReporter.jav
  a [Thread-16])
  * ERROR 10:24:44,590 Duplicate entry 'HS_27451657073' for key 3 (JDBCExceptionRe
  porter.java [Thread-16])
  * ERROR 10:24:44,623 Internal process failed (AbstractStatementInternalProcess.j
  ava [Thread-16])
  org.hibernate.exception.ConstraintViolationException: Could not execute JDBC bat
  ch update
-         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
+         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
  ava:96)
-         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
+         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
  er.java:66)
-         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
+         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
  275)
-         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
- 
-         at
+         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
+         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
  ns(AbstractFlushingEventListener.java:321)
-         at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
+         at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
  aultAutoFlushEventListener.java:64)
-         at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1
+         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
+         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
+         at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGene
  ricStore.java:235)
-         at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga
+         at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga
  nisationUnitByName(DefaultOrganisationUnitService.java:192)
-         at sun.reflect.GeneratedMethodAccessor333.invoke(Unknown Source)
-         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
-         at java.lang.reflect.Method.invoke(Unknown Source)
-         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
- on(AopUtils.java:309)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
- inpoint(ReflectiveMethodInvocation.java:183)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
- ReflectiveMethodInvocation.java:150)
-         at org.springframework.transaction.interceptor.TransactionInterceptor.in
- voke(TransactionInterceptor.java:110)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
- ReflectiveMethodInvocation.java:172)
-         at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
+         at sun.reflect.GeneratedMethodAccessor333.invoke(Unknown Source)
+         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
+         at java.lang.reflect.Method.invoke(Unknown Source)
+         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
+ on(AopUtils.java:309)
+         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
+ inpoint(ReflectiveMethodInvocation.java:183)
+         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
+ ReflectiveMethodInvocation.java:150)
+         at org.springframework.transaction.interceptor.TransactionInterceptor.in
+ voke(TransactionInterceptor.java:110)
+         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
+ ReflectiveMethodInvocation.java:172)
+         at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
  e(ExposeInvocationInterceptor.java:90)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
- ReflectiveMethodInvocation.java:172)
-         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
- cAopProxy.java:202)
-         at $Proxy17.getOrganisationUnitByName(Unknown Source)
-         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
+         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
+         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
  ing(OrganisationUnitImporter.java:44)
-         at org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImp
+         at org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImp
  orter.java:84)
-         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importOb
+         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importOb
  ject(OrganisationUnitImporter.java:64)
-         at org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.re
+         at org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.re
  ad(OrganisationUnitConverter.java:239)
-         at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
+         at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
  (DefaultConverterInvoker.java:45)
-         at sun.reflect.GeneratedMethodAccessor284.invoke(Unknown Source)
-         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
-         at java.lang.reflect.Method.invoke(Unknown Source)
-         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
- on(AopUtils.java:309)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
- inpoint(ReflectiveMethodInvocation.java:183)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
- ReflectiveMethodInvocation.java:150)
-         at org.springframework.transaction.interceptor.TransactionInterceptor.in
- voke(TransactionInterceptor.java:110)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
- ReflectiveMethodInvocation.java:172)
-         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
- cAopProxy.java:202)
-         at $Proxy98.invokeRead(Unknown Source)
-         at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConvert
+         at sun.reflect.GeneratedMethodAccessor284.invoke(Unknown Source)
+         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
+         at java.lang.reflect.Method.invoke(Unknown Source)
+         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
+ on(AopUtils.java:309)
+         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
+ inpoint(ReflectiveMethodInvocation.java:183)
+         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
+ ReflectiveMethodInvocation.java:150)
+         at org.springframework.transaction.interceptor.TransactionInterceptor.in
+ voke(TransactionInterceptor.java:110)
+         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
+ ReflectiveMethodInvocation.java:172)
+         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
+ cAopProxy.java:202)
+         at $Proxy98.invokeRead(Unknown Source)
+         at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConvert
  er.java:733)
-         at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImp
+         at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImp
  ortService.java:201)
-         at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
+         at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
  portInternalProcess.java:89)
-         at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
+         at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
  (AbstractStatementInternalProcess.java:103)
-         at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
+         at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
  (AbstractStatementInternalProcess.java:40)
-         at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
+         at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
  25)
-         at java.lang.Thread.run(Unknown Source)
+         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
+         at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
  nt.java:1666)
-         at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
+         at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
  1082)
-         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
+         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
  oxyPreparedStatement.java:1723)
-         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
+         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
  a:70)
-         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
+         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
  268)
-         ... 46 more
+         ... 46 more
  org.hibernate.exception.ConstraintViolationException: Could not execute JDBC bat
  ch update
-         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
+         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
  ava:96)
-         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
+         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
  er.java:66)
-         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
+         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
  275)
-         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
- 
-         at
+         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
+         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
  ns(AbstractFlushingEventListener.java:321)
-         at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
+         at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def
  aultAutoFlushEventListener.java:64)
-         at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1
+         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
+         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
+         at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGene
  ricStore.java:235)
-         at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga
+         at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga
  nisationUnitByName(DefaultOrganisationUnitService.java:192)
-         at sun.reflect.GeneratedMethodAccessor333.invoke(Unknown Source)
-         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
-         at java.lang.reflect.Method.invoke(Unknown Source)
-         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
- on(AopUtils.java:309)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
- inpoint(ReflectiveMethodInvocation.java:183)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
- ReflectiveMethodInvocation.java:150)
-         at org.springframework.transaction.interceptor.TransactionInterceptor.in
- voke(TransactionInterceptor.java:110)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
- ReflectiveMethodInvocation.java:172)
-         at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
+         at sun.reflect.GeneratedMethodAccessor333.invoke(Unknown Source)
+         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
+         at java.lang.reflect.Method.invoke(Unknown Source)
+         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
+ on(AopUtils.java:309)
+         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
+ inpoint(ReflectiveMethodInvocation.java:183)
+         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
+ ReflectiveMethodInvocation.java:150)
+         at org.springframework.transaction.interceptor.TransactionInterceptor.in
+ voke(TransactionInterceptor.java:110)
+         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
+ ReflectiveMethodInvocation.java:172)
+         at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
  e(ExposeInvocationInterceptor.java:90)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
- ReflectiveMethodInvocation.java:172)
-         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
- cAopProxy.java:202)
-         at $Proxy17.getOrganisationUnitByName(Unknown Source)
-         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
+         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
+         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatch
  ing(OrganisationUnitImporter.java:44)
-         at org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImp
+         at org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImp
  orter.java:84)
-         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importOb
+         at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importOb
  ject(OrganisationUnitImporter.java:64)
-         at org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.re
+         at org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.re
  ad(OrganisationUnitConverter.java:239)
-         at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
+         at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
  (DefaultConverterInvoker.java:45)
-         at sun.reflect.GeneratedMethodAccessor284.invoke(Unknown Source)
-         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
-         at java.lang.reflect.Method.invoke(Unknown Source)
-         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
- on(AopUtils.java:309)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
- inpoint(ReflectiveMethodInvocation.java:183)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
- ReflectiveMethodInvocation.java:150)
-         at org.springframework.transaction.interceptor.TransactionInterceptor.in
- voke(TransactionInterceptor.java:110)
-         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
- ReflectiveMethodInvocation.java:172)
-         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
- cAopProxy.java:202)
-         at $Proxy98.invokeRead(Unknown Source)
-         at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConvert
+         at sun.reflect.GeneratedMethodAccessor284.invoke(Unknown Source)
+         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
+         at java.lang.reflect.Method.invoke(Unknown Source)
+         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
+ on(AopUtils.java:309)
+         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
+ inpoint(ReflectiveMethodInvocation.java:183)
+         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
+ ReflectiveMethodInvocation.java:150)
+         at org.springframework.transaction.interceptor.TransactionInterceptor.in
+ voke(TransactionInterceptor.java:110)
+         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
+ ReflectiveMethodInvocation.java:172)
+         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
+ cAopProxy.java:202)
+         at $Proxy98.invokeRead(Unknown Source)
+         at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConvert
  er.java:733)
-         at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImp
+         at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImp
  ortService.java:201)
-         at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
+         at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
  portInternalProcess.java:89)
-         at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
+         at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
  (AbstractStatementInternalProcess.java:103)
-         at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
+         at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
  (AbstractStatementInternalProcess.java:40)
-         at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
+         at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
  25)
-         at java.lang.Thread.run(Unknown Source)
+         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
+         at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
  nt.java:1666)
-         at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
+         at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
  1082)
-         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
+         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
  oxyPreparedStatement.java:1723)
-         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
+         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
  a:70)
-         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
+         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
  268)
-         ... 46 more
+         ... 46 more

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

Title:
  Data import error between 2 DHIS2 systems

Status in DHIS 2:
  New

Bug description:
  When we imported meta data exported from DGHS into dhis2_h1_2_6, I found the following error
  * WARN  10:24:44,589 SQL Error: 1062, SQLState: 23000 (JDBCExceptionReporter.jav
  a [Thread-16])
  * ERROR 10:24:44,590 Duplicate entry 'HS_27451657073' for key 3 (JDBCExceptionRe
  porter.java [Thread-16])
  * ERROR 10:24:44,623 Internal process failed (AbstractStatementInternalProcess.j
  ava [Thread-16])
  org.hibernate.exception.ConstraintViolationException: Could not execute JDBC bat
  ch update
          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
  ava:96)
          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
  er.java:66)
          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
  275)
          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)

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

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

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

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

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

References

  Thread Previous • Date Previous • • Thread Next