Thanks Calle. This a bit strange because Ive had analytics running overnight after clicking the ‘Start Export’ button. Do I need to change any default settings in some of the other apps before running analytics ?
Best Wishes Ryan From: Calle Hedberg <calle.hedb...@gmail.com> Sent: 26 March 2018 11:45 To: Ryan Nazareth <r...@mantaraymedia.co.uk> Cc: dhis2-us...@lists.launchpad.net; dhis2-devs@lists.launchpad.net Subject: Re: [Dhis2-devs] Analytics not stopping Ryan Those log errors are not relevant - you see them because you haven't run analytics yet. Regards Calle On 26 March 2018 at 12:22, Ryan Nazareth <r...@mantaraymedia.co.uk<mailto:r...@mantaraymedia.co.uk>> wrote: 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<mailto:dhis2-devs@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- ******************************************* Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com<mailto:calle.hedb...@gmail.com> Skype: calle_hedberg *******************************************
_______________________________________________ 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
