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:
Management Reporter
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):
Show/hide error message
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)
Component: Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService
User: DOMAIN\PerfectImage
The second error message, however, got down to detail and showed exactly what the error was:
Show/hide error message
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.GLCurrencyCollection.ValidateItems()
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)
Component: Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService
User: DOMAIN\PerfectImage
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.
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.