[
http://mifosforge.jira.com/browse/MIFOS-3417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59091#action_59091
]
Udai Gupta commented on MIFOS-3417:
-----------------------------------
I have backup of secdep before and after they upgraded to 1.5
A) Before upgrade mysql dump has timestamp - 14 May 2010
B) After upgrade mysql dump has timestamp - 20 May 2010
C) Latest mysql dump has timestamp - 13 July 2010
Some query that I ran to find the zero interest posting even though the running
balance is more than 1000 (bad data)
SELECT account_id,COUNT(account_id) AS no_of_wrong_int_posted FROM
savings_activity_details
WHERE ACCOUNT_ACTION_ID = 11 AND BALANCE_AMOUNT > 1000 AND amount = 0
GROUP BY account_id
results (number of rows)
A) 0
B) 1844
C) 5382
Let's leave A out as it has no wrong(assuming all non-zero posting are correct)
interest posting.
SELECT * FROM (SELECT account_id,COUNT(account_id) AS no_of_wrong_int_posted
FROM savings_activity_details
WHERE ACCOUNT_ACTION_ID = 11 AND BALANCE_AMOUNT > 1000 AND amount = 0
GROUP BY account_id) AS d WHERE no_of_wrong_int_posted = <use 1,2,3 or 4 to see
freq of wrong interest postings>
secdep came live in Aug 2009, all there savings account has 3 month interest
calculation and posting frequestion. i.e. interest is calculated right before
it is posted, minimum balance for calculation is 1000 and it's Average balance
interest calculation.
no_of_wrong_int_posted = 1
B) 681
C) 3605
no_of_wrong_int_posted = 2
B) 636
C) 671
no_of_wrong_int_posted = 3
B) 527
C) 635
no_of_wrong_int_posted = 4
B) 0
C) 471
681 + 636 + 527 + 0 = 1844
3605 + 671 + 635 + 471 = 5382
Now, we have more than 5382 or more account with wrong interest posting to be
fixed. (secdep currently has around 23 K savings account).
Reason for corrupted data,
- Interest calculation job failure (leaving interest to be posted as zero)
* For the scenario of (same day interest calculation and the posting) Mifos
cannot recover from interest calculation job failure.
Next,
Why interest posting job will post zero interest posting for past as the last
interest posting date should have been moving/updated by 1.3 (or not?).
Recovery:
Create a utility using mifos code to recalculate and post the interest for
affected accounts
> Zero savings interest posted for previous periods with account that has
> above-minimum balance.
> ----------------------------------------------------------------------------------------------
>
> Key: MIFOS-3417
> URL: http://mifosforge.jira.com/browse/MIFOS-3417
> Project: mifos
> Issue Type: Bug
> Components: Savings Account
> Affects Versions: Release 1.5
> Reporter: jbrewster
> Assignee: Udai Gupta
> Priority: Major
> Fix For: Release E - Iteration 3, Release E
>
> Attachments: 3417txn.JPG, SavingsAcctTableRslt.txt, screenshot-1.jpg
>
>
> (Related to issue MIFOS-3312)
> While testing fixes for MIFOS-3312, I noticed accounts were
> interesting_posting in activity log for savings account shows multiple times.
> For example, Individual Compulsory Fund # 000100000029684 has two zero
> interest postings:
> 30/06/2010 Interest_Posting 0 4935
> 31/03/2010 Interest_Posting 0 4935
> Queried the production data snapshot and there are over 8,000 entries where
> interest posting is zero and min balance is above 1000. Need to analyze
> these other interest periods to determine whether the interest for that
> period is missing or if interest posting of zero is correct. (maybe account
> is dormant and that results in no interesting posting?) I see create dates
> in savings_activity_details table with zero posting are from Dec 2009, March
> 2010, and June 2010.
> Query I used:
> SELECT * FROM savings_activity_details s where amount = '0.0' and
> balance_amount > '1000.0';
> For example account 000100000029684, I've attached a screenshot of the
> activity details and the transaction log.
--
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
