[
http://mifosforge.jira.com/browse/MIFOS-3717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kay Chau updated MIFOS-3717:
----------------------------
Fix Version/s: (was: Release E - Iteration 9)
(was: Release E - Iteration 7)
Release 1.6.1
Assignee: emilytucker
> NPE viewing migrated GK customers due null currency id
> ------------------------------------------------------
>
> Key: MIFOS-3717
> URL: http://mifosforge.jira.com/browse/MIFOS-3717
> Project: mifos
> Issue Type: Bug
> Components: Clients
> Affects Versions: Release 1.6.0
> Environment: 1.6 release with GK data set
> Reporter: jbrewster
> Assignee: emilytucker
> Priority: Major
> Fix For: Release 1.6.1
>
> Attachments: GroupNPE.txt
>
>
> While testing resolved issue MIFOS-3706, encountered another NPE trying to
> view a group within a migrated Kendra.
> Repro steps:
> Pre-test: upgrade Mifos instance with GK data to latest 1.6.x branch build -
> a1a7b471f24e4977a9a439224ce377e2fc04716a
> 1. Log onto test instance with GK data (ask jeff for details)
> 2. search for Kendra 0036-000082070
> 3. click on Group "03:04:76:0102" from Kendra details page
> 4. Get error "More than one row returned" in getCustomerAccountSummaryDto.
> See attached trace "GroupNPE.txt".
> expected result: View Group details
> actual result: exception (see attachment)
> Investigation with KeithW identified null currency for the group account
> being searched. So query:
> select a.global_account_num as globalAccountNum,
> cs.misc_fees_currency_id as currency,
> ((cs.misc_fees - cs.misc_fees_paid) +
> (cs.misc_penalty - cs.misc_penalty_paid)) as totalChargeDue,
> sum(cfs.amount - cfs.amount_paid) as totalFeesDue
> from account a
> join customer_schedule cs on cs.account_id = a.account_id
> left join customer_fee_schedule cfs on cfs.id = cs.id
> where a.customer_id = '82316'
> and (cs.action_date <= date('2010-09-14') or cs.action_date = (select
> min(cs2.action_date)
> from customer_schedule cs2
> where cs2.account_id = cs.account_id
> and cs2.action_date >= date('2010-09-14')))
> group by globalAccountNum, currency;
> Returned:
> globalAccountNum, currency, totalChargeDue, totalFeesDue
> '000100000252275', , ,
> '000100000252275', 2, 0.0000,
> First row above has an unexpected null currency. This occurs in many records
> for GK (older snapshot)
> SELECT count(*) FROM customer_schedule c where c.misc_fees_currency_id is
> null; ==> 6347330
> SELECT count(*) FROM customer_schedule c where c.misc_fees_paid_currency_id
> is null ==== 12010423
> SELECT count(*) FROM customer_schedule c where c.misc_penalty_currency_id is
> null; ==== 12010427
> SELECT distinct c.amount_currency_id FROM customer_fee_schedule c; === 0
> SELECT distinct c.amount_paid_currency_id FROM customer_fee_schedule c; === 0
> Per Keith, all currency_id fields for these fields should have the same value
> - e.g. '2'
--
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
