Issues running iReport with custom datasource from within DHIS-2

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

· 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

I'm also interested in the answer to the question.

My presumption is that this constraint was placed to ensure that artifacts created from previously defined data elements are will always persist. Another way of saying this is:

If before I saved Number of Maternal Deaths in org_unit January 2012 = 10, deleting the data (10) will result in destroying some integrity that was built into DHIS2.

Am I right?

···

Sent from my BB Curve 9320

-----Original Message-----
From: <duttas@wpro.who.int>
Sender: dhis2-users-bounces+alvin.marcelo=gmail.com@lists.launchpad.net
Date: Mon, 17 Dec 2012 23:04:16
To: <jason.p.pickering@gmail.com>; <tran.hispvietnam@gmail.com>
Cc: <dhis2-users@lists.launchpad.net>; <op.registrering@me.com>
Subject: [Dhis2-users] Deleting data elements with data attached to them

_______________________________________________
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

I'm also interested in the answer to the question.

My presumption is that this constraint was placed to ensure that artifacts
created from previously defined data elements are will always persist.
Another way of saying this is:

If before I saved Number of Maternal Deaths in org_unit January 2012 = 10,
deleting the data (10) will result in destroying some integrity that was
built into DHIS2.

Am I right?

Yes that's right, Alvin and Nick. So you would have to delete the
datavalues in the database associated with this dataelement before you can
remove the dataelement.

···

On 18 December 2012 00:08, Alvin B. Marcelo <alvin.marcelo@gmail.com> wrote:

Sent from my BB Curve 9320

-----Original Message-----
From: <duttas@wpro.who.int>
Sender: dhis2-users-bounces+alvin.marcelo=gmail.com@lists.launchpad.net
Date: Mon, 17 Dec 2012 23:04:16
To: <jason.p.pickering@gmail.com>; <tran.hispvietnam@gmail.com>
Cc: <dhis2-users@lists.launchpad.net>; <op.registrering@me.com>
Subject: [Dhis2-users] Deleting data elements with data attached to them

_______________________________________________
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

_______________________________________________
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

Also make sure that that “Number of Maternal Deaths” data element should not be part of or associated with any existing data set ( like data entry form ).

Am i right Bob !!!

Regards,

Brajesh

···

On 18 December 2012 00:08, Alvin B. Marcelo alvin.marcelo@gmail.com wrote:

I’m also interested in the answer to the question.

My presumption is that this constraint was placed to ensure that artifacts created from previously defined data elements are will always persist. Another way of saying this is:

If before I saved Number of Maternal Deaths in org_unit January 2012 = 10, deleting the data (10) will result in destroying some integrity that was built into DHIS2.

Am I right?

Yes that’s right, Alvin and Nick. So you would have to delete the datavalues in the database associated with this dataelement before you can remove the dataelement.

Sent from my BB Curve 9320

-----Original Message-----

From: duttas@wpro.who.int

Sender: dhis2-users-bounces+alvin.marcelo=gmail.com@lists.launchpad.net

Date: Mon, 17 Dec 2012 23:04:16

To: jason.p.pickering@gmail.com; tran.hispvietnam@gmail.com

Cc: dhis2-users@lists.launchpad.net; op.registrering@me.com

Subject: [Dhis2-users] Deleting data elements with data attached to them


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


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

This can get a lot more complicated if you have already begun making charts, maps, report tables, etc…. and have saved favorites.

You should also make sure that the dataelementid is not used in any of the following tables:

Dataelementgroupmembers

Mapview

Chartdataelements

Datadictionarydataelements

datasetmembers

detargetmembers

expressiondataelement

programstage_dataelements

reporttable_dataelements

(there may be more!)

Dataelementids are also used in indicator defintions, but I don’t think referential integrity is enforced. You should also make sure that you are not using the data element in an numerator or denominator calculations.

If you make a copy of your database locally and you are comfortable using pgadmin you can try to delete the row with the data element you want to remove. It will give you error messages that show which constraints are being violated and you can delete the reference(s) to the dataelements in those files first.

Randy

···

Am i right Bob !!!

Regards,

Brajesh

On Tue, Dec 18, 2012 at 4:43 AM, Bob Jolliffe bobjolliffe@gmail.com wrote:

On 18 December 2012 00:08, Alvin B. Marcelo alvin.marcelo@gmail.com wrote:

I’m also interested in the answer to the question.

My presumption is that this constraint was placed to ensure that artifacts created from previously defined data elements are will always persist. Another way of saying this is:

If before I saved Number of Maternal Deaths in org_unit January 2012 = 10, deleting the data (10) will result in destroying some integrity that was built into DHIS2.

Am I right?

Yes that’s right, Alvin and Nick. So you would have to delete the datavalues in the database associated with this dataelement before you can remove the dataelement.

Sent from my BB Curve 9320

-----Original Message-----

From: duttas@wpro.who.int

Sender: dhis2-users-bounces+alvin.marcelo=gmail.com@lists.launchpad.net

Date: Mon, 17 Dec 2012 23:04:16

To: jason.p.pickering@gmail.com; tran.hispvietnam@gmail.com

Cc: dhis2-users@lists.launchpad.net; op.registrering@me.com

Subject: [Dhis2-users] Deleting data elements with data attached to them


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


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


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

Regards,

Brajesh