dhis2-devs team mailing list archive

Thread
Date
[Bug 1769917] [NEW] ERROR: relation "analytics" does not exist

To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
From: pomi daniel <pomi144@xxxxxxxxx>
Date: Tue, 08 May 2018 14:55:11 -0000
Reply-to: Bug 1769917 <1769917@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
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
Follow ups

Re: [Bug 1769917] [NEW] ERROR: relation "analytics" does not exist
From: Knut Staring, 2018-05-09