dhis2-devs team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

Thanks, that works.

Lars

On Oct 21, 2016 5:28 PM, "Alan Hill" <ahill@xxxxxxxxxx> wrote:

> Hi Lars
>
> Many thanks for the response.
>
> I could recreate the database locally and then share a copy of the db with
> you on dropbox?  Would that work?
>
> Kind regards
>
> Alan
>
>
> On Thu, Oct 20, 2016 at 11:48 PM, Lars Helge Øverland <lars@xxxxxxxxx>
> wrote:
>
>> Hi Alan,
>>
>> okay. I think I need to have a look at the db to sort this one out. Are
>> you able to share a login to the server (dhis and ssh) privately ?
>>
>> best regards,
>>
>> Lars
>>
>>
>> On Fri, Oct 21, 2016 at 12:34 AM, Alan Hill <ahill@xxxxxxxxxx> wrote:
>>
>>> Hi there
>>>
>>> Just resurrecting this one....maybe it's been fixed in 2.24 / 2.25?
>>>
>>> Thanks
>>>
>>> Alan
>>>
>>>
>>> On Wed, Sep 21, 2016 at 12:19 PM, Alan Hill <ahill@xxxxxxxxxx> wrote:
>>>
>>>> Hi there
>>>>
>>>> We're having a small issue in 2.23 with the Pivot Table.
>>>>
>>>> We create our metadata for programs and program stages and then import
>>>> data through our custom import app using the web API.
>>>>
>>>> Then if we go into Pivot Table for the Program / Event Data Items and
>>>> click 'Update', the page hangs with 'Loading...'   We get the error below
>>>> in our Tomcat logs:
>>>>
>>>> * INFO  2016-09-21 11:46:46,715 'admin' create
>>>> org.hisp.dhis.program.ProgramDataElement, name: MALAWI 2010 (6) MALAWI
>>>> 2010 (6) WM - ever participated in a literacy program outside of primary,
>>>> uid: BKGvXg1sV5l (AuditLogUtil.java [qtp219396780-43])
>>>> ** INFO  2016-09-21 11:46:46,727 'admin' create
>>>> org.hisp.dhis.program.ProgramDataElement, name: MALAWI 2010 (6) MALAWI 2010
>>>> (6) BR - Intermittent preventive treatment for malaria during pregnancy,
>>>> uid: R3XNjq83Was (AuditLogUtil.java [qtp219396780-15])*
>>>> ** INFO  2016-09-21 11:46:46,727 'admin' create
>>>> org.hisp.dhis.program.ProgramDataElement, name: MALAWI 2010 (6) MALAWI 2010
>>>> (6) BR - Intermittent preventive treatment for malaria during pregnancy,
>>>> uid: e6bsk7HlMFZ (AuditLogUtil.java [qtp219396780-43])*
>>>> * INFO  2016-09-21 11:46:46,740 'admin' create
>>>> org.hisp.dhis.program.ProgramDataElement, name: MALAWI 2010 (6) MALAWI
>>>> 2010 (6) BR - month of birth, uid: gJ23iAx6HVg (AuditLogUtil.java
>>>> [qtp219396780-15])
>>>> * WARN  2016-09-21 11:46:46,740 SQL Error: 0, SQLState: 23505
>>>> (SqlExceptionHelper.java [qtp219396780-43])
>>>> ** ERROR 2016-09-21 11:46:46,741 ERROR: duplicate key value violates
>>>> unique constraint "programdataelement_unique_key"*
>>>> *  Detail: Key (programid, dataelementid)=(12372, 13027) already
>>>> exists. (SqlExceptionHelper.java [qtp219396780-43])*
>>>> 2016-09-21 11:46:46.770:WARN:oejs.ServletHandler:qtp219396780-43:
>>>> org.springframework.web.util.NestedServletException: Request
>>>> processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:
>>>> could not execute statement; SQL [n/a]; constraint
>>>> [programdataelement_unique_key]; nested exception is
>>>> org.hibernate.exception.ConstraintViolationException: could not
>>>> execute statement
>>>> at org.springframework.web.servlet.FrameworkServlet.processRequ
>>>> est(FrameworkServlet.java:980)
>>>> at org.springframework.web.servlet.FrameworkServlet.doGet(Frame
>>>> workServlet.java:859)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
>>>> at org.springframework.web.servlet.FrameworkServlet.service(Fra
>>>> meworkServlet.java:844)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
>>>> at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder
>>>> .java:800)
>>>> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1669)
>>>> 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:90)
>>>> 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.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1652)
>>>> at org.springframework.web.filter.ShallowEtagHeaderFilter.doFil
>>>> terInternal(ShallowEtagHeaderFilter.java:87)
>>>> at org.hisp.dhis.servlet.filter.ExcludableShallowEtagHeaderFilt
>>>> er.doFilterInternal(ExcludableShallowEtagHeaderFilter.java:102)
>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>> (OncePerRequestFilter.java:107)
>>>> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1652)
>>>> at org.springframework.orm.hibernate4.support.OpenSessionInView
>>>> Filter.doFilterInternal(OpenSessionInViewFilter.java:151)
>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>> (OncePerRequestFilter.java:107)
>>>> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1652)
>>>> at org.springframework.web.filter.CharacterEncodingFilter.doFil
>>>> terInternal(CharacterEncodingFilter.java:121)
>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>> (OncePerRequestFilter.java:107)
>>>> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1652)
>>>> at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHan
>>>> dler.java:585)
>>>> at org.eclipse.jetty.server.handler.ScopedHandler.handle(Scoped
>>>> Handler.java:143)
>>>> at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHa
>>>> ndler.java:577)
>>>> at org.eclipse.jetty.server.session.SessionHandler.doHandle(Ses
>>>> sionHandler.java:223)
>>>> at org.eclipse.jetty.server.handler.ContextHandler.doHandle(Con
>>>> textHandler.java:1127)
>>>> at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHand
>>>> ler.java:515)
>>>> at org.eclipse.jetty.server.session.SessionHandler.doScope(Sess
>>>> ionHandler.java:185)
>>>> at org.eclipse.jetty.server.handler.ContextHandler.doScope(Cont
>>>> extHandler.java:1061)
>>>> at org.eclipse.jetty.server.handler.ScopedHandler.handle(Scoped
>>>> Handler.java:141)
>>>> at org.eclipse.jetty.server.handler.ContextHandlerCollection.ha
>>>> ndle(ContextHandlerCollection.java:215)
>>>> at org.eclipse.jetty.server.handler.HandlerCollection.handle(Ha
>>>> ndlerCollection.java:110)
>>>> at org.eclipse.jetty.server.handler.HandlerWrapper.handle(Handl
>>>> erWrapper.java:97)
>>>> at org.eclipse.jetty.server.Server.handle(Server.java:497)
>>>> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
>>>> at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConne
>>>> ction.java:245)
>>>> at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnec
>>>> tion.java:540)
>>>> * INFO  2016-09-21 11:46:46,813 'admin' create
>>>> org.hisp.dhis.program.ProgramDataElement, name: MALAWI 2010 (6) MALAWI
>>>> 2010 (6) BR - ORS for diarrhea, uid: ZR6t6HZO5bJ (AuditLogUtil.java
>>>> [qtp219396780-15])
>>>> at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(Queued
>>>> ThreadPool.java:635)
>>>> at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedT
>>>> hreadPool.java:555)
>>>> at java.lang.Thread.run(Thread.java:745)
>>>> Caused by:
>>>> org.springframework.dao.DataIntegrityViolationException: could not
>>>> execute statement; SQL [n/a]; constraint [programdataelement_unique_key];
>>>> nested exception is org.hibernate.exception.ConstraintViolationException:
>>>> could not execute statement
>>>> at org.springframework.orm.hibernate4.SessionFactoryUtils.conve
>>>> rtHibernateAccessException(SessionFactoryUtils.java:163)
>>>> at org.springframework.orm.hibernate4.HibernateTransactionManag
>>>> er.convertHibernateAccessException(HibernateTransactionManag
>>>> er.java:730)
>>>> at org.springframework.orm.hibernate4.HibernateTransactionManag
>>>> er.doCommit(HibernateTransactionManager.java:592)
>>>> 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.$Proxy55.getOrAddProgramDataElement(Unknown Source)
>>>> at org.hisp.dhis.dimension.DefaultDimensionService.getOrAddData
>>>> DimensionalItemObject(DefaultDimensionService.java:355)
>>>> at org.hisp.dhis.analytics.data.DefaultDataQueryService.getDime
>>>> nsion(DefaultDataQueryService.java:256)
>>>> at org.hisp.dhis.analytics.data.DefaultDataQueryService.getDime
>>>> nsionalObjects(DefaultDataQueryService.java:209)
>>>> at org.hisp.dhis.analytics.data.DefaultDataQueryService.getFrom
>>>> Url(DefaultDataQueryService.java:130)
>>>> at org.hisp.dhis.webapi.controller.AnalyticsController.getJson(
>>>> AnalyticsController.java:108)
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
>>>> ssorImpl.java:62)
>>>> 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)
>>>> at org.springframework.web.servlet.DispatcherServlet.doDispatch
>>>> (DispatcherServlet.java:959)
>>>> at org.springframework.web.servlet.DispatcherServlet.doService(
>>>> DispatcherServlet.java:893)
>>>> at org.springframework.web.servlet.FrameworkServlet.processRequ
>>>> est(FrameworkServlet.java:968)
>>>> at org.springframework.web.servlet.FrameworkServlet.doGet(Frame
>>>> workServlet.java:859)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
>>>> at org.springframework.web.servlet.FrameworkServlet.service(Fra
>>>> meworkServlet.java:844)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
>>>> at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder
>>>> .java:800)
>>>> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1669)
>>>> 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:90)
>>>> 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.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1652)
>>>> at org.springframework.web.filter.ShallowEtagHeaderFilter.doFil
>>>> terInternal(ShallowEtagHeaderFilter.java:87)
>>>> at org.hisp.dhis.servlet.filter.ExcludableShallowEtagHeaderFilt
>>>> er.doFilterInternal(ExcludableShallowEtagHeaderFilter.java:102)
>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>> (OncePerRequestFilter.java:107)
>>>> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1652)
>>>> at org.springframework.orm.hibernate4.support.OpenSessionInView
>>>> Filter.doFilterInternal(OpenSessionInViewFilter.java:151)
>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>> (OncePerRequestFilter.java:107)
>>>> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1652)
>>>> at org.springframework.web.filter.CharacterEncodingFilter.doFil
>>>> terInternal(CharacterEncodingFilter.java:121)
>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>> (OncePerRequestFilter.java:107)
>>>> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1652)
>>>> at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHan
>>>> dler.java:585)
>>>> at org.eclipse.jetty.server.handler.ScopedHandler.handle(Scoped
>>>> Handler.java:143)
>>>> at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHa
>>>> ndler.java:577)
>>>> at org.eclipse.jetty.server.session.SessionHandler.doHandle(Ses
>>>> sionHandler.java:223)
>>>> at org.eclipse.jetty.server.handler.ContextHandler.doHandle(Con
>>>> textHandler.java:1127)
>>>> at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHand
>>>> ler.java:515)
>>>> at org.eclipse.jetty.server.session.SessionHandler.doScope(Sess
>>>> ionHandler.java:185)
>>>> at org.eclipse.jetty.server.handler.ContextHandler.doScope(Cont
>>>> extHandler.java:1061)
>>>> at org.eclipse.jetty.server.handler.ScopedHandler.handle(Scoped
>>>> Handler.java:141)
>>>> at org.eclipse.jetty.server.handler.ContextHandlerCollection.ha
>>>> ndle(ContextHandlerCollection.java:215)
>>>> at org.eclipse.jetty.server.handler.HandlerCollection.handle(Ha
>>>> ndlerCollection.java:110)
>>>> at org.eclipse.jetty.server.handler.HandlerWrapper.handle(Handl
>>>> erWrapper.java:97)
>>>> at org.eclipse.jetty.server.Server.handle(Server.java:497)
>>>> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
>>>> at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConne
>>>> ction.java:245)
>>>> at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnec
>>>> tion.java:540)
>>>> at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(Queued
>>>> ThreadPool.java:635)
>>>> at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedT
>>>> hreadPool.java:555)
>>>> at java.lang.Thread.run(Thread.java:745)
>>>> Caused by:
>>>> org.hibernate.exception.ConstraintViolationException: could not
>>>> execute statement
>>>> at org.hibernate.exception.internal.SQLStateConversionDelegate.
>>>> convert(SQLStateConversionDelegate.java:129)
>>>> at org.hibernate.exception.internal.StandardSQLExceptionConvert
>>>> er.convert(StandardSQLExceptionConverter.java:49)
>>>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>>>> ExceptionHelper.java:124)
>>>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>>>> ExceptionHelper.java:109)
>>>> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.execu
>>>> teUpdate(ResultSetReturnImpl.java:189)
>>>> at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.ad
>>>> dToBatch(NonBatchingBatch.java:59)
>>>> at org.hibernate.persister.entity.AbstractEntityPersister.inser
>>>> t(AbstractEntityPersister.java:3079)
>>>> at org.hibernate.persister.entity.AbstractEntityPersister.inser
>>>> t(AbstractEntityPersister.java:3521)
>>>> at org.hibernate.action.internal.EntityInsertAction.execute(Ent
>>>> ityInsertAction.java:88)
>>>> at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)
>>>> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu
>>>> eue.java:387)
>>>> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu
>>>> eue.java:303)
>>>> at org.hibernate.event.internal.AbstractFlushingEventListener.p
>>>> erformExecutions(AbstractFlushingEventListener.java:349)
>>>> at org.hibernate.event.internal.DefaultFlushEventListener.onFlu
>>>> sh(DefaultFlushEventListener.java:56)
>>>> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195)
>>>> at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.
>>>> java:404)
>>>> at org.hibernate.engine.transaction.internal.jdbc.JdbcTransacti
>>>> on.beforeTransactionCommit(JdbcTransaction.java:101)
>>>> at org.hibernate.engine.transaction.spi.AbstractTransactionImpl
>>>> .commit(AbstractTransactionImpl.java:175)
>>>> at org.springframework.orm.hibernate4.HibernateTransactionManag
>>>> er.doCommit(HibernateTransactionManager.java:584)
>>>> 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.$Proxy55.getOrAddProgramDataElement(Unknown Source)
>>>> at org.hisp.dhis.dimension.DefaultDimensionService.getOrAddData
>>>> DimensionalItemObject(DefaultDimensionService.java:355)
>>>> at org.hisp.dhis.analytics.data.DefaultDataQueryService.getDime
>>>> nsion(DefaultDataQueryService.java:256)
>>>> at org.hisp.dhis.analytics.data.DefaultDataQueryService.getDime
>>>> nsionalObjects(DefaultDataQueryService.java:209)
>>>> at org.hisp.dhis.analytics.data.DefaultDataQueryService.getFrom
>>>> Url(DefaultDataQueryService.java:130)
>>>> at org.hisp.dhis.webapi.controller.AnalyticsController.getJson(
>>>> AnalyticsController.java:108)
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
>>>> ssorImpl.java:62)
>>>> 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)
>>>> at org.springframework.web.servlet.DispatcherServlet.doDispatch
>>>> (DispatcherServlet.java:959)
>>>> at org.springframework.web.servlet.DispatcherServlet.doService(
>>>> DispatcherServlet.java:893)
>>>> at org.springframework.web.servlet.FrameworkServlet.processRequ
>>>> est(FrameworkServlet.java:968)
>>>> at org.springframework.web.servlet.FrameworkServlet.doGet(Frame
>>>> workServlet.java:859)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
>>>> at org.springframework.web.servlet.FrameworkServlet.service(Fra
>>>> meworkServlet.java:844)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
>>>> at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder
>>>> .java:800)
>>>> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1669)
>>>> 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:90)
>>>> 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.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1652)
>>>> at org.springframework.web.filter.ShallowEtagHeaderFilter.doFil
>>>> terInternal(ShallowEtagHeaderFilter.java:87)
>>>> at org.hisp.dhis.servlet.filter.ExcludableShallowEtagHeaderFilt
>>>> er.doFilterInternal(ExcludableShallowEtagHeaderFilter.java:102)
>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>> (OncePerRequestFilter.java:107)
>>>> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1652)
>>>> at org.springframework.orm.hibernate4.support.OpenSessionInView
>>>> Filter.doFilterInternal(OpenSessionInViewFilter.java:151)
>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>> (OncePerRequestFilter.java:107)
>>>> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1652)
>>>> at org.springframework.web.filter.CharacterEncodingFilter.doFil
>>>> terInternal(CharacterEncodingFilter.java:121)
>>>> at org.springframework.web.filter.OncePerRequestFilter.doFilter
>>>> (OncePerRequestFilter.java:107)
>>>> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilte
>>>> r(ServletHandler.java:1652)
>>>> at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHan
>>>> dler.java:585)
>>>> at org.eclipse.jetty.server.handler.ScopedHandler.handle(Scoped
>>>> Handler.java:143)
>>>> at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHa
>>>> ndler.java:577)
>>>> at org.eclipse.jetty.server.session.SessionHandler.doHandle(Ses
>>>> sionHandler.java:223)
>>>> at org.eclipse.jetty.server.handler.ContextHandler.doHandle(Con
>>>> textHandler.java:1127)
>>>> at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHand
>>>> ler.java:515)
>>>> at org.eclipse.jetty.server.session.SessionHandler.doScope(Sess
>>>> ionHandler.java:185)
>>>> at org.eclipse.jetty.server.handler.ContextHandler.doScope(Cont
>>>> extHandler.java:1061)
>>>> at org.eclipse.jetty.server.handler.ScopedHandler.handle(Scoped
>>>> Handler.java:141)
>>>> at org.eclipse.jetty.server.handler.ContextHandlerCollection.ha
>>>> ndle(ContextHandlerCollection.java:215)
>>>> at org.eclipse.jetty.server.handler.HandlerCollection.handle(Ha
>>>> ndlerCollection.java:110)
>>>> at org.eclipse.jetty.server.handler.HandlerWrapper.handle(Handl
>>>> erWrapper.java:97)
>>>> at org.eclipse.jetty.server.Server.handle(Server.java:497)
>>>> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
>>>> at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConne
>>>> ction.java:245)
>>>> at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnec
>>>> tion.java:540)
>>>> at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(Queued
>>>> ThreadPool.java:635)
>>>> at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedT
>>>> hreadPool.java:555)
>>>> at java.lang.Thread.run(Thread.java:745)
>>>> Caused by:
>>>> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>>>> unique constraint "programdataelement_unique_key"|  Detail: Key
>>>> (programid, dataelementid)=(12372, 13027) already exists.
>>>> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons
>>>> e(QueryExecutorImpl.java:2284)
>>>> at org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer
>>>> yExecutorImpl.java:2003)
>>>> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut
>>>> orImpl.java:200)
>>>> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
>>>> at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgP
>>>> reparedStatement.java:161)
>>>> at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPrep
>>>> aredStatement.java:133)
>>>>
>>> ...