dhis2-devs team mailing list archive

[Morten Olav Hansen <morten@xxxxxxxxx>]

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
>
>