[
http://mifosforge.jira.com/browse/MIFOS-3874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Udai Gupta resolved MIFOS-3874.
-------------------------------
Resolution: Fixed
Fix Version/s: Release E - Iteration 9
*NOTE:* These cleanup queries are specific to Gayl's database.
This query is for making sure that all the accounts get processed in next
interest posting batch job. As all your savings product have same interest
posting period this query will take care of all accounts
{code}
UPDATE savings_account s JOIN account a ON s.account_id=a.account_id
SET next_int_post_date='2010-12-31', last_int_post_date='2010-09-30'
WHERE account_state_id IN (16,18);
{code}
Delete all the interest posting of December 2010 due to batch job failure.
{code}
DELETE s,a FROM savings_trxn_detail s INNER JOIN account_trxn a
WHERE s.account_trxn_id=a.account_trxn_id
AND account_action_id=11 AND DATE(created_date)='2010-12-31';
DELETE FROM account_payment WHERE payment_date = '2010-12-31'
{code}
Fix date of interest posting (since there is only one interest posting which is
in Sept 2009)
{code}
UPDATE savings_trxn_detail s JOIN account_trxn a
SET action_date='2010-09-30'
WHERE s.account_trxn_id=a.account_trxn_id AND account_action_id=11;
{code}
> 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
> Priority: Major
> Fix For: Release E - Iteration 9, 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
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
