dhis2-users team mailing list archive

[Jan Henrik Øverland <jan@xxxxxxxxx>]

Okay, could be a bug then. Please share what Lars asked for if possible.

On 30 January 2017 at 13:11, Marc Garnica <marcgarnica13@xxxxxxxxx> wrote:

> The analytics export does not register any error in the logs. The data is
> monthly data added through a csv file, it was not the first time we run the
> analytics on the server and the other times it went well.
>
> Marc
>
> 2017-01-30 13:00 GMT+01:00 Jan Henrik Øverland <jan@xxxxxxxxx>:
>
>> Any error messages during the export process?
>>
>> On 30 January 2017 at 12:56, Marc Garnica <marcgarnica13@xxxxxxxxx>
>> wrote:
>>
>>> We did it twice, but it seems that the queries are crashing.
>>>
>>> Thanks!
>>>
>>> 2017-01-30 12:51 GMT+01:00 Jan Henrik Øverland <jan@xxxxxxxxx>:
>>>
>>>> Hi Marc,
>>>>
>>>> Please go to the main menu > Reports > Analytics (left menu) and click
>>>> Start export.
>>>>
>>>> As soon as it completes you should get the data in the analysis apps.
>>>>
>>>> On 30 January 2017 at 12:46, 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
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Jan Henrik Øverland
>>>> Software developer, DHIS 2
>>>> University of Oslo
>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>
>>>
>>>
>>
>>
>> --
>> Jan Henrik Øverland
>> Software developer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>
>


-- 
Jan Henrik Øverland
Software developer, DHIS 2
University of Oslo
http://www.dhis2.org <https://www.dhis2.org/>