Standard report not working

Lars · 6 September 2012 10:49

Thanks Ese, good that you figured it out. Sorry for not replying earlier.
Lars

···

On Wed, Sep 5, 2012 at 2:25 PM, Ese Egerega <ese@cis.com.ng> wrote:
=0AHi Lars,

Am sure you have been too busy to respond. I thought I should let you know =
that the error is now fixed.
=0A
The problem had to do with the Locale on the server. I listed out the local=
es (locale -a) on the server and I noticed that utf-8 was not available so =
I generated locales manually ($ sudo locale-gen) and that was it.=20
=0A=0A
My jasper reports are now loading.

Thanks,

Ese

On Mon, Sep 3, 2012 at 6:15 PM, Ese Egerega <ese@cis.com.ng> wrote:
=0A=0AHi Lars,

I restarted my server and report table is now working but am still having t=
rouble using the "downloading as report" link. Meanwhile, tomcat log is not=
showing any errors (see below).=20
=0A=0A
=0AWhen I run the report table, I can download as Excel, CSV, PDF and JRXML=
but I get an error when I click on "Download as report".=20

Below is the URL of the page that loads. I noticed also that when I change =
the word jasper on the URL to pdf, it works perfectly with no errors.
=0A=0A=0A
Any idea why this is happening? Please advice.

http://50.62.13.132/dhis/dhis-web-reporting/exportTable.action?uid=3DyF0uPA=
lmBZx&type=3Djasper&useLast=3Dtrue
=0A=0A=0A
http://50.62.13.132/dhis/dhis-web-reporting/exportTable.action?uid=3DyF0uPA=
lmBZx&type=3Dpdf&useLast=3Dtrue
=0A=0A=0A

TOMCAT LOG:
* INFO=C2=A0 2012-09-03 09:46:39,640 User login success: 'admin' (DefaultUs=
erAuditService.java [ajp-bio-8009-exec-4])
* INFO=C2=A0 2012-09-03 09:49:05,884 Running report table: TEGIN - Monthly =
Report (DefaultReportTableService.java [ajp-bio-8009-exec-4])
=0A=0A=0A* INFO=C2=A0 2012-09-03 09:49:05,886 Reporting period date default=
: August 2012 (DefaultReportTableService.java [ajp-bio-8009-exec-4])
* INFO=C2=A0 2012-09-03 09:49:05,887 Organisation unit: Nigeria (DefaultRep=
ortTableService.java [ajp-bio-8009-exec-4])=0A=0A
=0A

On Mon, Sep 3, 2012 at 2:31 PM, Ese Egerega <ese@cis.com.ng> wrote:
=0A=0A=0AHi Lars,

Thanks for your response.=20

It appears that the problem is more complex than I thought. I think there i=
s a problem with the database. Standard tables and report tables are no lon=
ger working.=20

=0A=0A=0AI get the following error each time I click on standard reports or=
report tables. The problem started when I ungraded from version 2.8 to 2.9
=0A
Exception (org.hibernate.exception.SQLGrammarException):=0A =
ERROR: column this_.last3months does not exist=0A Position: 873=0A =
=0A =0A =0A [+]=0A Caused by (org.postgresql.=
util.PSQLException):=0A ERROR: column this_.last3months does not e=
xist=0A Position: 873=0A Below is the tomcat server log:

* WARN=C2=A0 2012-09-03 05:44:28,810 SQL Error: 0, SQLState: 42703 (SqlExce=
ptionHelper.java [ajp-bio-8009-exec-5])
* ERROR 2012-09-03 05:44:28,811 ERROR: column this_.last3months does not ex=
ist
=0A=0A=0A=0A=C2=A0 Position: 873 (SqlExceptionHelper.java [ajp-bio-8009-exe=
c-5])
* ERROR 2012-09-03 05:44:28,814 Error while executing action (ExceptionInte=
rceptor.java [ajp-bio-8009-exec-5])
org.hibernate.exception.SQLGrammarException: ERROR: column this_.last3month=
s does not exist
=0A=0A=0A=0A=C2=A0 Position: 873
=C2=A0=C2=A0=C2=A0 at org.hibernate.exception.internal.SQLStateConversionDe=
legate.convert(SQLStateConversionDelegate.java:122)
=C2=A0=C2=A0=C2=A0 at org.hibernate.exception.internal.StandardSQLException=
Converter.convert(StandardSQLExceptionConverter.java:49)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.hibernate.engine.jdbc.spi.SqlExceptio=
nHelper.convert(SqlExceptionHelper.java:125)
=C2=A0=C2=A0=C2=A0 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.conv=
ert(SqlExceptionHelper.java:110)
=C2=A0=C2=A0=C2=A0 at org.hibernate.engine.jdbc.internal.proxy.AbstractStat=
ementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129=
)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.hibernate.engine.jdbc.internal.proxy.=
AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
=C2=A0=C2=A0=C2=A0 at $Proxy121.executeQuery(Unknown Source)
=C2=A0=C2=A0=C2=A0 at org.hibernate.loader.Loader.getResultSet(Loader.java:=
1953)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.hibernate.loader.Loader.doQuery(Loade=
r.java:829)
=C2=A0=C2=A0=C2=A0 at org.hibernate.loader.Loader.doQueryAndInitializeNonLa=
zyCollections(Loader.java:289)
=C2=A0=C2=A0=C2=A0 at org.hibernate.loader.Loader.doList(Loader.java:2438)
=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.hibernate.loader.Loader.listUsingQueryCa=
che(Loader.java:2283)
=0A=C2=A0=C2=A0=C2=A0 at org.hibernate.loader.Loader.list(Loader.java:2246)
=C2=A0=C2=A0=C2=A0 at org.hibernate.loader.criteria.CriteriaLoader.list(Cri=
teriaLoader.java:122)
=C2=A0=C2=A0=C2=A0 at org.hibernate.internal.SessionImpl.list(SessionImpl.j=
ava:1622)
=C2=A0=C2=A0=C2=A0 at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl=
.java:374)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.hibernate.HibernateGenericS=
tore.getBetween(HibernateGenericStore.java:294)
=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.reporttable.impl.DefaultReportTableServ=
ice.getReportTablesBetween(DefaultReportTableService.java:241)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at sun.reflect.NativeMethodAccessorImpl.invo=
ke0(Native Method)
=C2=A0=C2=A0=C2=A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMet=
hodAccessorImpl.java:39)
=C2=A0=C2=A0=C2=A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Deleg=
atingMethodAccessorImpl.java:25)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at java.lang.reflect.Method.invoke(Method.ja=
va:597)
=C2=A0=C2=A0=C2=A0 at org.springframework.aop.support.AopUtils.invokeJoinpo=
intUsingReflection(AopUtils.java:318)
=C2=A0=C2=A0=C2=A0 at org.springframework.aop.framework.ReflectiveMethodInv=
ocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.aop.framework.Reflect=
iveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
=C2=A0=C2=A0=C2=A0 at org.springframework.transaction.interceptor.Transacti=
onInterceptor.invoke(TransactionInterceptor.java:110)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.aop.framework.Reflect=
iveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
=C2=A0=C2=A0=C2=A0 at org.springframework.aop.interceptor.ExposeInvocationI=
nterceptor.invoke(ExposeInvocationInterceptor.java:90)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.aop.framework.Reflect=
iveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
=C2=A0=C2=A0=C2=A0 at org.springframework.aop.framework.JdkDynamicAopProxy.=
invoke(JdkDynamicAopProxy.java:202)
=C2=A0=C2=A0=C2=A0 at $Proxy77.getReportTablesBetween(Unknown Source)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.reporting.tablecreator.acti=
on.GetAllTablesAction.execute(GetAllTablesAction.java:98)
=C2=A0=C2=A0=C2=A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M=
ethod)
=C2=A0=C2=A0=C2=A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMet=
hodAccessorImpl.java:39)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at sun.reflect.DelegatingMethodAccessorImpl.=
invoke(DelegatingMethodAccessorImpl.java:25)
=C2=A0=C2=A0=C2=A0 at java.lang.reflect.Method.invoke(Method.java:597)
=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvocation.invok=
eAction(DefaultActionInvocation.java:453)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvo=
cation.invokeActionOnly(DefaultActionInvocation.java:292)
=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvocation.invok=
e(DefaultActionInvocation.java:255)
=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.webportal.interceptor.XWorkPortalUserIn=
terceptor.intercept(XWorkPortalUserInterceptor.java:87)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvo=
cation.invoke(DefaultActionInvocation.java:249)
=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.webportal.interceptor.XWorkPortalModule=
Interceptor.intercept(XWorkPortalModuleInterceptor.java:90)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvo=
cation.invoke(DefaultActionInvocation.java:249)
=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuIn=
terceptor.intercept(XWorkPortalMenuInterceptor.java:96)
=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvocation.invok=
e(DefaultActionInvocation.java:249)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.webportal.interceptor.XWork=
PortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118)
=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvocation.invok=
e(DefaultActionInvocation.java:249)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.interceptor.ContextIntercep=
tor.intercept(ContextInterceptor.java:81)
=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvocation.invok=
e(DefaultActionInvocation.java:249)
=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.interceptor.UserSettingInterceptor.inte=
rcept(UserSettingInterceptor.java:80)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvo=
cation.invoke(DefaultActionInvocation.java:249)
=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.security.intercept.LoginInterceptor.int=
ercept(LoginInterceptor.java:84)
=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvocation.invok=
e(DefaultActionInvocation.java:249)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.security.intercept.XWorkSec=
urityInterceptor.intercept(XWorkSecurityInterceptor.java:103)
=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvocation.invok=
e(DefaultActionInvocation.java:249)
=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.interceptor.SystemSettingInterceptor.in=
tercept(SystemSettingInterceptor.java:88)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvo=
cation.invoke(DefaultActionInvocation.java:249)
=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I=
18nInterceptor.java:137)
=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvocation.invok=
e(DefaultActionInvocation.java:249)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.interceptor.Param=
etersInterceptor.doIntercept(ParametersInterceptor.java:211)
=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.interceptor.MethodFilterInter=
ceptor.intercept(MethodFilterInterceptor.java:98)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvo=
cation.invoke(DefaultActionInvocation.java:249)
=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.interceptor.StaticParametersI=
nterceptor.intercept(StaticParametersInterceptor.java:190)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvo=
cation.invoke(DefaultActionInvocation.java:249)
=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.interceptor.ExceptionInterceptor.interc=
ept(ExceptionInterceptor.java:100)
=C2=A0=C2=A0=C2=A0 at com.opensymphony.xwork2.DefaultActionInvocation.invok=
e(DefaultActionInvocation.java:249)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.apache.struts2.impl.StrutsActionProxy=
.execute(StrutsActionProxy.java:54)
=C2=A0=C2=A0=C2=A0 at org.apache.struts2.dispatcher.Dispatcher.serviceActio=
n(Dispatcher.java:510)
=C2=A0=C2=A0=C2=A0 at org.apache.struts2.dispatcher.FilterDispatcher.doFilt=
er(FilterDispatcher.java:432)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.apache.catalina.core.ApplicationFilte=
rChain.internalDoFilter(ApplicationFilterChain.java:243)
=C2=A0=C2=A0=C2=A0 at org.apache.catalina.core.ApplicationFilterChain.doFil=
ter(ApplicationFilterChain.java:210)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterChainProxy$Vir=
tualFilterChain.doFilter(FilterChainProxy.java:322)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.access.i=
ntercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:11=
6)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.access.intercept.Fil=
terSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterCh=
ainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.access.ExceptionTran=
slationFilter.doFilter(ExceptionTranslationFilter.java:113)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterCh=
ainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.session.SessionManag=
ementFilter.doFilter(SessionManagementFilter.java:103)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterCh=
ainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.authentication.Anony=
mousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterCh=
ainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.servletapi.SecurityC=
ontextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFi=
lter.java:54)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterCh=
ainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.savedrequest.Request=
CacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterCh=
ainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.authentication.www.B=
asicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterCh=
ainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.authentication.Abstr=
actAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessing=
Filter.java:182)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterCh=
ainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.authentication.logou=
t.LogoutFilter.doFilter(LogoutFilter.java:105)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterCh=
ainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
=C2=A0=C2=A0=C2=A0 at org.hisp.dhis.security.filter.AutomaticAccessFilter.d=
oFilter(AutomaticAccessFilter.java:112)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterChainProxy$Vir=
tualFilterChain.doFilter(FilterChainProxy.java:334)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.context.=
SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.=
java:87)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterChainProxy$Vir=
tualFilterChain.doFilter(FilterChainProxy.java:334)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterCh=
ainProxy.doFilterInternal(FilterChainProxy.java:184)
=C2=A0=C2=A0=C2=A0 at org.springframework.security.web.FilterChainProxy.doF=
ilter(FilterChainProxy.java:155)
=C2=A0=C2=A0=C2=A0 at org.springframework.web.filter.DelegatingFilterProxy.=
invokeDelegate(DelegatingFilterProxy.java:346)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.web.filter.Delegating=
FilterProxy.doFilter(DelegatingFilterProxy.java:259)
=C2=A0=C2=A0=C2=A0 at org.apache.catalina.core.ApplicationFilterChain.inter=
nalDoFilter(ApplicationFilterChain.java:243)
=C2=A0=C2=A0=C2=A0 at org.apache.catalina.core.ApplicationFilterChain.doFil=
ter(ApplicationFilterChain.java:210)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.springframework.orm.hibernate4.suppor=
t.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119=
)
=C2=A0=C2=A0=C2=A0 at org.springframework.web.filter.OncePerRequestFilter.d=
oFilter(OncePerRequestFilter.java:76)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.apache.catalina.core.ApplicationFilte=
rChain.internalDoFilter(ApplicationFilterChain.java:243)
=C2=A0=C2=A0=C2=A0 at org.apache.catalina.core.ApplicationFilterChain.doFil=
ter(ApplicationFilterChain.java:210)
=C2=A0=C2=A0=C2=A0 at org.apache.catalina.core.StandardWrapperValve.invoke(=
StandardWrapperValve.java:225)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.apache.catalina.core.StandardContextV=
alve.invoke(StandardContextValve.java:123)
=C2=A0=C2=A0=C2=A0 at org.apache.catalina.authenticator.AuthenticatorBase.i=
nvoke(AuthenticatorBase.java:472)
=C2=A0=C2=A0=C2=A0 at org.apache.catalina.core.StandardHostValve.invoke(Sta=
ndardHostValve.java:168)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.apache.catalina.valves.ErrorReportVal=
ve.invoke(ErrorReportValve.java:98)
=C2=A0=C2=A0=C2=A0 at org.apache.catalina.valves.AccessLogValve.invoke(Acce=
ssLogValve.java:927)
=C2=A0=C2=A0=C2=A0 at org.apache.catalina.core.StandardEngineValve.invoke(S=
tandardEngineValve.java:118)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.apache.catalina.connector.CoyoteAdapt=
er.service(CoyoteAdapter.java:407)
=C2=A0=C2=A0=C2=A0 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcess=
or.java:200)
=C2=A0=C2=A0=C2=A0 at org.apache.coyote.AbstractProtocol$AbstractConnection=
Handler.process(AbstractProtocol.java:579)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.apache.tomcat.util.net.JIoEndpoint$So=
cketProcessor.run(JIoEndpoint.java:310)
=C2=A0=C2=A0=C2=A0 at java.util.concurrent.ThreadPoolExecutor$Worker.runTas=
k(ThreadPoolExecutor.java:886)
=C2=A0=C2=A0=C2=A0 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Th=
readPoolExecutor.java:908)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at java.lang.Thread.run(Thread.java:619)
Caused by: org.postgresql.util.PSQLException: ERROR: column this_.last3mont=
hs does not exist
=C2=A0 Position: 873
=C2=A0=C2=A0=C2=A0 at org.postgresql.core.v3.QueryExecutorImpl.receiveError=
Response(QueryExecutorImpl.java:2103)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.postgresql.core.v3.QueryExecutorImpl.=
processResults(QueryExecutorImpl.java:1836)
=C2=A0=C2=A0=C2=A0 at org.postgresql.core.v3.QueryExecutorImpl.execute(Quer=
yExecutorImpl.java:257)
=C2=A0=C2=A0=C2=A0 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(A=
bstractJdbc2Statement.java:512)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.postgresql.jdbc2.AbstractJdbc2Stateme=
nt.executeWithFlags(AbstractJdbc2Statement.java:388)
=C2=A0=C2=A0=C2=A0 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQu=
ery(AbstractJdbc2Statement.java:273)
=C2=A0=C2=A0=C2=A0 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.ex=
ecuteQuery(NewProxyPreparedStatement.java:76)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at sun.reflect.GeneratedMethodAccessor201.in=
voke(Unknown Source)
=C2=A0=C2=A0=C2=A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Deleg=
atingMethodAccessorImpl.java:25)
=C2=A0=C2=A0=C2=A0 at java.lang.reflect.Method.invoke(Method.java:597)
=0A=0A=0A=0A=C2=A0=C2=A0=C2=A0 at org.hibernate.engine.jdbc.internal.proxy.=
AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHand=
ler.java:122)
=C2=A0=C2=A0=C2=A0 ... 114 more

=0AOn Mon, Sep 3, 2012 at 9:28 AM, Lars Helge =C3=98verland <larshelge@gmai=
l.com> wrote:
=0AHello Ese,
there is no need to install jasper on the server.
What is probably the cause is an error with the jasper design file you have=
uploaded. Try looking in the Tomcat server log while you execute the repor=
t and post the output..=0A=0A=0A=0A=0A
regards,
Lars

On Sun, Sep 2, 2012 at 12:15 AM, Ese Egerega <ese@cis.com.ng> wrote:
=0A=0A=0A=0A=0AI may be wrong but it appears that am getting this error mes=
sage because I don't have jasper installed on my server (Ubuntu 10.0.4).=20
=0A=0A=0A=0A=0A
Can anyone help me with a link to the version of Jasper that works best wit=
h dhis v2.8? I will appreciate it.
=0A
Thanks,
Ese

On Sat, Sep 1, 2012 at 8:36 PM, Ese Egerega <ese@cis.com.ng> wrote:
=0A=0ADear All,

Can anyone be of help? I get the following error each time I try to run a s=
tandard report:

Oops, something went wrong
=0A=0A=09=09=09=09=09Do not panic, we have recorded it in the log=0A =
=20

I get the same error when I try to download a report table report

=0A
I am running version DHIS 2.8

=0A
=0A
_______________________________________________
=0AMailing list: DHIS 2 Users in Launchpad
=0APost to =C2=A0 =C2=A0 : dhis2-users@lists.launchpad.net
=0AUnsubscribe : DHIS 2 Users in Launchpad
=0AMore help =C2=A0 : ListHelp - Launchpad Help
=0A

=0A
=0A
=0A
=0A
=0A
-----Inline Attachment Follows-----

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

--1671867401-1076052391-1346996703=:38803
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;">Thanks Lars<div><br></div><div>regards<br><br=

<div><font color=3D"#0000bf">PEPELA WANJALA</font></div><div><font color=

=3D"#6000bf"><strong>MINISTRY OF HEALTH HEADQUARTERS</strong></font></div><=

<strong><font color=3D"#6000bf">HEALTH INFORMATION SYSTEM</font></=
</div><div><strong>AFYA HOUSE, HIS LG 37</strong></div><div><strong>=

P.O BOX 30016, NAIROBI, KENYA</strong></div><div><strong>TEL: +254 (020) 27=
17077 EXT 45097</strong></div><div><strong>CELL: +254 (0) 722375633 or 0202=
033363</strong></div><div><strong>EMAIL: <font color=3D"#0000bf"><a rel=3D"=
nofollow" target=3D"_blank" href=3D"mailto:wanjala2p@yahoo.com">wanjala2p@y=
ahoo.com</a></font></strong></div><div><strong><font color=3D"#0000bf">&nbs=
p;           <a rel=3D"no=
follow" target=3D"_blank"
href=3D"mailto:hmis@health.go.ke">hmis@health.go.ke</a></font></strong></d=

<div><font class=3D"Apple-style-span" color=3D"#00007f"><span class=3D"A=

pple-style-span" style=3D"font-size:19px;font-weight:800;line-height:21px;"=

<i><img src=3D"http://mail.yimg.com/us.yimg.com/i/mesg/tsmileys2/18.gif">&=

nbsp;</i></span></font><b><span style=3D"font-size:14.0pt;color:#7030A0;">"=
HealthInformation Management - Making a World of Difference=E2=80=9D</span>=
</b></div><p class=3D"MsoNormal" style=3D"margin-bottom:0in;margin-bottom:.=
0001pt;line-height:normal;"><span style=3D"color:#7030A0;"></span></p><div>=
 </div><br><br>--- On <b>Thu, 9/6/12, Lars Helge =C3=98verland <i><=
larshelge@gmail.com></i></b> wrote:<br><blockquote style=3D"border-left:=
2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From=
: Lars Helge =C3=98verland <larshelge@gmail.com><br>Subject: Re: [Dhi=
s2-users] Standard report not working<br>To: "Ese Egerega" <ese@cis.com.=
ng><br>Cc:
dhis2-users@lists.launchpad.net<br>Date: Thursday, September 6, 2012, 10:4=
9 AM<br><br><div id=3D"yiv221794775">Thanks Ese, good that you figured it o=
ut. Sorry for not replying earlier.<div><br></div><div>Lars<br><br><div cla=
ss=3D"yiv221794775gmail_quote">On Wed, Sep 5, 2012 at 2:25 PM, Ese Egerega =
<span dir=3D"ltr"><<a rel=3D"nofollow" ymailto=3D"mailto:ese@cis.com.ng"=
target=3D"_blank" href=3D"/mc/compose?to=3Dese@cis.com.ng">ese@cis.com.ng<=
/a>></span> wrote:<br>=0A<blockquote class=3D"yiv221794775gmail_quote" s=
tyle=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi =
Lars,<br><br>Am sure you have been too busy to respond. I thought I should =
let you know that the error is now fixed.<br>=0A<br>The problem had to do w=
ith the Locale on the server. I listed out the locales (locale -a) on the s=
erver and I noticed that utf-8 was not available so I generated locales man=
ually ($ sudo locale-gen) and that was it. <br>=0A=0A<br>My jasper reports =
are now loading.<br><br>Thanks,<br><br>Ese<div class=3D"yiv221794775HOEnZb"=

<div class=3D"yiv221794775h5"><br><br><div class=3D"yiv221794775gmail_quot=

e">On Mon, Sep 3, 2012 at 6:15 PM, Ese Egerega <span dir=3D"ltr"><<a rel=
=3D"nofollow" ymailto=3D"mailto:ese@cis.com.ng" target=3D"_blank" href=3D"/=
mc/compose?to=3Dese@cis.com.ng">ese@cis.com.ng</a>></span> wrote:<br>=0A=
=0A<blockquote class=3D"yiv221794775gmail_quote" style=3D"margin:0 0 0 .8ex=
;border-left:1px #ccc solid;padding-left:1ex;">Hi Lars,<br><br>I restarted =
my server and report table is now working but am still having trouble using=
the<b> "downloading as report"</b> link. Meanwhile, tomcat log is not show=
ing any errors (see below). <br>=0A=0A<br>=0AWhen I run the report table, I=
can download as Excel, CSV, PDF and JRXML but I get an error when I click =
on <b>"Download as report".</b> <br><br>Below is the URL of the page that l=
oads. I noticed also that when I change the word<span style=3D"color:rgb(25=
5,0,0);"> jasper</span> on the URL to <span style=3D"color:rgb(255,0,0);">p=
df,</span> it works perfectly with no errors.<br>=0A=0A=0A<br>Any idea why =
this is happening? Please advice.<br><br><b><a rel=3D"nofollow" target=3D"_=
blank" href=3D"http://50.62.13.132/dhis/dhis-web-reporting/exportTable.act=
ion?uid=3DyF0uPAlmBZx&type=3D">http://50.62.13.132/dhis/dhis-web-report=
ing/exportTable.action?uid=3DyF0uPAlmBZx&type=3D</a><span style=3D"colo=
r:rgb(255,0,0);">jasper</span>&useLast=3Dtrue<br>=0A=0A=0A<br><a rel=3D=
"nofollow" target=3D"_blank" href=3D"http://50.62.13.132/dhis/dhis-web-rep=
orting/exportTable.action?uid=3DyF0uPAlmBZx&type=3D">http://50.62.13.13=
2/dhis/dhis-web-reporting/exportTable.action?uid=3DyF0uPAlmBZx&type=3D<=
/a></b><b><span style=3D"color:rgb(255,0,0);">pdf</span>&useLast=3Dtrue=
</b><br>=0A=0A=0A<br><br><u><b>TOMCAT LOG:</b></u><br>* INFO  2012-09-=
03 09:46:39,640 User login success: 'admin' (DefaultUserAuditService.java [=
ajp-bio-8009-exec-4])<br>* INFO  2012-09-03 09:49:05,884 Running repor=
t table: TEGIN - Monthly Report (DefaultReportTableService.java [ajp-bio-80=
09-exec-4])<br>=0A=0A=0A* INFO  2012-09-03 09:49:05,886 Reporting peri=
od date default: August 2012 (DefaultReportTableService.java [ajp-bio-8009-=
exec-4])<br>* INFO  2012-09-03 09:49:05,887 Organisation unit: Nigeria=
(DefaultReportTableService.java [ajp-bio-8009-exec-4])<div>=0A=0A<div><br>=
=0A<br><br><div class=3D"yiv221794775gmail_quote">On Mon, Sep 3, 2012 at 2:=
31 PM, Ese Egerega <span dir=3D"ltr"><<a rel=3D"nofollow" ymailto=3D"mai=
lto:ese@cis.com.ng" target=3D"_blank" href=3D"/mc/compose?to=3Dese@cis.com.=
ng">ese@cis.com.ng</a>></span> wrote:<br><blockquote class=3D"yiv2217947=
75gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;paddin=
g-left:1ex;">=0A=0A=0AHi Lars,<br><br>Thanks for your response. <br><br>It =
appears that the problem is more complex than I thought. I think there is a=
problem with the database. Standard tables and report tables are no longer=
working. <br><br>=0A=0A=0AI get the following error each time I click on s=
tandard reports or report tables. The problem started when I ungraded from =
version 2.8 to 2.9<br>=0A<br><h5> Exception (org.hibernate.exception=
.SQLGrammarException):=0A ERROR: column this_.last3months does not=
exist=0A Position: 873=0A </h5>=0A =0A <h5>=0A =
<span><a rel=3D"nofollow">[+]</a></span>=0A Caused by (org.postgre=
sql.util.PSQLException):=0A ERROR: column this_.last3months does n=
ot exist=0A Position: 873=0A </h5><u>Below is the tomcat server log</=

:<br><br>* WARN  2012-09-03 05:44:28,810 SQL Error: 0, SQLState: 427=

03 (SqlExceptionHelper.java [ajp-bio-8009-exec-5])<br>* ERROR 2012-09-03 05=
:44:28,811 ERROR: column this_.last3months does not exist<br>=0A=0A=0A=0A&n=
bsp; Position: 873 (SqlExceptionHelper.java [ajp-bio-8009-exec-5])<br>* ERR=
OR 2012-09-03 05:44:28,814 Error while executing action (ExceptionIntercept=
or.java [ajp-bio-8009-exec-5])<br>org.hibernate.exception.SQLGrammarExcepti=
on: ERROR: column this_.last3months does not exist<br>=0A=0A=0A=0A  Po=
sition: 873<br>    at org.hibernate.exception.internal.SQLSt=
ateConversionDelegate.convert(SQLStateConversionDelegate.java:122)<br>&nbsp=
;   at org.hibernate.exception.internal.StandardSQLExceptionConve=
rter.convert(StandardSQLExceptionConverter.java:49)<br>=0A=0A=0A=0A &n=
bsp;  at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlE=
xceptionHelper.java:125)<br>    at org.hibernate.engine.jdbc=
.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)<br> &nbsp=
;  at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyH=
andler.continueInvocation(AbstractStatementProxyHandler.java:129)<br>=0A=0A=
=0A=0A    at org.hibernate.engine.jdbc.internal.proxy.Abstra=
ctProxyHandler.invoke(AbstractProxyHandler.java:81)<br>    a=
t $Proxy121.executeQuery(Unknown Source)<br>    at org.hiber=
nate.loader.Loader.getResultSet(Loader.java:1953)<br>=0A=0A=0A=0A &nbs=
p;  at org.hibernate.loader.Loader.doQuery(Loader.java:829)<br> &=
nbsp;  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyColle=
ctions(Loader.java:289)<br>    at org.hibernate.loader.Loade=
r.doList(Loader.java:2438)<br>=0A=0A=0A    at org.hibernate.=
loader.Loader.listUsingQueryCache(Loader.java:2283)<br>=0A  &nbsp=
; at org.hibernate.loader.Loader.list(Loader.java:2246)<br>  &nbs=
p; at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java=
:122)<br>    at org.hibernate.internal.SessionImpl.list(Sess=
ionImpl.java:1622)<br>    at org.hibernate.internal.Criteria=
Impl.list(CriteriaImpl.java:374)<br>=0A=0A=0A=0A    at org.h=
isp.dhis.hibernate.HibernateGenericStore.getBetween(HibernateGenericStore.j=
ava:294)<br>    at org.hisp.dhis.reporttable.impl.DefaultRep=
ortTableService.getReportTablesBetween(DefaultReportTableService.java:241)<=

=0A=0A=0A=0A    at sun.reflect.NativeMethodAccessorImpl.i=

nvoke0(Native Method)<br>    at sun.reflect.NativeMethodAcce=
ssorImpl.invoke(NativeMethodAccessorImpl.java:39)<br>    at =
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp=
l.java:25)<br>=0A=0A=0A=0A    at java.lang.reflect.Method.in=
voke(Method.java:597)<br>    at org.springframework.aop.supp=
ort.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)<br> &nb=
sp;  at org.springframework.aop.framework.ReflectiveMethodInvocation.i=
nvokeJoinpoint(ReflectiveMethodInvocation.java:183)<br>=0A=0A=0A=0A &n=
bsp;  at org.springframework.aop.framework.ReflectiveMethodInvocation.=
proceed(ReflectiveMethodInvocation.java:150)<br>    at org.s=
pringframework.transaction.interceptor.TransactionInterceptor.invoke(Transa=
ctionInterceptor.java:110)<br>=0A=0A=0A=0A    at org.springf=
ramework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodI=
nvocation.java:172)<br>    at org.springframework.aop.interc=
eptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:9=
0)<br>=0A=0A=0A=0A    at org.springframework.aop.framework.R=
eflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<br>&=
nbsp;   at org.springframework.aop.framework.JdkDynamicAopProxy.i=
nvoke(JdkDynamicAopProxy.java:202)<br>    at $Proxy77.getRep=
ortTablesBetween(Unknown Source)<br>=0A=0A=0A=0A    at org.h=
isp.dhis.reporting.tablecreator.action.GetAllTablesAction.execute(GetAllTab=
lesAction.java:98)<br>    at sun.reflect.NativeMethodAccesso=
rImpl.invoke0(Native Method)<br>    at sun.reflect.NativeMet=
hodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br>=0A=0A=0A=0A&nb=
sp;   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegati=
ngMethodAccessorImpl.java:25)<br>    at java.lang.reflect.Me=
thod.invoke(Method.java:597)<br>    at com.opensymphony.xwor=
k2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453)<b=

=0A=0A=0A=0A    at com.opensymphony.xwork2.DefaultActionIn=

vocation.invokeActionOnly(DefaultActionInvocation.java:292)<br>  =
  at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAct=
ionInvocation.java:255)<br>    at org.hisp.dhis.webportal.in=
terceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.j=
ava:87)<br>=0A=0A=0A=0A    at com.opensymphony.xwork2.Defaul=
tActionInvocation.invoke(DefaultActionInvocation.java:249)<br>  &=
nbsp; at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.i=
ntercept(XWorkPortalModuleInterceptor.java:90)<br>=0A=0A=0A=0A  &=
nbsp; at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActi=
onInvocation.java:249)<br>    at org.hisp.dhis.webportal.int=
erceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.ja=
va:96)<br>    at com.opensymphony.xwork2.DefaultActionInvoca=
tion.invoke(DefaultActionInvocation.java:249)<br>=0A=0A=0A=0A  &n=
bsp; at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.in=
tercept(XWorkPortalParamsInterceptor.java:118)<br>    at com=
.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation=
.java:249)<br>=0A=0A=0A=0A    at org.hisp.dhis.interceptor.C=
ontextInterceptor.intercept(ContextInterceptor.java:81)<br>  &nbs=
p; at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI=
nvocation.java:249)<br>    at org.hisp.dhis.interceptor.User=
SettingInterceptor.intercept(UserSettingInterceptor.java:80)<br>=0A=0A=0A=
=0A    at com.opensymphony.xwork2.DefaultActionInvocation.in=
voke(DefaultActionInvocation.java:249)<br>    at org.hisp.dh=
is.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)<=

    at com.opensymphony.xwork2.DefaultActionInvocation.in=

voke(DefaultActionInvocation.java:249)<br>=0A=0A=0A=0A    at=
org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkS=
ecurityInterceptor.java:103)<br>    at com.opensymphony.xwor=
k2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)<br>&nbs=
p;   at org.hisp.dhis.interceptor.SystemSettingInterceptor.interc=
ept(SystemSettingInterceptor.java:88)<br>=0A=0A=0A=0A    at =
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocat=
ion.java:249)<br>    at org.hisp.dhis.interceptor.I18nInterc=
eptor.intercept(I18nInterceptor.java:137)<br>    at com.open=
symphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java=
:249)<br>=0A=0A=0A=0A    at com.opensymphony.xwork2.intercep=
tor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211)<br>&n=
bsp;   at com.opensymphony.xwork2.interceptor.MethodFilterInterce=
ptor.intercept(MethodFilterInterceptor.java:98)<br>=0A=0A=0A=0A  =
  at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAct=
ionInvocation.java:249)<br>    at com.opensymphony.xwork2.in=
terceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor=
.java:190)<br>=0A=0A=0A=0A    at com.opensymphony.xwork2.Def=
aultActionInvocation.invoke(DefaultActionInvocation.java:249)<br> &nbs=
p;  at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(Except=
ionInterceptor.java:100)<br>    at com.opensymphony.xwork2.D=
efaultActionInvocation.invoke(DefaultActionInvocation.java:249)<br>=0A=0A=
=0A=0A    at org.apache.struts2.impl.StrutsActionProxy.execu=
te(StrutsActionProxy.java:54)<br>    at org.apache.struts2.d=
ispatcher.Dispatcher.serviceAction(Dispatcher.java:510)<br>  &nbs=
p; at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatc=
her.java:432)<br>=0A=0A=0A=0A    at org.apache.catalina.core=
.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)<b=

    at org.apache.catalina.core.ApplicationFilterChain.doF=

ilter(ApplicationFilterChain.java:210)<br>    at org.springf=
ramework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh=
ainProxy.java:322)<br>=0A=0A=0A=0A    at org.springframework=
.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecur=
ityInterceptor.java:116)<br>    at org.springframework.secur=
ity.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityI=
nterceptor.java:83)<br>=0A=0A=0A=0A    at org.springframewor=
k.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx=
y.java:334)<br>    at org.springframework.security.web.acces=
s.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)<=

=0A=0A=0A=0A    at org.springframework.security.web.Filte=

rChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)<br>&nbsp=
;   at org.springframework.security.web.session.SessionManagement=
Filter.doFilter(SessionManagementFilter.java:103)<br>=0A=0A=0A=0A &nbs=
p;  at org.springframework.security.web.FilterChainProxy$VirtualFilter=
Chain.doFilter(FilterChainProxy.java:334)<br>    at org.spri=
ngframework.security.web.authentication.AnonymousAuthenticationFilter.doFil=
ter(AnonymousAuthenticationFilter.java:113)<br>=0A=0A=0A=0A  &nbs=
p; at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.=
doFilter(FilterChainProxy.java:334)<br>    at org.springfram=
ework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFil=
ter(SecurityContextHolderAwareRequestFilter.java:54)<br>=0A=0A=0A=0A &=
nbsp;  at org.springframework.security.web.FilterChainProxy$VirtualFil=
terChain.doFilter(FilterChainProxy.java:334)<br>    at org.s=
pringframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(R=
equestCacheAwareFilter.java:45)<br>=0A=0A=0A=0A    at org.sp=
ringframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(Fil=
terChainProxy.java:334)<br>    at org.springframework.securi=
ty.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthentic=
ationFilter.java:150)<br>=0A=0A=0A=0A    at org.springframew=
ork.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainPr=
oxy.java:334)<br>    at org.springframework.security.web.aut=
hentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthent=
icationProcessingFilter.java:182)<br>=0A=0A=0A=0A    at org.=
springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(F=
ilterChainProxy.java:334)<br>    at org.springframework.secu=
rity.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)=
<br>=0A=0A=0A=0A    at org.springframework.security.web.Filt=
erChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)<br>&nbs=
p;   at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFil=
ter(AutomaticAccessFilter.java:112)<br>    at org.springfram=
ework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChain=
Proxy.java:334)<br>=0A=0A=0A=0A    at org.springframework.se=
curity.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContex=
tPersistenceFilter.java:87)<br>    at org.springframework.se=
curity.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.ja=
va:334)<br>=0A=0A=0A=0A    at org.springframework.security.w=
eb.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)<br> &n=
bsp;  at org.springframework.security.web.FilterChainProxy.doFilter(Fi=
lterChainProxy.java:155)<br>    at org.springframework.web.f=
ilter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)<=

=0A=0A=0A=0A    at org.springframework.web.filter.Delegat=

ingFilterProxy.doFilter(DelegatingFilterProxy.java:259)<br>  &nbs=
p; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl=
icationFilterChain.java:243)<br>    at org.apache.catalina.c=
ore.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)<br>=0A=
=0A=0A=0A    at org.springframework.orm.hibernate4.support.O=
penSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)<b=

    at org.springframework.web.filter.OncePerRequestFilter=

.doFilter(OncePerRequestFilter.java:76)<br>=0A=0A=0A=0A    a=
t org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat=
ionFilterChain.java:243)<br>    at org.apache.catalina.core.=
ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)<br> &=
nbsp;  at org.apache.catalina.core.StandardWrapperValve.invoke(Standar=
dWrapperValve.java:225)<br>=0A=0A=0A=0A    at org.apache.cat=
alina.core.StandardContextValve.invoke(StandardContextValve.java:123)<br>&n=
bsp;   at org.apache.catalina.authenticator.AuthenticatorBase.inv=
oke(AuthenticatorBase.java:472)<br>    at org.apache.catalin=
a.core.StandardHostValve.invoke(StandardHostValve.java:168)<br>=0A=0A=0A=0A=
    at org.apache.catalina.valves.ErrorReportValve.invoke(Er=
rorReportValve.java:98)<br>    at org.apache.catalina.valves=
.AccessLogValve.invoke(AccessLogValve.java:927)<br>    at or=
g.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:=
118)<br>=0A=0A=0A=0A    at org.apache.catalina.connector.Coy=
oteAdapter.service(CoyoteAdapter.java:407)<br>    at org.apa=
che.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)<br>  &=
nbsp; at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.proce=
ss(AbstractProtocol.java:579)<br>=0A=0A=0A=0A    at org.apac=
he.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)<br=

    at java.util.concurrent.ThreadPoolExecutor$Worker.runTa=

sk(ThreadPoolExecutor.java:886)<br>    at java.util.concurre=
nt.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)<br>=0A=0A=0A=
=0A    at java.lang.Thread.run(Thread.java:619)<br>Caused by=
: org.postgresql.util.PSQLException: ERROR: column this_.last3months does n=
ot exist<br>  Position: 873<br>    at org.postgresql.co=
re.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)<b=

=0A=0A=0A=0A    at org.postgresql.core.v3.QueryExecutorImp=

l.processResults(QueryExecutorImpl.java:1836)<br>    at org.=
postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br=

    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(=

AbstractJdbc2Statement.java:512)<br>=0A=0A=0A=0A    at org.p=
ostgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statem=
ent.java:388)<br>    at org.postgresql.jdbc2.AbstractJdbc2St=
atement.executeQuery(AbstractJdbc2Statement.java:273)<br>   =
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProx=
yPreparedStatement.java:76)<br>=0A=0A=0A=0A    at sun.reflec=
t.GeneratedMethodAccessor201.invoke(Unknown Source)<br>    a=
t sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)<br>    at java.lang.reflect.Method.invoke(Metho=
d.java:597)<br>=0A=0A=0A=0A    at org.hibernate.engine.jdbc.=
internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractSta=
tementProxyHandler.java:122)<br>    ... 114 more<div><div><b=

<br><br><br><div class=3D"yiv221794775gmail_quote">=0AOn Mon, Sep 3, 2012=

at 9:28 AM, Lars Helge =C3=98verland <span dir=3D"ltr"><<a rel=3D"nofol=
low" ymailto=3D"mailto:larshelge@gmail.com" target=3D"_blank" href=3D"/mc/c=
ompose?to=3Dlarshelge@gmail.com">larshelge@gmail.com</a>></span> wrote:<=

=0A<blockquote class=3D"yiv221794775gmail_quote" style=3D"margin:0 0 0 .=

8ex;border-left:1px #ccc solid;padding-left:1ex;">Hello Ese,<div><br></div>=
<div>there is no need to install jasper on the server.</div><div><br></div>=
<div>What is probably the cause is an error with the jasper design file you=
have uploaded. Try looking in the Tomcat server log while you execute the =
report and post the output..</div>=0A=0A=0A=0A=0A<div><br></div><div>regard=
s,</div><div><br></div><div>Lars<br><br><div class=3D"yiv221794775gmail_quo=
te"><div><div>On Sun, Sep 2, 2012 at 12:15 AM, Ese Egerega <span dir=3D"ltr=
"><<a rel=3D"nofollow" ymailto=3D"mailto:ese@cis.com.ng" target=3D"_blan=
k" href=3D"/mc/compose?to=3Dese@cis.com.ng">ese@cis.com.ng</a>></span> w=
rote:<br>=0A=0A=0A=0A=0A</div></div><blockquote class=3D"yiv221794775gmail_=
quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1=
ex;"><div><div>I may be wrong but it appears that am getting this error mes=
sage because I don't have jasper installed on my server (Ubuntu 10.0.4). <b=

=0A=0A=0A=0A=0A<br>Can anyone help me with a link to the version of Jaspe=

r that works best with dhis v2.8? I will appreciate it.<br>=0A<br>Thanks,<b=

Ese<div><div><br><br><div class=3D"yiv221794775gmail_quote">On Sat, Sep 1=

, 2012 at 8:36 PM, Ese Egerega <span dir=3D"ltr"><<a rel=3D"nofollow" ym=
ailto=3D"mailto:ese@cis.com.ng" target=3D"_blank" href=3D"/mc/compose?to=3D=
ese@cis.com.ng">ese@cis.com.ng</a>></span> wrote:<br>=0A<blockquote clas=
s=3D"yiv221794775gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #c=
cc solid;padding-left:1ex;">=0ADear All,<br><br>Can anyone be of help? I ge=
t the following error each time I try to run a standard report:<br><br><spa=
n style=3D"color:rgb(255,0,0);">Oops, something went wrong</span><br style=
=3D"color:rgb(255,0,0);">=0A<span style=3D"color:rgb(255,0,0);">=0A=09=09=
=09=09=09Do not panic, we have recorded it in the log=0A </s=

<br><br>I get the same error when I try to download a report table repo=

rt<br><br><img alt=3D""><br>=0A<br>I am running version DHIS 2.8<br><br>=0A=
</blockquote></div><br>=0A</div></div><br></div></div>_____________________=
__________________________<br>=0AMailing list: <a rel=3D"nofollow" target=
=3D"_blank" href=3D"https://launchpad.net/~dhis2-users">https://launchpad=
.net/~dhis2-users</a><br>=0APost to     : <a rel=3D"nofollow" yma=
ilto=3D"mailto:dhis2-users@lists.launchpad.net" target=3D"_blank" href=3D"/=
mc/compose?to=3Ddhis2-users@lists.launchpad.net">dhis2-users@lists.launchpa=
d.net</a><br>=0AUnsubscribe : <a rel=3D"nofollow" target=3D"_blank" href=3D=
"https://launchpad.net/~dhis2-users">https://launchpad.net/~dhis2-users</=

<br>=0AMore help   : <a rel=3D"nofollow" target=3D"_blank" href=3D"h=

ttps://help.launchpad.net/ListHelp">https://help.launchpad.net/ListHelp</a>=
<br>=0A<br></blockquote></div><br></div>=0A</blockquote></div><br>=0A</div>=
</div></blockquote></div><br>=0A</div></div></blockquote></div><br>=0A</div=

</div></blockquote></div><br></div>=0A</div><br>-----Inline Attachment Fol=

lows-----<br><br><div class=3D"plainMail">_________________________________=
______________<br>Mailing list: <a href=3D"https://launchpad.net/~dhis2-use=
rs" target=3D"_blank">https://launchpad.net/~dhis2-users</a><br>Post to&nbs=
p;    : <a ymailto=3D"mailto:dhis2-users@lists.launchpad.net=
" href=3D"/mc/compose?to=3Ddhis2-users@lists.launchpad.net">dhis2-users@lis=
ts.launchpad.net</a><br>Unsubscribe : <a href=3D"https://launchpad.net/~dhi=
s2-users" target=3D"_blank">https://launchpad.net/~dhis2-users</a><br>More =
help   : <a href=3D"https://help.launchpad.net/ListHelp" tar=
get=3D"_blank">https://help.launchpad.net/ListHelp</a><br></div></blockquot=

</div></td></tr></table>

--1671867401-1076052391-1346996703=:38803--