| Thread Previous • Date Previous • Date Next • Thread Next |
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 <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<mailto: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<mailto:calle.hedberg@xxxxxxxxx>>
Sent: 26 March 2018 11:45
To: Ryan Nazareth <ryan@xxxxxxxxxxxxxxxxxxx<mailto:ryan@xxxxxxxxxxxxxxxxxxx>>
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>; dhis2-devs@xxxxxxxxxxxxxxxxxxx<mailto: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<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.hedberg@xxxxxxxxx<mailto:calle.hedberg@xxxxxxxxx>
Skype: calle_hedberg
*******************************************
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto: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<mailto:lars@xxxxxxxxx>
https://www.dhis2.org<https://www.dhis2.org/>
Attachment:
dhis.log
Description: dhis.log
| Thread Previous • Date Previous • Date Next • Thread Next |
