← Back to team overview

dhis2-devs team mailing list archive

Re: Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist

 

Below is the copy of the error log:
* INFO  2014-09-11 17:18:33,189 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-32])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "ds","uidlevel2", count(value) as value from completenesstarget where "ds" in ('hOoA0bFo96D', 'hWqRDn4VpaF') and "uidlevel2" in ('OxnNb1tfpXB', 'SDB3KHGyjiK', 'VU9xLppiHNF', 'WWQvbVWpnpp', 'XgmvbwoMxuT', 'lTzRY1k8J28', 'o3BMs74aL2D') group by "ds","uidlevel2"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "completenesstarget" does not exist
  Position: 53
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
    at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
    at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:325)
    at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:129)
    at sun.reflect.GeneratedMethodAccessor482.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:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "completenesstarget" does not exist
  Position: 53
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
    at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
    at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
    ... 13 more
* INFO  2014-09-11 17:18:33,188 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-31])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "ds","uidlevel2", count(value) as value from completenesstarget where "ds" in ('U8NAwVfGzO7', 'VWU7Rtolaec') and "uidlevel2" in ('OxnNb1tfpXB', 'SDB3KHGyjiK', 'VU9xLppiHNF', 'WWQvbVWpnpp', 'XgmvbwoMxuT', 'lTzRY1k8J28', 'o3BMs74aL2D') group by "ds","uidlevel2"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "completenesstarget" does not exist
  Position: 53
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
    at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
    at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:325)
    at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:129)
    at sun.reflect.GeneratedMethodAccessor482.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:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "completenesstarget" does not exist



Moemedi Ntunyane
Co-founder KeyInConsulting


From: moemedi.ntunyane@xxxxxxxxxxx
To: larshelge@xxxxxxxxx
CC: dhis2-devs@xxxxxxxxxxxxxxxxxxx
Subject: RE: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist
Date: Fri, 12 Sep 2014 09:45:30 +0200




Hi Lars

Will send the copy of the log file as I am not at the station. I generated the analytics tables but the errors shows that the errors analytics tables  cannot be created....


Regards,

Moemedi Ntunyane
Co-founder KeyInConsulting


Date: Thu, 11 Sep 2014 14:19:19 -0400
Subject: Re: [Dhis2-devs] Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist
From: larshelge@xxxxxxxxx
To: moemedi.ntunyane@xxxxxxxxxxx
CC: dhis2-devs@xxxxxxxxxxxxxxxxxxx

Hi Moemedi,
did you run the analytics table generation process first? If yes, any exceptions in the tomcat log?
Lars
On Thu, Sep 11, 2014 at 12:51 PM, Moemedi Ntunyane <moemedi.ntunyane@xxxxxxxxxxx> wrote:



Hi All
All data seems to be ok as it is available in data entry screen and only not available in reports

Moemedi Ntunyane
Co-founder KeyInConsulting


From: moemedi.ntunyane@xxxxxxxxxxx
To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
Subject: Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist
Date: Thu, 11 Sep 2014 17:34:51 +0200




Hi all
I am having a problem with generating pivot tables as dat cannot be found and the follwing error appears:Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2009" does not exist
thnzx in advance

Moemedi Ntunyane
Co-founder KeyInConsulting
 		 	   		   		 	   		  

_______________________________________________

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



 		 	   		   		 	   		  

Follow ups

References