dhis2-devs team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

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@xxxxxxxxx>
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@xxxxxxxxxxxxxxxx> 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 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(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 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
>>>>
>>>>
>>>
>>
>> _______________________________________________
>> 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
>>
>>
>
> _______________________________________________
> 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
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>