Dear All,
I have an instance of DHIS2 version 2.16, which is primarily used for
tracker related data on Single event with registration. The issue is after
generating analytic tables and view results on Event Reports I receive "No
data found" on both aggregated data as well as individual records. I tested
it on 2.17 and 2.18, but same error persists.
I checked the catalina.out and it puts out several errors related to
"uidlevels". Same appear for uidlevel3. In analytic table only uidlevel1 is
there, which is also empty. Following is the exact error.
column "uidlevel2" does not exist....
The relevant portion of catalina.out is attached herewith. I'd be grateful
if you could help me fix this.
Thank you
--
Pamod
* INFO 2015-01-23 22:55:25,382 Query failed, likely because the requested
analytics table does not exis t
(JdbcEventAnalyticsManager.java [http-bio-8080-exec-4])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar [select psi, ps, exe cutiondate, longitude, latitude,
ouname, oucode, "ou","Qa4oueS34QK" from analytics_event_2014_ujjobvvaap
l where executiondate >= '2014-01-01' and executiondate <=
'2014-12-31' and (uidlevel2 = 'vxQB0NMggC2' ) and ps =
'gknkafmeM9y' and "Qa4oueS34QK" >= '1' limit 100 offset 0]; nested exception is
org.postgresql .util.PSQLException: ERROR: column "uidlevel2"
does not exist
Position: 201
at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExcept
ionTranslator.java:99)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFal
lbackSQLExceptionTranslator.java:73)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFal
lbackSQLExceptionTranslator.java:81)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFal
lbackSQLExceptionTranslator.java:81)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
at
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
at
org.hisp.dhis.analytics.event.data.JdbcEventAnalyticsManager.getEvents(JdbcEventAnalyticsMana
ger.java:250)
at
org.hisp.dhis.analytics.event.data.JdbcEventAnalyticsManager.getEvents(JdbcEventAnalyticsMana
ger.java:236)
at
org.hisp.dhis.analytics.event.data.DefaultEventAnalyticsService.getEvents(DefaultEventAnalyti
csService.java:305)
at
org.hisp.dhis.webapi.controller.EventAnalyticsController.getQueryJson(EventAnalyticsControlle
r.java:233)
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:606)
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod
.java:221)
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandl
erMethod.java:137)
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAnd
Handle(ServletInvocableHandlerMethod.java:110)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHand
leMethod(RequestMappingHandlerAdapter.java:777)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInte
rnal(RequestMappingHandlerAdapter.java:706)
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandle
rMethodAdapter.java:85)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
at
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
303)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:330)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecu
rityInterceptor.java:118)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSe
curityInterceptor.java:84)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslat
ionFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFi
lter.java:103)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(Anonym
ousAuthenticationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(
SecurityContextHolderAwareRequestFilter.java:154)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAw
areFilter.java:45)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicA
uthenticationFilter.java:150)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilt
er(AbstractAuthenticationProcessingFilter.java:199)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilt
er(AbstractAuthenticationProcessingFilter.java:199)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.
java:64)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.jav
a:110)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:115)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilte
r.java:57)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFil
terInternal(WebAsyncManagerIntegrationFilter.java:50)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.java:342)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityCo
ntextPersistenceFilter.java:87)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProx
y.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.jav
a:344)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilt
er.java:82)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessi
onInViewFilter.java:150)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilt
er.java:88)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:60
7)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: ERROR: column "uidlevel2" does
not exist
Position: 201
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285)
at
com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate
.java:455)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
... 91 more
* INFO 2015-01-23 22:55:25,383 Time: 8552 micros: Got events 0 (Timer.java
[http-bio-8080-exec-4])
* INFO 2015-01-23 22:55:41,632 Time: 927 micros: Planned event query, got
partitions: [analytics_event_ 2014_ujjobvvaapl] (Timer.java
[http-bio-8080-exec-4])
* INFO 2015-01-23 22:55:41,646 Time: 15499 micros: Got events 0 (Timer.java
[http-bio-8080-exec-4])
* INFO 2015-01-23 22:58:05,117 Time: 827 micros: Planned event query, got
partitions: [analytics_event_2014_ujjobvvaapl] (Timer.java
[http-bio-8080-exec-6])
* INFO 2015-01-23 22:58:05,122 Time: 5549 micros: Got events 0 (Timer.java
[http-bio-8080-exec-6])
* INFO 2015-01-23 22:59:14,387 Time: 1638 micros: Planned event query, got
partitions: [analytics_event_2014_ujjobvvaapl] (Timer.java
[http-bio-8080-exec-9])
* INFO 2015-01-23 22:59:14,390 Query failed, likely because the requested
analytics table does not exist (JdbcEventAnalyticsManager.java
[http-bio-8080-exec-9])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar [select count(psi) from analytics_event_2014_ujjobvvaapl where
executiondate >= '2014-01-01' and executiondate <= '2014-12-31' and (uidlevel3
= 'S4GV8YWShtz' ) and ps = 'gknkafmeM9y' and lower("Q1u0m5TTwAN") in ('1. yes')
]; nested exception is org.postgresql.util.PSQLException: ERROR: column
"uidlevel3" does not exist_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
