[
https://issues.apache.org/jira/browse/FINERACT-2378?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18022276#comment-18022276
]
Adam Monsen edited comment on FINERACT-2378 at 9/23/25 11:14 PM:
-----------------------------------------------------------------
[I noticed both of these failures on Sep
9|https://lists.apache.org/thread/942h6hh8h8mv3o1fnkpq1o29xxy1sbx3], and some
others:
*
[SavingsAccrualIntegrationTest|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsAccrualIntegrationTest.html].
[testAccrualsAreReversedImmediatelyAfterBackdatedTransaction()|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsAccrualIntegrationTest.html#testAccrualsAreReversedImmediatelyAfterBackdatedTransaction()]
*
[SavingsInterestPostingTest|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html].
[testOverdraftAndInterestPosting_WithOverdraftProduct_WhitBalanceGreaterZero()|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html#testOverdraftAndInterestPosting_WithOverdraftProduct_WhitBalanceGreaterZero()]
*
[SavingsInterestPostingTest|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html].
[testOverdraftAndInterestPosting_WithOverdraftProduct_WhitBalanceLessZero()|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html#testOverdraftAndInterestPosting_WithOverdraftProduct_WhitBalanceLessZero()]
*
[SavingsInterestPostingTest|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html].
[testOverdraftInterestWithOverdraftProduct()|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html#testOverdraftInterestWithOverdraftProduct()]
*
[SavingsInterestPostingTest|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html].
[testPostInterestWithOverdraftProduct()|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html#testPostInterestWithOverdraftProduct()]
*
[SchedulerJobsTestResults|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SchedulerJobsTestResults.html].
[testInterestTransferForSavings()|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SchedulerJobsTestResults.html#testInterestTransferForSavings()]
At some point I'll remove the linked-to test results above, so, for posterity,
here's the entire test report:
[^2025-09-09-002-test-result.tgz]
was (Author: meonkeys):
[I noticed both of these failures on Sep
9|https://github.com/apache/fineract/pull/5051], and some others:
*
[SavingsAccrualIntegrationTest|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsAccrualIntegrationTest.html].
[testAccrualsAreReversedImmediatelyAfterBackdatedTransaction()|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsAccrualIntegrationTest.html#testAccrualsAreReversedImmediatelyAfterBackdatedTransaction()]
*
[SavingsInterestPostingTest|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html].
[testOverdraftAndInterestPosting_WithOverdraftProduct_WhitBalanceGreaterZero()|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html#testOverdraftAndInterestPosting_WithOverdraftProduct_WhitBalanceGreaterZero()]
*
[SavingsInterestPostingTest|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html].
[testOverdraftAndInterestPosting_WithOverdraftProduct_WhitBalanceLessZero()|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html#testOverdraftAndInterestPosting_WithOverdraftProduct_WhitBalanceLessZero()]
*
[SavingsInterestPostingTest|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html].
[testOverdraftInterestWithOverdraftProduct()|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html#testOverdraftInterestWithOverdraftProduct()]
*
[SavingsInterestPostingTest|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html].
[testPostInterestWithOverdraftProduct()|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SavingsInterestPostingTest.html#testPostInterestWithOverdraftProduct()]
*
[SchedulerJobsTestResults|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SchedulerJobsTestResults.html].
[testInterestTransferForSavings()|https://adammonsen.com/tmp/2025-09-09-002-test-result/classes/org.apache.fineract.integrationtests.SchedulerJobsTestResults.html#testInterestTransferForSavings()]
At some point I'll remove the linked-to test results above, so, for posterity,
here's the entire test report:
[^2025-09-09-002-test-result.tgz]
> Failing integration test:
> `org.apache.fineract.integrationtests.SchedulerJobsTestResults#testInterestTransferForSavings`
> ------------------------------------------------------------------------------------------------------------------------
>
> Key: FINERACT-2378
> URL: https://issues.apache.org/jira/browse/FINERACT-2378
> Project: Apache Fineract
> Issue Type: Bug
> Affects Versions: 1.12.1
> Reporter: Adam Saghy
> Assignee: Naphlin Peter Akena
> Priority: Critical
> Attachments: 2025-09-09-002-test-result.tgz,
> image-2025-09-22-13-40-49-917.png
>
>
> Integration test started to fail:
> {code:java}
> org.apache.fineract.integrationtests.SchedulerJobsTestResults#testInterestTransferForSavings{code}
> *Test result*
>
> {code:java}
> org.opentest4j.AssertionFailedError: Verifying opening Balance ==> Expected
> :100000.0 Actual :99998.86 <Click to see difference> at
> org.junit.jupiter.api.AssertionFailureBuilder.build(AssertionFailureBuilder.java:151)
> at
> org.junit.jupiter.api.AssertionFailureBuilder.buildAndThrow(AssertionFailureBuilder.java:132)
> at org.junit.jupiter.api.AssertEquals.failNotEqual(AssertEquals.java:197) at
> org.junit.jupiter.api.AssertEquals.assertEquals(AssertEquals.java:182) at
> org.junit.jupiter.api.Assertions.assertEquals(Assertions.java:1156) at
> org.apache.fineract.integrationtests.SchedulerJobsTestResults.testInterestTransferForSavings(SchedulerJobsTestResults.java:1337)
> at java.base/java.lang.reflect.Method.invoke(Method.java:580) at
> java.base/java.util.ArrayList.forEach(ArrayList.java:1596) at
> java.base/java.util.ArrayList.forEach(ArrayList.java:1596){code}
> !image-2025-09-22-13-40-49-917.png!
> *Once it's fixed, remove @Disabled annotation from:*
> {noformat}
> org.apache.fineract.integrationtests.SchedulerJobsTestResults#testInterestTransferForSavings{noformat}
>
> Seems there is an another failing test:
>
> {code:java}
> org.apache.fineract.integrationtests.SavingsInterestPostingTest
> Test
> testOverdraftAndInterestPosting_WithOverdraftProduct_WhitBalanceGreaterZero()
> PASSED (4.1s) Test testPostInterestWithOverdraftProduct() FAILED (4s)
> org.opentest4j.AssertionFailedError: Expected exactly one INTEREST
> posting on posting date ==> expected: <1> but was: <0> at
> app//org.apache.fineract.integrationtests.SavingsInterestPostingTest.testPostInterestWithOverdraftProduct(SavingsInterestPostingTest.java:133)
> {code}
> *I was able to reproduce if i run `AccountTransferTest` (whole test class)
> and after i run*
> *`SavingsInterestPostingTest`.*
> *Backend console log*
>
> {code:java}
> Caused by: java.sql.BatchUpdateException: Batch entry 869 INSERT INTO
> acc_gl_journal_entry(account_id,office_id,reversal_id,currency_code,transaction_id,savings_transaction_id,client_transaction_id,reversed,ref_num,manual_entry,entry_date,type_enum,amount,description,entity_type_enum,entity_id,created_on_utc,last_modified_on_utc,is_running_balance_calculated,office_running_balance,organization_running_balance,payment_details_id,transaction_date,share_transaction_id,
> created_by, last_modified_by, submitted_on_date) VALUES (('0'::int8),
> ('18'::int8), (NULL), ('USD'), ('S243757'), ('243757'::int8), (NULL),
> ('FALSE'::boolean), (NULL), ('FALSE'::boolean), ('2013-04-01'::date),
> ('2'::int8), ('255.8444'::numeric), (NULL), ('2'::int8), ('36'::int8),
> ('2025-09-22 15:39:29.534134+00'::timestamp with time zone), ('2025-09-22
> 15:39:29.534134+00'::timestamp with time zone), ('FALSE'::boolean),
> ('0'::numeric), ('0'::numeric), (NULL), ('2013-04-01'::date), (NULL),
> ('2'::int8), ('2'::int8), ('2025-03-01'::date)) was aborted: ERROR: insert or
> update on table "acc_gl_journal_entry" violates foreign key constraint
> "FK_acc_gl_journal_entry_acc_gl_account" Detail: Key (account_id)=(0) is not
> present in table "acc_gl_account". Call getNextException to see other errors
> in the batch.{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
