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
_______________________________________________
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
