Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum

SSRS Fetch xml based report fails on execution after long records count

Posted on by 1,255

Hi there genious,

I'm running a report on D365 and after 70.000 records fetching the report crash and shows system error, its a report builded with leads taking data since 1.1.2016 until today, and its D365 Online, what the $@#= i should do to get that report runs more quick and support querying all records (i assume more than 100.000 and will grow)

Someone can gimme a couple of tips and stuffs to get that report running lovely?

Thanks in advance from any help!

Categories:
  • Vile Andreas Rantala Profile Picture
    Vile Andreas Rantala 1,255 on at
    RE: SSRS Fetch xml based report fails on execution after long records count

    Hi Judy, after something like 5 minutes, this is the error

    "An error has occurred.

    Try this action again. If the problem continues, check the Microsoft Dynamics 365 Community for solutions or contact your organization's Microsoft Dynamics 365 Administrator. Finally, you can contact Microsoft Support."

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS Fetch xml based report fails on execution after long records count

    Hi,

    Could you offer the detailed error messages here? It will help us to identify this issue.

    BR,

    Judy

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans