Hi Morten,
I am using DHIS version 2.23 with the new importer. I am using two instances of DHIS for metadata sync. Whenever I make some changes to the admin user on one instance and sync into the other, the Sync fails and throws an exception. However, if I create a new user, and make modifications, the sync is successful (Throws no exceptions)
Is this a known issue?
Following is the Log trace for the exception:
- WARN 2016-03-28 14:55:14,258 SQL Error: 0, SQLState: 23505 (SqlExceptionHelper.java [qtp1727373358-379])
* ERROR 2016-03-28 14:55:14,258 ERROR: duplicate key value violates unique constraint “uk_ktwf16f728hce9ahtpmm7w5lx”
** Detail: Key (uid)=(ARhWqW6Lohm) already exists. (SqlExceptionHelper.java [qtp1727373358-379])**
* ERROR 2016-03-28 14:55:14,259 Exception occurred while trying to import the metadata. could not execute statement; SQL [n/a]; constraint [uk_ktwf16f728hce9ahtpmm7w5lx]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement (DefaultMetadataSyncService.java [qtp1727373358-379])
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [uk_ktwf16f728hce9ahtpmm7w5lx]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:163)
at org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:730)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:592)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at com.sun.proxy.$Proxy141.addVersion(Unknown Source)
at org.hisp.dhis.dxf2.metadata.sync.DefaultMetadataSyncService.doMetadataSync(DefaultMetadataSyncService.java:211)
at org.hisp.dhis.webapi.controller.metadata.sync.MetadataSyncController.metadataSync(MetadataSyncController.java:78)
at sun.reflect.GeneratedMethodAccessor1041.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:817)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:731)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
Could you please help fix this?
Thanks
···
Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533