Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths. (qlack2-fuse-aaa)

[AndreasZimnas]

Creating the database tables for qlack2-fuse-aaa fails for MSSQL Server 2014 and MSSQL Server 2016 with following error message:

[ERROR] Reason: liquibase.exception.DatabaseException: Introducing FOREIGN KEY constraint 'fk_aaa_group_aaa_group' on table 'aaa_group' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. [Failed SQL: ALTER TABLE [db_datareader].[aaa_group] ADD CONSTRAINT [fk_aaa_group_aaa_group] FOREIGN KEY ([parent]) REFERENCES [db_datareader].[aaa_group] ([id]) ON UPDATE CASCADE ON DELETE CASCADE]