web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter in...
Microsoft Dynamics GP (Archived)

Management Reporter integration error

(0) ShareShare
ReportReport
Posted on by Dave Bosserman 980

After installing CU6 for Management Reporter, I cannot get the datamart integration to work. 

In the Data Mart Integration log, the error message is "[CurrencyPairProvider to Exchange Rate Type] has encountered an error. Processing will be aborted. Error text: Sequence contains no matching element"

The log immediately below it has: "[ExchangeRateProvider to Exchange Rate] has encountered an error. Processing will be aborted. Error text: Sequence contains no matching element"

Any help or suggestions appreciated...

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    I did a quick search but did not find where this issue has been reported to us before. My initial thought is that MR is seeing a currency maybe in a transaction that it cannot match with a valid currency for that company. I would recommend checking each currency that is set up to ensure they all have valid ISO codes. I would also ensure each company had a valid functional currency set. Finally, you will need to search your data for currency codes that do not match what you have set up. It may be best to log a support case if you are unable to locate the problem as this will likely take some digging.

  • mwood1177 Profile Picture
    mwood1177 95 on at

    I am also getting these same errors after applying CU6.  My integration will complete but it bogs down all the CPU on the server.  Did not have any issues before updating to CU6.  Any suggestions to what may be causing this?

  • DIANA ERICKSON Profile Picture
    DIANA ERICKSON 10 on at

    We are also getting the same errors when trying to install CU6.  Has anyone found a solution to these errors?

    Thanks.

  • Community Member Profile Picture
    Community Member on at

    We are having this issue as well after applying CU6, anyone found a solution yet?

  • mwood1177 Profile Picture
    mwood1177 95 on at

    I have not found a solution yet.  I am most likely going to open a case with MS in the next week or so.  I will report back if I find anything.

  • DIANA ERICKSON Profile Picture
    DIANA ERICKSON 10 on at

    Not entirely sure if below works or not because after implementing this change we had further complications with a bad company database.

    1. The issue could be related to SQL change tracking on for multicurrency.

    2. Start the Configuration Console, click on the DDM Integration, under "ERP Integrations".

       a. Click on "Reconfigure change tracking" and enter the "sa" username and password.

       b.Click Ok.

    3. You can also manually do this by right-clicking the MC40600 and MC00100 and selecting Properties. Then click Change Tracking and set that to True.

    4. Stop and start the Application/Process services.

    HTH

  • Richard Rook Profile Picture
    Richard Rook 90 on at

    I have this issue as well on a CU7 install.  No luck using the suggestion above.

  • mwood1177 Profile Picture
    mwood1177 95 on at

    I ended up opening a case with MS.  There was a query in CU 6 that was causing my problems.  Upgrading to CU7 and recreating the data mart fixed my issues.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    This post indicates there may be a solution, which does not require the data mart to be rebuilt.

    community.dynamics.com/.../105619

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans