dhis2-devs team mailing list archive

[Archana Chillala <archanac@xxxxxxxxxxxxxxxx>]

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.convertHibernateAccessException(SessionFactoryUtils.java:164)
at
org.springframework.orm.hibernate5.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:741)
at
org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:589)
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.interceptor.ExposeInvocationInterceptor.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.postJsonObject(MapController.java:129)
at sun.reflect.GeneratedMethodAccessor1850.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
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)


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>