dhis2-devs team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

Hi Jose,

this is caused by the "None" aggregation type. It needs to be set in order
to have the event analytics work properly.

I have reported the maintenance app issue here:

https://github.com/dhis2/maintenance-app/issues/284

We will fix. If it is urgent you can set the aggregation type through the
API or in database.

best regards,

Lars





On Tue, Nov 8, 2016 at 6:24 AM, Jose Garcia Muñoz <josemp10@xxxxxxxxx>
wrote:

>
> Hi devs,
>
> each time I try to do some calculation with event data items
> (numeric/integer/.. tracker dataelements), I'm getting the following SQL
> exception (attached at the bottom of them email). The SQL is:
>
> select none("DvTQcjDWH3M") as value,"monthly" from analytics_event_2016_lyyizex7izm
> where Monthly in ('201601', '201602', '201603', '201604', '201605',
> '201606', '201607', '201608', '201609', '201610') and (uidlevel1 =
> 'FvUGp8I75zV' ) group by "monthly" limit 100001
>
> The table 'analytics_event_2016_lyyizex7izm' exists in the database, so I
> believe this is happening becuase the agg operator should be 'sum' instead
> of 'none' (otherwise we would need to group also by the "DvTQcjDWH3M"
> column). I check the dataelement definition and in fact the agg type is
> 'none'. However in 2.25, the interface does not allow us to create tracker
> dataelements with an aggregation type different than 'none'..
>
> Would this be related to the issue we are having? Am I missing something?
> It is strange because it is working in the Sierra Leone demo, but I don't
> know if this is because the datelements has been upgraded from the previous
> version, while I'm creating them directly in 2.25
>
> Many thanks
> Jose
>
>
> * INFO  2016-11-08 05:45:59,032 Query failed, likely because the requested
> analytics table does not exist (JdbcEventAnalyticsManager.java
> [http-apr-8080-exec-4])
> org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
> SQL grammar [select none("DvTQcjDWH3M") as value,"monthly" from
> analytics_event_2016_lyyizex7izm where Monthly in ('201601', '201602',
> '201603', '201604', '201605', '201606', '201607', '201608', '201609',
> '201610') and (uidlevel1 = 'FvUGp8I75zV' ) group by "monthly" limit
> 100001]; nested exception is org.postgresql.util.PSQLException: ERROR:
> error de sintaxis en o cerca de ½(╗
>   Position: 12
>         at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTransl
> ator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
>         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTr
> anslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> 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/>