[FINERACT-1260] EntityExistsException: Cannot delete or update a parent row: a foreign key constraint fails (`fineract_default`.`m_loan_transaction_repayment_schedule_mapping`, CONSTRAINT `FK_mappings_m_loan_repayment_schedule`...

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Auto Closed
• Component/s: Loan
• Labels: Cleanup2022
• Assignee: Unassigned
• Reporter: Michael Vorburger
• Created: 12/Nov/20 21:51
• Updated: 07/Nov/22 18:11
• Resolved: 07/Nov/22 18:11

Description

See FINERACT-932 for general background; I've found this in logs of https://www.fineract.dev:

Caused by: org.apache.openjpa.persistence.EntityExistsException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470) ~[openjpa-3.1.2.jar:3.1.2] at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308) ~[openjpa-3.1.2.jar:3.1.2] at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199) ~[openjpa-3.1.2.jar:3.1.2] at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2116) ~[openjpa-3.1.2.jar:3.1.2] at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84) ~[openjpa-3.1.2.jar:3.1.2] at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1600) ~[openjpa-3.1.2.jar:3.1.2] at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035) ~[openjpa-3.1.2.jar:3.1.2] at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:669) ~[openjpa-3.1.2.jar:3.1.2] at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:534) ~[spring-orm-5.2.10.RELEASE.jar:5.2.10.RELEASE] ... 19 common frames omitted Caused by: org.apache.openjpa.persistence.EntityExistsException: Cannot delete or update a parent row: a foreign key constraint fails (`fineract_default`.`m_loan_transaction_repayment_schedule_mapping`, CONSTRAINT `FK_mappings_m_loan_repayment_schedule` FOREIGN KEY (`loan_repayment_schedule_id`) REFERENCES `m_loan_repayment_s)

 

Issue Links

• blocks: FINERACT-932 Parent Issue for Error Logs seeing during "normal" usage (e.g. on fineract.dev)