Uploaded image for project: 'Apache Fineract'
  1. Apache Fineract
  2. FINERACT-1050

loan_repayment_schedule_id column contraint errors

    XMLWordPrintableJSON

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"}"
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            kaze Yemdjih Kaze Nasser
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: