dhis2-devs team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

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