HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViolationException: could not execute statement]

Issue

• After an upgrade from JBoss EAP 7.1.1 to JBoss EAP 7.4.8 the following errors are logged in EAP's log file:

12:15:24,307 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Camel (camel) thread #7 - Consumer[XX_TO_YY]) SQL Error: 1452, SQLState: 23000
12:15:24,307 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Camel (camel) thread #7 - Consumer[XX_TO_YY]) Cannot add or update a child row: a foreign key constraint fails (`entity`.`property`, CONSTRAINT `FK_SALE_CONTEXTS_REFTBL` FOREIGN KEY (`REFTABLE_ID`) REFERENCES `fetransactions` (`REFTABLE_ID`))
12:15:24,307 ERROR [org.hibernate.internal.ExceptionMapperStandardImpl] (Camel (camel) thread #7 - Consumer[XX_TO_YY]) HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViolationException: could not execute statement]