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 <josem...@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 < > 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] >> <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 <mor...@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 < >>> 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 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] >>>> <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@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >> >> _______________________________________________ >> 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: 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 l...@dhis2.org http://www.dhis2.org <https://www.dhis2.org/>
_______________________________________________ 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
