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
Yes Dan the company at least should have one transaction in order to build new report
Thanks
Babu
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
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
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.
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
Did you check for a blank budget record in GL00200?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156