[
http://mifosforge.jira.com/browse/MIFOS-4088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=61599#action_61599
]
Udai Gupta commented on MIFOS-4088:
-----------------------------------
Investigating against 1.6.x code
The Named query "getCustomerAccountSummaryDto"
is returning 2 values, while the logic expects it to be unique.
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 = 127846 and (cs.action_date <= CURRENT_DATE
or cs.action_date = (select min(cs2.action_date) from customer_schedule cs2
where cs2.account_id = cs.account_id and cs2.action_date >= CURRENT_DATE))
group by globalAccountNum, currency
called by
org.mifos.customers.persistence.CustomerDaoHibernate.getCustomerAccountSummaryDto(Integer)
> error "More than one row returned" with GK data
> -----------------------------------------------
>
> Key: MIFOS-4088
> URL: http://mifosforge.jira.com/browse/MIFOS-4088
> Project: mifos
> Issue Type: Bug
> Components: Groups
> Environment: gk data set, 1.6.x war deployed
> Reporter: jbrewster
> Assignee: Udai Gupta
> Fix For: Release E - Iteration 11, Release E
>
> Attachments: screenshot-1.jpg
>
>
> Praveen noted in email that GK saw a null point exception issue for the Old
> GK migrated Customers.while browsing the Customer related page.
> I did my own testing, and encountered an exception on certain groups and
> centers. I'm not sure if this is the same issue that Praveen noted.
> My repro steps:
> 1. login to test instance with GK data (jeff can provide info)
> 2. search for client 0037-000130074
> 3. click on client, view client details.
> 4. click on group in breadcrumb above the client - 06:02:31:0506
> expected result: see group details page
> actual result: error - More than one row returned
> see attached stack trace.
> I assume this has something to do with certain older data. If so, this is a
> duplicate of MIFOS-3717. Would like Praveen to confirm these repro steps.
--
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
------------------------------------------------------------------------------
The Next 800 Companies to Lead America's Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book "Blueprint to a
Billion" shares his insights and actions to help propel your
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
