[
http://mifosforge.jira.com/browse/MIFOS-3418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59131#action_59131
]
Udai Gupta commented on MIFOS-3418:
-----------------------------------
Yesterday Van and I discussed about the possible causes for data corruption. In
short the cause was a bug in 1.3 (visible only when the balance is less than
minimum balance required for posting), and Interest posting/calculation not
able to recover from failure correctly. I will put the details of bug in 1.3 in
later part of this comment.
The fix is crawling the savings account (and activities), fix interest postings
and balance
* Updating the interest posting and corresponding transaction entries
(account_trxn and financial_trxn).
* Running Balance for each activity if there is a wrong interest posting in
past (we will see how many cases appear once the script is complete)
fixing interest posting most of the time will be just checking
A. interest amount posted
B. running balance at the time of interest posting
It may be possible that we could find some of the interest posting entries
missing, script will create interest posting entry as required.
If there is any change found in balance or interest posting the script will log
that and we can analyze what we really want with those entries (ignore/allow)
when running the script on production database.
Most of the facts about discrepancies in database will surface out after
running the script.
Bug in 1.3, (repro)
- create an account with less than minimum balance required for calculation.
- run the batch job for first interest posting (assume secdep scenario sept
2009)(in 1.3 it will skip interest posting according to the rule of minimum
balance)
- make some deposit to bring the balance above minimum required
- run the batch job for second interest posting (the interest posting date will
be of sept 2009 instead of dec 2009)
In 1.3 when interest posting skip posting it also skips updating the last
interest posting date.
Some of the interest posting for March and June 2010 are zero because the
interest calculation job failed and posting job has no way to recover from that.
> Develop cleanup script and procedure for posting interest on missed SECDEP
> savings accounts
> --------------------------------------------------------------------------------------------
>
> Key: MIFOS-3418
> URL: http://mifosforge.jira.com/browse/MIFOS-3418
> Project: mifos
> Issue Type: Task
> Components: Savings Account
> Affects Versions: Release 1.6.0
> Reporter: jbrewster
> Assignee: Udai Gupta
> Priority: Major
> Fix For: Release E - Iteration 3, Release E
>
>
> We need to prepare a procedure and cleanup script to repost interest savings
> on savings accounts missed due to issue MIFOS-3312.
> First task is to determine which accounts should be updated. See issue
> MIFOS-3417 for other possibilities,but immediately known accounts are ones
> posted end of June with interest posting of 0.0 when account balance is above
> 1000 (their savings product requires min bal of 1000).
> Emily and I agreed that removing the previous interest_posting 0.0 entries
> can be ignored, and the cleanup procedure can skip those steps unless there
> is a technical reason to do that cleanup.
> The script will need to modify savings_account.last_int_post_date and
> 2010-03-31 & savings_account.next_int_post_date to 2010-06-30 for this
> selected accounts.
> After script is run, admin will need to rerun SavingsIntPosting task which
> should post properly calculated interest and return the post date values to
> June and Sept.
--
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
