[
http://mifosforge.jira.com/browse/MIFOS-3312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59024#action_59024
]
jbrewster commented on MIFOS-3312:
----------------------------------
Agree we need to have a plan and test procedure around correction and recovery
of missing interest postings for production data. My initial goal is to
confirm that the proper interest will be posted for Q2 now that it's 2 weeks
later and additional deposits have been made on the account.
To confirm that accuracy, I first had to reverse engineer the interest posting
calculation for a previous interest period. The SECDEP savings products are
using average balance calculations. The attached spreadsheet
"averageBalanceInterestPostingExample.xls" has the calculation for Q1 from
Mifos and the Q2 expected calculation for savings account # 000100000018517.
The average balance is calculated with A=P(1 + r/n) where P is current balance,
r is interest (.05) and n is frequency of posting (4 since this is a quarterly
posting). Feedback on this calculation welcome if I'm not doing this properly.
Calculation for this account on Q2 is 74.4 in the spreadsheet. (not figuring
rounding rules) To test the interest posting of this account, I did these
steps:
1. stopped tomcat
2. modified savings_account.last_int_post_date and 2010-03-31 &
savings_account.next_int_post_date to 2010-06-30 for this single account.
3. Started tomcat and ran batch jobs
4. login and review account activity for account 000100000018517
5. confirmed the interest posting is 74.0.
Note on the screenshot interest posting shows up with 0.0 for 6/29 and 74.0 for
6/30. We need to decide whether to remove the previous 0.0 postings from the
tables as John noted above. When I do this query:
SELECT * FROM savings_activity_details s where amount = '0.0';
I see many more 0.0 postings with large balances prior to end of June 2010.
Would like to discuss cleanup with team (Ryan, John?)
> Interest not posting for savings accounts in 1.5
> ------------------------------------------------
>
> Key: MIFOS-3312
> URL: http://mifosforge.jira.com/browse/MIFOS-3312
> Project: mifos
> Issue Type: Bug
> Components: Savings Account
> Affects Versions: Release 1.5
> Reporter: jbrewster
> Assignee: johnwoodlock
> Priority: Critical
> Fix For: Release 1.5.1, Release 1.6.0, Release E - Iteration 2,
> Release E
>
> Attachments: averageBalanceInterestPostingExample.xls,
> debugMifoslog.txt, issue3312SavingsIntCalcErrors.txt, screenshot-1.jpg,
> screenshot-2.jpg, screenshot-3.jpg
>
>
> SECDEP reported several accounts were not posting interest on their 3 month
> interest posting date - 30 June 2010.
> I've confirmed that many accounts were flagged in the SavingsIntCalcTask as
> of 30 June. Previously, a few tasks were flagged every day (see MIFOS-2714).
> A large list appears every day starting 30 June. Note the attached list may
> be truncated and not completely list all failed postings.
>
>
>
>
> Here is the error listed in Mifos.log:
> org.mifos.framework.components.batchjobs.exceptions.BatchJobException: Failure
> at
> org.mifos.framework.components.batchjobs.helpers.SavingsIntCalcHelper.execute(SavingsIntCalcHelper.java:67)
> at
> org.mifos.framework.components.batchjobs.TaskHelper.perform(TaskHelper.java:201)
> at
> org.mifos.framework.components.batchjobs.TaskHelper.executeTask(TaskHelper.java:114)
> at
> org.mifos.framework.components.batchjobs.MifosTask.run(MifosTask.java:55)
> at java.util.TimerThread.mainLoop(Timer.java:512)
> at java.util.TimerThread.run(Timer.java:462)
> 2010-07-07/00:13:16.698/PHT INFO, org.mifos.framework.components.batchjobs,
> TaskHelper, executeTask, 113, SavingsIntCalcTask will run catch-up execution
> for Sat Jan 02 08:00:20 PHT 2010
> I've taken a snapshot of the SECDEP test database for further debugging.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
