Hi @phil
Thank you and the DHIS team for the job done.
I wanted to test version 41 before to upgrade, and installed it on the local machine.
When I run analytics, have received following errors messages:
2024-06-01 18:51:06 StatementCallback; SQL [create index in__ax_ae3o6seyewn_2007_GmLGu on analytics_tei_events_ae3o6seyewn_2007_temp using btree(eventdatavalues);]; ERROR: index row size 4448 exceeds btree version 4 maximum 2704 for index in__ax_ae3o6seyewn_2007_GmLGu Detail: Index row references tuple (0,1) in relation analytics_tei_events_ae3o6seyewn_2007_temp. Hint: Values larger than 1/3 of a buffer page cannot be indexed. Consider a function index of an MD5 hash of the value, or use full text indexing.; nested exception is org.postgresql.util.PSQLException: ERROR: index row size 4448 exceeds btree version 4 maximum 2704 for index in__ax_ae3o6seyewn_2007_GmLGu Detail: Index row references tuple (0,1) in relation analytics_tei_events_ae3o6seyewn_2007_temp. Hint: Values larger than 1/3 of a buffer page cannot be indexed. Consider a function index of an MD5 hash of the value, or use full text indexing. 2024-06-01 18:51:06 StatementCallback; SQL [create index in__ax_ae3o6seyewn_2021_QUghT on analytics_tei_events_ae3o6seyewn_2021_temp using btree(eventdatavalues);]; ERROR: index row requires 9000 bytes, maximum size is 8191; nested exception is org.postgresql.util.PSQLException: ERROR: index row requires 9000 bytes, maximum size is 8191
and this is only part of error messages.
Do you have any ideas what it could be?
Thank you
Regards,
Ulanbek