[
http://mifosforge.jira.com/browse/MIFOS-3874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=62865#action_62865
]
Kojo Gambrah-Sampaney commented on MIFOS-3874:
----------------------------------------------
Gayl, I trying to verify that this issue has been resolved for you and that the
inconsistencies created in the database due to the interest posting failure has
been cleaned up successfully. Will you confirm that you don't see any interest
posting from December as Udai asked earlier?
> 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
------------------------------------------------------------------------------
Oracle to DB2 Conversion Guide: Learn learn about native support for PL/SQL,
new data types, scalar functions, improved concurrency, built-in packages,
OCI, SQL*Plus, data movement tools, best practices and more.
http://p.sf.net/sfu/oracle-sfdev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
