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 / Finance | Project Operations, Human Resources, ... / connecting to Manageme...
Finance | Project Operations, Human Resources, ...
Unanswered

connecting to Management Reporter application service takes long time when rebuilding data mart

(0) ShareShare
ReportReport
Posted on by Jason Yeung 6

Hi,

I'm trying to rebuild my Data Mart of Management Reporter. I have GP version 18.3. When I try to enable integration, it is trying to connect to the Management Reporter application service, but it is taking a long time to connect. I waited a couple of hours, but it is still trying connect. Below is how my configuration console looks like:

20211008_5F00_trying-to-connect.png

It seems stuck at this stage and it doesn't complain that I entered an incorrect password or it can't connect to the server. It just hangs. I was wondering is it normal for the console to take a few hours to connect? If it doesn't what issues would I have to look at so it would connect correctly? Thanks!

Jason

Categories:
Microsoft Dynamics GP
  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: connecting to Management Reporter application service takes long time when rebuilding data mart

    Hi Jason,

    The update of GP won't matter unless you are on an old build of MR.  If you have the 2.12.16xxx you'll be good to go.  If the timestamp on the 'last time an integration occurred' line does not change, you'll want to check the data mart integration logs.  MR is connected to the services.  When you install the services, they connect.  If they don't you would not have been able to install them.  If you see the two services listed and can stop/start them, the services are connected.   

  • Jason Yeung Profile Picture
    Jason Yeung 6 on at
    RE: connecting to Management Reporter application service takes long time when rebuilding data mart

    Hi Greg,

    Also we recently updated from GP 16 to GP 18.3. The data mart used to be for GP 16. I was wondering could the different version number cause the slowness as well?

    Jason

  • Jason Yeung Profile Picture
    Jason Yeung 6 on at
    RE: connecting to Management Reporter application service takes long time when rebuilding data mart

    Hi Greg,

    Thanks for your response. We left the program on over the weekend and when we checked yesterday, it was still trying to connect to the application service. The "last time an integration occurred" line did change did change, but we ended up cancelling the task and rolling back the server.

    I was wondering does it normally take days for the program to connect to the service? unfortunately we cancelled and rolled back before checking the logs. We could try again at a later date.

    Jason

  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: connecting to Management Reporter application service takes long time when rebuilding data mart

    You'll always see that line in the console, so it's nothing to worry about.  What you'll want to look at is the 'Last time an integration occurred' line.  The time stamp on that should change every few minutes.  You can also look at the Data Mart Integration log and see if there are any errors.  Periodically refresh the logs and check if new integrations are occurring.  

    You had an integration occur at 3:29 so the data mart is connected.  If there was an issue with the connection, you would have gotten an error when configuring it.  If you're able to click the Enable Integration button, the connect is there.  Depending on how many companies, how many years, how many transaction, etc., that you are integrating, the initial data mart load can take some time.  If you don't meet the system requirements for memory, that can add to the amount of time it takes too.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans