dhis2-devs team mailing list archive

[Ryan Nazareth <ryan@xxxxxxxxxxxxxxxxxxx>]

Hi all,

I am trying to import the Sierra Leone database - Ive just run analytics after importing the sql dump into PostgreSQL., but it doesn't seem to stop (Ive had it run overnight and re run it again with skipping the event and enrolment data generation.
These are some of the errors I was getting in my log fil (below). Any help would be greatly appreciated (there is probably something trivial which Ive missed out)

Best Wishes
Ryan

Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2018" does not exist
  Position: 53
                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)
                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189)
                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
                at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
                at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
                at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
                at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
                at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
                at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:231)
                at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)
                at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:458)
                at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
                ... 18 more
* INFO  2018-03-21 15:33:49,670 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [taskScheduler-20])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","co","uidlevel2","yearly", sum(value) as value from analytics_2017 where "dx" in ('DTVRnCGamkV') and "co" in ('bRowv6yZOF2', 'Prlt0C1RF0s', 'V6L425pT3A0') and "uidlevel2" in ('qhqAxPSTUXp') and "yearly" in ('2017') group by "dx","co","uidlevel2","yearly"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2017" does not exist
  Position: 65
                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:474)
                at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:515)
                at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:496)
                at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:140)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
                at java.lang.reflect.Method.invoke(Unknown Source)
                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(Unknown Source)
                at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
                at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
                at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
                at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2017" does not exist
  Position: 65
                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)
                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189)
                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
                at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
                at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
                at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
                at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
                at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
                at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:231)
                at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)
                at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:458)
                at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
                ... 18 more