[
http://mifosforge.jira.com/browse/MIFOS-3717?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=60082#action_60082
]
johnwoodlock commented on MIFOS-3717:
-------------------------------------
Cautionary Note:)
if you decide to get GK to update the currency_id to 2 (a simple update query)
you may have to be a tad careful if millions and millions of rows are to be
updated that it doesnt fall over because of transaction size and rollback
(which could take ages and make ppl not confident about the change).
If someone does have a go with the simple update query on a test copy and it
falls over... I suggest breaking down the update into a number of separate
updates e.g. by branch - so you'd get a list of branches and do an update query
for each of them.
example untested update for one branch
update customer_schedule cs
join account a on a.account_id = cs.account_id and a.office_id = x
set 'the currency id' = 2
where 'the currency id' is null
> 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
> Priority: Major
> 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
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
