Thanks Morten, it works. Regards, Furqon
On Thu, Oct 8, 2015 at 8:51 AM, Morten Olav Hansen <[email protected]> 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 <[email protected]> > 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 < >> [email protected]> 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 : [email protected] >>> 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 : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > -- Salam *Furqonuddin Ramdhani*
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
