Skip to main content

Notifications

Microsoft Dynamics GP forum
Under review by Community Managers

Under review

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

MR 2012 Services

Posted on by 15

When my accountant runs a report, nothing happens and the Report Queue Status message says "Unable to create the related report".  After I restart the two MR services, the report runs. 

After 15 minutes and every 15 minutes thereafter, I get this error:

Log Name:      Application
Source:        Management Reporter 2012 Services
Date:          4/18/2022 10:45:07 AM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      xxxxxx.xxx.com
Description:
Microsoft.Dynamics.Performance.Reporting.DataProvider.Service.DirectLinkException: The connection to the Microsoft Dynamics GP database failed. Contact your system administrator. ---> Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLConnectionException: The connection to the Microsoft Dynamics GP database failed. Contact your system administrator.
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.DataConnector.CreateConnectionUsingGPCredentials(String dataSourceName, String databaseName, String userName, String password)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.DataConnector.CreateConnection()
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.DataConnector.OpenConnection()
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.DataConnector.EnsureDatabaseAccess(String dynamicsDatabase, String entityDatabase)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.GLProvider.HandleConnect(EntitySettingCollection settings, CredentialCollection credentials)
   at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.Connect(EntitySettingCollection settings, CredentialCollection credentials)
   at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemConnection.Open()
   at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystem.CreateConnection(SourceSystem system, EntitySettingCollection settings, CredentialCollection credentials)
   at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystem.Connect(EntitySettingCollection settings, CredentialCollection credentials)
   at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(Guid providerTypeId, EntitySettingCollection settings, StoredCredential credential)

Any help would be appreciated

Categories:

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans