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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Management Reporter fo...
Microsoft Dynamics SL (Archived)

Management Reporter for SL 20111 - Data Mart integration Stuck

(0) ShareShare
ReportReport
Posted on by Community Member

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

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Butch Adams Profile Picture
    Butch Adams 4,763 on at

    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

  • Community Member Profile Picture
    Community Member on at

    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

  • Butch Adams Profile Picture
    Butch Adams 4,763 on at

    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 on at

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

    Regards,

    Veeresham

  • Community Member Profile Picture
    Community Member on at

    Hi Butch,

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

    Regards,

    Veeresham

  • Butch Adams Profile Picture
    Butch Adams 4,763 on at

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

    Run the script against the App database.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

  • Community Member Profile Picture
    Community Member on at

    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

  • Community Member Profile Picture
    Community Member on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans