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 / Finance | Project Operations, Human Resources, ... / GP and management repo...
Finance | Project Operations, Human Resources, ...
Suggested Answer

GP and management reporter upgade

(0) ShareShare
ReportReport
Posted on by CSS 267

We are upgrading from GP 2015 to GP 2018, moving to new servers SQL 2019 on Windows Server 2019 and GP 2018 on Server 2016.

We have tested the GP upgrade and server migration and that seems to be working.

The problem is moving Management Reporter. The current MR version is 2012 CU12, which is not compatible with SQL 2019.

When we try to restore the CU12 MR database to a new MR CU16 install we get database version errors.

Can we avoid upgrading the existing MR CU12 to CU16 on SQL2012. Is there a MR ver that we can go to with GP2018 and SQL2019 that would allow us to move direct from CU12.

 

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Very interested in this - we have the same problem.  We are trying to install CU16 on SQL2019 and we are getting errors.  Any other suggestions are welcome.

  • CSS Profile Picture
    CSS 267 on at

    we have no problems installing MR CU16 with SQL 2019. Our issue is moving the existing CU12 database to the new install.

  • Darian Profile Picture
    Darian on at

    The latest installer of CU16 will work for SQL2019, so make sure the latest installer is downloaded from the MR download website.

    mbs.microsoft.com/.../MROverview

    As far as moving servers this should be a normal server move as documented in this link:

    community.dynamics.com/.../how-to-move-your-management-reporter-2012-database-to-a-new-server

    The only difference of this, is when you point to the existing MR database, it will notice that it is an older version of the database.  The installer will prompt you to update the database.  Providing there are not underlying issues, it should update the MR database without issue.

    If there is an issue with the upgrade itself,  I would suggest logging a support case.  There may need to be some cleanup of old reports in the MR database or other issues causing the upgrade to fail.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    I agree with Darian.. this should work, as I've already done it a few times.

    Bill, that seems rather strange to me. Are you sure you installed CU16.0009.1 ? I had no issues so far with this version..  The never ending problem with migrating MR from one server to another is when you don't have the credentials of the original installer of MR and need to get yourself (or the service account) added to the MR security prior to the installation, otherwise MR will simply not let you connect to it, even after it was upgraded.

    Beat

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    So Beat I was planning on doing a 'fresh' install of MR CU16 on the new machine, then use the building block import to move the files over.  Is that not a good solution?  You are correct, we do not have the orginal MR creds and no one has any idea - so not trying to move the database at all.

    I will ensure the CU16 version and update later.

    Thanks.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Bill,

    That would be one way of doing it, that always work, though with the cons that you lose all the security and report history.. sometimes it's a good for a bad, as you start with a clean slate.

    If you want to know how to 'fix' the security in the MR database when moving from an old system where you don't have proper credentials, I can show you some tricks by using SQL scripts. That allowed me a few times to move MR between servers without losing all the settings.

    Of course the encryption keys have to be reset anyway, but that's the easy part of it.

    PS: this is the official way of moving from one server to a new one: https://community.dynamics.com/gp/b/dynamicsgp/posts/how-to-move-your-management-reporter-2012-database-to-a-new-server

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Already working on the link provided.  I will update on where I get to later this afternoon - thanks.

    *****

    In the meantime, CSS, did you you get your situation resolved - seems that this thread took a turn from your orginal question - sorry for hijacking - hope we can contribute to a solution.

  • CSS Profile Picture
    CSS 267 on at

    Our new plan is to upgrade the MR to CU16 prior to moving it. We want to test the upgrade in a GP2015 MR 2012 CU12 test  environment which has been setup on new servers. After using the  Move MR doc we find that the old SQL server name remains in the MR database ControlCompany records table and needs to be changed. did we miss a step that would have updated this after restoring the moved database?

  • Darian Profile Picture
    Darian on at

    This table houses the Legacy adapter company.  Are you using the Legacy adapter?  If so, you will need to go into the Configuration Console, Go to the Legacy integration, Click the Import button, it will give a list of your companies, then click the Import Companies button in bottom right corner.  It will prompt a message to change company connection information, click yes to this and it will update that connection information.

    **If you are using Data Mart, this is mostly like old information that is in the MR database, and is not used for the data mart integration.

  • CSS Profile Picture
    CSS 267 on at

    we are not using the legacy data mart. We got the MR 2012 CU12 running in the test environment this morning. We installed CU16 without errors when we started the configuration console the task list said we needed to upgrade the database which was expected we entered the SQL credentials and the database upgrade started. It has been running for 2+hours, which does not seem correct. There are 11 companies and the old MRDB was approx 12GB

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans