Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
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!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans