dhis2-devs team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

It seems the analytics process does not start. Can you look in the
developer console for errors and network activity?


On 26 March 2018 at 19:16, Ryan Nazareth <ryan@xxxxxxxxxxxxxxxxxxx> wrote:

> Hi Lars,
>
>
>
> Ive attached the log file. I have just reinstalled dhis2 and ran it with
> the default dhs conf file – the analytics (export) seemed to do run with a
> summary/report generated. When I ran it again after logging in to DHIS2
> after adjusting the conf file with my PostgreSQL details  -   I get the
> yellow bar (pic below)  and it does not stop.
>
>
>
>
>
> *From:* Lars Helge Øverland <lars@xxxxxxxxx>
> *Sent:* 26 March 2018 15:49
> *To:* Ryan Nazareth <ryan@xxxxxxxxxxxxxxxxxxx>
> *Cc:* calle.hedberg@xxxxxxxxx; dhis2-users@xxxxxxxxxxxxxxxxxxx;
> dhis2-devs@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Dhis2-users] [Dhis2-devs] Analytics not stopping
>
>
>
> Hi Ryan,
>
>
>
> are you getting any other errors in the tomcat log which you can share?
>
>
>
> regards,
>
>
>
> Lars
>
>
>
>
>
> On 26 March 2018 at 16:42, Ryan Nazareth <ryan@xxxxxxxxxxxxxxxxxxx> wrote:
>
> 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> 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
> <https://maps.google.com/?q=46D+Alma+Road,+7700+Rosebank,+SOUTH+AFRICA&entry=gmail&source=g>
>
> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>
> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>
> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>
> --
>
> Lars Helge Øverland
>
> Technical lead, DHIS 2
>
> University of Oslo
>
> lars@xxxxxxxxx
>
> https://www.dhis2.org
>
>
>



-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
lars@xxxxxxxxx
https://www.dhis2.org