# Query failed, likely because the requested analytics table does not exist **URL:** \ **Category:** Support - Assistance technique\ **Created:** [19 June 2020 03:41 UTC](https://community.dhis2.org/t/query-failed-likely-because-the-requested-analytics-table-does-not-exist/39586 "2020-06-19T03:41:31Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![jayasanka](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jayasanka/32/29727_2.png) [@jayasanka](https://community.dhis2.org/u/jayasanka)\ **Post date:** [19 June 2020 03:41 UTC](https://community.dhis2.org/t/query-failed-likely-because-the-requested-analytics-table-does-not-exist/39586/1 "2020-06-19T03:41:31Z")
Hi all, I get this error when I’m trying to visualize data using the Data Visualizer app. I checked the DB and there’s no table named `analytics`. The UI shows a “No Data” message and there’s an error throwing from the backend. Could someone please help me to solve this? DHIS2 version - `dhis2-stable-2.34.0` DB - postgresql 9.6 Tomcat - 9 ![Screenshot 2020-06-19 at 09.05.23](https://dhis2.b-cdn.net/uploads/default/original/3X/2/d/2d7154ae4fdfcafc319eecd90ac0b2a7f2636e72.jpeg) Log: ``` * INFO 2020-06-19T09:00:46,088 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [taskScheduler-4]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select ax."dx",ax."monthly", sum(value) as value from analytics as ax where ax."dx" in ('nhCnp6MU3SL') and ax."monthly" in ('201906', '201907', '201908', '201909', '201910', '201911', '201912', '202001', '202002', '202003', '202004', '202005') and ( ax."uidlevel1" in ('sa8qg1wcJ5s') ) group by ax."dx",ax."monthly"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics" does not exist Position: 55 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:235) ~[spring-jdbc-5.2.3.RELEASE.jar:5.2.3.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.2.3.RELEASE.jar:5.2.3.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443) ~[spring-jdbc-5.2.3.RELEASE.jar:5.2.3.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388) ~[spring-jdbc-5.2.3.RELEASE.jar:5.2.3.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452) ~[spring-jdbc-5.2.3.RELEASE.jar:5.2.3.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:495) ~[spring-jdbc-5.2.3.RELEASE.jar:5.2.3.RELEASE] at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:633) ~[dhis-service-analytics-2.34.0.jar:?] at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:153) ~[dhis-service-analytics-2.34.0.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_202] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_202] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.2.3.RELEASE.jar:5.2.3.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.2.3.RELEASE.jar:5.2.3.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.3.RELEASE.jar:5.2.3.RELEASE] at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115) ~[spring-aop-5.2.3.RELEASE.jar:5.2.3.RELEASE] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_202] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_202] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics" does not exist Position: 55 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224) ~[postgresql-42.2.5.jar:42.2.5] at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327) ~[c3p0-0.9.5.5.jar:0.9.5.5] at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:439) ~[spring-jdbc-5.2.3.RELEASE.jar:5.2.3.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376) ~[spring-jdbc-5.2.3.RELEASE.jar:5.2.3.RELEASE] ... 18 more ``` About DHIS2 Page: ![Screenshot 2020-06-19 at 09.15.07](https://dhis2.b-cdn.net/uploads/default/original/3X/2/1/218bf044a1a7b70122eefd29d64f90569fccd578.jpeg) ---
**Author:** ![jthomas](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jthomas/32/32752_2.png) [@jthomas](https://community.dhis2.org/u/jthomas)\ **Post date:** [19 June 2020 03:47 UTC](https://community.dhis2.org/t/query-failed-likely-because-the-requested-analytics-table-does-not-exist/39586/2 "2020-06-19T03:47:54Z")
Strange, but you ran analytics atleast once right? from Data Administration → Analytics ![image](https://dhis2.b-cdn.net/uploads/default/original/3X/7/e/7e35454d2f79e9f2147929b8763edf554e895b88.png) ---
**Author:** ![jayasanka](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jayasanka/32/29727_2.png) [@jayasanka](https://community.dhis2.org/u/jayasanka)\ **Post date:** [19 June 2020 03:54 UTC](https://community.dhis2.org/t/query-failed-likely-because-the-requested-analytics-table-does-not-exist/39586/3 "2020-06-19T03:54:28Z")
Thanks @jthomas, I was unaware about that. Thanks It worked!! By the way, Do I need to rerun this after certain period? ---
**Author:** ![jthomas](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jthomas/32/32752_2.png) [@jthomas](https://community.dhis2.org/u/jthomas)\ **Post date:** [19 June 2020 04:08 UTC](https://community.dhis2.org/t/query-failed-likely-because-the-requested-analytics-table-does-not-exist/39586/4 "2020-06-19T04:08:50Z")
Glad it worked! Yes whenever you want to get the data aggregated to analytics\_xxx tables. You can read a bit more [here](https://docs.dhis2.org/2.27/en/user/html/generate_analytics_tables.html) ---
**Author:** ![jayasanka](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jayasanka/32/29727_2.png) [@jayasanka](https://community.dhis2.org/u/jayasanka)\ **Post date:** [20 June 2020 10:59 UTC](https://community.dhis2.org/t/query-failed-likely-because-the-requested-analytics-table-does-not-exist/39586/5 "2020-06-20T10:59:16Z")
Thanks @jthomas!