[
https://issues.apache.org/jira/browse/FINERACT-1050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17151795#comment-17151795
]
Awasum Yannick commented on FINERACT-1050:
------------------------------------------
Maybe this should be fixed before we merge the EclipseLink migration PR?
[https://github.com/apache/fineract/pull/928/files]
> loan_repayment_schedule_id column contraint errors
> --------------------------------------------------
>
> Key: FINERACT-1050
> URL: https://issues.apache.org/jira/browse/FINERACT-1050
> Project: Apache Fineract
> Issue Type: Bug
> Affects Versions: 1.4.0
> Reporter: Yemdjih Kaze Nasser
> Priority: Major
>
> 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.
> {code:java}
> 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"}"
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
