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 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