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(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 >>> 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
