[
http://mifosforge.jira.com/browse/MIFOS-3706?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59988#action_59988
]
jbrewster commented on MIFOS-3706:
----------------------------------
testing note:
On gk data set, this 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 = '82071'
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 totalChargeDue is null, totalFeesDue is null
> NPE viewing customer when totalChargesDue is null for migrated customer
> accounts
> --------------------------------------------------------------------------------
>
> Key: MIFOS-3706
> URL: http://mifosforge.jira.com/browse/MIFOS-3706
> Project: mifos
> Issue Type: Bug
> Components: Clients
> Affects Versions: Release 1.6.0
> Environment: 1.6, gk data set
> Reporter: jbrewster
> Priority: Major
>
> Issue reported by Praveen at GK:
> "While browsing through the Mifos application (V 1.6). when you clicking on
> the Kendra/Center link in Clients & Accounts Page. It is throwing error
> page(Error page is attached with this mail).
> We found that, the error page is coming only with the old Kendras, Groups &
> Clients.
> Old Kendra, Group & Clients: information which is migrated from our legacy
> software."
> Examples include:
> Global_Account_num:
> 0036-000082071
> 0036-000082070
> In troubleshooting with KeithW, issue was narrowed to the fact that Mifos DAO
> for this area presumes the fees and penalties will be populated with a value
> (not null). It appears the migrated customers are the ones with null,
> however our query showed a very large number of records that returned
> totalChargeDue of null (12M of 43M total).
> Repro steps:
> 1. login to mifos instance with GK data.
> 2. query for 0036-000082071
> 3. click result to view details
> Expected result: able to view client details
> actual result: attached NPE
--
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
