Error in Management Reporter through D365 - The operation could not be completed due to a problem in the data provider framework

(0) Share

Report

Posted on by Rhushikesh R

758

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?

https://www.gpug.com/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=b961d15f-63fc-421b-9da1-54b4248c92f3

6888.Solution01.png

Thank you in advance.

I have the same question (0)

All responses (10)

Answers (4)

Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Harshal Nayak on at

Like (0)

Report

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

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report
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.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (1)

Report

Hi Rhushikesh,

You can try running these commands and check if you face any errors.

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Harshal Nayak on at

Like (1)

Report

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.

Was this reply helpful? Yes No