[Bug 1483215] [NEW] Exception while Importing Meta Data

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

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@gmail.com> 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

Thanks Morten.

···

On Wed, Aug 12, 2015 at 7:06 AM, Morten Olav Hansen < 1483215@bugs.launchpad.net> wrote:

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@gmail.com> 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 subscribed to the bug
report.
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

--
Thanks,
Neeraj Gupta

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

** Changed in: dhis2
       Status: New => Fix Released

···

--
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:
  Fix Released

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

Hi All,

is this bug already solved ? I still have this problem when importing my
metadata from version 2.19 to 2.20,

ERROR 2015-10-08 06:07:57,109 ERROR: duplicate key value violates unique
constraint "uk_pbj3u1nk9vnuof8f47utvowmv"
  Detail: Key (name)=(default) already exists. (SqlExceptionHelper.java
[taskScheduler-2])
* ERROR 2015-10-08 06:07:57,111 Unexpected error occurred in scheduled
task. (TaskUtils.java [taskScheduler-2])
org.springframework.dao.DataIntegrityViolationException: could not execute
statement; SQL [n/a]; constraint [uk_pbj3u1nk9vnuof8f47utvowmv]; nested
exception is org.hibernate.exception.ConstraintViolationException: could
not execute statement

any suggestion ?

Thanks

···

On Fri, Sep 18, 2015 at 3:21 PM, jason.p.pickering < 1483215@bugs.launchpad.net> wrote:

** Changed in: dhis2
       Status: New => Fix Released

--
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:
  Fix Released

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

_______________________________________________
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

--
Best Regards,
*Furqonuddin Ramdhani*

** Attachment added: "metadata category option2.xml"
   https://bugs.launchpad.net/bugs/1483215/+attachment/4488032/+files/metadata%20category%20option2.xml

--
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:
  Fix Released

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

Hi

This is not an ideal solution, but could you take your XML file and find
all category/options with name "default" and remove them? hopefully it
should work after that, we did fix a bug similar to this a few weeks ago..
but I'm hearing some people still have issues with it, so I will have
another look

···

--
Morten

On Thu, Oct 8, 2015 at 6:32 AM, Furqonuddin Ramdhani <furqon17@gmail.com> wrote:

Hi All,

is this bug already solved ? I still have this problem when importing my
metadata from version 2.19 to 2.20,

ERROR 2015-10-08 06:07:57,109 ERROR: duplicate key value violates unique
constraint "uk_pbj3u1nk9vnuof8f47utvowmv"
  Detail: Key (name)=(default) already exists. (SqlExceptionHelper.java
[taskScheduler-2])
* ERROR 2015-10-08 06:07:57,111 Unexpected error occurred in scheduled
task. (TaskUtils.java [taskScheduler-2])
org.springframework.dao.DataIntegrityViolationException: could not execute
statement; SQL [n/a]; constraint [uk_pbj3u1nk9vnuof8f47utvowmv]; nested
exception is org.hibernate.exception.ConstraintViolationException: could
not execute statement

any suggestion ?

Thanks

On Fri, Sep 18, 2015 at 3:21 PM, jason.p.pickering < > 1483215@bugs.launchpad.net> wrote:

** Changed in: dhis2
       Status: New => Fix Released

--
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:
  Fix Released

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

_______________________________________________
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

--
Best Regards,
*Furqonuddin Ramdhani*

_______________________________________________
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 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:
  Fix Released

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

Thanks Morten, it works.

Regards,

Furqon

···

On Thu, Oct 8, 2015 at 8:51 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi

This is not an ideal solution, but could you take your XML file and find all category/options with name “default” and remove them? hopefully it should work after that, we did fix a bug similar to this a few weeks ago… but I’m hearing some people still have issues with it, so I will have another look


Morten

On Thu, Oct 8, 2015 at 6:32 AM, Furqonuddin Ramdhani furqon17@gmail.com wrote:

Hi All,

is this bug already solved ? I still have this problem when importing my metadata from version 2.19 to 2.20,

ERROR 2015-10-08 06:07:57,109 ERROR: duplicate key value violates unique constraint “uk_pbj3u1nk9vnuof8f47utvowmv”

Detail: Key (name)=(default) already exists. (SqlExceptionHelper.java [taskScheduler-2])

  • ERROR 2015-10-08 06:07:57,111 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])

org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [uk_pbj3u1nk9vnuof8f47utvowmv]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement

any suggestion ?

Thanks


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

On Fri, Sep 18, 2015 at 3:21 PM, jason.p.pickering 1483215@bugs.launchpad.net wrote:

** Changed in: dhis2

   Status: New => Fix Released

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:

Fix Released

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:
      at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:
      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](http://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
      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


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

Best Regards,
Furqonuddin Ramdhani

Salam
Furqonuddin Ramdhani