Think I agree here. We could skip indexing of non-aggregateable data elements/attributes per now entirely (including text value type) as we cannot do analytics on it.
We could look into text indexing (lucene) but that is for later. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1567901 Title: Analytics Indexing Failure - long text Status in DHIS: New Bug description: DHIS 2.21 when performing an analytics update, analytics fails, returning the error: ----------------------------------------------------------------------- * ERROR 2016-04-08 13:29:32,627 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2]) java.lang.RuntimeException: Exception during execution ... Caused by: java.util.concurrent.ExecutionException: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [create index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ" on analytics_event_temp_1980_dvqwq9jgpn8 ("ciWR6s18VWH")]; ERROR: index row size 3512 exceeds maximum 2712 for index "in_ciWR6s18VWH_ax_event_1980_dvqwq9jgpn8_M0WjJ" Hint: Values larger than 1/3 of a buffer page cannot be indexed. ----------------------------------------------------------------------- Notes: This has not been checked on 2.22. This has been replicated on any browser version. Server is Ubuntu 14.04 LTS, Tomcat 8, Java 8. Recommend turning off indexing for long-text values, or using a set-length of some part of the string for the purposes of indexing. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1567901/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
