[FINERACT-992] Field 'office_id' doesn't have a default value

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Cannot Reproduce
• Affects Version/s: 1.4.0
• Fix Version/s: 1.4.0
• Assignee: Michael Vorburger
• Reporter: Michael Vorburger
• Created: 21/May/20 21:47
• Updated: 24/May/20 18:09
• Resolved: 24/May/20 18:09

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).

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

Issue Links

• blocks: FINERACT-922 Improve SchedulerJobHelper to be more reliable and prevent flaky tests