Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

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

Posted on by 745

I created two new companies.  If I try to create a new column or use the report wizard I get the error if I am in one of the new companies.  In the existing companies it works fine.  I have checked and both companies have functional currencies.  The functional currency has an ISO code.  The other currencies did not but I did add them.  No budgets in either company.  I posted a transaction in one company.  I looked at my fiscal periods in both GP and SQL and they look correct.  I only have two fiscal years for my new companies.  The other companies have 8 or more years.  The event viewer logs don't seem to help but one of the messages does mention a missing object of GLScenario.  Not sure what that is  We are on version:  2.1.7.4033.43.  here are the messages:

Log Name:      Application
Source:        Management Reporter Report Designer
Date:          12/3/2014 9:12:35 AM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A

System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault]: The operation could not be completed due to a problem in the data provider framework. (Fault Detail is equal to Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Management Reporter Report Designer" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-12-03T14:12:35.000000000Z" />
    <EventRecordID>136933</EventRecordID>
    <Channel>Application</Channel>
   
    <Security />
  </System>
  <EventData>
    <Data>System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault]: The operation could not be completed due to a problem in the data provider framework. (Fault Detail is equal to Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault).</Data>
  </EventData>
</Event>

Error Message 2:

Log Name:      Application
Source:        Management Reporter 2012 Services
Date:          12/3/2014 9:12:35 AM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A

Description:
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

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Management Reporter 2012 Services" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-12-03T14:12:35.000000000Z" />
    <EventRecordID>136932</EventRecordID>
    <Channel>Application</Channel>
  
    <Security />
  </System>
  <EventData>
    <Data>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

  </EventData>
</Event>

Error Message 3:

Log Name:      Application
Source:        Management Reporter 2012 Services
Date:          12/3/2014 9:12:35 AM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A

Description:
Microsoft.Dynamics.Performance.DataProvider.Core.ValidationException: The collection cannot be empty.  At least one object must be present in the collection. \r\nMissing object type: GLScenario
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLScenarioCollection.ValidateItems()
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLSystemProvider.HandleRequest(GLScenarioRequest 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

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Management Reporter 2012 Services" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-12-03T14:12:35.000000000Z" />
    <EventRecordID>136931</EventRecordID>
    <Channel>Application</Channel>
    
    <Security />
  </System>
  <EventData>
    <Data>Microsoft.Dynamics.Performance.DataProvider.Core.ValidationException: The collection cannot be empty.  At least one object must be present in the collection. \r\nMissing object type: GLScenario
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLScenarioCollection.ValidateItems()
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLSystemProvider.HandleRequest(GLScenarioRequest 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
 
  </EventData>
</Event>

 

*This post is locked for comments

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

    Yes Dan the company at least should have one transaction in order to build new report

    Thanks

    Babu

  • Dan Bigelow Profile Picture
    Dan Bigelow 745 on at
    RE: Management Reporter Error: The operation could not be completed due to a problem in the data provider framework

    I did have a trx but in my other company I do not.  So I rebuilt the data mart and the one company which has the trx works and the other does not. So I am thinking once I post something into the company it will work

  • Dan Bigelow Profile Picture
    Dan Bigelow 745 on at
    RE: Management Reporter Error: The operation could not be completed due to a problem in the data provider framework

    Yes - not the issue.  I rebuilt the data mart and it works.  Also you must have a posted trx as well but thank you for the response

  • Dan Bigelow Profile Picture
    Dan Bigelow 745 on at
    RE: Management Reporter Error: The operation could not be completed due to a problem in the data provider framework

    It did but basically I rebuilt the datamart and it works now.  Just a heads up you have to make sure you have a posted trx as well - from another user.

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Management Reporter Error: The operation could not be completed due to a problem in the data provider framework

    follow community.dynamics.com/.../110605.aspx

  • Verified answer
    RE: Management Reporter Error: The operation could not be completed due to a problem in the data provider framework

    Hi Dan,

    This is due to set up new company database doesn't have any transaction so please post a journal for 0.01 cents then close MR and try again.  It should work

    Thanks,

    Babu

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter Error: The operation could not be completed due to a problem in the data provider framework

    Did you check for a blank budget record in GL00200?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans