Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Report not working sin...
Microsoft Dynamics CRM (Archived)

Report not working since upgrade

(0) ShareShare
ReportReport
Posted on by Eturyu 155

Hi, I created report that is used everyday via the report wizard. We have just updated our test environment with the latest version. Everything went along smoothly, the only issue is after the update, I can no longer run this particular report.

I have the live environment still running it normally every day, but the newly updated test environment now tells there is a fetch XML error, and will no longer run this one particular report. Oddly doesn't seem to affect any other reports.

Please note, no coding was used to create this report, just the OOB report wizard.

*This post is locked for comments

  • Suggested answer
    Eturyu Profile Picture
    Eturyu 155 on at
    RE: Report not working since upgrade

    Hi, Workaround sorted it out, but never found out what the issue was.

    When (above) i mentioned i had tried recreating the report, and no change, that was via the report wizard using the existing report as a starting point but not overwriting.

    When i re-created the report from scratch, purposely not using the report wizard, and not using the failing report as template, the completely new version of the report worked fine from then on.

    Hope it helps.

  • roman_gryphon Profile Picture
    roman_gryphon 80 on at
    RE: Report not working since upgrade

    Hello,

    did you every figure this out?  

    We recently upgraded and we are experiencing the exact same error.  

    When we reviewed the event logs, there were no discernable errors specific to this issue.  The logs were clean.

    The platform traces reveal nothing as they were clean as well.

    If you have resolved this, please let us know.

    Thanks,

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 21,009 Super User 2024 Season 2 on at
    RE: Report not working since upgrade

    Hi Eturyu,

    One possibility is that you are missing security privileges for entities used in the FetchXML query of the report, but this does not seem likely since the problem only started occurring after the test environment update.

    I recommend contacting Microsoft Support about this issue.

  • Eturyu Profile Picture
    Eturyu 155 on at
    RE: Report not working since upgrade

    Hello,

    Thanks for the response, it is a generic message though..

    I'm not sure how to achieve the first two options you laid out, but I tried re-creating the report via the report wizard, and no change.

    6215.REPORTERROR.jpg 

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 21,009 Super User 2024 Season 2 on at
    RE: Report not working since upgrade

    Hi Eturyu,

    Is the FetchXML error generic or does it have a log attached?

    You have a few options:

    • Export the report and import it back into CRM.
    • Export the report, edit the report in SQL Server Reporting Services (SSRS), and import the report back into CRM.
    • Recreate the report.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans