Analytics not stopping

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

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@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

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@gmail.com

Skype: calle_hedberg


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

···

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@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

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@gmail.com

Skype: calle_hedberg


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@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.hedberg@gmail.com

Sent: 26 March 2018 11:45

To: Ryan Nazareth ryan@mantaraymedia.co.uk

Cc: dhis2-users@lists.launchpad.net; 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 ryan@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

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@gmail.com

Skype: calle_hedberg



Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@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

lars@dhis2.org

https://www.dhis2.org

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.

dhis.log (46.8 KB)

···

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@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.hedberg@gmail.com

Sent: 26 March 2018 11:45

To: Ryan Nazareth ryan@mantaraymedia.co.uk

Cc: dhis2-users@lists.launchpad.net; 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 ryan@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

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@gmail.com

Skype: calle_hedberg



Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@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

lars@dhis2.org

https://www.dhis2.org

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

image

···

On 26 March 2018 at 19:16, Ryan Nazareth ryan@mantaraymedia.co.uk 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@dhis2.org

Sent: 26 March 2018 15:49

To: Ryan Nazareth ryan@mantaraymedia.co.uk

Cc: calle.hedberg@gmail.com; dhis2-users@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 ryan@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.hedberg@gmail.com

Sent: 26 March 2018 11:45

To: Ryan Nazareth ryan@mantaraymedia.co.uk

Cc: dhis2-users@lists.launchpad.net; 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 ryan@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

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@gmail.com

Skype: calle_hedberg



Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@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

lars@dhis2.org

https://www.dhis2.org

Lars Helge Øverland

Technical lead, DHIS 2

University of Oslo

lars@dhis2.org

https://www.dhis2.org