dhis2-devs team mailing list archive

[Ryan Nazareth <ryan@xxxxxxxxxxxxxxxxxxx>]

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.hedberg@xxxxxxxxx>
Sent: 26 March 2018 11:45
To: Ryan Nazareth <ryan@xxxxxxxxxxxxxxxxxxx>
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx; dhis2-devs@xxxxxxxxxxxxxxxxxxx
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 <ryan@xxxxxxxxxxxxxxxxxxx<mailto:ryan@xxxxxxxxxxxxxxxxxxx>> 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@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
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.hedberg@xxxxxxxxx<mailto:calle.hedberg@xxxxxxxxx>

Skype: calle_hedberg

*******************************************