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

Field 'office_id' doesn't have a default value

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.4.0
    • Fix Version/s: 1.4.0
    • Component/s: None
    • Labels:
      None

      Description

      I just ran into the following "interesting" exception while locally running the (new) testTriggeringManualExecutionOfAllSchedulerJobs() in SchedulerJobsTest from https://github.com/apache/fineract/pull/817 for FINERACT-922:

      Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Field 'office_id' doesn't have a default value {prepstmnt 449198571 INSERT INTO m_savings_account_transaction (amount, balance_end_date_derived, bal
      ance_number_of_days_derived, created_date, cumulative_balance_derived, transaction_date, is_loan_disbursement, is_manual, overdraft_amount_derived, release_id_of_hold_amount, is_reversed, running_balance_derive
      d, transaction_type_enum, appuser_id, payment_detail_id, savings_account_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=1364, state=HY000]

      Full details in attached log. It's now easily reproducible (on PR #817, after fixing the points Petri raised in code review).

      Petri Tuomola thought this may peek your interest you... do you have any time & motivation to dig into and fix this?

        Attachments

        1. fineract-platform.log
          5.65 MB
          Michael Vorburger

          Issue Links

            Activity

              People

              • Assignee:
                vorburger Michael Vorburger
                Reporter:
                vorburger Michael Vorburger
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: