dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #32779
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