dhis2-users team mailing list archive

[Marc Garnica <marcgarnica13@xxxxxxxxx>]

Hi! We have imported some data and run the analytics but we are can not
manage to see the data in the Pivot Table App, the data is available at the
Data entry app. Whenever we try to build the tables it shows up a "No data
to display" message.

The logs register this error every time we update the table in the Pivot
table app:

*nested exception is org.postgresql.util.PSQLException: ERROR: column
"analytics_2015.dx" must appear in the GROUP BY clause or be used in an
aggregate function*

*  Position: 8*

*        at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99)*

*        at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)*

*        at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)*

*        at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)*

*        at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415)*

*        at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470)*

*        at
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:511)*

*        at
org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:438)*

*        at
org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:146)*

*        at sun.reflect.GeneratedMethodAccessor1112.invoke(Unknown Source)*

*        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)*

*        at java.lang.reflect.Method.invoke(Method.java:498)*

*        at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)*

*        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)*

*        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)*

*        at
org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:108)*

*        at java.util.concurrent.FutureTask.run(FutureTask.java:266)*

*        at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)*

*        at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)*

*        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)*

*        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)*

*        at java.lang.Thread.run(Thread.java:745)*

*Caused by: org.postgresql.util.PSQLException: ERROR: column
"analytics_2015.dx" must appear in the GROUP BY clause or be used in an
aggregate function*

*  Position: 8*

*        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)*

*        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)*


Any help will be so helpful! Thanks !!