15We are having an issue with our Management Reporter 2012. When our accountant tries to run a report it will sit for a while and then error out. The queue message was "Unable to create the related report"
If I restart the MR services, the report works.
After restarting the services, I get this error every 15 minutes:
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 thoughts would be appreciated.
