[
http://mifosforge.jira.com/browse/MIFOS-3417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59057#action_59057
]
johnwoodlock commented on MIFOS-3417:
-------------------------------------
RERAN BATCH JOB
--------------
Changed the last_int_post_date & next_int_post_date to '2010-03-21' and
'2010-06-30' on backup Van gave me (dated 6/7/2010)
Ran the posting batch job (for mifos v 1.5.0.1 -
branches/v1.5.x/applicat...@17364)
The 4921 accounts that had interest to be posted all non-zero posting on the
account_trxn table and the savings_activity_account.
Not sure where to go from here (will talk with Udai when his available).
6/5/2010 might be a significant date (1.5 upgrade?, some pre 1.5 upgrade work?)
Ryan mentioned there was work on holiday pushout... and that it impacted
schedules... I can't see schedule changes affecting the posting job but maybe
there was more done than schedule changes.
I suppose to be certain... we should get the backup from 30th June (prior to
batch job running)... then set the system date to 1/7/2010 and rerun the batch
job using mifos v 1.5.0.1 - branches/v1.5.x/applicat...@17364 and see if zeroes
are posted or not. Can someone get that backup?
> 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 2, 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
