[
http://mifosforge.jira.com/browse/MIFOS-3874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jbrewster updated MIFOS-3874:
-----------------------------
Status: Verified (was: Resolved)
> Interest posting batch job failure cause interest postings with wrong
> (future) dates
> ------------------------------------------------------------------------------------
>
> Key: MIFOS-3874
> URL: http://mifosforge.jira.com/browse/MIFOS-3874
> Project: mifos
> Issue Type: Bug
> Components: Savings Account
> Affects Versions: Release 1.6.1
> Environment: version 1.6
> Reporter: Gayl Kennedy
> Assignee: Udai Gupta
> Fix For: Release E - Iteration 9, Release E
>
> Attachments: Gayl-sceernshot.jpg
>
>
> Our interest on saving accounts is set up to post quarterly so the first
> quarter end was Sept 30th.
> This week we noted that some accounts had an interest posting for Sept 30th
> but some also had it for Dec 31, 2010 which is incorrect.
> Note the 31 Dec posting had zero value.
> What will happen to those accounts on 31 Dec when they should get interest?
> I don't understand the inconsistency
> example 1 - 3% interest - see Sept & Dec date
> Date Description Amount
> 31/12/2010 Interest_Posting 0.00
> 30/09/2010 Interest_Posting 42.84
> example 2 - 3% interest - just see Sept date
> Date Description Amount
> 30/09/2010 Interest_Posting 551.52
> we ran 2 queries provided by Uday - both of which returned no results.
> # 1: to see interest posting batch job was ran twice on any day.
> select * from (select count(*) as a from scheduled_tasks where
> taskname="SavingsIntPostingTask" group by date(starttime)) d where a >1
>
> The 2nd query to see if batch job ran for any future date.
> SELECT * FROM scheduled_tasks WHERE taskname="SavingsIntPostingTask"
> AND DATE(starttime) > '2010-10-30'
--
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
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
