Liquibase Problems

cj_maradiagaa · July 27, 2022, 1:27am

**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?

krivopustov · July 28, 2022, 5:53am

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

cj_maradiagaa · July 28, 2022, 2:39pm

gaslov · August 2, 2022, 3:04pm

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.