error "More than one row returned" with GK data

Keith actually GK came back and said they did do it and it still didn't work, so we need to investigate if there was more cleanup that needed to be done

Kay, did GK update test data and production data?

has there being a mistake with the test data then?

seems Udai's still sees nulls on the customer_schedule table fields for currency_id's (there are 4 fields i think that were to be updated)

The test data on our internal test server isn't the data that Praveen has been using - it's an older GK snapshot that we should confirm/run the cleanup queries we have identified. I used this data set to confirm the errors found for 3717, but don't recall if I ran the cleanup on that data on that server. Praveen says he's hitting a subsequent error after running cleanup described for 3717.

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.

Tested with internal GK test instance where queries had been run and instance upgraded to 1.6.1. Now able to view group without error.