Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Auto Closed
-
1.4.0
-
None
-
None
Description
Dupicate value for column loan_repayment_schedule_id. I think the entity relationship around this column are messed up. I don't know how they manage to work till now but eclipselink doesn't seem to agree with it.
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.7.v20200504-69f2c2b80d): org.eclipse.persistence.exceptions.DatabaseException\nInternal Exception: java.sql.SQLIntegrityConstraintViolationException: Column 'loan_repayment_schedule_id' cannot be null\nError Code: 1048\nCall: INSERT INTO m_loan_transaction_repayment_schedule_mapping (loan_transaction_id, ID, amount, fee_charges_portion_derived, interest_portion_derived, penalty_charges_portion_derived, principal_portion_derived, loan_repayment_schedule_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n\tbind => [5022, null, 412.00, null, 12.00, null, 400.00, null]\nQuery: ValueReadQuery(name=\"SEQ_GEN_IDENTITY\" sql=\"SELECT LAST_INSERT_ID()\"); nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.7.v20200504-69f2c2b80d): org.eclipse.persistence.exceptions.DatabaseException\nInternal Exception: java.sql.SQLIntegrityConstraintViolationException: Column 'loan_repayment_schedule_id' cannot be null\nError Code: 1048\nCall: INSERT INTO m_loan_transaction_repayment_schedule_mapping (loan_transaction_id, ID, amount, fee_charges_portion_derived, interest_portion_derived, penalty_charges_portion_derived, principal_portion_derived, loan_repayment_schedule_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n\tbind => [5022, null, 412.00, null, 12.00, null, 400.00, null]\nQuery: ValueReadQuery(name=\"SEQ_GEN_IDENTITY\" sql=\"SELECT LAST_INSERT_ID()\")","path":"/fineract-provider/api/v1/loans/1113"}"