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 !!
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
