Try to run Analytics ( under Reports) On Tue, May 8, 2018, 5:06 PM pomi daniel <pomi...@gmail.com> 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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp