dhis2-devs team mailing list archive

[Morten Olav Hansen <morten@xxxxxxxxx>]

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 <archanac@xxxxxxxxxxxxxxxx
> 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": "nalinim@xxxxxxxxxxxxxxxx",
>      "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 archanac@xxxxxxxxxxxxxxxx
> 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 <
> archanac@xxxxxxxxxxxxxxxx> 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 archanac@xxxxxxxxxxxxxxxx
>> 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>
>>
>
>