dhis2-devs team mailing list archive

[Archana Chillala <archanac@xxxxxxxxxxxxxxxx>]

Hi Morten,

You're right, it works fine on the play server, but not on our machines.
Not sure of the reason, though.




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, Nov 7, 2016 at 7:04 AM, Morten Olav Hansen <morten@xxxxxxxxx> wrote:

> Hi Archana
>
> Seems to work fine on the play/demo server, but maybe you have a certain
> config that doesn't work.
>
> Can you try and reproduce on [1] and give us the steps back?
>
> [1] https://play.dhis2.org/demo (admin/district)
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Fri, Nov 4, 2016 at 7:18 PM, Archana Chillala <
> archanac@xxxxxxxxxxxxxxxx> wrote:
>
>> Hi,
>>
>> We are using the latest version of DHIS 2.25 (build - 5e16867).
>> We are trying to create a favourite on GIS module, but it does not get
>> created. Following is the exception it throws in the logs.
>>
>>
>> * INFO  2016-11-03 11:43:07,115 'admin' create org.hisp.dhis.mapping.Map,
>> name: amsterdam location, uid: c9wq3KMvvuy (AuditLogUtil.java
>> [http-bio-8080-exec-2])
>> * WARN  2016-11-03 11:43:07,131 SQL Error: 0, SQLState: 23502
>> (SqlExceptionHelper.java [http-bio-8080-exec-2])
>> * *ERROR 2016-11-03 11:43:07,133 ERROR: null value in column "uid"
>> violates not-null constraint*
>> *  Detail: Failing row contains (369, null, null, null, null, boundary,
>> null, f, f, f, null, null, null, null, null, null, null, null, null, null,
>> 5, null, 1, null, null, f, f, 11px, null, normal, null, f, null, 0, null,
>> null, null). (SqlExceptionHelper.java [http-bio-8080-exec-2])*
>> * ERROR 2016-11-03 11:43:07,134 HHH000346: Error during managed flush
>> [could not execute statement] (SessionImpl.java [http-bio-8080-exec-2])
>> org.springframework.dao.DataIntegrityViolationException: could not
>> execute statement; SQL [n/a]; constraint [uid]; nested exception is
>> org.hibernate.exception.ConstraintViolationException: could not execute
>> statement
>> at org.springframework.orm.hibernate5.SessionFactoryUtils.conve
>> rtHibernateAccessException(SessionFactoryUtils.java:164)
>> at org.springframework.orm.hibernate5.HibernateTransactionManag
>> er.convertHibernateAccessException(HibernateTransactionManager.java:741)
>> at org.springframework.orm.hibernate5.HibernateTransactionManag
>> er.doCommit(HibernateTransactionManager.java:589)
>> at org.springframework.transaction.support.AbstractPlatformTran
>> sactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
>> at org.springframework.transaction.support.AbstractPlatformTran
>> sactionManager.commit(AbstractPlatformTransactionManager.java:730)
>> at org.springframework.transaction.interceptor.TransactionAspec
>> tSupport.commitTransactionAfterReturning(TransactionAspectSu
>> pport.java:485)
>> at org.springframework.transaction.interceptor.TransactionAspec
>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
>> at org.springframework.transaction.interceptor.TransactionInter
>> ceptor.invoke(TransactionInterceptor.java:96)
>> at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:179)
>> at org.springframework.aop.interceptor.ExposeInvocationIntercep
>> tor.invoke(ExposeInvocationInterceptor.java:92)
>> at org.springframework.aop.framework.ReflectiveMethodInvocation
>> .proceed(ReflectiveMethodInvocation.java:179)
>> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>> JdkDynamicAopProxy.java:208)
>> at com.sun.proxy.$Proxy130.addMap(Unknown Source)
>> at org.hisp.dhis.webapi.controller.mapping.MapController.postJs
>> onObject(MapController.java:129)
>> at sun.reflect.GeneratedMethodAccessor1850.invoke(Unknown Source)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>> thodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:498)
>> at org.springframework.web.method.support.InvocableHandlerMetho
>> d.doInvoke(InvocableHandlerMethod.java:221)
>> at org.springframework.web.method.support.InvocableHandlerMetho
>> d.invokeForRequest(InvocableHandlerMethod.java:136)
>> at org.springframework.web.servlet.mvc.method.annotation.Servle
>> tInvocableHandlerMethod.invokeAndHandle(ServletInvocableHand
>> lerMethod.java:110)
>> at org.springframework.web.servlet.mvc.method.annotation.Reques
>> tMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHan
>> dlerAdapter.java:817)
>> at org.springframework.web.servlet.mvc.method.annotation.Reques
>> tMappingHandlerAdapter.handleInternal(RequestMappingHandlerA
>> dapter.java:731)
>> at org.springframework.web.servlet.mvc.method.AbstractHandlerMe
>> thodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
>>
>>
>> Could you help fix the issue?
>>
>>
>> *Cheers,*
>>
>> 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>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>