[ https://issues.apache.org/jira/browse/FINERACT-1050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yemdjih Kaze Nasser updated FINERACT-1050: ------------------------------------------ Summary: loan_repayment_schedule_id column contraint errors (was: Failing ClientLoanIntegrationTest) > 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)