Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

Management Reporter for SL 20111 - Data Mart integration Stuck

Posted on by Microsoft Employee

Hi,

We installed Management Reporter with CU14 for SL 2011. ERP validation was successful. Then we started the integration process to build Data Mart database. It looks like the integration is stuck and it's still running. We disabled the integration process and removed it twice. We are still having the issue.

I would appreciate your If could provide some information to resolve the issue.

Regards,

Veeresham

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter for SL 20111 - Data Mart integration Stuck

    Awesome! I saw it afterward I hit send. Had started typing earlier n left the window open so had not seen the updates.

    Happy you are okay.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter for SL 20111 - Data Mart integration Stuck

    Hi Dilcia,

    Yes, I ran the MR diagnostic script and updated the incorrect information.

    The issue was resolved after adding the following line to the MRServiceHost.settings.config file .

    <add key="IntegrationFiscalYearStart" value="2014" />

    Regards,

    Veeresham

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter for SL 20111 - Data Mart integration Stuck

    Hi Veeresham,

    Did you run the Management Reporter diagnostic script to see if there is a data issue preventing your Data Mart Integration?  It was a life saver for me on many occasions.

    Here is a link the script:

    https://support.microsoft.com/en-us/help/2931999/how-to-correct-data-errors-that-prevent-management-reporter-integration

    Hope this helps!

    Dilcia

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter for SL 20111 - Data Mart integration Stuck

    Thank you so much for your time and help!

    Since I am trying to create a Data Mart database for more than one company, I have added the following line to the MRServiceHost.settings.config file to limit the data.

    <add key="IntegrationFiscalYearStart" value="2014" />

    The issue was resolved.

    Regards,

    Veeresham

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Management Reporter for SL 20111 - Data Mart integration Stuck

    It's just a parameter that can be added that is not normally there.

    Run the script against the App database.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter for SL 20111 - Data Mart integration Stuck

    Hi Butch,

    Do have to run this SQL script against the SL Application or MR Data Mart database?

    Regards,

    Veeresham

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter for SL 20111 - Data Mart integration Stuck

    Is it a custom script or the script is missing in the database?

    Regards,

    Veeresham

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Management Reporter for SL 20111 - Data Mart integration Stuck

    The script I provided will create it. Change the "Select '2016'" line to the year for how far back you'd like to go. MR will use that information to limit the history it tries to load in the DDM.

    Five segments is something like 16 million combinations the DDM build has to go through.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter for SL 20111 - Data Mart integration Stuck

    Hi Butch,

    Thank you much for the information!

    We have five account segments and data since 1998.

    I did not find the stored procedure (Get_MR_FiscalYear_Start) in MR Data Mart database?

    Regards,

    Veeresham

  • Verified answer
    Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Management Reporter for SL 20111 - Data Mart integration Stuck

    How many segments do you have? If you have a lot of subaccount segments and a lot of previous years, you can create a lot of combinations to process.

    If you want to test on a limited dataset, try limiting the number of years you go backwards try running this sql script against your APP database:

    IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('dbo.Get_MR_FiscalYear_Start'))

    DROP Procedure dbo.Get_MR_FiscalYear_Start

    GO

    Create Proc Get_MR_FiscalYear_Start as

    Select '2016'

    GO

    Grant Execute on [Get_MR_FiscalYear_Start] to [E8F575915A2E4897A517779C0DD7CE]

    GO

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans