Re: [Dhis2-devs] Unable to create a favourites on GIS module

2016-12-01 Thread Saurabh 
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!

On Thu, Dec 1, 2016 at 5:23 PM Jose Garcia Muñoz  wrote:

>
> 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, ff,
> 00ff00, #d4,#fed98e,#fe9929,#d95f0e,#993404, null, 5, 15,
> 0.800044, null, null, f, f, 11px, normal, normal, #00, 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 
> 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 <
> archa...@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.
>
>
>
>
> Archana Chillala
> Application Developer
> Email archa...@thoughtworks.com
> Telephone +91 9100960533 <+91+9100960533>
> [image: ThoughtWorks]
> 
>
> On Mon, Nov 7, 2016 at 7:04 AM, Morten Olav Hansen 
> 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 <
> archa...@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
>

Re: [Dhis2-devs] Unable to create a favourites on GIS module

2016-12-01 Thread Jose Garcia Muñoz 
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, ff,
00ff00, #d4,#fed98e,#fe9929,#d95f0e,#993404, null, 5, 15,
0.800044, null, null, f, f, 11px, normal, normal, #00, 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 
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 <
> archa...@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.
>>
>>
>>
>>
>> Archana Chillala
>> Application Developer
>> Email archa...@thoughtworks.com
>> Telephone +91 9100960533 <+91+9100960533>
>> [image: ThoughtWorks]
>> 
>>
>> On Mon, Nov 7, 2016 at 7:04 AM, Morten Olav Hansen 
>> 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 <
>>> archa...@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.conve
 rtHibernateAccessException(SessionFactoryUtils.java:164)
 at org.springframework.orm.hibernate5.HibernateTransactionManag
 er.convertHibernateAccessException(HibernateTransactionManag
 er.java:741)
 at org.springframework.orm.hibernate5.HibernateTransactionManag
 er.doCommit(HibernateTransactionManager.java:589)
 at org.springframework.transaction.support.AbstractPlatformTran
 sactionManager.processCommit(AbstractPlatformTransactionMana
 ger.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

Re: [Dhis2-devs] Unable to create a favourites on GIS module

2016-11-17 Thread Lars Helge Øverland 
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 
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 <
> archa...@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.
>>
>>
>>
>>
>> Archana Chillala
>> Application Developer
>> Email archa...@thoughtworks.com
>> Telephone +91 9100960533 <+91+9100960533>
>> [image: ThoughtWorks]
>> 
>>
>> On Mon, Nov 7, 2016 at 7:04 AM, Morten Olav Hansen 
>> 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 <
>>> archa...@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.conve
 rtHibernateAccessException(SessionFactoryUtils.java:164)
 at org.springframework.orm.hibernate5.HibernateTransactionManag
 er.convertHibernateAccessException(HibernateTransactionManag
 er.java:741)
 at org.springframework.orm.hibernate5.HibernateTransactionManag
 er.doCommit(HibernateTransactionManager.java:589)
 at org.springframework.transaction.support.AbstractPlatformTran
 sactionManager.processCommit(AbstractPlatformTransactionMana
 ger.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

Re: [Dhis2-devs] Unable to create a favourites on GIS module

2016-11-08 Thread Jose Garcia Muñoz 
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  wrote:

> 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 archa...@thoughtworks.com
> Telephone +91 9100960533 <+91+9100960533>
> [image: ThoughtWorks]
> 
>
> On Mon, Nov 7, 2016 at 7:04 AM, Morten Olav Hansen 
> 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 <
>> archa...@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.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(AbstractPlatformTransactionMana
>>> ger.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
>>>

Re: [Dhis2-devs] Unable to create a favourites on GIS module

2016-11-08 Thread Archana Chillala 
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 archa...@thoughtworks.com
Telephone +91 9100960533 <+91+9100960533>
[image: ThoughtWorks]


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

Re: [Dhis2-devs] Unable to create a favourites on GIS module

2016-11-06 Thread Morten Olav Hansen 
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 
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 archa...@thoughtworks.com
> Telephone +91 9100960533 <+91+9100960533>
> [image: 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
>
>
___
Mailing list: