[
http://mifosforge.jira.com/browse/MIFOS-4088?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Udai Gupta resolved MIFOS-4088.
-------------------------------
Resolution: Fixed
Story Points: 2
Above mentioned query with 1.6.1 should fix issue.
There are other Recommended(but not necessary) queries that GK should run on
their database.
update customer_schedule set misc_fees_currency_id=2 where
misc_fees_currency_id is null;
update customer_schedule set misc_penalty_paid_currency_id=2 where
misc_penalty_paid_currency_id is null;
update customer_schedule set misc_fees_paid_currency_id=2 where
misc_fees_paid_currency_id is null;
update customer_schedule set misc_penalty_currency_id=2 where
misc_penalty_currency_id is null;
update customer_schedule set misc_fees_paid=0.0000 where misc_fees_paid is null;
update customer_schedule set misc_penalty=0.0000 where misc_penalty is null;
update customer_schedule set misc_penalty_paid=0.0000 where misc_penalty_paid
is null;
update customer_schedule set misc_fees=0.0000 where misc_fees is null;
They can run one query at a time one externally, doesn't matter if they are on
1.5 or they upgrade to 1.6.
Each query is going to update huge number of rows.
> 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
> Priority: Critical
> 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
------------------------------------------------------------------------------
Centralized Desktop Delivery: Dell and VMware Reference Architecture
Simplifying enterprise desktop deployment and management using
Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
client virtualization framework. Read more!
http://p.sf.net/sfu/dell-eql-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
