This article describes some important items you need to consider when upgrading to Cleo Harmony 5.8.
- The Cleo Unify file/folder share and anonymous download link options have been removed as Unify is no longer being offered within Portal and the REST API. As part of this, the embedded Graph DB was also removed. If upgrading a system where Unify in Portal is in use, the product installer will block the upgrade until the system option "Disable Unify In Portal" is set to "True". (Go to Administration > System > Other to find "Disable Unify in Portal".) The Portal Two-Factor Authentication (TFA) option, which was previously tied to Unify In Portal licensing, is still supported. But if upgrading, the product installer will also block the upgrade if TFA is in use and the last 5.7 patch has not been installed (which will migrate TFA away from the Graph DB).
- VersaLex now supports MySQL 8. However, as part of this, the 'Recursive' column in the 'VLSLAKPI' database table had to be renamed to 'Recurse' as 'Recursive' is now a reserved keyword in MySQL 8. The column rename was applied to ALL databases and versions, not just MySQL 8. VersaLex will attempt to rename the column at startup after upgrade, but if the database user configured in VersaLex does not have DDL privilege or if the column rename otherwise fails, the column must be renamed outside of VersaLex. There is also a database view 'View_Checkpoints' where the 'Recursive' column was renamed. VersaLex will actually first attempt to drop this view, then rename the table column, and then recreate the view. For reference, use [Export Database Definition...] in the Transfers configuration window and find references to 'Recursive' in the CREATE TABLE VLSLAKPI and CREATE VIEW View_Checkpoints statements.
- If you are upgrading from VersaLex 126.96.36.199 or older and you use Cleo Dashboards, you must upgrade Cleo Dashboards to v3.3.6 or newer because of database changes in VersaLex. In addition, Cleo Dashboards v3.3.6 requires Clarify v5.1.16 or newer.