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:
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156