dhis2-users team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

Hi Marc,

never seen this one before. Did you generate analytics tables first? Need
some more info. Can you share a dhis + server login privately?

regards,

Lars


On Mon, Jan 30, 2017 at 12:46 PM, Marc Garnica <marcgarnica13@xxxxxxxxx>
wrote:

> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>