Management Reporter Error: “The operation could not be completed due to a problem in the data provider framework”
February 10th, 2017 by Ian Grieve
A bit like Integration Manager, Management Reporter often presents highly generic meaningless error messages to users. The error message below was provided to me by a client a while ago (but I have just stumbled across the screenshots again), which I was then able to reproduce just be ruunning the report:
The operation could not be completed due to a problem in the data provider framework.
The key with Management Reporter errors is to look in the Windows Event Viewer for the actual detail. There were two error messages recorded, the first of which was just the same as the message presented to the user (and shown above):
Microsoft.Dynamics.Performance.Reporting.Common.ReportingProviderFrameworkException: The operation could not be completed due to a problem in the data provider framework.
at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.SubmitRequestErrorHandler[T](Func`1 requestSubmission)
at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor)
at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor)
The second error message, however, got down to detail and showed exactly what the error was:
Microsoft.Dynamics.Performance.DataProvider.Core.ValidationException: One functional currency code must be defined. Correct the data to define a functional currency code for the provider.
at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLSystemProvider.HandleRequest(GLCurrencyRequest request)
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemRequest.Handle[TRequest](SourceSystemProvider provider, TRequest request)
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.SubmitRequest(SourceSystemRequest request)
had a database which was created and backed up; the databases then overwritten from live, new companies created and backups restored over.
needed to grant access to currency in Multicurrency Access
The client had just had some new companies created and had one person working with me to configure them while someone else was updating the reporting packs. They were a bit ahead of the company configuration and tried to generate the reports before we had done initial configuration meaning a Functional Currency had not been defined for all of the new companies.
If you see this error and are not sure of which company does not have a Functional Currency set, I have previously posted a script which returns the Functional Currency for each company connected to the system database.
Once you set a Functional Currency in the Multicurrency Setup window ( ), the error message will stop being produced.
Read original post Management Reporter Error: "The operation could not be completed due to a problem in the data provider framework" at azurecurve|Ramblings of a Dynamics GP Consultant