Error updating 2.34.6 to 2.35.6

[stebu (Samuel)]

Processing: ServerLogs_2.35.6…
Processing: ServerLogs_2.35.6…
ServerLogs_2.35.6.docx (223.6 KB)

Hello,
I have a DHIS2.0 environment set up using Bob Jollife’s NG_tools as summarized below
Ubuntu 20.04
Tomcat 9
Postgres 13

When I try to upgrade from v2.3.4.6 to v2.35.6, I get some errors (Tomcat log attached). Glad if I can get any assistance.

@ifeanyiokoye

[Gassim (AL-Gassim Sharaf Addin)]

Hi @stebu, welcome and thank you for posting this in the Community of Practice! I see that in you server log you have this error ( *** WARN 2021-08-29T13:51:06,125 Could not perform upgrade of table 'trackedentityattributevalue'. Column 'value' should be altered to data type varchar(1200) and receive a new index. For more information, please see the following post: https://community.dhis2.org/t/important-database-upgrade-for-tracker-performance/38766 ***) which is mentioned in a CoP post by @Stian in 2020; so I would recommend following these instructions before upgrading:

@Stian

Summary

If your instance fails to perform the database upgrade and is unable to start, manual intervention is required. Remove any values longer than 1200 characters, and start DHIS2 again.

Important: Ensure you make a backup of your database prior to making these changes.

Useful SQL statements

The following SQL snippets are relevant for this issue.

-- List all values that exceeds 1200 characters
SELECT value FROM trackedentityattributevalue WHERE length(value) > 1200;

-- Delete all values that exceeds 1200 characters (be careful)
DELETE FROM trackedentityattributevalue WHERE length(value) > 1200;

-- Change the data type (done by DHIS2 during upgrade)
ALTER TABLE trackedentityattributevalue 
ALTER COLUMN value SET DATA TYPE VARCHAR(1200);

-- Adding the btree index (Done by DHIS2 during upgrade)
CREATE INDEX in_trackedentity_attribute_value 
ON trackedentityattributevalue 
USING btree (trackedentityattributeid, LOWER(value));

Initially, this error must be fixed for the upgrade to work, so if you face any issue following the fix instructions please let us know and please add the log. If the fix is successful, I hope the upgrade to 2.35.6 will work after this fix, but if you still face an issue, please post here!

Thanks!

[stebu (Samuel)]

Hi @Gassim ,
Thanks for your response. I stumbled unto the post Another upgrade issue from 2.34.6 to 2.35.6 - #9 by Stian which solved my issue.
ST

[Gassim (AL-Gassim Sharaf Addin)]

You’re welcome, and congratulations @stebu . I’m glad you solved it! Thank you for sharing the solution! ( :