Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Error launching report...
Finance forum

Error launching report designer for Management reporter in D365 Finance & Operations sandbox environment

Posted on by 11,627

Hi All,

After upgrading database from AX 2012 R2 to D365, I am tyring to open report designer from GL -> Inquiries and reports -> Financial reports, but it shows me the following error:

"The operations could not be completed due to the error in data provider framework". I found the below blog post which mentioned the same error but in event logs I can see different errors:

https://community.dynamics.com/gp/b/azurecurve/archive/2017/02/10/management-reporter-error-the-operation-could-not-be-completed-due-to-a-problem-in-the-data-provider-framework

In event logs on UAT machine, following error messages are showing:

The operation could not be completed due to a problem in the data provider framework.
Component: Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService
User: user@tenant.onmicrosoft.com

Machine: UAT machine name

The collection cannot be empty. At least one object must be present in the collection. \r\nMissing object type: GLScenario
Component: Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService
User: user@tenant.onmicrosoft.com
Machine: UAT machine name

On BI machine, I can see plenty of errors in event viewer related to missing objects. Some of them are shown below:

{"Class":16,"Number":1088,"State":13,"Message":"Cannot find the object \"BUDGETCYCLE\" because it does not exist or you do not have permissions.","ErrorCode":-2146232060,"Procedure":"","LineNumber":9,"Errors":[{"Class":16,"Number":1088,"State":13,"Message":"Cannot find the object \"BUDGETCYCLE\" because it does not exist or you do not have permissions.","Procedure":"","LineNumber":9,"Source":".Net SqlClient Data Provider"}],"ConnectionId":"b74b-4de1cc8653e9","Source":".Net SqlClient Data Provider"}
Machine: Machine1

{"Class":16,"Number":1088,"State":13,"Message":"Cannot find the object \"DIMENSIONATTRIBUTE\" because it does not exist or you do not have permissions.","ErrorCode":-2146232060,"Procedure":"","LineNumber":9,"Errors":[{"Class":16,"Number":1088,"State":13,"Message":"Cannot find the object \"DIMENSIONATTRIBUTE\" because it does not exist or you do not have permissions.","Procedure":"","LineNumber":9,"Source":".Net SqlClient Data Provider"}],"ConnectionId":"4de1cc8653e9","Source":".Net SqlClient Data Provider"}
Machine: Machine1

{"Class":16,"Number":1088,"State":13,"Message":"Cannot find the object \"DIMENSIONATTRIBUTEVALUECOMBINATION\" because it does not exist or you do not have permissions.","ErrorCode":-2146232060,"Procedure":"","LineNumber":9,"Errors":[{"Class":16,"Number":1088,"State":13,"Message":"Cannot find the object \"DIMENSIONATTRIBUTEVALUECOMBINATION\" because it does not exist or you do not have permissions.","Procedure":"","LineNumber":9,"Source":".Net SqlClient Data Provider"}],"ConnectionId":"49b3-9d54-1686df130f94","Source":".Net SqlClient Data Provider"}
Machine: Machine1

Does anyone have any clue what these errors relates to and how to resolve this issue? I am looking for urgent resolution as it is blocking us moving forward

Thanks,

Baber.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Error launching report designer for Management reporter in D365 Finance & Operations sandbox environment

    Hi Baber,

    You can try to reset the MR data mart as explained in the documentation:

    docs.microsoft.com/.../reset-financial-reporting-datamart-after-restore

    blogs.msdn.microsoft.com/.../resetting-the-management-reporter-data-mart-for-dynamics-365-for-operations

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans