Liquibase Problems

test.rar (202.5 KB)

**generates the following error **

Caused by: liquibase.exception.DatabaseException: (conn=117562) Can’t DROP FOREIGN KEY FK_DYWSERVICESERVI_ON_EMPLOYEE; check that it exists [Failed SQL: (1091) ALTER TABLE dynawash.DYW_SERVICE_SERVICE_ITEM DROP FOREIGN KEY FK_DYWSERVICESERVI_ON_EMPLOYEE]

is it a problem with case sensitive names?

Hi Cesar,

Thanks for the report, I have created an issue: https://youtrack.haulmont.com/issue/JST-3072
Are you using the latest Studio 1.3.2?

Regards,
Konstantin

2 Likes

image
image

Hi,

During problem investigation I’ve found that ServiceServiceItem entity has three indexes defined with the same name: IDX_SERVICESERVICEITEM. This names duplication causes invalid diff changelog generation that you faced with.
So you need to delete that invalid changelog, set unique names for indexes and generate diff changelog again.

1 Like