dhis2-devs team mailing list archive

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

To: pomi144@xxxxxxxxx
From: Knut Staring <knutst@xxxxxxxxx>
Date: Wed, 09 May 2018 03:07:57 +0000
Cc: DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <152579131232.7282.10935159701912872261.malonedeb@wampee.canonical.com>
Try to run Analytics ( under Reports)

On Tue, May 8, 2018, 5:06 PM pomi daniel <pomi144@xxxxxxxxx> wrote:

> 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
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
References

[Bug 1769917] [NEW] ERROR: relation "analytics" does not exist
From: pomi daniel, 2018-05-08