← Back to team overview

dhis2-devs team mailing list archive

Re: Pivot table and analytics

 

Hi Lars

Just wondered if you'd had a chance to look at this one?

Something I should mention is that after restarting Tomcat after the data
has been loaded, this error does not occur so you may not see it.

Hope that helps.

Kind regards

Alan



On Fri, Oct 21, 2016 at 11:49 AM, Lars Helge Øverland <lars@xxxxxxxxx>
wrote:

> 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)
>>>>>
>>>> ...
>
>

References