Issues running iReport with custom datasource from within DHIS-2

Randy_Wilson · 6 December 2012 14:03

We have created a variety of custom iReports that pull data from the aggregateddatavalue, dataelement, organisationunit tables and a foreign table that stores PBF tariffs (included in the same database). They run fine in iReport preview and I can install them in the standard reports list, but when I try to run them I only get a message “process finished” and then the chrome “Oops…!” message when it tries to run the viewer.

Is there documentation anywhere about how to configure iReports (compatibility, etc….) so that this works correctly? I am able to run a report based on a report table without an issue. I remember having this same issue when Jason and Martin were out here training our team in custom queries and iReport.

I’m using Version 4.7 of iReport and DHIS-2 version 2.10.

Randy Wilson

jason · 6 December 2012 14:25

Might be useful to post your report someplace so we can take a look at it.

Be sure you save it as version 4.5.0

Tools->Options->General

I think this is the version for 2.9, but it may have changed in 2.10.

Regards,

Jason

···

On Thu, Dec 6, 2012 at 4:03 PM, Wilson,Randy rwilson@msh.org wrote:

We have created a variety of custom iReports that pull data from the aggregateddatavalue, dataelement, organisationunit tables and a foreign table that stores PBF tariffs (included in the same database). They run fine in iReport preview and I can install them in the standard reports list, but when I try to run them I only get a message “process finished” and then the chrome “Oops…!” message when it tries to run the viewer.

Is there documentation anywhere about how to configure iReports (compatibility, etc….) so that this works correctly? I am able to run a report based on a report table without an issue. I remember having this same issue when Jason and Martin were out here training our team in custom queries and iReport.

I’m using Version 4.7 of iReport and DHIS-2 version 2.10.

Randy Wilson

Lars · 7 December 2012 21:37

Hi Randy,

sorry about this, I agree we need to be able to see the stack trace when a standard reports fails. I have made a fix and back-ported to 2.10. If you can update your server, then re-run the report and post the stack trace then we will be able to help you. Download latest 2.10 from here in 30 min:

http://apps.dhis2.org/ci/job/dhis-web-2.10/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war

regards,

Lars

···

On Thu, Dec 6, 2012 at 4:03 PM, Wilson,Randy rwilson@msh.org wrote:

We have created a variety of custom iReports that pull data from the aggregateddatavalue, dataelement, organisationunit tables and a foreign table that stores PBF tariffs (included in the same database). They run fine in iReport preview and I can install them in the standard reports list, but when I try to run them I only get a message “process finished” and then the chrome “Oops…!” message when it tries to run the viewer.

Is there documentation anywhere about how to configure iReports (compatibility, etc….) so that this works correctly? I am able to run a report based on a report table without an issue. I remember having this same issue when Jason and Martin were out here training our team in custom queries and iReport.

I’m using Version 4.7 of iReport and DHIS-2 version 2.10.

Randy Wilson

Randy_Wilson · 8 December 2012 05:13

Thanks Lars,

I’ve downloaded and run the report again. Now I’m seeing the error stack:

HTTP Status 500 - Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException

···

type Exception report

message
Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException

description
The server encountered an internal error (Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException) that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException

    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:972)

    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)

    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)

    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)

    org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)

    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

    org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

root cause

java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException

    java.lang.Class.forName0(Native Method)

    java.lang.Class.forName(Class.java:264)

    net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:157)

    net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:115)

    net.sf.jasperreports.engine.JasperCompileManager.getCompiler(JasperCompileManager.java:730)

    net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:240)

    net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:226)

    net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:481)

    org.hisp.dhis.report.impl.DefaultReportService.renderReport(DefaultReportService.java:165)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    java.lang.reflect.Method.invoke(Method.java:601)

    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

    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:90)

    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

    $Proxy68.renderReport(Unknown Source)

    org.hisp.dhis.api.controller.ReportController.getReport(ReportController.java:155)

    org.hisp.dhis.api.controller.ReportController.getReportAsPdf(ReportController.java:83)

    org.hisp.dhis.api.controller.ReportController$$FastClassByCGLIB$$5a511b54.invoke(<generated>)

    net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

    org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618)

    org.hisp.dhis.api.controller.ReportController$$EnhancerByCGLIB$$42d6f68.getReportAsPdf(<generated>)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    java.lang.reflect.Method.invoke(Method.java:601)

    org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213)

    org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)

    org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)

    org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)

    org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)

    org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)

    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)

    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)

    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)

    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)

    org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)

    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

    org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

root cause

java.lang.ClassNotFoundException: org.codehaus.groovy.control.CompilationFailedException

    org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1711)

    org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1556)

    java.lang.Class.forName0(Native Method)

    java.lang.Class.forName(Class.java:264)

    net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:157)

    net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:115)

    net.sf.jasperreports.engine.JasperCompileManager.getCompiler(JasperCompileManager.java:730)

    net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:240)

    net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:226)

    net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:481)

    org.hisp.dhis.report.impl.DefaultReportService.renderReport(DefaultReportService.java:165)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    java.lang.reflect.Method.invoke(Method.java:601)

    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

    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:90)

    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

    $Proxy68.renderReport(Unknown Source)

    org.hisp.dhis.api.controller.ReportController.getReport(ReportController.java:155)

    org.hisp.dhis.api.controller.ReportController.getReportAsPdf(ReportController.java:83)

    org.hisp.dhis.api.controller.ReportController$$FastClassByCGLIB$$5a511b54.invoke(<generated>)

    net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

    org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618)

    org.hisp.dhis.api.controller.ReportController$$EnhancerByCGLIB$$42d6f68.getReportAsPdf(<generated>)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    java.lang.reflect.Method.invoke(Method.java:601)

    org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213)

    org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)

    org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)

    org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)

    org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)

    org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)

    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)

    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)

    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)

    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)

    org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)

    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

    org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

From: Lars Helge Øverland [mailto:larshelge@gmail.com]

Sent: Friday, December 07, 2012 11:38 PM

To: Jason Pickering

Cc: Wilson,Randy; dhis2-users; Ola Hodne Titlestad

Subject: Re: [Dhis2-users] Issues running iReport with custom datasource from within DHIS-2

Hi Randy,

sorry about this, I agree we need to be able to see the stack trace when a standard reports fails. I have made a fix and back-ported to 2.10. If you can update your server, then re-run the report and post the stack trace then we will be able to help you. Download latest 2.10 from here in 30 min:

http://apps.dhis2.org/ci/job/dhis-web-2.10/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war

regards,

Lars

On Thu, Dec 6, 2012 at 3:25 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Might be useful to post your report someplace so we can take a look at it.

Be sure you save it as version 4.5.0

Tools->Options->General

I think this is the version for 2.9, but it may have changed in 2.10.

Regards,

Jason

On Thu, Dec 6, 2012 at 4:03 PM, Wilson,Randy rwilson@msh.org wrote:

We have created a variety of custom iReports that pull data from the aggregateddatavalue, dataelement, organisationunit tables and a foreign table that stores PBF tariffs (included in the same database). They run fine in iReport preview and I can install them in the standard reports list, but when I try to run them I only get a message “process finished” and then the chrome “Oops…!” message when it tries to run the viewer.

Is there documentation anywhere about how to configure iReports (compatibility, etc….) so that this works correctly? I am able to run a report based on a report table without an issue. I remember having this same issue when Jason and Martin were out here training our team in custom queries and iReport.

I’m using Version 4.7 of iReport and DHIS-2 version 2.10.

Randy Wilson

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

jason · 8 December 2012 06:48

Well, it would seem that the language of the report is still set to “Groovy” and not “Java”. You mentioned you had already done this though, and it had no effect. Are you sure the report language option is set to Java?

Regards,

Jason

···

On Sat, Dec 8, 2012 at 7:13 AM, Wilson,Randy rwilson@msh.org wrote:

Thanks Lars,

I’ve downloaded and run the report again. Now I’m seeing the error stack:

HTTP Status 500 - Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException

type Exception report

message
Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException

description
The server encountered an internal error (Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException) that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException

    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:972)

    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)

    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)

    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)

    org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)

    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

    org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

root cause

java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException

    java.lang.Class.forName0(Native Method)

    java.lang.Class.forName(Class.java:264)

    net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:157)

    net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:115)

    net.sf.jasperreports.engine.JasperCompileManager.getCompiler(JasperCompileManager.java:730)

    net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:240)

    net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:226)

    net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:481)

    org.hisp.dhis.report.impl.DefaultReportService.renderReport(DefaultReportService.java:165)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    java.lang.reflect.Method.invoke(Method.java:601)

    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

    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:90)

    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

    $Proxy68.renderReport(Unknown Source)

    org.hisp.dhis.api.controller.ReportController.getReport(ReportController.java:155)

    org.hisp.dhis.api.controller.ReportController.getReportAsPdf(ReportController.java:83)

    org.hisp.dhis.api.controller.ReportController$$FastClassByCGLIB$$5a511b54.invoke(<generated>)

    net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

    org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618)

    org.hisp.dhis.api.controller.ReportController$$EnhancerByCGLIB$$42d6f68.getReportAsPdf(<generated>)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    java.lang.reflect.Method.invoke(Method.java:601)

    org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213)

    org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)

    org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)

    org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)

    org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)

    org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)

    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)

    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)

    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)

    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)

    org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)

    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

    org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

root cause

java.lang.ClassNotFoundException: org.codehaus.groovy.control.CompilationFailedException

    org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1711)

    org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1556)

    java.lang.Class.forName0(Native Method)

    java.lang.Class.forName(Class.java:264)

    net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:157)

    net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:115)

    net.sf.jasperreports.engine.JasperCompileManager.getCompiler(JasperCompileManager.java:730)

    net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:240)

    net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:226)

    net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:481)

    org.hisp.dhis.report.impl.DefaultReportService.renderReport(DefaultReportService.java:165)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    java.lang.reflect.Method.invoke(Method.java:601)

    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

    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:90)

    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

    $Proxy68.renderReport(Unknown Source)

    org.hisp.dhis.api.controller.ReportController.getReport(ReportController.java:155)

    org.hisp.dhis.api.controller.ReportController.getReportAsPdf(ReportController.java:83)

    org.hisp.dhis.api.controller.ReportController$$FastClassByCGLIB$$5a511b54.invoke(<generated>)

    net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

    org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618)

    org.hisp.dhis.api.controller.ReportController$$EnhancerByCGLIB$$42d6f68.getReportAsPdf(<generated>)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    java.lang.reflect.Method.invoke(Method.java:601)

    org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213)

    org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)

    org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)

    org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)

    org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)

    org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)

    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)

    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)

    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)

    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)

    org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)

    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

    org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

From: Lars Helge Øverland [mailto:larshelge@gmail.com]

Sent: Friday, December 07, 2012 11:38 PM

To: Jason Pickering

Cc: Wilson,Randy; dhis2-users; Ola Hodne Titlestad

Subject: Re: [Dhis2-users] Issues running iReport with custom datasource from within DHIS-2

Hi Randy,

sorry about this, I agree we need to be able to see the stack trace when a standard reports fails. I have made a fix and back-ported to 2.10. If you can update your server, then re-run the report and post the stack trace then we will be able to help you. Download latest 2.10 from here in 30 min:

http://apps.dhis2.org/ci/job/dhis-web-2.10/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war

regards,

Lars

On Thu, Dec 6, 2012 at 3:25 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Might be useful to post your report someplace so we can take a look at it.

Be sure you save it as version 4.5.0

Tools->Options->General

I think this is the version for 2.9, but it may have changed in 2.10.

Regards,

Jason

On Thu, Dec 6, 2012 at 4:03 PM, Wilson,Randy rwilson@msh.org wrote:

We have created a variety of custom iReports that pull data from the aggregateddatavalue, dataelement, organisationunit tables and a foreign table that stores PBF tariffs (included in the same database). They run fine in iReport preview and I can install them in the standard reports list, but when I try to run them I only get a message “process finished” and then the chrome “Oops…!” message when it tries to run the viewer.

Is there documentation anywhere about how to configure iReports (compatibility, etc….) so that this works correctly? I am able to run a report based on a report table without an issue. I remember having this same issue when Jason and Martin were out here training our team in custom queries and iReport.

I’m using Version 4.7 of iReport and DHIS-2 version 2.10.

Randy Wilson

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Lars · 8 December 2012 10:14

In ireport, select the report itself, then look towards the bottom of the properties window, change from Groovy to Java.

···

On Sat, Dec 8, 2012 at 7:13 AM, Wilson,Randy rwilson@msh.org wrote:

Thanks Lars,

I’ve downloaded and run the report again. Now I’m seeing the error stack:

HTTP Status 500 - Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException

type Exception report

message
Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException

description
The server encountered an internal error (Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException) that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException

    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:972)

    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)

    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)

    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)

    org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)

    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

    org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

root cause

java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException

    java.lang.Class.forName0(Native Method)

    java.lang.Class.forName(Class.java:264)

    net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:157)

    net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:115)

    net.sf.jasperreports.engine.JasperCompileManager.getCompiler(JasperCompileManager.java:730)

    net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:240)

    net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:226)

    net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:481)

    org.hisp.dhis.report.impl.DefaultReportService.renderReport(DefaultReportService.java:165)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    java.lang.reflect.Method.invoke(Method.java:601)

    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

    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:90)

    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

    $Proxy68.renderReport(Unknown Source)

    org.hisp.dhis.api.controller.ReportController.getReport(ReportController.java:155)

    org.hisp.dhis.api.controller.ReportController.getReportAsPdf(ReportController.java:83)

    org.hisp.dhis.api.controller.ReportController$$FastClassByCGLIB$$5a511b54.invoke(<generated>)

    net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

    org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618)

    org.hisp.dhis.api.controller.ReportController$$EnhancerByCGLIB$$42d6f68.getReportAsPdf(<generated>)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    java.lang.reflect.Method.invoke(Method.java:601)

    org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213)

    org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)

    org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)

    org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)

    org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)

    org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)

    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)

    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)

    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)

    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)

    org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)

    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

    org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

root cause

java.lang.ClassNotFoundException: org.codehaus.groovy.control.CompilationFailedException

    org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1711)

    org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1556)

    java.lang.Class.forName0(Native Method)

    java.lang.Class.forName(Class.java:264)

    net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:157)

    net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:115)

    net.sf.jasperreports.engine.JasperCompileManager.getCompiler(JasperCompileManager.java:730)

    net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:240)

    net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:226)

    net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:481)

    org.hisp.dhis.report.impl.DefaultReportService.renderReport(DefaultReportService.java:165)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    java.lang.reflect.Method.invoke(Method.java:601)

    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

    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:90)

    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

    $Proxy68.renderReport(Unknown Source)

    org.hisp.dhis.api.controller.ReportController.getReport(ReportController.java:155)

    org.hisp.dhis.api.controller.ReportController.getReportAsPdf(ReportController.java:83)

    org.hisp.dhis.api.controller.ReportController$$FastClassByCGLIB$$5a511b54.invoke(<generated>)

    net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

    org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618)

    org.hisp.dhis.api.controller.ReportController$$EnhancerByCGLIB$$42d6f68.getReportAsPdf(<generated>)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    java.lang.reflect.Method.invoke(Method.java:601)

    org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213)

    org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)

    org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)

    org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)

    org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)

    org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)

    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)

    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)

    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)

    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)

    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

    org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)

    org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)

    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

    org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

From: Lars Helge Øverland [mailto:larshelge@gmail.com]

Sent: Friday, December 07, 2012 11:38 PM

To: Jason Pickering

Cc: Wilson,Randy; dhis2-users; Ola Hodne Titlestad

Subject: Re: [Dhis2-users] Issues running iReport with custom datasource from within DHIS-2

Hi Randy,

sorry about this, I agree we need to be able to see the stack trace when a standard reports fails. I have made a fix and back-ported to 2.10. If you can update your server, then re-run the report and post the stack trace then we will be able to help you. Download latest 2.10 from here in 30 min:

http://apps.dhis2.org/ci/job/dhis-web-2.10/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war

regards,

Lars

On Thu, Dec 6, 2012 at 3:25 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Might be useful to post your report someplace so we can take a look at it.

Be sure you save it as version 4.5.0

Tools->Options->General

I think this is the version for 2.9, but it may have changed in 2.10.

Regards,

Jason

On Thu, Dec 6, 2012 at 4:03 PM, Wilson,Randy rwilson@msh.org wrote:

We have created a variety of custom iReports that pull data from the aggregateddatavalue, dataelement, organisationunit tables and a foreign table that stores PBF tariffs (included in the same database). They run fine in iReport preview and I can install them in the standard reports list, but when I try to run them I only get a message “process finished” and then the chrome “Oops…!” message when it tries to run the viewer.

Is there documentation anywhere about how to configure iReports (compatibility, etc….) so that this works correctly? I am able to run a report based on a report table without an issue. I remember having this same issue when Jason and Martin were out here training our team in custom queries and iReport.

I’m using Version 4.7 of iReport and DHIS-2 version 2.10.

Randy Wilson

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Duttas · 12 December 2012 04:41

Hi all,

I am wondering if someone is able to point me in the right direction.

I have created a program to collect individual data with a variety of yes-only responses as a single event without registration. There is a data form that is filled in here at the end of a year of following a single child through their routine vaccinations. I am wondering if there is a way to create formulas to aggregate these responses.

For example, looking at hepatitis B at birth as well as 2 months and 4 months later. Is there a way I can determine the drop-out and completion rate (or manipulate this data otherwise) using the yes-only responses? In the user manual I was looking at the section “** Person Aggregation Query Builder Management” but that wasn’t exactly what I wanted to do. Thanks in advance,**

Nick

Olav · 12 December 2012 07:29

Hi,
I think you would have to use the Query Builder to do this.

You would need a regular dataset with data elements and queries for:
total number of events
children with Hep B at birth
children with Hep B at 2 months
children with Hep B at 4 months

You can then use indicators to calculate the drop out/completion rates.

Olav

12. des. 2012 kl. 05:41 skrev duttas@wpro.who.int:

···

Hi all,

I am wondering if someone is able to point me in the right direction.

I have created a program to collect individual data with a variety of yes-only responses as a single event without registration. There is a data form that is filled in here at the end of a year of following a single child through their routine vaccinations. I am wondering if there is a way to create formulas to aggregate these responses.

For example, looking at hepatitis B at birth as well as 2 months and 4 months later. Is there a way I can determine the drop-out and completion rate (or manipulate this data otherwise) using the yes-only responses? In the user manual I was looking at the section “Person Aggregation Query Builder Management” but that wasn’t exactly what I wanted to do. Thanks in advance,

Nick

This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

Duttas · 17 December 2012 01:10

Olav,

Thank you for your response.

Regarding the syntax if I want to check if a value is true how do I check that?

Ie.

[DE:37948.37949.37952] = true

[DE:37948.37949.37952] is true

[DE:37948.37949.37952] true

None of the above have worked? Thanks,

Nick

···

From: Olav [mailto:op.registrering@me.com]

Sent: Wednesday, 12 December 2012 6:29 PM

To: Dutta, Mr Shurajit Nicky (SOL)

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Manipulating data entered through program modules

Hi,

I think you would have to use the Query Builder to do this.

You would need a regular dataset with data elements and queries for:

total number of events

children with Hep B at birth

children with Hep B at 2 months

children with Hep B at 4 months

You can then use indicators to calculate the drop out/completion rates.

Olav

des. 2012 kl. 05:41 skrev
duttas@wpro.who.int:

Hi all,

I am wondering if someone is able to point me in the right direction.

I have created a program to collect individual data with a variety of yes-only responses as a single event without registration. There is a data form that is filled in here at the end of a year of following a single child through their routine vaccinations. I am wondering if there is a way to create formulas to aggregate these responses.

For example, looking at hepatitis B at birth as well as 2 months and 4 months later. Is there a way I can determine the drop-out and completion rate (or manipulate this data otherwise) using the yes-only responses? In the user manual I was looking at the section “** Person Aggregation Query Builder Management” but that wasn’t exactly what I wanted to do. Thanks in advance,**

Nick

This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Tran_Chau · 17 December 2012 02:37

Hi,

The formula should be: [DE:37948.37949.37952] = ***'*true’ for data element with YES/NO type.

Best regards,

···

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Mon, Dec 17, 2012 at 8:10 AM, duttas@wpro.who.int wrote:

[DE:37948.37949.37952] = true

jason · 17 December 2012 05:26

I checked the server and saw this error. Not sure how to resolve it however it. The query passes the test, but this happens when trying to aggregate the data manually.

Best regards,

Jason

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 (java.lang.IllegalArgumentException): entity for parameter binding cannot be null

org.hibernate.internal.AbstractQueryImpl.resolveEntityName(AbstractQueryImpl.java:587)
org.hibernate.internal.AbstractQueryImpl.setEntity(AbstractQueryImpl.java:645)
org.hisp.dhis.patientdatavalue.hibernate.HibernatePatientDataValueStore.get(HibernatePatientDataValueStore.java:112)
org.hisp.dhis.patientdatavalue.DefaultPatientDataValueService.getPatientDataValues(DefaultPatientDataValueService.java:125)
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:616)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
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:90)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
$Proxy57.getPatientDataValues(Unknown source)
org.hisp.dhis.caseentry.action.caseaggregation.CaseAggregationResultDetailsAction.execute(CaseAggregationResultDetailsAction.java:200)
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:616)
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453)
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255)
org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:137)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:100)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:510)
org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:432)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
java.lang.Thread.run(Thread.jav

···

On Mon, Dec 17, 2012 at 4:37 AM, Tran Chau tran.hispvietnam@gmail.com wrote:

Hi,

The formula should be: [DE:37948.37949.37952] = ***'*true’ for data element with YES/NO type.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Mon, Dec 17, 2012 at 8:10 AM, duttas@wpro.who.int wrote:

[DE:37948.37949.37952] = true

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Tran_Chau · 17 December 2012 07:38

Hi Jason,

If your formulas belong to the anonymous program ( single event without registration ), please use operator as Number of visits and re-test it again.

Thank you.

Best regards,

···

On Mon, Dec 17, 2012 at 4:37 AM, Tran Chau tran.hispvietnam@gmail.com wrote:

Hi,

The formula should be: [DE:37948.37949.37952] = ***'*true’ for data element with YES/NO type.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Mon, Dec 17, 2012 at 8:10 AM, duttas@wpro.who.int wrote:

[DE:37948.37949.37952] = true

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

jason · 17 December 2012 08:59

Hi there. Thanks for this. It seems to work now!

Best regards,

Jason

···

On Mon, Dec 17, 2012 at 9:38 AM, Tran Chau tran.hispvietnam@gmail.com wrote:

Hi Jason,

If your formulas belong to the anonymous program ( single event without registration ), please use operator as Number of visits and re-test it again.

Thank you.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Mon, Dec 17, 2012 at 12:26 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

I checked the server and saw this error. Not sure how to resolve it however it. The query passes the test, but this happens when trying to aggregate the data manually.

Best regards,

Jason

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 (java.lang.IllegalArgumentException): entity for parameter binding cannot be null

org.hibernate.internal.AbstractQueryImpl.resolveEntityName(AbstractQueryImpl.java:587)

org.hibernate.internal.AbstractQueryImpl.setEntity(AbstractQueryImpl.java:645)

org.hisp.dhis.patientdatavalue.hibernate.HibernatePatientDataValueStore.get(HibernatePatientDataValueStore.java:112)

org.hisp.dhis.patientdatavalue.DefaultPatientDataValueService.getPatientDataValues(DefaultPatientDataValueService.java:125)

sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

java.lang.reflect.Method.invoke(Method.java:616)

org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

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:90)

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

$Proxy57.getPatientDataValues(Unknown source)

org.hisp.dhis.caseentry.action.caseaggregation.CaseAggregationResultDetailsAction.execute(CaseAggregationResultDetailsAction.java:200)

sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

java.lang.reflect.Method.invoke(Method.java:616)

com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453)

com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255)

org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:98)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:137)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211)

com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:100)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)

org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:510)

org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:432)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)

org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)

org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)

org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)

org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)

org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)

org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)

org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)

org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)

java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

java.lang.Thread.run(Thread.jav

On Mon, Dec 17, 2012 at 4:37 AM, Tran Chau tran.hispvietnam@gmail.com wrote:

Hi,

The formula should be: [DE:37948.37949.37952] = ***'*true’ for data element with YES/NO type.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Mon, Dec 17, 2012 at 8:10 AM, duttas@wpro.who.int wrote:

[DE:37948.37949.37952] = true

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Duttas · 17 December 2012 23:04

Dear all,

Sorry for all the questions lately. Thank you for your assistance with the program aggregation.

I have built some test data elements and stored some meaningless data values within them. In the user guide I see this warning:

“Simply press the delete button to delete a data element. Note that this operation is only possible if there is no

data attached to the data element itself.”

Is there any way to overcome this and delete these elements that I only used for testing purposes? Thanks,

Nick

···

From: Jason Pickering [mailto:jason.p.pickering@gmail.com]

Sent: Monday, 17 December 2012 8:00 PM

To: Tran Chau

Cc: Dutta, Mr Shurajit Nicky (SOL); dhis2-users@lists.launchpad.net; Olav

Subject: Re: [Dhis2-users] Manipulating data entered through program modules

Hi there. Thanks for this. It seems to work now!

Best regards,

Jason

On Mon, Dec 17, 2012 at 9:38 AM, Tran Chau tran.hispvietnam@gmail.com wrote:

Hi Jason,

If your formulas belong to the anonymous program ( single event without registration ), please use operator as Number of visits and re-test it again.

Thank you.

Best regards,

Châu Thu Trân

HISP Viet Nam

Email: tran.hispvietnam@gmail.com

On Mon, Dec 17, 2012 at 12:26 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

I checked the server and saw this error. Not sure how to resolve it however it. The query passes the test, but this happens when trying to aggregate the data manually.

Best regards,

Jason

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.

[Go back]

[-] Exception (java.lang.IllegalArgumentException): entity for parameter binding cannot be null

· org.hibernate.internal.AbstractQueryImpl.resolveEntityName(AbstractQueryImpl.java:587)

· org.hibernate.internal.AbstractQueryImpl.setEntity(AbstractQueryImpl.java:645)

· org.hisp.dhis.patientdatavalue.hibernate.HibernatePatientDataValueStore.get(HibernatePatientDataValueStore.java:112)

· org.hisp.dhis.patientdatavalue.DefaultPatientDataValueService.getPatientDataValues(DefaultPatientDataValueService.java:125)

· sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)

· sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

· sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

· java.lang.reflect.Method.invoke(Method.java:616)

· org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

· 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:90)

· org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

· org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

· $Proxy57.getPatientDataValues(Unknown source)

· org.hisp.dhis.caseentry.action.caseaggregation.CaseAggregationResultDetailsAction.execute(CaseAggregationResultDetailsAction.java:200)

· sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)

· sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

· sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

· java.lang.reflect.Method.invoke(Method.java:616)

· com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453)

· com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292)

· com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255)

· org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)