dhis2-devs team mailing list archive

Thread
Date
[Bug 731818] [NEW] export-aggregate-data-throws-exception

To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
From: "jason.p.pickering" <731818@xxxxxxxxxxxxxxxxxx>
Date: Wed, 09 Mar 2011 08:23:53 -0000
Reply-to: Bug 731818 <731818@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

While attempting to export aggregate data (orgunit with children)
An exception occurred

Sorry! The system failed to execute the operation. Usually, no data is
lost and you can continue working by going back to the previous page. If
you wish to report the incident, please save this page by choosing "File
-> Save (page as)" in your browser and include the saved page in the
report. The problem details are listed below.

[-] Exception (org.hibernate.LazyInitializationException): failed to
lazily initialize a collection of role:
org.hisp.dhis.organisationunit.OrganisationUnit.children, no session or
session was closed

    * org.hibernate.collection.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:383)
    * org.hibernate.collection.AbstractPersistentCollection.throwLazyInitializationExceptionIfNotConnected(AbstractPersistentCollection.java:375)
    * org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:368)
    * org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:111)
    * org.hibernate.collection.PersistentSet.iterator(PersistentSet.java:186)
    * org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.addOrganisationUnitChildrenAtLevel(DefaultOrganisationUnitService.java:335)
    * org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrganisationUnitsAtLevel(DefaultOrganisationUnitService.java:315)
    * sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
    * sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
    * sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
    * java.lang.reflect.Method.invoke(Unknown source)
    * org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
    * org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    * org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    * org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    * org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    * org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    * org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    * org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    * $Proxy12.getOrganisationUnitsAtLevel(Unknown source)
    * org.hisp.dhis.importexport.action.exp.DataValueExportAction.execute(DataValueExportAction.java:228)
    * sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
    * sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
    * sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
    * java.lang.reflect.Method.invoke(Unknown source)
    * com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
    * com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
    * org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:82)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:85)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:91)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:117)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:70)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:107)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:94)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyInterceptor.java:90)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:124)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:98)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:141)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    * com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:98)
    * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    * org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
    * org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
    * org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
    * org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
    * org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
    * org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:129)
    * org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
    * org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
    * org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
    * org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
    * org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
    * org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
    * org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
    * org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
    * org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
    * org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
    * org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
    * org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    * org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
    * org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
    * org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    * org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
    * org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
    * org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
    * org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
    * org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
    * org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440)
    * org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
    * org.mortbay.jetty.Server.handle(Server.java:326)
    * org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
    * org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
    * org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
    * org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
    * org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
    * org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
    * org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

** Affects: dhis2
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/731818

Title:
  export-aggregate-data-throws-exception

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  While attempting to export aggregate data (orgunit with children)
  An exception occurred

  Sorry! The system failed to execute the operation. Usually, no data is
  lost and you can continue working by going back to the previous page.
  If you wish to report the incident, please save this page by choosing
  "File -> Save (page as)" in your browser and include the saved page in
  the report. The problem details are listed below.

  [-] Exception (org.hibernate.LazyInitializationException): failed to
  lazily initialize a collection of role:
  org.hisp.dhis.organisationunit.OrganisationUnit.children, no session
  or session was closed

      * org.hibernate.collection.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:383)
      * org.hibernate.collection.AbstractPersistentCollection.throwLazyInitializationExceptionIfNotConnected(AbstractPersistentCollection.java:375)
      * org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:368)
      * org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:111)
      * org.hibernate.collection.PersistentSet.iterator(PersistentSet.java:186)
      * org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.addOrganisationUnitChildrenAtLevel(DefaultOrganisationUnitService.java:335)
      * org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrganisationUnitsAtLevel(DefaultOrganisationUnitService.java:315)
      * sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
      * sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
      * sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
      * java.lang.reflect.Method.invoke(Unknown source)
      * org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      * org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      * org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      * org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      * org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      * org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      * org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      * org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      * $Proxy12.getOrganisationUnitsAtLevel(Unknown source)
      * org.hisp.dhis.importexport.action.exp.DataValueExportAction.execute(DataValueExportAction.java:228)
      * sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
      * sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
      * sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
      * java.lang.reflect.Method.invoke(Unknown source)
      * com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
      * com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
      * org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:82)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:85)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:91)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:117)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:70)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:107)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:94)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyInterceptor.java:90)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:124)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:98)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:141)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
      * com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:98)
      * com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
      * org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
      * org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
      * org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
      * org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
      * org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
      * org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:129)
      * org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
      * org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
      * org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
      * org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
      * org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
      * org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
      * org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
      * org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
      * org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
      * org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
      * org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
      * org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
      * org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
      * org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
      * org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
      * org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
      * org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
      * org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
      * org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
      * org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
      * org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440)
      * org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
      * org.mortbay.jetty.Server.handle(Server.java:326)
      * org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
      * org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
      * org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
      * org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
      * org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
      * org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
      * org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Follow ups

[Bug 731818] Re: export-aggregate-data-throws-exception
From: Lars Helge Øverland, 2011-03-13
[Bug 731818] [NEW] export-aggregate-data-throws-exception
From: jason.p.pickering, 2011-03-09
References

[Bug 731818] [NEW] export-aggregate-data-throws-exception
From: jason.p.pickering, 2011-03-09