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

Field 'office_id' doesn't have a default value

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Cannot Reproduce
    • 1.4.0
    • 1.4.0
    • None
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment