Public bug reported:
Hello,
I upgraded my instance from DHIS2.28 to DHIS2.29 and got the following
error on the log while doing Pivot table, Charts and Maps. I run the SQL
upgrade script once before I start DHIS2.29. What should I do to correct
this?
Thanks,
Pomi
* INFO 2018-05-08 17:36:04,377 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [taskScheduler-8])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","uidlevel7", sum(value) as value from analytics where "dx" in ('Lhwupe9ARtD') and "uidlevel7" in ('a2rGudptU9y', 'rmTuQQu5Cd1', 'QeouCQL1Kxz', 'stZIGHjhBOP', 'bKEWIjHGwLZ', 'Ebe2i9o8MFu', 'rSJFQckC1ZL', 'aP6shyOqKtv', 'fm2EXY0iTCF', 'ZHpV7sSfd8h', 'Nw6tkDzUpXc', 'mEcsf3e9BYD', 'NoPlF6zKicI', 'GuB7CdPSUZb', 't9Iel1dYemy', 'NCqLy5YDjWB', 'dgWvP3qMHVR', 'XTUSvYQhjyO', 'G9YU861eLuq', 'hqlPwEejMS3', 'dFh14qklWx2', 'ggeSXqftOEc', 'aXfNDzIyq0L', 'YopyTuJgBlD', 'oDhCmY4KQzq', 'MH6QPVknNc4', 'mlM2oIDxpV0', 'cI0K4f7KUoy', 'IufFkhrI9Bd', 'pVCtMm6YlNW', 'jCk8HloqEgX', 'ptaDyRF5MPn', 'gPeoUytsx95', 'Pj6riBWwJog', 'A3V2OBdP0Ez', 'Ncy9uvgLi1w', 'A0MTuYiRj9K', 'BvXDCREJSAK', 'zZc0UqKzgpB', 'lGBS0ftMQda', 'FzxlgRdG42h', 'APnE86U4GJl', 'ikpzabBFmC1', 'MzGQrwC4DkN', 'rbYzxtq3BGe', 'du0gXO8GNMY', 'HJIKWkj9Eoq', 'xAenCGkxa9M', 'p6YuH7oGtrI', 'gXWqtS9kFM1') and ( "monthly" in ('201801') ) and "yearly" in ('2018') group by "dx","uidlevel7"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics" does not exist
Position: 51
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:478)
at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:519)
at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:581)
at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:156)
at sun.reflect.GeneratedMethodAccessor896.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:115)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics" does not exist
Position: 51
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:461)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
... 17 more
** 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/1769917
Title:
ERROR: relation "analytics" does not exist
Status in DHIS:
New
Bug description:
Hello,
I upgraded my instance from DHIS2.28 to DHIS2.29 and got the following
error on the log while doing Pivot table, Charts and Maps. I run the
SQL upgrade script once before I start DHIS2.29. What should I do to
correct this?
Thanks,
Pomi
* INFO 2018-05-08 17:36:04,377 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [taskScheduler-8])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","uidlevel7", sum(value) as value from analytics where "dx" in ('Lhwupe9ARtD') and "uidlevel7" in ('a2rGudptU9y', 'rmTuQQu5Cd1', 'QeouCQL1Kxz', 'stZIGHjhBOP', 'bKEWIjHGwLZ', 'Ebe2i9o8MFu', 'rSJFQckC1ZL', 'aP6shyOqKtv', 'fm2EXY0iTCF', 'ZHpV7sSfd8h', 'Nw6tkDzUpXc', 'mEcsf3e9BYD', 'NoPlF6zKicI', 'GuB7CdPSUZb', 't9Iel1dYemy', 'NCqLy5YDjWB', 'dgWvP3qMHVR', 'XTUSvYQhjyO', 'G9YU861eLuq', 'hqlPwEejMS3', 'dFh14qklWx2', 'ggeSXqftOEc', 'aXfNDzIyq0L', 'YopyTuJgBlD', 'oDhCmY4KQzq', 'MH6QPVknNc4', 'mlM2oIDxpV0', 'cI0K4f7KUoy', 'IufFkhrI9Bd', 'pVCtMm6YlNW', 'jCk8HloqEgX', 'ptaDyRF5MPn', 'gPeoUytsx95', 'Pj6riBWwJog', 'A3V2OBdP0Ez', 'Ncy9uvgLi1w', 'A0MTuYiRj9K', 'BvXDCREJSAK', 'zZc0UqKzgpB', 'lGBS0ftMQda', 'FzxlgRdG42h', 'APnE86U4GJl', 'ikpzabBFmC1', 'MzGQrwC4DkN', 'rbYzxtq3BGe', 'du0gXO8GNMY', 'HJIKWkj9Eoq', 'xAenCGkxa9M', 'p6YuH7oGtrI', 'gXWqtS9kFM1') and ( "monthly" in ('201801') ) and "yearly" in ('2018') group by "dx","uidlevel7"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics" does not exist
Position: 51
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:478)
at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:519)
at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:581)
at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:156)
at sun.reflect.GeneratedMethodAccessor896.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:115)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics" does not exist
Position: 51
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:461)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
... 17 more
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1769917/+subscriptions