Error when installing Email Template plugin

Support
#1

Hi, using Jmix 1,5
when installing email template plugin (email plugin already installed earlier), I receive liquibase error:
Liquibase: Migration failed for change set io/jmix/emailtemplates/liquibase/changelog/001-emailtemplates.xml::1::emailtemplates:

 Reason: liquibase.exception.DatabaseException: ERROR: there is no unique constraint matching given keys for referenced table "report_report" [Failed SQL: (0) CREATE TABLE public.EMLTMP_TEMPLATE_REPORT (ID UUID NOT NULL, VERSION INTEGER DEFAULT 1 NOT NULL, CREATE_TS TIMESTAMP WITHOUT TIME ZONE, CREATED_BY VARCHAR(50), UPDATE_TS TIMESTAMP WITHOUT TIME ZONE, UPDATED_BY VARCHAR(50), DELETE_TS TIMESTAMP WITHOUT TIME ZONE, DELETED_BY VARCHAR(50), NAME VARCHAR(255), REPORT_ID UUID NOT NULL, EMAIL_TEMPLATE_ID UUID, CONSTRAINT "EMLTMP_TEMPLATE_REPORT_pkey" PRIMARY KEY (ID), CONSTRAINT FK_ET_TEMPLATEREPORT_REPORT FOREIGN KEY (REPORT_ID) REFERENCES public.REPORT_REPORT(ID), CONSTRAINT FK_ET_TEMPLATEREPORT_TEMPLATE FOREIGN KEY (EMAIL_TEMPLATE_ID) REFERENCES public.EMLTMP_EMAIL_TEMPLATE(ID))]

Did anyone conquer this before?

Thanks,
br
HP

#2

Hello,

not exactly this problem, but I had a problem like this before.
Check the error message - it wants to create a table, but it can’t, because when creating the constraint(s) it doesn’t find what fields in the referenced tables it needs, most likely this part
CONSTRAINT FK_ET_TEMPLATEREPORT_REPORT FOREIGN KEY (REPORT_ID) REFERENCES public.REPORT_REPORT(ID),
Do you have this table in the database, and does it have field “ID” or is it maybe REPORT_ID or ID_REPORT or something?

Either correct this part in the liquibase changelog, or execute SQL manually without that part, then check what’s up and add this constraint manually. (backup before) Do you have a report add-on installed?

Kind regards,
Mladen

#3

Hi, thanks for quick response…

yes to all. I already found the constrain and checked. having installed reports before, yes I have report_report and id as pkey. … don’t know. will check further,

thanks so far,
HP