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, ... / Cannot update database...
Finance | Project Operations, Human Resources, ...
Answered

Cannot update database of Management Reporter

(0) ShareShare
ReportReport
Posted on by Hamza Bin Mushtaq 160

Hello everyone,

We had a server crash recently, today we have restored the VMs.

MR was non-functional so we decided to refresh the services.

We used MR versions: 2.12.16009.1, the oldest version in MR CU16 we could find in the partner portal.

After installation of new services, using the old MR Database we are getting the error the DATABASE UPGRADE FAILED. 

30/06/2021 11:49:54 AM - Current database schema version for ManagementReporter6: 2.12.16000; deployment package schema version: 2.12.16009; update required: True

 

We actually need the building blocks of OLD MR to get our old report templates. 

Is there any way we can achieve this?

Regards,

Hamza

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Hamza,

    Do you still have an old copy of your system e.g. in a different demo/test machine?

    If you have then you can export all of the MR building blocks (reports, rows, columns, trees) in a tdbx file that you can then import in the newly build MR in your live environment.

    Best regards,

    Ludwig

  • JoshP Profile Picture
    JoshP on at

    Hello Hamza,

    Thank you for the information. I see that you are correct the oldest CU16 version currently included in the "Previous Releases" document is the 16009 release. I believe this change was for brevity to keep the document readable. I have a few suggestions for you:

    1. Use the suggestion by Ludwig and restore your report designs using a .tdbx file to import into a newly created MR database

    2. Troubleshoot the reason for the failed database upgrade. This might be unnecessary if the end goal is to return back to the earlier MR version.

    3. Attempt to download an older CU16 release. Note that if you wish to try and obtain an older CU16 version, a new support case would be required in order to create a secure file transfer site and provide you with a direct one-time download link.

    Thanks!

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 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans