You’re offline. This is a read only version of the page.
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
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.
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
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:
Hope this helps!
Dilcia
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
It's just a parameter that can be added that is not normally there.
Run the script against the App database.
Hi Butch,
Do have to run this SQL script against the SL Application or MR Data Mart database?
Regards,
Veeresham
Is it a custom script or the script is missing in the database?
Regards,
Veeresham
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.
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (