dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #38892
Re: [Bug 1483215] [NEW] Exception while Importing Meta Data
Hi
We had an issue in older version of DHIS 2 import, where the "default"
created categories/coc etc was duplicated. I think this is what has
happened in your case also, I would upgrade to the latest version of DHIS,
and make sure you delete any duplicate "default" categories (they should
not have any data element/data set linked to them)
--
Morten
On Mon, Aug 10, 2015 at 6:26 PM, Neeraj <neeraj.hisp@xxxxxxxxx> wrote:
> Public bug reported:
>
> Hi,
>
> Created a new Database with 5 Category Options, 2 Categories and 1
> Category Combination, 1 data element, 2 dataset and 2 organisation
> units.
>
> Exported meta data with Import/Export App by selecting all
> options(default selection) and got metadata.xml (zip file) and created a
> fresh instance with empty database and tried to import the metadata zip
> file to that and found following Exception.
>
>
> * INFO 2015-08-10 16:36:44,952 User 'admin' started import at Mon Aug 10
> 16:36:
> 44 IST 2015 (DefaultImportService.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:44,954 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:44 IST 2015, message: Importing meta-data]
> (InMemoryNotifier.jav
> a [taskScheduler-1])
> * INFO 2015-08-10 16:36:44,958 Building object-bridge maps (preheatCache:
> true)
> . (DefaultObjectBridge.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,170 Building object-bridge maps took 0.22
> seconds. (
> DefaultObjectBridge.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,170 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 2 OrganisationUnits]
> (InMemoryNo
> tifier.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,186 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 2 OrganisationUnitLevels]
> (InMem
> oryNotifier.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,201 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 6 CategoryOptions]
> (InMemoryNoti
> fier.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,201 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 3 Categories]
> (InMemoryNotifier.
> java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,201 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 2 CategoryCombos]
> (InMemoryNotif
> ier.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,217 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 7 CategoryOptionCombos]
> (InMemor
> yNotifier.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,218 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 1 DataElements]
> (InMemoryNotifie
> r.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,218 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 1 Users]
> (InMemoryNotifier.java
> [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,218 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 1 DataSets]
> (InMemoryNotifier.ja
> va [taskScheduler-1])
> * WARN 2015-08-10 16:36:45,265 SQL Error: 0, SQLState: 23505
> (SqlExceptionHelpe
> r.java [taskScheduler-1])
> * ERROR 2015-08-10 16:36:45,265 ERROR: duplicate key value violates unique
> const
> raint "uk_pbj3u1nk9vnuof8f47utvowmv"
> Detail: Key (name)=(default) already exists. (SqlExceptionHelper.java
> [taskSch
> eduler-1])
> * ERROR 2015-08-10 16:36:45,265 Unexpected error occurred in scheduled
> task. (Ta
> skUtils.java [taskScheduler-1])
> org.hibernate.exception.ConstraintViolationException: could not execute
> statemen
> t
> at
> org.hibernate.exception.internal.SQLStateConversionDelegate.convert(S
> QLStateConversionDelegate.java:129)
> at
> org.hibernate.exception.internal.StandardSQLExceptionConverter.conver
> t(StandardSQLExceptionConverter.java:49)
> at
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
> Helper.java:124)
> at
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
> Helper.java:109)
> at
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(
> ResultSetReturnImpl.java:189)
> at
> org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(
> NonBatchingBatch.java:59)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
> tEntityPersister.java:3079)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
> tEntityPersister.java:3521)
> at
> org.hibernate.action.internal.EntityInsertAction.execute(EntityInsert
> Action.java:88)
> at
> org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)
> at
> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:
> 387)
> at
> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:
> 303)
> at
> org.hibernate.event.internal.AbstractFlushingEventListener.performExe
> cutions(AbstractFlushingEventListener.java:349)
> at
> org.hibernate.event.internal.DefaultFlushEventListener.onFlush(Defaul
> tFlushEventListener.java:56)
> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195)
> at
> org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
>
> er$NonIdentifiableObjects.saveDataElementOperands(DefaultIdentifiableObjectImpor
> ter.java:1164)
> at
> org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
> er$NonIdentifiableObjects.save(DefaultIdentifiableObjectImporter.java:981)
> at
> org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
> er.newObject(DefaultIdentifiableObjectImporter.java:362)
> at
> org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
> er.startImport(DefaultIdentifiableObjectImporter.java:556)
> at
> org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
> er.importObjectLocal(DefaultIdentifiableObjectImporter.java:511)
> at
> org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
> er.importObjects(DefaultIdentifiableObjectImporter.java:187)
> at
> org.hisp.dhis.dxf2.metadata.DefaultImportService.doImport(DefaultImpo
> rtService.java:264)
> at
> org.hisp.dhis.dxf2.metadata.DefaultImportService.importMetaData(Defau
> ltImportService.java:181)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
> on(AopUtils.java:317)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
> inpoint(ReflectiveMethodInvocation.java:190)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:157)
> at
> org.springframework.transaction.interceptor.TransactionInterceptor$1.
> proceedWithInvocation(TransactionInterceptor.java:99)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.
> invokeWithinTransaction(TransactionAspectSupport.java:281)
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.in
> voke(TransactionInterceptor.java:96)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:179)
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
> cAopProxy.java:207)
> at $Proxy319.importMetaData(Unknown Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
> on(AopUtils.java:317)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
> inpoint(ReflectiveMethodInvocation.java:190)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:157)
> at
> org.springframework.aop.support.DelegatingIntroductionInterceptor.doP
> roceed(DelegatingIntroductionInterceptor.java:133)
> at
> org.springframework.aop.support.DelegatingIntroductionInterceptor.inv
> oke(DelegatingIntroductionInterceptor.java:121)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:179)
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
> cAopProxy.java:207)
> at $Proxy275.importMetaData(Unknown Source)
> at
> org.hisp.dhis.importexport.action.util.ImportMetaDataTask.run(ImportM
> etaDataTask.java:97)
> at
> org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl
> e.run(DelegatingErrorHandlingRunnable.java:54)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:47
> 1)
> at
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
> access$201(ScheduledThreadPoolExecutor.java:178)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
> run(ScheduledThreadPoolExecutor.java:292)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
> java:1110)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
> .java:603)
> at java.lang.Thread.run(Thread.java:722)
> Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value
> violate
> s unique constraint "uk_pbj3u1nk9vnuof8f47utvowmv"
> Detail: Key (name)=(default) already exists.
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
> ecutorImpl.java:2198)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
> Impl.java:1927)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
> va:255)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
> ement.java:561)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
> Jdbc2Statement.java:419)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
> c2Statement.java:365)
> at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
> roxyPreparedStatement.java:105)
> at
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(
> ResultSetReturnImpl.java:186)
> ... 53 more
>
>
> Please help.
>
> ** Affects: dhis2
> Importance: Undecided
> Status: New
>
> --
> You received this bug notification because you are subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1483215
>
> Title:
> Exception while Importing Meta Data
>
> Status in DHIS:
> New
>
> Bug description:
> Hi,
>
> Created a new Database with 5 Category Options, 2 Categories and 1
> Category Combination, 1 data element, 2 dataset and 2 organisation
> units.
>
> Exported meta data with Import/Export App by selecting all
> options(default selection) and got metadata.xml (zip file) and created
> a fresh instance with empty database and tried to import the metadata
> zip file to that and found following Exception.
>
>
> * INFO 2015-08-10 16:36:44,952 User 'admin' started import at Mon Aug
> 10 16:36:
> 44 IST 2015 (DefaultImportService.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:44,954 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:44 IST 2015, message: Importing meta-data]
> (InMemoryNotifier.jav
> a [taskScheduler-1])
> * INFO 2015-08-10 16:36:44,958 Building object-bridge maps
> (preheatCache: true)
> . (DefaultObjectBridge.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,170 Building object-bridge maps took 0.22
> seconds. (
> DefaultObjectBridge.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,170 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 2 OrganisationUnits]
> (InMemoryNo
> tifier.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,186 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 2
> OrganisationUnitLevels] (InMem
> oryNotifier.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,201 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 6 CategoryOptions]
> (InMemoryNoti
> fier.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,201 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 3 Categories]
> (InMemoryNotifier.
> java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,201 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 2 CategoryCombos]
> (InMemoryNotif
> ier.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,217 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 7 CategoryOptionCombos]
> (InMemor
> yNotifier.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,218 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 1 DataElements]
> (InMemoryNotifie
> r.java [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,218 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 1 Users]
> (InMemoryNotifier.java
> [taskScheduler-1])
> * INFO 2015-08-10 16:36:45,218 [Level: INFO, category: METADATA_IMPORT,
> time: M
> on Aug 10 16:36:45 IST 2015, message: Importing 1 DataSets]
> (InMemoryNotifier.ja
> va [taskScheduler-1])
> * WARN 2015-08-10 16:36:45,265 SQL Error: 0, SQLState: 23505
> (SqlExceptionHelpe
> r.java [taskScheduler-1])
> * ERROR 2015-08-10 16:36:45,265 ERROR: duplicate key value violates
> unique const
> raint "uk_pbj3u1nk9vnuof8f47utvowmv"
> Detail: Key (name)=(default) already exists. (SqlExceptionHelper.java
> [taskSch
> eduler-1])
> * ERROR 2015-08-10 16:36:45,265 Unexpected error occurred in scheduled
> task. (Ta
> skUtils.java [taskScheduler-1])
> org.hibernate.exception.ConstraintViolationException: could not execute
> statemen
> t
> at
> org.hibernate.exception.internal.SQLStateConversionDelegate.convert(S
> QLStateConversionDelegate.java:129)
> at
> org.hibernate.exception.internal.StandardSQLExceptionConverter.conver
> t(StandardSQLExceptionConverter.java:49)
> at
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
> Helper.java:124)
> at
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
> Helper.java:109)
> at
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(
> ResultSetReturnImpl.java:189)
> at
> org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(
> NonBatchingBatch.java:59)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
> tEntityPersister.java:3079)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
> tEntityPersister.java:3521)
> at
> org.hibernate.action.internal.EntityInsertAction.execute(EntityInsert
> Action.java:88)
> at
> org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)
> at
> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:
> 387)
> at
> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:
> 303)
> at
> org.hibernate.event.internal.AbstractFlushingEventListener.performExe
> cutions(AbstractFlushingEventListener.java:349)
> at
> org.hibernate.event.internal.DefaultFlushEventListener.onFlush(Defaul
> tFlushEventListener.java:56)
> at
> org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195)
> at
> org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
>
> er$NonIdentifiableObjects.saveDataElementOperands(DefaultIdentifiableObjectImpor
> ter.java:1164)
> at
> org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
>
> er$NonIdentifiableObjects.save(DefaultIdentifiableObjectImporter.java:981)
> at
> org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
> er.newObject(DefaultIdentifiableObjectImporter.java:362)
> at
> org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
> er.startImport(DefaultIdentifiableObjectImporter.java:556)
> at
> org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
> er.importObjectLocal(DefaultIdentifiableObjectImporter.java:511)
> at
> org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
> er.importObjects(DefaultIdentifiableObjectImporter.java:187)
> at
> org.hisp.dhis.dxf2.metadata.DefaultImportService.doImport(DefaultImpo
> rtService.java:264)
> at
> org.hisp.dhis.dxf2.metadata.DefaultImportService.importMetaData(Defau
> ltImportService.java:181)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
> on(AopUtils.java:317)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
> inpoint(ReflectiveMethodInvocation.java:190)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:157)
> at
> org.springframework.transaction.interceptor.TransactionInterceptor$1.
> proceedWithInvocation(TransactionInterceptor.java:99)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.
> invokeWithinTransaction(TransactionAspectSupport.java:281)
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.in
> voke(TransactionInterceptor.java:96)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:179)
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
> cAopProxy.java:207)
> at $Proxy319.importMetaData(Unknown Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
> on(AopUtils.java:317)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
> inpoint(ReflectiveMethodInvocation.java:190)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:157)
> at
> org.springframework.aop.support.DelegatingIntroductionInterceptor.doP
> roceed(DelegatingIntroductionInterceptor.java:133)
> at
> org.springframework.aop.support.DelegatingIntroductionInterceptor.inv
> oke(DelegatingIntroductionInterceptor.java:121)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:179)
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
> cAopProxy.java:207)
> at $Proxy275.importMetaData(Unknown Source)
> at
> org.hisp.dhis.importexport.action.util.ImportMetaDataTask.run(ImportM
> etaDataTask.java:97)
> at
> org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl
> e.run(DelegatingErrorHandlingRunnable.java:54)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:47
> 1)
> at
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
> access$201(ScheduledThreadPoolExecutor.java:178)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
> run(ScheduledThreadPoolExecutor.java:292)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
> java:1110)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
> .java:603)
> at java.lang.Thread.run(Thread.java:722)
> Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value
> violate
> s unique constraint "uk_pbj3u1nk9vnuof8f47utvowmv"
> Detail: Key (name)=(default) already exists.
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
> ecutorImpl.java:2198)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
> Impl.java:1927)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
> va:255)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
> ement.java:561)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
> Jdbc2Statement.java:419)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
> c2Statement.java:365)
> at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
> roxyPreparedStatement.java:105)
> at
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(
> ResultSetReturnImpl.java:186)
> ... 53 more
>
>
> Please help.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1483215/+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/1483215
Title:
Exception while Importing Meta Data
Status in DHIS:
New
Bug description:
Hi,
Created a new Database with 5 Category Options, 2 Categories and 1
Category Combination, 1 data element, 2 dataset and 2 organisation
units.
Exported meta data with Import/Export App by selecting all
options(default selection) and got metadata.xml (zip file) and created
a fresh instance with empty database and tried to import the metadata
zip file to that and found following Exception.
* INFO 2015-08-10 16:36:44,952 User 'admin' started import at Mon Aug 10 16:36:
44 IST 2015 (DefaultImportService.java [taskScheduler-1])
* INFO 2015-08-10 16:36:44,954 [Level: INFO, category: METADATA_IMPORT, time: M
on Aug 10 16:36:44 IST 2015, message: Importing meta-data] (InMemoryNotifier.jav
a [taskScheduler-1])
* INFO 2015-08-10 16:36:44,958 Building object-bridge maps (preheatCache: true)
. (DefaultObjectBridge.java [taskScheduler-1])
* INFO 2015-08-10 16:36:45,170 Building object-bridge maps took 0.22 seconds. (
DefaultObjectBridge.java [taskScheduler-1])
* INFO 2015-08-10 16:36:45,170 [Level: INFO, category: METADATA_IMPORT, time: M
on Aug 10 16:36:45 IST 2015, message: Importing 2 OrganisationUnits] (InMemoryNo
tifier.java [taskScheduler-1])
* INFO 2015-08-10 16:36:45,186 [Level: INFO, category: METADATA_IMPORT, time: M
on Aug 10 16:36:45 IST 2015, message: Importing 2 OrganisationUnitLevels] (InMem
oryNotifier.java [taskScheduler-1])
* INFO 2015-08-10 16:36:45,201 [Level: INFO, category: METADATA_IMPORT, time: M
on Aug 10 16:36:45 IST 2015, message: Importing 6 CategoryOptions] (InMemoryNoti
fier.java [taskScheduler-1])
* INFO 2015-08-10 16:36:45,201 [Level: INFO, category: METADATA_IMPORT, time: M
on Aug 10 16:36:45 IST 2015, message: Importing 3 Categories] (InMemoryNotifier.
java [taskScheduler-1])
* INFO 2015-08-10 16:36:45,201 [Level: INFO, category: METADATA_IMPORT, time: M
on Aug 10 16:36:45 IST 2015, message: Importing 2 CategoryCombos] (InMemoryNotif
ier.java [taskScheduler-1])
* INFO 2015-08-10 16:36:45,217 [Level: INFO, category: METADATA_IMPORT, time: M
on Aug 10 16:36:45 IST 2015, message: Importing 7 CategoryOptionCombos] (InMemor
yNotifier.java [taskScheduler-1])
* INFO 2015-08-10 16:36:45,218 [Level: INFO, category: METADATA_IMPORT, time: M
on Aug 10 16:36:45 IST 2015, message: Importing 1 DataElements] (InMemoryNotifie
r.java [taskScheduler-1])
* INFO 2015-08-10 16:36:45,218 [Level: INFO, category: METADATA_IMPORT, time: M
on Aug 10 16:36:45 IST 2015, message: Importing 1 Users] (InMemoryNotifier.java
[taskScheduler-1])
* INFO 2015-08-10 16:36:45,218 [Level: INFO, category: METADATA_IMPORT, time: M
on Aug 10 16:36:45 IST 2015, message: Importing 1 DataSets] (InMemoryNotifier.ja
va [taskScheduler-1])
* WARN 2015-08-10 16:36:45,265 SQL Error: 0, SQLState: 23505 (SqlExceptionHelpe
r.java [taskScheduler-1])
* ERROR 2015-08-10 16:36:45,265 ERROR: duplicate key value violates unique const
raint "uk_pbj3u1nk9vnuof8f47utvowmv"
Detail: Key (name)=(default) already exists. (SqlExceptionHelper.java [taskSch
eduler-1])
* ERROR 2015-08-10 16:36:45,265 Unexpected error occurred in scheduled task. (Ta
skUtils.java [taskScheduler-1])
org.hibernate.exception.ConstraintViolationException: could not execute statemen
t
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(S
QLStateConversionDelegate.java:129)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.conver
t(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
Helper.java:124)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
Helper.java:109)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(
ResultSetReturnImpl.java:189)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(
NonBatchingBatch.java:59)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:3079)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:3521)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsert
Action.java:88)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:
387)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:
303)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExe
cutions(AbstractFlushingEventListener.java:349)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(Defaul
tFlushEventListener.java:56)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195)
at org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
er$NonIdentifiableObjects.saveDataElementOperands(DefaultIdentifiableObjectImpor
ter.java:1164)
at org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
er$NonIdentifiableObjects.save(DefaultIdentifiableObjectImporter.java:981)
at org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
er.newObject(DefaultIdentifiableObjectImporter.java:362)
at org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
er.startImport(DefaultIdentifiableObjectImporter.java:556)
at org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
er.importObjectLocal(DefaultIdentifiableObjectImporter.java:511)
at org.hisp.dhis.dxf2.metadata.importers.DefaultIdentifiableObjectImport
er.importObjects(DefaultIdentifiableObjectImporter.java:187)
at org.hisp.dhis.dxf2.metadata.DefaultImportService.doImport(DefaultImpo
rtService.java:264)
at org.hisp.dhis.dxf2.metadata.DefaultImportService.importMetaData(Defau
ltImportService.java:181)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.
proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.
invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:207)
at $Proxy319.importMetaData(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:157)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doP
roceed(DelegatingIntroductionInterceptor.java:133)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.inv
oke(DelegatingIntroductionInterceptor.java:121)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:207)
at $Proxy275.importMetaData(Unknown Source)
at org.hisp.dhis.importexport.action.util.ImportMetaDataTask.run(ImportM
etaDataTask.java:97)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl
e.run(DelegatingErrorHandlingRunnable.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:47
1)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violate
s unique constraint "uk_pbj3u1nk9vnuof8f47utvowmv"
Detail: Key (name)=(default) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
c2Statement.java:365)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(
ResultSetReturnImpl.java:186)
... 53 more
Please help.
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1483215/+subscriptions
Follow ups
References
