dhis2-devs team mailing list archive

[Hannan Khan <hannank@xxxxxxxxx>]

Thanks Viet.

I think this was the problem. After update, the problem is resolved.

Regards

Hannan

On Fri, Jun 9, 2017 at 9:43 AM, Viet Nguyen <viet@xxxxxxxxx> wrote:

> Hi Hannan,
>
> Currently we don't support property = 'comment' , I think it has the same
> meaning as 'description' ?
> If that is the case, can you run a query to update all of those records as
> below
>
> update objecttranslation set property = 'DESCRIPTION' where property = '
>> comment';
>
>
>
> On Fri, Jun 9, 2017 at 10:35 AM, Hannan Khan <hannank@xxxxxxxxx> wrote:
>
>> Dear Viet
>>
>> The first query output is 0.
>> second query output is in the attached. there are 3457 rows. I noticed
>> that in the 'organisationunit' table this 'type' has the same value. But
>> note that there are 19385 rows have null values in the 'type' column.
>>
>> Thank you for your kind effort.
>>
>> Regards
>>
>> Hannan
>>
>> On Fri, Jun 9, 2017 at 9:06 AM, Viet Nguyen <viet@xxxxxxxxx> wrote:
>>
>>> Hi Hannan,
>>>
>>> As discussed yesterday, I need more info to investigate this issue.
>>>
>>> Can you run the below queries in your upgraded database and send over
>>> the result.
>>>
>>> select count(*)  from objecttranslation where property is null;
>>>
>>> select * from objecttranslation where value like 'UH & FWC/Union Sub
>>> Centers(New)';
>>>
>>>
>>> On Thu, Jun 8, 2017 at 9:42 AM, Hannan Khan <hannank@xxxxxxxxx> wrote:
>>>
>>>> Thanks Viet.
>>>>
>>>> But there is no record in 'translation' with null value. II run the
>>>> query and outcome is null.
>>>>
>>>> But the problem persists.
>>>>
>>>> Need urgent help.
>>>>
>>>> Regards
>>>>
>>>> Hannan
>>>>
>>>> On Wed, Jun 7, 2017 at 3:10 PM, Viet Nguyen <viet@xxxxxxxxx> wrote:
>>>>
>>>>> Hi Hannan,
>>>>>
>>>>> I think this is caused by some invalid translation records in your
>>>>> database.
>>>>>
>>>>> Can you try to run the below query with the old database and then run
>>>>> the upgrade procedures again. Meanwhile I will try to add some null check
>>>>> conditions to the upgrade query to make sure this issue won't happen again.
>>>>>
>>>>> delete from translation where objectproperty is null;
>>>>>
>>>>>
>>>>> Regards,
>>>>>
>>>>> On Wed, Jun 7, 2017 at 9:58 AM, Hannan Khan <hannank@xxxxxxxxx> wrote:
>>>>>
>>>>>> Thanks a lot Calle and Morten. But how can I solve this.
>>>>>>
>>>>>> I got some clue form your mail, will check and get back to you within
>>>>>> few hours (stupid meetings!!).
>>>>>>
>>>>>> Regards
>>>>>>
>>>>>> Hannan
>>>>>>
>>>>>>
>>>>>> On Tue, Jun 6, 2017 at 1:25 PM, Calle Hedberg <
>>>>>> calle.hedberg@xxxxxxxxx> wrote:
>>>>>>
>>>>>>> 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 <hannank@xxxxxxxxx> 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.StandardSQLExceptionConvert
>>>>>>>> er.convert(StandardSQLExceptionConverter.java:42)
>>>>>>>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>>>>>>>> ExceptionHelper.java:111)
>>>>>>>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>>>>>>>> ExceptionHelper.java:97)
>>>>>>>> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.execu
>>>>>>>> teUpdate(ResultSetReturnImpl.java:207)
>>>>>>>> at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.ad
>>>>>>>> dToBatch(NonBatchingBatch.java:45)
>>>>>>>> at org.hibernate.persister.entity.AbstractEntityPersister.inser
>>>>>>>> t(AbstractEntityPersister.java:2947)
>>>>>>>> at org.hibernate.persister.entity.AbstractEntityPersister.inser
>>>>>>>> t(AbstractEntityPersister.java:3447)
>>>>>>>> at org.hibernate.action.internal.EntityInsertAction.execute(Ent
>>>>>>>> ityInsertAction.java:89)
>>>>>>>> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu
>>>>>>>> eue.java:582)
>>>>>>>> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu
>>>>>>>> eue.java:456)
>>>>>>>> at org.hibernate.event.internal.AbstractFlushingEventListener.p
>>>>>>>> erformExecutions(AbstractFlushingEventListener.java:337)
>>>>>>>> at org.hibernate.event.internal.DefaultFlushEventListener.onFlu
>>>>>>>> sh(DefaultFlushEventListener.java:39)
>>>>>>>> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
>>>>>>>> at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundle
>>>>>>>> Service.commit(DefaultObjectBundleService.java:167)
>>>>>>>> at sun.reflect.GeneratedMethodAccessor2719.invoke(Unknown Source)
>>>>>>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>>>>>>>> thodAccessorImpl.java:43)
>>>>>>>> at java.lang.reflect.Method.invoke(Method.java:498)
>>>>>>>> at org.springframework.aop.support.AopUtils.invokeJoinpointUsin
>>>>>>>> gReflection(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.TransactionInter
>>>>>>>> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>>>>>>>> at org.springframework.transaction.interceptor.TransactionAspec
>>>>>>>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
>>>>>>>> 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.framework.JdkDynamicAopProxy.invoke(
>>>>>>>> JdkDynamicAopProxy.java:213)
>>>>>>>> at com.sun.proxy.$Proxy175.commit(Unknown Source)
>>>>>>>> at org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.imp
>>>>>>>> ortMetadata(DefaultMetadataImportService.java:127)
>>>>>>>> at sun.reflect.GeneratedMethodAccessor2712.invoke(Unknown Source)
>>>>>>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>>>>>>>> thodAccessorImpl.java:43)
>>>>>>>> at java.lang.reflect.Method.invoke(Method.java:498)
>>>>>>>> at org.springframework.aop.support.AopUtils.invokeJoinpointUsin
>>>>>>>> gReflection(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.TransactionInter
>>>>>>>> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>>>>>>>> at org.springframework.transaction.interceptor.TransactionAspec
>>>>>>>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
>>>>>>>> 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.framework.JdkDynamicAopProxy.invoke(
>>>>>>>> JdkDynamicAopProxy.java:213)
>>>>>>>> at com.sun.proxy.$Proxy177.importMetadata(Unknown Source)
>>>>>>>> at org.hisp.dhis.webapi.controller.AbstractCrudController.putJs
>>>>>>>> onObject(AbstractCrudController.java:703)
>>>>>>>> at sun.reflect.GeneratedMethodAccessor2917.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:205)
>>>>>>>> at org.springframework.web.method.support.InvocableHandlerMetho
>>>>>>>> d.invokeForRequest(InvocableHandlerMethod.java:133)
>>>>>>>> at org.springframework.web.servlet.mvc.method.annotation.Servle
>>>>>>>> tInvocableHandlerMethod.invokeAndHandle(ServletInvocableHand
>>>>>>>> lerMethod.java:116)
>>>>>>>> at org.springframework.web.servlet.mvc.method.annotation.Reques
>>>>>>>> tMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHan
>>>>>>>> dlerAdapter.java:827)
>>>>>>>> at org.springframework.web.servlet.mvc.method.annotation.Reques
>>>>>>>> tMappingHandlerAdapter.handleInternal(RequestMappingHandlerA
>>>>>>>> dapter.java:738)
>>>>>>>> at org.springframework.web.servlet.mvc.method.AbstractHandlerMe
>>>>>>>> thodAdapter.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.processRequ
>>>>>>>> est(FrameworkServlet.java:970)
>>>>>>>> at org.springframework.web.servlet.FrameworkServlet.doPut(Frame
>>>>>>>> workServlet.java:883)
>>>>>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:651)
>>>>>>>> at org.springframework.web.servlet.FrameworkServlet.service(Fra
>>>>>>>> meworkServlet.java:846)
>>>>>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
>>>>>>>> lter(ApplicationFilterChain.java:292)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
>>>>>>>> licationFilterChain.java:207)
>>>>>>>> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilte
>>>>>>>> r.java:52)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
>>>>>>>> lter(ApplicationFilterChain.java:240)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
>>>>>>>> licationFilterChain.java:207)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:330)
>>>>>>>> at org.springframework.security.web.access.intercept.FilterSecu
>>>>>>>> rityInterceptor.invoke(FilterSecurityInterceptor.java:118)
>>>>>>>> at org.springframework.security.web.access.intercept.FilterSecu
>>>>>>>> rityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.access.ExceptionTranslation
>>>>>>>> Filter.doFilter(ExceptionTranslationFilter.java:113)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.session.SessionManagementFi
>>>>>>>> lter.doFilter(SessionManagementFilter.java:103)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.authentication.AnonymousAut
>>>>>>>> henticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.servletapi.SecurityContextH
>>>>>>>> olderAwareRequestFilter.doFilter(SecurityContextHolderAwareR
>>>>>>>> equestFilter.java:154)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.savedrequest.RequestCacheAw
>>>>>>>> areFilter.doFilter(RequestCacheAwareFilter.java:45)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.authentication.www.BasicAut
>>>>>>>> henticationFilter.doFilter(BasicAuthenticationFilter.java:150)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.hisp.dhis.security.filter.CorsFilter.doFilter(CorsFilter
>>>>>>>> .java:126)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.authentication.AbstractAuth
>>>>>>>> enticationProcessingFilter.doFilter(AbstractAuthenticationPr
>>>>>>>> ocessingFilter.java:199)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.authentication.AbstractAuth
>>>>>>>> enticationProcessingFilter.doFilter(AbstractAuthenticationPr
>>>>>>>> ocessingFilter.java:199)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.hisp.dhis.security.filter.CustomAuthenticationFilter.doF
>>>>>>>> ilter(CustomAuthenticationFilter.java:64)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.oauth2.provider.authentication.
>>>>>>>> OAuth2AuthenticationProcessingFilter.doFilter(OAuth2Authenti
>>>>>>>> cationProcessingFilter.java:140)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.authentication.logout.Logou
>>>>>>>> tFilter.doFilter(LogoutFilter.java:110)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter
>>>>>>>> (AutomaticAccessFilter.java:115)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.header.HeaderWriterFilter.d
>>>>>>>> oFilterInternal(HeaderWriterFilter.java:57)
>>>>>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>>>>>> (OncePerRequestFilter.java:107)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.context.request.async.WebAs
>>>>>>>> yncManagerIntegrationFilter.doFilterInternal(WebAsyncManager
>>>>>>>> IntegrationFilter.java:50)
>>>>>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>>>>>> (OncePerRequestFilter.java:107)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.context.SecurityContextPers
>>>>>>>> istenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
>>>>>>>> at org.springframework.security.web.FilterChainProxy$VirtualFil
>>>>>>>> terChain.doFilter(FilterChainProxy.java:342)
>>>>>>>> at org.springframework.security.web.FilterChainProxy.doFilterIn
>>>>>>>> ternal(FilterChainProxy.java:192)
>>>>>>>> at org.springframework.security.web.FilterChainProxy.doFilter(F
>>>>>>>> ilterChainProxy.java:160)
>>>>>>>> at org.springframework.web.filter.DelegatingFilterProxy.invokeD
>>>>>>>> elegate(DelegatingFilterProxy.java:346)
>>>>>>>> at org.springframework.web.filter.DelegatingFilterProxy.doFilte
>>>>>>>> r(DelegatingFilterProxy.java:262)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
>>>>>>>> lter(ApplicationFilterChain.java:240)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
>>>>>>>> licationFilterChain.java:207)
>>>>>>>> at org.hisp.dhis.servlet.filter.HttpUrlPatternFilter.doFilter(H
>>>>>>>> ttpUrlPatternFilter.java:120)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
>>>>>>>> lter(ApplicationFilterChain.java:240)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
>>>>>>>> licationFilterChain.java:207)
>>>>>>>> at org.springframework.web.filter.ShallowEtagHeaderFilter.doFil
>>>>>>>> terInternal(ShallowEtagHeaderFilter.java:105)
>>>>>>>> at org.hisp.dhis.servlet.filter.ExcludableShallowEtagHeaderFilt
>>>>>>>> er.doFilterInternal(ExcludableShallowEtagHeaderFilter.java:112)
>>>>>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>>>>>> (OncePerRequestFilter.java:107)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
>>>>>>>> lter(ApplicationFilterChain.java:240)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
>>>>>>>> licationFilterChain.java:207)
>>>>>>>> at org.springframework.orm.hibernate5.support.OpenSessionInView
>>>>>>>> Filter.doFilterInternal(OpenSessionInViewFilter.java:151)
>>>>>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>>>>>> (OncePerRequestFilter.java:107)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
>>>>>>>> lter(ApplicationFilterChain.java:240)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
>>>>>>>> licationFilterChain.java:207)
>>>>>>>> at org.springframework.web.filter.CharacterEncodingFilter.doFil
>>>>>>>> terInternal(CharacterEncodingFilter.java:197)
>>>>>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>>>>>> (OncePerRequestFilter.java:107)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
>>>>>>>> lter(ApplicationFilterChain.java:240)
>>>>>>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
>>>>>>>> licationFilterChain.java:207)
>>>>>>>> at org.apache.catalina.core.StandardWrapperValve.invoke(Standar
>>>>>>>> dWrapperValve.java:213)
>>>>>>>> at org.apache.catalina.core.StandardContextValve.invoke(Standar
>>>>>>>> dContextValve.java:106)
>>>>>>>> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(A
>>>>>>>> uthenticatorBase.java:502)
>>>>>>>> at org.apache.catalina.core.StandardHostValve.invoke(StandardHo
>>>>>>>> stValve.java:141)
>>>>>>>> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo
>>>>>>>> rtValve.java:79)
>>>>>>>> at org.apache.catalina.valves.AbstractAccessLogValve.invoke(Abs
>>>>>>>> tractAccessLogValve.java:616)
>>>>>>>> at org.apache.catalina.core.StandardEngineValve.invoke(Standard
>>>>>>>> EngineValve.java:88)
>>>>>>>> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd
>>>>>>>> apter.java:522)
>>>>>>>> at org.apache.coyote.http11.AbstractHttp11Processor.process(Abs
>>>>>>>> tractHttp11Processor.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(N
>>>>>>>> ioEndpoint.java:1460)
>>>>>>>> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
>>>>>>>> Executor.java:1142)
>>>>>>>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
>>>>>>>> lExecutor.java:617)
>>>>>>>> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.r
>>>>>>>> un(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.receiveErrorRespons
>>>>>>>> e(QueryExecutorImpl.java:2455)
>>>>>>>> at org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer
>>>>>>>> yExecutorImpl.java:2155)
>>>>>>>> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut
>>>>>>>> orImpl.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(PgP
>>>>>>>> reparedStatement.java:168)
>>>>>>>> at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPrep
>>>>>>>> aredStatement.java:135)
>>>>>>>> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUp
>>>>>>>> date(NewProxyPreparedStatement.java:105)
>>>>>>>> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.execu
>>>>>>>> teUpdate(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 hannank@xxxxxxxxx
>>>>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>>>>>>> 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 <+27%2021%20685%206472>
>>>>>>>
>>>>>>> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>>>>>>>
>>>>>>> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>>>>>>>
>>>>>>> Email: calle.hedberg@xxxxxxxxx
>>>>>>>
>>>>>>> Skype: calle_hedberg
>>>>>>>
>>>>>>> *******************************************
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> 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 hannank@xxxxxxxxx
>>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> Viet Nguyen
>>>>> Software Developer, DHIS 2
>>>>> University of Oslo
>>>>> http://www.dhis2.org
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> 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 hannank@xxxxxxxxx
>>>> S hannan.khan.dhaka
>>>> B hannan-tech.blogspot.com
>>>> L https://bd.linkedin.com/in/hannankhan
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>>
>>> Viet Nguyen
>>> Software Developer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>>
>>>
>>
>>
>> --
>> 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 hannank@xxxxxxxxx
>> S hannan.khan.dhaka
>> B hannan-tech.blogspot.com
>> L https://bd.linkedin.com/in/hannankhan
>>
>>
>>
>>
>
>
> --
>
> Viet Nguyen
> Software Developer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
>
>


-- 
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, 58816412 ext 118
F +88 02 58813 875
M+88 01819 239 241
M+88 01534 312 066
E hannank@xxxxxxxxx
S hannan.khan.dhaka
B hannan-tech.blogspot.com
L https://bd.linkedin.com/in/hannankhan