[
http://mifosforge.jira.com/browse/MIFOS-3312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59020#action_59020
]
johnwoodlock commented on MIFOS-3312:
-------------------------------------
Although, I still don't know why there was a 'mass' zero interest posting on
1/7/2010... I think the very latest 1.5.x hudson war works ok. I've
run the posting job again and it appears to work fine.
Might be time to move the process forward. It would be good to have a more
formal test with more pairs of eyes. Below is a first cut test plan for
discussion with some gaps... I'm aware it can be improved upon by people who
are most familiar with the savings area... at secdep... and in the mifos code
base.
1. fix the accounts 'in error' by running the batch calculate interest job
This should 'catch-up' and result in two accounts (no.s and amounts mentioned
previously) having interest to post.
Question: Is interest to be posted calculated daily? The interest calculation
job only picks up accounts that have a next_int_calc_date < today (or catchup
date) so it doesnt appear so. Also, until may 8th the posting job used to read
each working day but not since. It runs for all accounts whose
next_int_post_date < today (maybe the previous mandatory accounts had varied
post dates and now all are on the same day)
2. delete all the postings applied in the last interest posting (all zero).
This should just affect saving_activity_details, account_payment, account_trxn
and savings_trxn_detail (financial_trxn shouldn't have any zero postings but
can check).
3. update the last_int_post_date and next_int_post_date to 2010-03-31 &
2010-06-30 resp. Then run the posting job again... this should correctly post
the interest for the 2 accounts that were 'in error' and also the 4291 accounts
that still have outstanding interest to be posted.
4. Then there's a need to changes dates to as if they ran on 1st July (or
actually run it on 1st July).
> 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: debugMifoslog.txt, issue3312SavingsIntCalcErrors.txt,
> screenshot-1.jpg, screenshot-2.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
