MR error 'Sequence contains no elements' after applying CU13
Greg Byer
2,586
Like
Share
ReportAfter upgrading to MR 2012 CU13, you may encounter the following error on the CompanyProvider to Company task:
Sequence contains no elements.
This error will occur if there is a missing record in the Reporting.ControlCompanyIntegration table, in the Management Reporter database. To correct this, you’ll need to run the following queries:
select * from Reporting.ControlCompany
select * from Reporting.ControlCompanyIntegration
There should be an equal number of records in both tables. The exception is if you have Legacy companies. Legacy companies will be in the Reporting.ControlCompany table only. If there is a record in the Reporting.ControlCompany but not the Reporting.ControlCompanyIntegration, you’ll need to make a backup of your database and then run this statement:
MERGE Reporting.ControlCompanyIntegration AS TARGET
USING Reporting.ControlCompany AS SOURCE ON (TARGET.ID = SOURCE.ID)
WHEN NOT MATCHED BY TARGET AND GLEntityID not in ('5F878A3C-5F4C-4806-B786-5CAB52C98F0F')
--Update the “1” as needed based on value in Reporting.ControlIntegrationSource
THEN INSERT (ID, SourceID) VALUES (SOURCE.ID, 1);
This issue is logged as bug 3669431 is scheduled to be fixed in an upcoming release.
Comments
-
I just finished an implementation of legacy MR 2012 CU16 (not CU13) and did a migration from FRx 6.7 SP12. I made edits to the building blocks as needed but was getting the same error as Greg did when attempting to generate some reports. Funny, I could run a balance sheet but when trying to generation profit & loss reports I would get the error.
When I first read this post, I thought that understood that a legacy installation is an exception and the first table would be populated & the second table would be empty, as mine was, so I thought that this script would not work in my case.
Then after not finding any other answers, I came back to this post and read Chris's comments and how the script was changed. So I decided, what could it hurt? I made a backup of my database & ran the edited script. It worked! Boy am I happy about that.
If you have a legacy implementation, Chris's modified script works like a charm.
-
Just experienced this on CU15. We had MR all set as far as companies using the Legacy mode, but no reports setup yet. Then we ran the FRx data migration, and the reports were all showing in MR. But each report failed with that same "Sequence contains no elements" error.
Found this blog entry, thank you! But I had a case of 1 row in the ControlCompany table, and none in the ControlCompanyIntegration table. I had to change the query above to set GLEntity IN instead of NOT IN, to load the entry into the ControlCompanyIntegration table, and then the reports ran successfully.
Weird, but all seems to be okay now.
*This post is locked for comments