| Hi - I think I have the same problem, I have an entity, let's say RootLayer that has a bidirectional manyToOne relationship to a MiddleLayer entity. The MiddleLayer entity has a composite key consisting of a validFrom date and the backreference to RootLayer. In addition, the MiddleLayer has a bidirectional manyToOne relationship to LeafLayer. With this setup, I can not delete an existing RootLayer object and I get the following error indicating a relationship between the audit tables and the normal tables: Referential integrity constraint violation: "FKJBI4GFCQ01BAT36P8GP8VLOJ3: PUBLIC.LEAF_LAYER_AUD FOREIGN KEY(MIDDLE_LAYER_ROOT_LAYER_FK) REFERENCES PUBLIC.ROOT_LAYER(ID) (1) I added a zip file with my use case, I hope it is understandable. |