=0A=
=0A=
=0A=
Below is the copy of the error log:
* INFO 2014-09-11 17:18:33=2C189 Query failed=2C likely because the reques=
ted analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncT=
askExecutor-32])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback=3B bad S=
QL grammar [select "ds"=2C"uidlevel2"=2C count(value) as value from complet=
enesstarget where "ds" in ('hOoA0bFo96D'=2C 'hWqRDn4VpaF') and "uidlevel2" =
in ('OxnNb1tfpXB'=2C 'SDB3KHGyjiK'=2C 'VU9xLppiHNF'=2C 'WWQvbVWpnpp'=2C 'Xg=
mvbwoMxuT'=2C 'lTzRY1k8J28'=2C 'o3BMs74aL2D') group by "ds"=2C"uidlevel2"]=
=3B 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.AbstractFallbackSQLExceptionTransla=
tor.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java=
:407)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:4=
56)
at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTempla=
te.java:501)
at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(Jdb=
cAnalyticsManager.java:325)
at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataV=
alues(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.invokeJoinpointUsingReflect=
ion(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJ=
oinpoint(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 "completeness=
target" does not exist
Position: 53
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryE=
xecutorImpl.java:2161)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecuto=
rImpl.java:1890)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.j=
ava:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Sta=
tement.java:560)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstrac=
tJdbc2Statement.java:403)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdb=
c2Statement.java:283)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStat=
ement.java:35)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.d=
oInStatement(JdbcTemplate.java:441)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java=
:396)
... 13 more
* INFO 2014-09-11 17:18:33=2C188 Query failed=2C likely because the reques=
ted analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncT=
askExecutor-31])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback=3B bad S=
QL grammar [select "ds"=2C"uidlevel2"=2C count(value) as value from complet=
enesstarget where "ds" in ('U8NAwVfGzO7'=2C 'VWU7Rtolaec') and "uidlevel2" =
in ('OxnNb1tfpXB'=2C 'SDB3KHGyjiK'=2C 'VU9xLppiHNF'=2C 'WWQvbVWpnpp'=2C 'Xg=
mvbwoMxuT'=2C 'lTzRY1k8J28'=2C 'o3BMs74aL2D') group by "ds"=2C"uidlevel2"]=
=3B 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.AbstractFallbackSQLExceptionTransla=
tor.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java=
:407)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:4=
56)
at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTempla=
te.java:501)
at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(Jdb=
cAnalyticsManager.java:325)
at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataV=
alues(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.invokeJoinpointUsingReflect=
ion(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJ=
oinpoint(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 "completeness=
target" does not exist
Moemedi Ntunyane
Co-founder KeyInConsulting