You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@fineract.apache.org by "Michael Vorburger (Jira)" <ji...@apache.org> on 2020/05/21 21:51:00 UTC
[jira] [Updated] (FINERACT-992) Field 'office_id' doesn't have a
default value
[ https://issues.apache.org/jira/browse/FINERACT-992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Vorburger updated FINERACT-992:
---------------------------------------
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:
{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?
was:
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.
Couldn't reproduce it.
> 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
> Priority: Critical
> Fix For: 1.4.0
>
>
> 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)