Unable to create a favourites on GIS module

Support - Assistance technique
1

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@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

2

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@thoughtworks.com 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.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@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

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

3

Hi Morten,

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

···

On Mon, Nov 7, 2016 at 7:04 AM, Morten Olav Hansen morten@dhis2.org 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)

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

–

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@thoughtworks.com 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.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@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

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

4

Hi Morten,

also we (PSI) are having the same problem. For some reason the uid is null when trying to save the favourite in the mapview table of the database.

Don’t know why it is working on the demo, but no in our database…

···

On Tue, Nov 8, 2016 at 12:11 PM, Archana Chillala archanac@thoughtworks.com wrote:

Hi Morten,

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

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

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

On Mon, Nov 7, 2016 at 7:04 AM, Morten Olav Hansen morten@dhis2.org 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@thoughtworks.com 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.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@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

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

5

Hi Archana and Jose,

are you able to privately share a login to the instances so that we can check it out?

regards,

Lars

···

On Tue, Nov 8, 2016 at 12:30 PM, Jose Garcia Muñoz josemp10@gmail.com wrote:

Hi Morten,

also we (PSI) are having the same problem. For some reason the uid is null when trying to save the favourite in the mapview table of the database.

Don’t know why it is working on the demo, but no in our database…

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

–

On Tue, Nov 8, 2016 at 12:11 PM, Archana Chillala archanac@thoughtworks.com wrote:

Hi Morten,

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

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

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

On Mon, Nov 7, 2016 at 7:04 AM, Morten Olav Hansen morten@dhis2.org 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@thoughtworks.com 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.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@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

6

Hi Lars, Morten,

any update on this? The issue is becoming really important now (We have a presentation in the Cambodia MoH tomorrow). This seems to happen only when we start a database from the scratch in 2.25. It is working fine when the database has been upgraded from previous versions.

Any quick comments will be highly appreciated.

thanks guys!

I’m copy the error again:

ERROR 2016-12-01 11:40:06,394 ERROR: null value in column “uid” violates not-null constraint

Detail: Failing row contains (15217, null, null, null, null, null, thematic1, 15218, f, f, f, null, null, null, null, null, 2, 5, ff0000, 00ff00, #ffffd4,#fed98e,#fe9929,#d95f0e,#993404, null, 5, 15, 0.800000000000000044, null, null, f, f, 11px, normal, normal, #000000, f, null, 0, null). (SqlExceptionHelper.java [http-apr-8081-exec-8])

  • ERROR 2016-12-01 11:40:06,395 HHH000346: Error during managed flush [could not execute statement] (SessionImpl.java [http-apr-8081-exec-8])
···

On Tue, Nov 8, 2016 at 12:30 PM, Jose Garcia Muñoz josemp10@gmail.com wrote:

Hi Morten,

also we (PSI) are having the same problem. For some reason the uid is null when trying to save the favourite in the mapview table of the database.

Don’t know why it is working on the demo, but no in our database…

On Tue, Nov 8, 2016 at 12:11 PM, Archana Chillala archanac@thoughtworks.com wrote:

Hi Morten,

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

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

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

On Mon, Nov 7, 2016 at 7:04 AM, Morten Olav Hansen morten@dhis2.org 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@thoughtworks.com 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.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@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

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

7

Hi Lars

We too are facing the same issue. We had configured an instance on 2.25 from scratch. We did talk to Bjorn about it, and he had raised a bug on JIRA for that as well.

This works fine on the demo instance.

Attached is the error that we get on console.

Thanks!

GIS error.txt (16.9 KB)

···

On Tue, Nov 8, 2016 at 12:30 PM, Jose Garcia Muñoz josemp10@gmail.com wrote:

Hi Morten,

also we (PSI) are having the same problem. For some reason the uid is null when trying to save the favourite in the mapview table of the database.

Don’t know why it is working on the demo, but no in our database…

On Tue, Nov 8, 2016 at 12:11 PM, Archana Chillala archanac@thoughtworks.com wrote:

Hi Morten,

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

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

Archana Chillala
Application Developer
Email
archanac@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

On Mon, Nov 7, 2016 at 7:04 AM, Morten Olav Hansen morten@dhis2.org 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@thoughtworks.com 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.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@thoughtworks.com
Telephone
+91 9100960533
ThoughtWorks

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