dhis2-devs team mailing list archive

[sumudu weerasinghe <sumuduw00@xxxxxxxxx>]

Hi All,

We used dhis 2.17 for aggregate data in our hospital. (No tracker ).
When i try to generate report from , dataset report, data visuializer  and
pivot tables , always gives "no datavalue found".
Analytic tables has already generated.

In the log it says -





*org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
SQL grammar [select "de","monthly", sum(value) as value from analytics_2014
where "de" in ('TmrNNl3pful') and "monthly" in ('201412') and ( "uidlevel7"
in ('s8MjXuFVsDr') ) group by "de","monthly"]; nested exception is
org.postgresql.util.PSQLException: ERROR: column "uidlevel7" does not exist*



I have gone through the analytic tables , but there is no column called
*"uidlevel7"*.
What is
*"uidlevel7" ?*
Can any one give reason for this error.

I used

   - DHIS2 2.17
   - R 17683
   - PostgreSQL
   - OS - windows 7

log and screen shot attached here.

        ... 13 more
* INFO  2015-03-30 12:37:30,720 Query failed, likely because the requested analy
tics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-81
])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL gram
mar [select "de","yearly","uidlevel1","BoeTDpgXP6X", sum(value) as value from an
alytics_2014 where "de" in ('TDYDzbhLN61') and "yearly" in ('2014') and "uidleve
l1" in ('HeeGWIEedOy') and "BoeTDpgXP6X" in ('J8ZJGZdKUZJ', 'kFlWQ1ES6Em', 'wUSb
rCG5U2T') group by "de","yearly","uidlevel1","BoeTDpgXP6X"]; nested exception is
 org.postgresql.util.PSQLException: ERROR: column "BoeTDpgXP6X" does not exist
  Position: 34
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTra
nslate(SQLStateSQLExceptionTranslator.java:97)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:73)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
413)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:46
8)
        at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplat
e.java:523)
        at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(Jdbc
AnalyticsManager.java:397)
        at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataVa
lues(JdbcAnalyticsManager.java:142)
        at sun.reflect.GeneratedMethodAccessor492.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(
AsyncExecutionInterceptor.java:97)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: column "BoeTDpgXP6X" does n
ot exist
  Position: 34
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2198)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1927)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:561)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:405)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:285)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyState
ment.java:35)
        at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.do
InStatement(JdbcTemplate.java:452)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
402)
        ... 13 more
* INFO  2015-03-30 12:37:30,718 Query failed, likely because the requested analy
tics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-82
])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL gram
mar [select "de","yearly","uidlevel1","BoeTDpgXP6X", sum(value) as value from an
alytics_2014 where "de" in ('XUPPA1Wi9BL') and "yearly" in ('2014') and "uidleve
l1" in ('HeeGWIEedOy') and "BoeTDpgXP6X" in ('J8ZJGZdKUZJ', 'kFlWQ1ES6Em', 'wUSb
rCG5U2T') group by "de","yearly","uidlevel1","BoeTDpgXP6X"]; nested exception is
 org.postgresql.util.PSQLException: ERROR: column "BoeTDpgXP6X" does not exist
  Position: 34
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTra
nslate(SQLStateSQLExceptionTranslator.java:97)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:73)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
413)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:46
8)
        at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplat
e.java:523)
        at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(Jdbc
AnalyticsManager.java:397)
        at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataVa
lues(JdbcAnalyticsManager.java:142)
        at sun.reflect.GeneratedMethodAccessor492.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(
AsyncExecutionInterceptor.java:97)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: column "BoeTDpgXP6X" does n
ot exist
  Position: 34
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2198)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1927)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:561)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:405)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:285)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyState
ment.java:35)
        at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.do
InStatement(JdbcTemplate.java:452)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
402)
        ... 13 more
* WARN  2015-03-30 12:37:54,068 No dataset categorycombos to check for approval,
 user admin datasetIds 256 (HibernateDataApprovalStore.java [http-apr-8080-exec-
10])
* WARN  2015-03-30 12:37:57,269 No dataset categorycombos to check for approval,
 user admin datasetIds 256 (HibernateDataApprovalStore.java [http-apr-8080-exec-
6])
* WARN  2015-03-30 12:37:59,523 No dataset categorycombos to check for approval,
 user admin datasetIds 256 (HibernateDataApprovalStore.java [http-apr-8080-exec-
4])
* INFO  2015-03-30 12:38:00,001 Remote server URL not set (DefaultSynchronizatio
nManager.java [taskScheduler-1])
* INFO  2015-03-30 12:38:00,002 Aborting synch, server not available (DefaultSyn
chronizationManager.java [taskScheduler-1])
* WARN  2015-03-30 12:38:01,742 No dataset categorycombos to check for approval,
 user admin datasetIds 256 (HibernateDataApprovalStore.java [http-apr-8080-exec-
8])
* WARN  2015-03-30 12:38:04,241 No dataset categorycombos to check for approval,
 user admin datasetIds 256 (HibernateDataApprovalStore.java [http-apr-8080-exec-
9])
* WARN  2015-03-30 12:38:06,236 No dataset categorycombos to check for approval,
 user admin datasetIds 256 (HibernateDataApprovalStore.java [http-apr-8080-exec-
7])
* WARN  2015-03-30 12:38:14,578 No dataset categorycombos to check for approval,
 user admin datasetIds 256 (HibernateDataApprovalStore.java [http-apr-8080-exec-
2])
* WARN  2015-03-30 12:38:16,320 No dataset categorycombos to check for approval,
 user admin datasetIds 256 (HibernateDataApprovalStore.java [http-apr-8080-exec-
3])
* WARN  2015-03-30 12:38:22,341 No dataset categorycombos to check for approval,
 user admin datasetIds 256 (HibernateDataApprovalStore.java [http-apr-8080-exec-
10])
* WARN  2015-03-30 12:38:24,754 No dataset categorycombos to check for approval,
 user admin datasetIds 256 (HibernateDataApprovalStore.java [http-apr-8080-exec-
6])
* WARN  2015-03-30 12:38:26,497 No dataset categorycombos to check for approval,
 user admin datasetIds 256 (HibernateDataApprovalStore.java [http-apr-8080-exec-
4])
* WARN  2015-03-30 12:38:28,212 No dataset categorycombos to check for approval,
 user admin datasetIds 256 (HibernateDataApprovalStore.java [http-apr-8080-exec-
8])
* INFO  2015-03-30 12:39:00,003 Remote server URL not set (DefaultSynchronizatio
nManager.java [taskScheduler-1])
* INFO  2015-03-30 12:39:00,004 Aborting synch, server not available (DefaultSyn
chronizationManager.java [taskScheduler-1])
* INFO  2015-03-30 12:39:40,909 Query failed, likely because the requested analy
tics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-88
])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL gram
mar [select "de","monthly", sum(value) as value from analytics_2014 where "de" i
n ('L90bya7AslG') and "monthly" in ('201412') and ( "uidlevel7" in ('s8MjXuFVsDr
') ) group by "de","monthly"]; nested exception is org.postgresql.util.PSQLExcep
tion: ERROR: column "uidlevel7" does not exist
  Position: 128
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTra
nslate(SQLStateSQLExceptionTranslator.java:97)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:73)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
413)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:46
8)
        at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplat
e.java:523)
        at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(Jdbc
AnalyticsManager.java:397)
        at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataVa
lues(JdbcAnalyticsManager.java:142)
        at sun.reflect.GeneratedMethodAccessor492.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(
AsyncExecutionInterceptor.java:97)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: column "uidlevel7" does not
 exist
  Position: 128
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2198)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1927)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:561)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:405)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:285)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyState
ment.java:35)
        at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.do
InStatement(JdbcTemplate.java:452)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
402)
        ... 13 more
* INFO  2015-03-30 12:39:40,911 Query failed, likely because the requested analy
tics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-89
])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL gram
mar [select "de","monthly", sum(value) as value from analytics_2014 where "de" i
n ('TmrNNl3pful') and "monthly" in ('201412') and ( "uidlevel7" in ('s8MjXuFVsDr
') ) group by "de","monthly"]; nested exception is org.postgresql.util.PSQLExcep
tion: ERROR: column "uidlevel7" does not exist
  Position: 128
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTra
nslate(SQLStateSQLExceptionTranslator.java:97)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:73)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:81)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
413)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:46
8)
        at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplat
e.java:523)
        at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(Jdbc
AnalyticsManager.java:397)
        at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataVa
lues(JdbcAnalyticsManager.java:142)
        at sun.reflect.GeneratedMethodAccessor492.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(
AsyncExecutionInterceptor.java:97)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: column "uidlevel7" does not
 exist
  Position: 128
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2198)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1927)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:561)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:405)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:285)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyState
ment.java:35)
        at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.do
InStatement(JdbcTemplate.java:452)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
402)
        ... 13 more
* INFO  2015-03-30 12:40:00,001 Remote server URL not set (DefaultSynchronizatio
nManager.java [taskScheduler-1])
* INFO  2015-03-30 12:40:00,002 Aborting synch, server not available (DefaultSyn
chronizationManager.java [taskScheduler-1])

Attachment: reportgeneration error.PNG
Description: PNG image