Re: [Dhis2-devs] [Bug 1769917] [NEW] ERROR: relation "analytics" does not exist

2018-05-08 Thread Knut Staring 
Try to run Analytics ( under Reports)

On Tue, May 8, 2018, 5:06 PM pomi daniel  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
>

[Dhis2-devs] [Bug 1769917] [NEW] ERROR: relation "analytics" does not exist

2018-05-08 Thread pomi daniel 
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.