You’re offline. This is a read only version of the page.
Announcements
752
Hi Everyone,
Recently we have deployed one Cloud hosted environment and moved AxDB database from Microsoft Managed VM to newly cloud hosted VM.
In older VM, we were able run and create the MR reports (Financial reports) without any error.
But on new VM, we are facing error as-
"The operation could not be completed due to a problem in the data provider framework".
And when I click on "Ok", another error pops up as "Value cannot be null. Parameter name: dimensions".
I went through event viewer log, and below are the screenshots of same. Please suggest what solution need to be applied.
Also do I need to copy "FinancialReportingDb" database from Old VM? Will this process of copying database resolve my issue?
If not what things I need to try. Please help.
While searching for issue, I found one more link in which solution has been suggested as shown in below screenshot. Could below mentioned reason be the cause of error which I am facing?
Thank you in advance.
Hello Rhushikesh,
Can you check event log for the error. you can check under application and services logs as well . This will give the error and next steps to proceed.
Hi Gunjan and Ludwig,
Thank you for your replies.
I have reset Data Mart, But now facing below new error,
"The connection to the Financial Reporting DDM database failed. The server name and user credentials are required."
What could be the root cause for same?
Hello Rhushikesh,
If you reset the datamart then all 'old' data that reside in the data mart are wiped out and created again from scratch.
There should not be a negative effect.
Best regards,
Ludwig
Hi Gunjan,
Sorry for the late reply. I would like to confirm one thing with you before I proceed to run reset data Mart command on new environment.
On friday, I ran command on old environment successfully.
But all data being displayed in Financial reports in D365 has been wiped out after running command.
This does not happen if we reset data mart from MR tool, correct?
So is there any way to reset the data mart without wiping out the old history in D365?
Also would you please confirm, whether wiping out the data in D365 will cause any negative impact?
I believe, in D365 it just maintains history of reports, correct? So ideally by resetting data mart will not cause any negative impacts in D365 data. correct?
Hi Rhushikesh,
You can try running these commands and check if you face any errors.
Import-Module .\Server\MRDeploy\MRDeploy.psd1 Reset-DatamartIntegration -Reason OTHER -ReasonDetail "" -SkipMRTableReset
Hi Gunjan,
If I stop the required services and navigate to below path, and run script as above, will it work?
I have never performed these steps before, hence asking for your confirmation. Please help.
Hello Rhushikesh,
since you have copied the DB you are getting this issue.
I would suggest you to perform the DataMart reset manually using the SQL scripts mentioned in this doc as you are unable to open the designer.
Reset the Financial reporting data mart - Finance & Operations | Dynamics 365 | Microsoft Docs
Hope this helps
Regards,
Harshal
You can try doing it using PowerShell. It is mentioned in the same page or you can use this link
Reset the Financial reporting data mart - Finance & Operations | Dynamics 365 | Microsoft Docs
Hi Gunjan,
The tool doesn't remain open. It gets closed when I click on Ok of error pop up. For resetting data mart, we have option in MR tool itself. Is there any other way to do the same?
Hi Rhushikesh,
Since you copied over data from another environment, did you reset the data mart already? You can check for the steps here on how you can do the same. Please do check the section "Clear users and companies" here as you might need to do the same.
#1
André Arnaud de Cal...
294,161
Super User 2025 Season 1
#2
Martin Dráb
232,942
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
