AddOn MessageTemplate - Liquibase changelog is not proccessed in DDBB Oracle 19

Support
,
1

Hi Jmix Team,

We are using JMIX 2.7 and we would like to use the message-template addon, for some reason the changelog of the liquibase is not processed.

After installing the addon the following changelog is created

image

But after running and checking the logs, these liquibase changes are not processed, no message informing of changes in the logs is displayed and the Message template tables are not created.

We checked the table DATABASECHANGELOG to ensure the changelog is not processed, as you can see the last change is before 27.11.2025 when we installed the addon.

image

We tried with other Addon “Reports” for testing purpose and when we build the apllication the following message is displayed and the tables are created correctly. (This is not displayed in Message Templates Addon)

image

We are using Oracle as a data base with version 19 which is higher than the requested in the documentation.

¿Any idea what we could be doing wrong? We have used many other addons without any problem.

Additional comment

We tried with another application that is not using Oracle database and the change is proccessed and the tables are created successfully.

image

¿Is there any incompability with this addon and Oracle 19?

Best Regards.

3

Hello!

Seems like this is bug, message template’s liquibase scripts are not applying to the database due to types mismatching. And i have created an issue on our github tracker so you can track status of the ticket. Thanks for detailed report!

Best regards,
Dmitry

4

We have double-checked the add-on with the latest Oracle 23 and couldn’t find any issues.

Could you provide the whole content of your master changelog.xml from the problematic project?

6

Hi Konstantin

Please find attached the changelog.xml and also here as picture

image
changelog.xml (1.7 KB)

We did a further research.

  1. We installed another new addon to see if the liquibase is triggered. The liquibase of other addons are working, i.e = Authorization server and the changelog is ran and the tables are created.

image

  1. We create a new project from scratch with our Oracle database and the addon Message Templates runs smoothly, meaning this is not a problem with Oracle Datababase.

We assume that a combination of changelogs in our project are clashing but we do not know if this is related to a combination of JMIX addon or due to our custom changelog (that we assume should not have any impact).

We will keep searching for a solution.

Thanks you in case you have any hint.

7

Hi Luis,

Thank you for this additional information.

Can you try to run your application on an empty Oracle database?

Also, could provide the contents of the databasechangelog table, preferably in Excel or CSV format? You can send it to me in a private message here.

8

Hi Konstantin,

We have an entry in the table databasechangelog from April 2025 related to the Message Template AddOn. After deleting the entry in this table the Message Template was installed correctly.

Thank you for time.

Best Regards.

1 Like