Hi Archana I think is at least a little related to a few fixes I just did. Please note that if you are using the admin user, you need to make sure that also userCredentials.id is set to a static id (auto-generated on empty databases) KvMx6c1eoYo
That said, I was never able to replicate your exact issue.. -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Mon, Mar 28, 2016 at 6:08 PM, Archana Chillala <archa...@thoughtworks.com > wrote: > Here's a sample payload for the issue mentioned. > > > { > "date": "2016-03-28T09:25:10.323+0000", > "users": [ > { > "code": "admin", > "created": "2016-03-22T11:02:03.749+0000", > "lastUpdated": "2016-03-28T09:25:06.034+0000", > "id": "M5zQapPyTZI", > "firstName": "admin", > "surname": "admin", > "email": "nali...@thoughtworks.com", > "userCredentials": { > "code": "admin", > "created": "2016-03-22T11:02:03.787+0000", > "lastUpdated": "2016-03-28T09:25:06.032+0000", > "id": "Cexdz32gWas", > "lastLogin": "2016-03-22T11:02:03.787+0000", > "passwordLastUpdated": "2016-03-22T11:02:03.788+0000", > "invitation": false, > "externalAuth": false, > "selfRegistered": false, > "disabled": false, > "username": "admin", > "userInfo": { > "id": "M5zQapPyTZI" > }, > "user": { > "id": "M5zQapPyTZI" > }, > "cogsDimensionConstraints": [], > "catDimensionConstraints": [], > "userRoles": [ > { > "id": "yrB6vc5Ip3r" > } > ] > }, > "attributeValues": [], > "teiSearchOrganisationUnits": [], > "organisationUnits": [ > { > "id": "nRFBGboJZ76" > } > ], > "dataViewOrganisationUnits": [] > } > ] > } > > Archana Chillala > Application Developer > Email archa...@thoughtworks.com > Telephone +91 9100960533 <+91+9100960533> > [image: ThoughtWorks] > <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator> > > On Mon, Mar 28, 2016 at 4:29 PM, Archana Chillala < > archa...@thoughtworks.com> wrote: > >> 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 archa...@thoughtworks.com >> Telephone +91 9100960533 <+91+9100960533> >> [image: ThoughtWorks] >> <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator> >> > >
_______________________________________________ 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