dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #23601
Re: [Bug 1189045] [NEW] Old report tables (from 2.10) are not working on 2.12
Hi Marko,
you can create a SQL View in data admin module -> sql view like this and
view the output:
select name from indicator where numerator is null or numerator = '' or
denominator is null or denominator = '';
Lars
On Tue, Jul 23, 2013 at 8:50 PM, Marko David Garcia
<markodavidgm@xxxxxxxxx>wrote:
> Hi friends, we have the same problem.
> How can I see the indicators values, or how can I clean the null or empty
> values?.
>
> Thank you very much.
>
>
>
>
> 2013/6/18 Lars Helge Øverland <larshelge@xxxxxxxxx>
>
>> Hi Caveman,
>>
>> it looks like this error is caused by an indicator with a null/missing
>> numerator. Can you please check for this in your database?
>>
>> Lars
>>
>>
>> On Sat, Jun 8, 2013 at 11:53 PM, Orvalho Joaquim Auusto
>> <orvaquim@xxxxxxxxx>wrote:
>>
>> > Public bug reported:
>> >
>> > My old report tables designed on version 2.10 are not being generated on
>> > 2.12.
>> >
>> > I have run both datamart and analytics. When I try to generate those
>> > report tables I get this on the catalina.out:
>> >
>> > * INFO 2013-06-08 23:51:30,888 Generating report table grid:
>> HntS8zC0eFT,
>> > date: Sat Dec 01 00:00:00 CAT 2012, ou: XrSevkDRESe
>> > (DefaultReportTableService.java [http-9080-3])
>> > * INFO 2013-06-08 23:51:31,037 Split on de: 4 (DefaultQueryPlanner.java
>> > [http-9080-3])
>> > Time: 1952 micros: Planned query, got: 4 for optimal: 4
>> > Time: 34029 micros: Analytics SQL: select de,Monthly,co, sum(value) as
>> > value from analytics_2012 where de in ('K7cHhK8vR4L', 'c84dFlkOMS0',
>> > 'K6SVqNDiFdd', 'QC2mRUtFHNS', 'xXGPmh7ihAl', 'b1wgBBJbFrX') and Monthly
>> in
>> > ('201212') group by de,Monthly,co
>> > Time: 34117 micros: Analytics SQL: select de,Monthly,co, sum(value) as
>> > value from analytics_2012 where de in ('qvx8gBKV6bM', 'XRFVcYwVVcm',
>> > 'nGMJGc4ZwIY', 'JQgUI8Z7xS0', 'KnflWufpayh', 'uA11KKxoO5G') and Monthly
>> in
>> > ('201212') group by de,Monthly,co
>> > Time: 36695 micros: Analytics SQL: select de,Monthly,co, sum(value) as
>> > value from analytics_2012 where de in ('iVh9sX2kem9', 'BN0Ym07T1YX',
>> > 'QT2t4hnEN0e', 'NoLW5m1q2mn', 'm7L9JsRGxFJ', 'Ngr63bWMZaM') and Monthly
>> in
>> > ('201212') group by de,Monthly,co
>> > Time: 41915 micros: Analytics SQL: select de,Monthly,co, sum(value) as
>> > value from analytics_2012 where de in ('Yy0k0M9I6By', 'pjhHtGHeApk',
>> > 'Vh90cgF0E1m', 'dM9Of9QMPVp', 'JbCxyXdyUsc', 'Hh9LKZTcjin') and Monthly
>> in
>> > ('201212') group by de,Monthly,co
>> > Time: 44891 micros: Got aggregated values for query group
>> > Time: 45158 micros: Got aggregated values
>> > * ERROR 2013-06-08 23:51:31,084 Error while executing action
>> > (ExceptionInterceptor.java [http-9080-3])
>> > java.lang.NullPointerException
>> > at java.io.StringReader.<init>(StringReader.java:50)
>> > at org.nfunk.jep.JEP.parseExpression(Unknown Source)
>> > at
>> >
>> org.hisp.dhis.system.util.MathUtils.calculateExpression(MathUtils.java:88)
>> > at
>> >
>> org.hisp.dhis.expression.DefaultExpressionService.getIndicatorValue(DefaultExpressionService.java:159)
>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> > at
>> >
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> > at
>> >
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> > at java.lang.reflect.Method.invoke(Method.java:616)
>> > at
>> >
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
>> > at
>> >
>> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>> > at
>> >
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>> > at sun.proxy.$Proxy61.getIndicatorValue(Unknown Source)
>> > at
>> >
>> org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValues(DefaultAnalyticsService.java:242)
>> > at
>> >
>> org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:446)
>> > at
>> >
>> org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:477)
>> > at
>> >
>> org.hisp.dhis.reporttable.impl.DefaultReportTableService.getReportTableGrid(DefaultReportTableService.java:115)
>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> > at
>> >
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> > at
>> >
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> > at java.lang.reflect.Method.invoke(Method.java:616)
>> > at
>> >
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
>> > at
>> >
>> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
>> > at
>> >
>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
>> > at
>> >
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>> > at
>> >
>> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>> > at
>> >
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>> > at sun.proxy.$Proxy64.getReportTableGrid(Unknown Source)
>> > at
>> >
>> org.hisp.dhis.reporting.tablecreator.action.ExportTableAction.execute(ExportTableAction.java:185)
>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> > at
>> >
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> > at
>> >
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> > at java.lang.reflect.Method.invoke(Method.java:616)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
>> > at
>> >
>> org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:112)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:103)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:135)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:249)
>> > at
>> >
>> com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:109)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
>> > at
>> >
>> org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:546)
>> > at
>> >
>> org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
>> > at
>> >
>> org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
>> > at
>> >
>> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
>> > at
>> >
>> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
>> > at
>> >
>> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
>> > at
>> >
>> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> > at
>> >
>> org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:152)
>> > at
>> >
>> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> > at
>> >
>> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
>> > at
>> >
>> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> > at
>> >
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>> > at
>> >
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>> > at
>> >
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>> > at
>> >
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
>> > at
>> >
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>> > at
>> >
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
>> > at
>> >
>> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
>> > at
>> >
>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
>> > at
>> > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
>> > at java.lang.Thread.run(Thread.java:679)
>> >
>> > My system is:
>> >
>> > Current user:
>> > orvaquim
>> > Version:
>> > 2.12
>> > Build revision:
>> > 11149
>> > Build date:
>> > 2013-06-07 08:08
>> > User agent:
>> > Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101
>> > Firefox/21.0
>> > External configuration directory:
>> > /opt/dhis2
>> > Environment variable:
>> > DHIS2_HOME
>> > Database type:
>> > PostgreSQL
>> > Database name:
>> > dhisdb
>> > Database user:
>> > sa
>> > Java Opts:
>> > Java version:
>> > 1.6.0_27
>> > Java vendor:
>> > Sun Microsystems Inc.
>> > OS name:
>> > Linux
>> > OS architecture:
>> > amd64
>> > OS version:
>> > 3.2.0-45-generic
>> > Server date:
>> > 2013-06-08 23:52
>> > Server memory:
>> > Mem Total in JVM: 1152 Free in JVM: 673 Max Limit: 1703
>> > CPU cores:
>> > 4
>> >
>> > Thank you
>> >
>> > ** Affects: dhis2
>> > Importance: Undecided
>> > Status: New
>> >
>> > --
>> > You received this bug notification because you are a member of DHIS 2
>> > developers, which is subscribed to DHIS.
>> > https://bugs.launchpad.net/bugs/1189045
>> >
>> > Title:
>> > Old report tables (from 2.10) are not working on 2.12
>> >
>> > Status in DHIS 2 - District Health Information Software:
>> > New
>> >
>> > Bug description:
>> > My old report tables designed on version 2.10 are not being generated
>> > on 2.12.
>> >
>> > I have run both datamart and analytics. When I try to generate those
>> > report tables I get this on the catalina.out:
>> >
>> > * INFO 2013-06-08 23:51:30,888 Generating report table grid:
>> > HntS8zC0eFT, date: Sat Dec 01 00:00:00 CAT 2012, ou: XrSevkDRESe
>> > (DefaultReportTableService.java [http-9080-3])
>> > * INFO 2013-06-08 23:51:31,037 Split on de: 4
>> (DefaultQueryPlanner.java
>> > [http-9080-3])
>> > Time: 1952 micros: Planned query, got: 4 for optimal: 4
>> > Time: 34029 micros: Analytics SQL: select de,Monthly,co, sum(value) as
>> > value from analytics_2012 where de in ('K7cHhK8vR4L', 'c84dFlkOMS0',
>> > 'K6SVqNDiFdd', 'QC2mRUtFHNS', 'xXGPmh7ihAl', 'b1wgBBJbFrX') and Monthly
>> in
>> > ('201212') group by de,Monthly,co
>> > Time: 34117 micros: Analytics SQL: select de,Monthly,co, sum(value) as
>> > value from analytics_2012 where de in ('qvx8gBKV6bM', 'XRFVcYwVVcm',
>> > 'nGMJGc4ZwIY', 'JQgUI8Z7xS0', 'KnflWufpayh', 'uA11KKxoO5G') and Monthly
>> in
>> > ('201212') group by de,Monthly,co
>> > Time: 36695 micros: Analytics SQL: select de,Monthly,co, sum(value) as
>> > value from analytics_2012 where de in ('iVh9sX2kem9', 'BN0Ym07T1YX',
>> > 'QT2t4hnEN0e', 'NoLW5m1q2mn', 'm7L9JsRGxFJ', 'Ngr63bWMZaM') and Monthly
>> in
>> > ('201212') group by de,Monthly,co
>> > Time: 41915 micros: Analytics SQL: select de,Monthly,co, sum(value) as
>> > value from analytics_2012 where de in ('Yy0k0M9I6By', 'pjhHtGHeApk',
>> > 'Vh90cgF0E1m', 'dM9Of9QMPVp', 'JbCxyXdyUsc', 'Hh9LKZTcjin') and Monthly
>> in
>> > ('201212') group by de,Monthly,co
>> > Time: 44891 micros: Got aggregated values for query group
>> > Time: 45158 micros: Got aggregated values
>> > * ERROR 2013-06-08 23:51:31,084 Error while executing action
>> > (ExceptionInterceptor.java [http-9080-3])
>> > java.lang.NullPointerException
>> > at java.io.StringReader.<init>(StringReader.java:50)
>> > at org.nfunk.jep.JEP.parseExpression(Unknown Source)
>> > at
>> >
>> org.hisp.dhis.system.util.MathUtils.calculateExpression(MathUtils.java:88)
>> > at
>> >
>> org.hisp.dhis.expression.DefaultExpressionService.getIndicatorValue(DefaultExpressionService.java:159)
>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> > at
>> >
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> > at
>> >
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> > at java.lang.reflect.Method.invoke(Method.java:616)
>> > at
>> >
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
>> > at
>> >
>> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>> > at
>> >
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>> > at sun.proxy.$Proxy61.getIndicatorValue(Unknown Source)
>> > at
>> >
>> org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValues(DefaultAnalyticsService.java:242)
>> > at
>> >
>> org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:446)
>> > at
>> >
>> org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:477)
>> > at
>> >
>> org.hisp.dhis.reporttable.impl.DefaultReportTableService.getReportTableGrid(DefaultReportTableService.java:115)
>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> > at
>> >
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> > at
>> >
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> > at java.lang.reflect.Method.invoke(Method.java:616)
>> > at
>> >
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
>> > at
>> >
>> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
>> > at
>> >
>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
>> > at
>> >
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>> > at
>> >
>> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
>> > at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>> > at
>> >
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>> > at sun.proxy.$Proxy64.getReportTableGrid(Unknown Source)
>> > at
>> >
>> org.hisp.dhis.reporting.tablecreator.action.ExportTableAction.execute(ExportTableAction.java:185)
>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> > at
>> >
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> > at
>> >
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> > at java.lang.reflect.Method.invoke(Method.java:616)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
>> > at
>> >
>> org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:112)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:103)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:135)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:249)
>> > at
>> >
>> com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:109)
>> > at
>> >
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> > at
>> >
>> org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
>> > at
>> >
>> org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:546)
>> > at
>> >
>> org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
>> > at
>> >
>> org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
>> > at
>> >
>> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
>> > at
>> >
>> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
>> > at
>> >
>> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
>> > at
>> >
>> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
>> > at
>> >
>> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> > at
>> >
>> org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:152)
>> > at
>> >
>> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> > at
>> >
>> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
>> > at
>> >
>> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> > at
>> >
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>> > at
>> >
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>> > at
>> >
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>> > at
>> >
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
>> > at
>> >
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>> > at
>> >
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
>> > at
>> >
>> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
>> > at
>> >
>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
>> > at
>> > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
>> > at java.lang.Thread.run(Thread.java:679)
>> >
>> > My system is:
>> >
>> > Current user:
>> > orvaquim
>> > Version:
>> > 2.12
>> > Build revision:
>> > 11149
>> > Build date:
>> > 2013-06-07 08:08
>> > User agent:
>> > Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101
>> > Firefox/21.0
>> > External configuration directory:
>> > /opt/dhis2
>> > Environment variable:
>> > DHIS2_HOME
>> > Database type:
>> > PostgreSQL
>> > Database name:
>> > dhisdb
>> > Database user:
>> > sa
>> > Java Opts:
>> > Java version:
>> > 1.6.0_27
>> > Java vendor:
>> > Sun Microsystems Inc.
>> > OS name:
>> > Linux
>> > OS architecture:
>> > amd64
>> > OS version:
>> > 3.2.0-45-generic
>> > Server date:
>> > 2013-06-08 23:52
>> > Server memory:
>> > Mem Total in JVM: 1152 Free in JVM: 673 Max Limit: 1703
>> > CPU cores:
>> > 4
>> >
>> > Thank you
>> >
>> > To manage notifications about this bug go to:
>> > https://bugs.launchpad.net/dhis2/+bug/1189045/+subscriptions
>> >
>> > _______________________________________________
>> > Mailing list: https://launchpad.net/~dhis2-devs
>> > Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> > Unsubscribe : https://launchpad.net/~dhis2-devs
>> > More help : https://help.launchpad.net/ListHelp
>> >
>>
>> --
>> You received this bug notification because you are a member of DHIS 2
>> developers, which is subscribed to DHIS.
>> https://bugs.launchpad.net/bugs/1189045
>>
>> Title:
>> Old report tables (from 2.10) are not working on 2.12
>>
>> Status in DHIS 2 - District Health Information Software:
>> New
>>
>> Bug description:
>> My old report tables designed on version 2.10 are not being generated
>> on 2.12.
>>
>> I have run both datamart and analytics. When I try to generate those
>> report tables I get this on the catalina.out:
>>
>> * INFO 2013-06-08 23:51:30,888 Generating report table grid:
>> HntS8zC0eFT, date: Sat Dec 01 00:00:00 CAT 2012, ou: XrSevkDRESe
>> (DefaultReportTableService.java [http-9080-3])
>> * INFO 2013-06-08 23:51:31,037 Split on de: 4
>> (DefaultQueryPlanner.java [http-9080-3])
>> Time: 1952 micros: Planned query, got: 4 for optimal: 4
>> Time: 34029 micros: Analytics SQL: select de,Monthly,co, sum(value) as
>> value from analytics_2012 where de in ('K7cHhK8vR4L', 'c84dFlkOMS0',
>> 'K6SVqNDiFdd', 'QC2mRUtFHNS', 'xXGPmh7ihAl', 'b1wgBBJbFrX') and Monthly in
>> ('201212') group by de,Monthly,co
>> Time: 34117 micros: Analytics SQL: select de,Monthly,co, sum(value) as
>> value from analytics_2012 where de in ('qvx8gBKV6bM', 'XRFVcYwVVcm',
>> 'nGMJGc4ZwIY', 'JQgUI8Z7xS0', 'KnflWufpayh', 'uA11KKxoO5G') and Monthly in
>> ('201212') group by de,Monthly,co
>> Time: 36695 micros: Analytics SQL: select de,Monthly,co, sum(value) as
>> value from analytics_2012 where de in ('iVh9sX2kem9', 'BN0Ym07T1YX',
>> 'QT2t4hnEN0e', 'NoLW5m1q2mn', 'm7L9JsRGxFJ', 'Ngr63bWMZaM') and Monthly in
>> ('201212') group by de,Monthly,co
>> Time: 41915 micros: Analytics SQL: select de,Monthly,co, sum(value) as
>> value from analytics_2012 where de in ('Yy0k0M9I6By', 'pjhHtGHeApk',
>> 'Vh90cgF0E1m', 'dM9Of9QMPVp', 'JbCxyXdyUsc', 'Hh9LKZTcjin') and Monthly in
>> ('201212') group by de,Monthly,co
>> Time: 44891 micros: Got aggregated values for query group
>> Time: 45158 micros: Got aggregated values
>> * ERROR 2013-06-08 23:51:31,084 Error while executing action
>> (ExceptionInterceptor.java [http-9080-3])
>> java.lang.NullPointerException
>> at java.io.StringReader.<init>(StringReader.java:50)
>> at org.nfunk.jep.JEP.parseExpression(Unknown Source)
>> at
>> org.hisp.dhis.system.util.MathUtils.calculateExpression(MathUtils.java:88)
>> at
>> org.hisp.dhis.expression.DefaultExpressionService.getIndicatorValue(DefaultExpressionService.java:159)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:616)
>> at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
>> at
>> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>> at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>> at sun.proxy.$Proxy61.getIndicatorValue(Unknown Source)
>> at
>> org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValues(DefaultAnalyticsService.java:242)
>> at
>> org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:446)
>> at
>> org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:477)
>> at
>> org.hisp.dhis.reporttable.impl.DefaultReportTableService.getReportTableGrid(DefaultReportTableService.java:115)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:616)
>> at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
>> at
>> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
>> at
>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
>> at
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>> at
>> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>> at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>> at sun.proxy.$Proxy64.getReportTableGrid(Unknown Source)
>> at
>> org.hisp.dhis.reporting.tablecreator.action.ExportTableAction.execute(ExportTableAction.java:185)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:616)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
>> at
>> org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:112)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:103)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:135)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:249)
>> at
>> com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:109)
>> at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
>> at
>> org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
>> at
>> org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:546)
>> at
>> org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
>> at
>> org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
>> at
>> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
>> at
>> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> at
>> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> at
>> org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> at
>> org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> at
>> org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> at
>> org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> at
>> org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> at
>> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> at
>> org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> at
>> org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> at
>> org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> at
>> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
>> at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>> at
>> org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
>> at
>> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
>> at
>> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
>> at
>> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> at
>> org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:152)
>> at
>> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> at
>> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
>> at
>> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>> at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>> at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>> at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
>> at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>> at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
>> at
>> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
>> at
>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
>> at
>> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
>> at java.lang.Thread.run(Thread.java:679)
>>
>> My system is:
>>
>> Current user:
>> orvaquim
>> Version:
>> 2.12
>> Build revision:
>> 11149
>> Build date:
>> 2013-06-07 08:08
>> User agent:
>> Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101
>> Firefox/21.0
>> External configuration directory:
>> /opt/dhis2
>> Environment variable:
>> DHIS2_HOME
>> Database type:
>> PostgreSQL
>> Database name:
>> dhisdb
>> Database user:
>> sa
>> Java Opts:
>> Java version:
>> 1.6.0_27
>> Java vendor:
>> Sun Microsystems Inc.
>> OS name:
>> Linux
>> OS architecture:
>> amd64
>> OS version:
>> 3.2.0-45-generic
>> Server date:
>> 2013-06-08 23:52
>> Server memory:
>> Mem Total in JVM: 1152 Free in JVM: 673 Max Limit: 1703
>> CPU cores:
>> 4
>>
>> Thank you
>>
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/dhis2/+bug/1189045/+subscriptions
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Cordialmente,
>
>
> *Ing. Marko David Garcia M.
> *
> *Área de Sistemas integrados de Información
> Secretaría de Salud Departamental del Cauca
>
> *
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
>
References
