Lars, Thanks for fixing this - any chance of the fix being backported to 2.22 and/or 2.21?
Regards Calle On 12 April 2016 at 18:54, Lars Helge Øverland <[email protected]> wrote: > Impl a fix in trunk (2.23-SNAPSHOT) where data elements and attributes > with value type LONG_TEXT and without option sets are not indexed in the > event analytics tables. > > ** Changed in: dhis2 > Status: New => Fix Committed > > -- > 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: > Fix Committed > > 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 > -- ******************************************* Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: [email protected] Skype: calle_hedberg *******************************************
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
