Management Reporter Error: “The operation could not be completed due to a problem in the data provider framework”

Microsoft Dynamics GPA 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

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 (Financial >> Setup >> Multicurrency), the error message will stop being produced.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you'd like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.

Your Name (required):
Your Email (required):
Enquiry message:

What should we write about next?

Your Name (required) -
Your Email (required) -

Leave a Reply

Your email address will not be published. Required fields are marked *