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.
[cid:image001.jpg@01D3C52E.7D9E9A30] From: Lars Helge Øverland <l...@dhis2.org> Sent: 26 March 2018 15:49 To: Ryan Nazareth <r...@mantaraymedia.co.uk> Cc: calle.hedb...@gmail.com; dhis2-us...@lists.launchpad.net; dhis2-devs@lists.launchpad.net 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 <r...@mantaraymedia.co.uk<mailto:r...@mantaraymedia.co.uk>> 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.hedb...@gmail.com<mailto:calle.hedb...@gmail.com>> Sent: 26 March 2018 11:45 To: Ryan Nazareth <r...@mantaraymedia.co.uk<mailto:r...@mantaraymedia.co.uk>> Cc: dhis2-us...@lists.launchpad.net<mailto:dhis2-us...@lists.launchpad.net>; dhis2-devs@lists.launchpad.net<mailto: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<tel:+27%2021%20685%206472> Cell: +27-82-853-5352<tel:+27%2082%20853%205352> Iridium SatPhone: +8816-315-19119<tel:+881%206%20315%2019119> Email: calle.hedb...@gmail.com<mailto:calle.hedb...@gmail.com> Skype: calle_hedberg ******************************************* _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-us...@lists.launchpad.net<mailto:dhis2-us...@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- Lars Helge Øverland Technical lead, DHIS 2 University of Oslo l...@dhis2.org<mailto:l...@dhis2.org> https://www.dhis2.org<https://www.dhis2.org/>
dhis.log
Description: dhis.log
_______________________________________________ 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
