Hannan, That looks very much like the bug I picked up just before the Goa academy - it's caused by the fact that you have OrgUnit attributes with null values (if you have any other meta-data object with attribute records with null values it would be the same). I worked with Morten to track it down and fix it. If this is the same, it could be that update was lost, somehow (assuming your build is from ~30th April or later).
Build version don't tell me anything - what is the DATE of the 2.26 build you are using? Have you tried to update to the latest 2.26 build? Regards Calle On 6 June 2017 at 05:34, Hannan Khan <hann...@gmail.com> wrote: > Dear All > > We just upgrade nation instance form 22 to 26. Now we are facing an issue. > > When we trying to update a organization unit it cannot be saved. Log is > as follows. The build we are using is 8f9dc62 > > * WARN 2017-06-06 08:56:27,127 SQL Error: 0, SQLState: 23502 > (SqlExceptionHelper.java [http-nio-8080-exec-205]) > * ERROR 2017-06-06 08:56:27,128 ERROR: null value in column "property" > violates not-null constraint > Detail: Failing row contains (44356689, en_GB, null, UH & FWC/Union Sub > Centers(New)). (SqlExceptionHelper.java [http-nio-8080-exec-205]) > org.hibernate.exception.ConstraintViolationException: could not execute > statement > at org.hibernate.exception.internal.SQLStateConversionDelegate.convert( > SQLStateConversionDelegate.java:112) > at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert( > StandardSQLExceptionConverter.java:42) > at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert( > SqlExceptionHelper.java:111) > at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert( > SqlExceptionHelper.java:97) > at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate( > ResultSetReturnImpl.java:207) > at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch( > NonBatchingBatch.java:45) > at org.hibernate.persister.entity.AbstractEntityPersister.insert( > AbstractEntityPersister.java:2947) > at org.hibernate.persister.entity.AbstractEntityPersister.insert( > AbstractEntityPersister.java:3447) > at org.hibernate.action.internal.EntityInsertAction.execute( > EntityInsertAction.java:89) > at org.hibernate.engine.spi.ActionQueue.executeActions( > ActionQueue.java:582) > at org.hibernate.engine.spi.ActionQueue.executeActions( > ActionQueue.java:456) > at org.hibernate.event.internal.AbstractFlushingEventListener. > performExecutions(AbstractFlushingEventListener.java:337) > at org.hibernate.event.internal.DefaultFlushEventListener.onFlush( > DefaultFlushEventListener.java:39) > at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295) > at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService. > commit(DefaultObjectBundleService.java:167) > at sun.reflect.GeneratedMethodAccessor2719.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection > (AopUtils.java:333) > at org.springframework.aop.framework.ReflectiveMethodInvocation. > invokeJoinpoint(ReflectiveMethodInvocation.java:190) > at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:157) > at org.springframework.transaction.interceptor.TransactionInterceptor$1. > proceedWithInvocation(TransactionInterceptor.java:99) > at org.springframework.transaction.interceptor.TransactionAspectSupport. > invokeWithinTransaction(TransactionAspectSupport.java:282) > at org.springframework.transaction.interceptor. > TransactionInterceptor.invoke(TransactionInterceptor.java:96) > at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:179) > at org.springframework.aop.framework.JdkDynamicAopProxy. > invoke(JdkDynamicAopProxy.java:213) > at com.sun.proxy.$Proxy175.commit(Unknown Source) > at org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService. > importMetadata(DefaultMetadataImportService.java:127) > at sun.reflect.GeneratedMethodAccessor2712.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection > (AopUtils.java:333) > at org.springframework.aop.framework.ReflectiveMethodInvocation. > invokeJoinpoint(ReflectiveMethodInvocation.java:190) > at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:157) > at org.springframework.transaction.interceptor.TransactionInterceptor$1. > proceedWithInvocation(TransactionInterceptor.java:99) > at org.springframework.transaction.interceptor.TransactionAspectSupport. > invokeWithinTransaction(TransactionAspectSupport.java:282) > at org.springframework.transaction.interceptor. > TransactionInterceptor.invoke(TransactionInterceptor.java:96) > at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:179) > at org.springframework.aop.framework.JdkDynamicAopProxy. > invoke(JdkDynamicAopProxy.java:213) > at com.sun.proxy.$Proxy177.importMetadata(Unknown Source) > at org.hisp.dhis.webapi.controller.AbstractCrudController.putJsonObject( > AbstractCrudController.java:703) > at sun.reflect.GeneratedMethodAccessor2917.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:205) > at org.springframework.web.method.support.InvocableHandlerMethod. > invokeForRequest(InvocableHandlerMethod.java:133) > at org.springframework.web.servlet.mvc.method.annotation. > ServletInvocableHandlerMethod.invokeAndHandle( > ServletInvocableHandlerMethod.java:116) > at org.springframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.invokeHandlerMethod( > RequestMappingHandlerAdapter.java:827) > at org.springframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter. > java:738) > at org.springframework.web.servlet.mvc.method. > AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > at org.springframework.web.servlet.DispatcherServlet. > doDispatch(DispatcherServlet.java:963) > at org.springframework.web.servlet.DispatcherServlet. > doService(DispatcherServlet.java:897) > at org.springframework.web.servlet.FrameworkServlet.processRequest( > FrameworkServlet.java:970) > at org.springframework.web.servlet.FrameworkServlet. > doPut(FrameworkServlet.java:883) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:651) > at org.springframework.web.servlet.FrameworkServlet. > service(FrameworkServlet.java:846) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:292) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:207) > at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:240) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:207) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:330) > at org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) > at org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.access.ExceptionTranslationFilter. > doFilter(ExceptionTranslationFilter.java:113) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.session.SessionManagementFilter. > doFilter(SessionManagementFilter.java:103) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication. > AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter. > java:113) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.servletapi. > SecurityContextHolderAwareRequestFilter.doFilter( > SecurityContextHolderAwareRequestFilter.java:154) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.savedrequest.RequestCacheAwareFilter. > doFilter(RequestCacheAwareFilter.java:45) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication.www. > BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.hisp.dhis.security.filter.CorsFilter.doFilter(CorsFilter.java:126) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication. > AbstractAuthenticationProcessingFilter.doFilter( > AbstractAuthenticationProcessingFilter.java:199) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication. > AbstractAuthenticationProcessingFilter.doFilter( > AbstractAuthenticationProcessingFilter.java:199) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter( > CustomAuthenticationFilter.java:64) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.oauth2.provider.authentication. > OAuth2AuthenticationProcessingFilter.doFilter( > OAuth2AuthenticationProcessingFilter.java:140) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication.logout. > LogoutFilter.doFilter(LogoutFilter.java:110) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter( > AutomaticAccessFilter.java:115) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.header.HeaderWriterFilter. > doFilterInternal(HeaderWriterFilter.java:57) > at org.springframework.web.filter.OncePerRequestFilter. > doFilter(OncePerRequestFilter.java:107) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.context.request.async. > WebAsyncManagerIntegrationFilter.doFilterInternal( > WebAsyncManagerIntegrationFilter.java:50) > at org.springframework.web.filter.OncePerRequestFilter. > doFilter(OncePerRequestFilter.java:107) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.context.SecurityContextPersistenceFilt > er.doFilter(SecurityContextPersistenceFilter.java:87) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.FilterChainProxy.doFilterInternal( > FilterChainProxy.java:192) > at org.springframework.security.web.FilterChainProxy.doFilter( > FilterChainProxy.java:160) > at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate( > DelegatingFilterProxy.java:346) > at org.springframework.web.filter.DelegatingFilterProxy.doFilter( > DelegatingFilterProxy.java:262) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:240) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:207) > at org.hisp.dhis.servlet.filter.HttpUrlPatternFilter.doFilter( > HttpUrlPatternFilter.java:120) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:240) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:207) > at org.springframework.web.filter.ShallowEtagHeaderFilter. > doFilterInternal(ShallowEtagHeaderFilter.java:105) > at org.hisp.dhis.servlet.filter.ExcludableShallowEtagHeaderFil > ter.doFilterInternal(ExcludableShallowEtagHeaderFilter.java:112) > at org.springframework.web.filter.OncePerRequestFilter. > doFilter(OncePerRequestFilter.java:107) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:240) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:207) > at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter. > doFilterInternal(OpenSessionInViewFilter.java:151) > at org.springframework.web.filter.OncePerRequestFilter. > doFilter(OncePerRequestFilter.java:107) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:240) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:207) > at org.springframework.web.filter.CharacterEncodingFilter. > doFilterInternal(CharacterEncodingFilter.java:197) > at org.springframework.web.filter.OncePerRequestFilter. > doFilter(OncePerRequestFilter.java:107) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:240) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:207) > at org.apache.catalina.core.StandardWrapperValve.invoke( > StandardWrapperValve.java:213) > at org.apache.catalina.core.StandardContextValve.invoke( > StandardContextValve.java:106) > at org.apache.catalina.authenticator.AuthenticatorBase.invoke( > AuthenticatorBase.java:502) > at org.apache.catalina.core.StandardHostValve.invoke( > StandardHostValve.java:141) > at org.apache.catalina.valves.ErrorReportValve.invoke( > ErrorReportValve.java:79) > at org.apache.catalina.valves.AbstractAccessLogValve.invoke( > AbstractAccessLogValve.java:616) > at org.apache.catalina.core.StandardEngineValve.invoke( > StandardEngineValve.java:88) > at org.apache.catalina.connector.CoyoteAdapter.service( > CoyoteAdapter.java:522) > at org.apache.coyote.http11.AbstractHttp11Processor.process( > AbstractHttp11Processor.java:1095) > at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler. > process(AbstractProtocol.java:672) > at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor. > doRun(NioEndpoint.java:1504) > at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor. > run(NioEndpoint.java:1460) > at java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:617) > at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run( > TaskThread.java:61) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.postgresql.util.PSQLException: ERROR: null value in column > "property" violates not-null constraint > Detail: Failing row contains (44356689, en_GB, null, UH & FWC/Union Sub > Centers(New)). > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse( > QueryExecutorImpl.java:2455) > at org.postgresql.core.v3.QueryExecutorImpl.processResults( > QueryExecutorImpl.java:2155) > at org.postgresql.core.v3.QueryExecutorImpl.execute( > QueryExecutorImpl.java:288) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) > at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags( > PgPreparedStatement.java:168) > at org.postgresql.jdbc.PgPreparedStatement.executeUpdate( > PgPreparedStatement.java:135) > at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate( > NewProxyPreparedStatement.java:105) > at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate( > ResultSetReturnImpl.java:204) > ... 133 more > > Need urgent help. > > Regards > > Muhammad Abdul Hannan Khan > Team Leader > Support to the National HMIS > MIS, Director General of Health Service > Ministry of Health and Family Welfare > > T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118 > F +88 02 58813 875 > M+88 01819 239 241 > M+88 01534 312 066 > E hann...@gmail.com > S hannan.khan.dhaka > B hannan-tech.blogspot.com > L https://bd.linkedin.com/in/hannankhan > > > > > _______________________________________________ > 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 > > -- ******************************************* Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *******************************************
_______________________________________________ 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
