← Back to team overview

dhis2-devs team mailing list archive

Re: 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> 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
> 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

Skype: calle_hedberg

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

Follow ups

References