You’re offline. This is a read only version of the page.
Hello:
I installed Management Reporter 2012 (MR) with CU13 on a Terminal Server and began the data integration in the Configuration Console.
I actually did this, yesterday, on another server. But, I had to uninstall and start over on this other server, today. The first server has important 32-bit Access files, and the 64-bit Access engine that MR requires was disrupting the use of those files.
Anyway, I had no errors yesterday with the MR installation and configuration on that other server.
On this server, the data integration is going just fine. But, just after clicking the button to enable the integration, I got the error saying "Sequence contains no matching element".
Below is additional information from the Services log on this error.
How do I eliminate this error?
Thanks!
John
Sequence contains no matching element
--- Exception Dump ---
Caught Exception: [System.InvalidOperationException] Sequence contains no matching element
Stack trace:
at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate)
at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.GP.ExchangeRateProvider.CreateCurrencyPair(Company company, CurrencyTranslationType exchangeType, String currencyId, String exchangeTableId)
at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.GP.ExchangeRateProvider.ReadCurrencyPair(Company company, SqlDataReader reader, CurrencyTranslationType exchangeType)
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)
at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.GP.ExchangeRateProvider.GetPairs(Company company, String join, String where)
at System.Linq.Enumerable.<SelectManyIterator>d__14`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.GP.ExchangeRateProvider.SelectPerCurrencyPair(IEnumerable`1 exchangeRates, IEnumerable`1 currencyPairs)
at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.GP.ExchangeRateProvider.ReadObjects(DateTime modifiedDateTime)
at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.ReadObjectKeyList(String mapName, DbMap map, DateTime queryDate, Int32& count)
at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.ProcessRecordsImplementation(OperationType operationType)
*This post is locked for comments
I have the same question (0)
I opened an eSupport case with Microsoft. The MC40600 table of one of our company databases had a bogus Currency ID. The ID was only in this table and was not appearing in GP anywhere.
Once we got rid of this ID, we were able to deploy the Data Mart.
John
Share
Report
All responses (
Answers (
