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

Support - Assistance technique
1

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

2

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

3

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@hotmail.com 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@hotmail.com
To: dhis2-devs@lists.launchpad.net
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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

4

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

5

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

6

Hi All

Please help, this error exit and do not know if its a bug or what as tried running analytics tables for some while...

From log analysis it seems this is the error:

DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in column "iso" violates not-null constraint; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "iso" violates not-null constraint

Moemedi Ntunyane
Co-founder KeyInConsulting