15When my account runs a report, it fails to run and the Queue Status message is "Unable to create the related report". After I restart the two services, the reports run successfully.
After restarting, after 15 minutes, 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 help would be appreciated.
