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 <[email protected]> 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 _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
