Problem
I’m currently running Domibus v5.1. I want to migrate to version 5.1.5. To accomplish that I backed up my mysql database to restore it on another machine so I can test the different mysql scripts that I need to run to succeed in the update.
When I run the script ‘mysql-5.1-to-5.1.1-upgrade.ddl’ it fails with the following error message: ‘ERROR 1644 (45001) at line 64: Domibus Assertion Error: Please upgrade to 5.1. The last successful upgrade was to 5.0.4’.
Solution:
If this is the only error message, then do the following command:
INSERT INTO TB_VERSION (VERSION, BUILD_TIME, CREATION_TIME) VALUES ('5.1', '2024-01-10 16:04', (UTC_TIMESTAMP)) ON DUPLICATE KEY UPDATE BUILD_TIME='2024-01-10 16:04', CREATION_TIME = (UTC_TIMESTAMP);
For an Oracle database:
MERGE INTO TB_VERSION USING dual ON (VERSION = '5.1') WHEN MATCHED THEN UPDATE SET BUILD_TIME = '2024-01-10 16:04', CREATION_TIME = SYS_EXTRACT_UTC(CURRENT_TIMESTAMP) WHEN NOT MATCHED THEN INSERT (VERSION, BUILD_TIME, CREATION_TIME) VALUES ('5.1', '2024-01-10 16:04', SYS_EXTRACT_UTC(CURRENT_TIMESTAMP));