[jira] [Closed] (FINERACT-992) Field 'office_id' doesn't have a default value

["Michael Vorburger (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FINERACT-992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Vorburger closed FINERACT-992.
--------------------------------------
      Assignee: Michael Vorburger
    Resolution: Cannot Reproduce

Actually, while I could reliably reproduce this while running the SchedulerJobsTest in PR #817 against the database used above, the problems "went away" (couldn't reproduce anymore) on a fresh new database, so it looks like this was only related to a "corrupted" database that I somehow had...

Thus closing this as Cannot Reproduce.

PR #817 for FINERACT-922 can be merged now.

> Field 'office_id' doesn't have a default value
> ----------------------------------------------
>
>                 Key: FINERACT-992
>                 URL: https://issues.apache.org/jira/browse/FINERACT-992
>             Project: Apache Fineract
>          Issue Type: Bug
>    Affects Versions: 1.4.0
>            Reporter: Michael Vorburger
>            Assignee: Michael Vorburger
>            Priority: Blocker
>             Fix For: 1.4.0
>
>         Attachments: fineract-platform.log
>
>
> 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:
> {noformat}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]{noformat}
> 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?



--
This message was sent by Atlassian Jira
(v8.3.4#803005)