Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error Management Repor...
Microsoft Dynamics GP (Archived)

Error Management Reporter - Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled

(0) ShareShare
ReportReport
Posted on by Gilberto Ojeda 257

hi,

i have a problem with CU7 management reporter , i update the program and show this message in the report generation.

"Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled."

anybody has seen this message? Please Help thanks,

i tried:

1.- Restart services.

2.- Verify security

3.- Check building blocks

4.- Check row, columns, report definition 

5.- Create a new report definition, row, column and building block 

in the log show this:

Microsoft.Dynamics.Performance.Reporting.DataProvider.Service.DirectLinkException: The operation could not be completed because the specified credentials are not valid. ---> Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLConnectionAuthorizationException: The user ID and password are not a valid login.    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.SourceSystemConnection.Open()    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)    --- End of inner exception stack trace ---

Server stack trace:    at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(Guid providerTypeId, EntitySettingCollection settings, StoredCredential credential)    at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(Guid entityId, StoredCredential credential)    at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(DataServiceConnection connection)    at System.Lazy`1.CreateValue()

Exception rethrown at [0]:    at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(Guid providerTypeId, EntitySettingCollection settings, StoredCredential credential)    at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(Guid entityId, StoredCredential credential)    at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(DataServiceConnection connection)    at System.Lazy`1.CreateValue()    at System.Lazy`1.LazyInitValue()    at Microsoft.Dynamics.Performance.DataProvider.Core.AutoExpiringDisposableCache`2.AutoExpiringDisposableCacheItem`2.GetItem(Boolean acquireOwnership)    at Microsoft.Dynamics.Performance.DataProvider.Core.AutoExpiringDisposableCache`2.GetOrAdd(TKey key, Func`2 createCacheItemValue, Boolean acquireOwnership)    at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.UsingConnection[TResult](DataServiceConnection connection, Func`2 executor)    at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.<>c__DisplayClassb.<Connect>b__9()    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  User: ALIBAL\Administrator

---------------------------------------------------------------------------------------------------------------------------------------------------------------

System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault]: Invalid URI: The hostname could not be parsed. (Fault Detail is equal to Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault).

*This post is locked for comments

  • pciskowski Profile Picture
    pciskowski 5 on at
    RE: Error Management Reporter - Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled

    Server was out of hard drive space in my case.

  • Community Member Profile Picture
    Community Member on at
    RE: Error Management Reporter - Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled

    Thank you this worked for me

  • Tanya Henderson Profile Picture
    Tanya Henderson on at
    RE: Error Management Reporter - Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled

    Restarting the services fixed the issue immediately for me as well.

  • jpugh@fchc Profile Picture
    jpugh@fchc 5 on at
    RE: Error Management Reporter - Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled

    I deleted the user's account within MR and re-added it. This solved the problem for us.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Error Management Reporter - Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled

    Have you tried rebuilding the datamart integration with GP?  I have found that when everything else fails, doing that has resolved the issue.  Here is a link with a good explanation of how to do this:

    community.dynamics.com/.../missing-values-rebuild-your-data-mart-in-management-reporter-2012.aspx

     

    Amy Bessen

    Consultant

    Arctic Information Technology

  • Gilberto Ojeda Profile Picture
    Gilberto Ojeda 257 on at
    RE: Error Management Reporter - Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled

    Hi, The periods are open.

    I have done the following tests:

    1.- Restart Services.

    2.- Check security.

    3.- Check Building Blocks.

    4.- Create new Reports.

    5.- Create new Biulding Blocks.

    Greetings,

    GO

  • Gilberto Ojeda Profile Picture
    Gilberto Ojeda 257 on at
    RE: Error Management Reporter - Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled

    Hello, management reporter is installed in aplication server, with this specifications Windows Server 2008R2; Microsoft Dynamics GP 2010; SQL Server 2008R2. I'm just running reports.

    I install over the old version CU7 to perform the upgrade. during the process there were no errors of any kind, only this error when I want to run the report appears.

  • Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Error Management Reporter - Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled

    I've seen this message before, but in my case restarting the services fixed the issue.

    The error you're seeing is referring to invalid credentials; I've seen an error with this in when there were no open periods for Open Year being reported on.Do you have at least one period open?

  • Christopher Wan Profile Picture
    Christopher Wan 155 on at
    RE: Error Management Reporter - Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled

    Can any other users run reports? Are you running on a Terminal Server?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans