[
http://mifosforge.jira.com/browse/MIFOS-3874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=60830#action_60830
]
Udai Gupta commented on MIFOS-3874:
-----------------------------------
There were interest posting batch job failures around 30 Sept, recent savings
issues have been around interest calculation batch job failures.
{code}
SELECT * FROM scheduled_tasks WHERE taskname LIKE '%SavingsIntPostingTask%'
{code}
Savings interest calculation and posting code including batch jobs has been
rewritten, this issue gives a checkpoint of the effect of posting failure. In
future the savings batch job should be able to fix wrong interest postings,
data corruption like in this issue should be taken care in next releases.
There are around 576 accounts where interest posting will be in 2011-03-31
{code}
SELECT COUNT(*),next_int_post_date FROM SAVINGS_ACCOUNT s JOIN ACCOUNT a ON
s.account_id=a.account_id
WHERE account_state_id IN (16,18) GROUP BY next_int_post_date
{code}
It seems like only zero interest has been posted for December.
{code}
SELECT * FROM savings_activity_details WHERE account_action_id=11
AND DATE(created_date) = '2010-12-31' AND amount > 0
SELECT * FROM savings_trxn_detail s JOIN account_trxn a
ON s.account_trxn_id=a.account_trxn_id WHERE account_action_id=11
AND DATE(created_date) = '2010-12-31' AND amount > 0
{code}
Possible effect due to data corruption
- The interest posting for those 576 will not take place in December.
> Interest posting v1.6 error
> ---------------------------
>
> 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: keithwoodlock
> Priority: Major
> Fix For: Release E, Release E - Unscheduled
>
>
> 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
------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
