Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Fetch XML Reports not ...
Microsoft Dynamics CRM (Archived)

Fetch XML Reports not working

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi All,

We are currently working with CRM 2011 UR 13.

We are facing the issue with reports. We developed some reports using SSRS and used SQL Server filtered views to create reports, the reports working perfectly. However, whenever we create any report through report wizard, it creates the report successfully. However, it does not run and end up with rsprocessingaborted error.

No error messages generated in the vent viewer as well. Basically this is the issue with all Fetch XML reports. Are we missing any specific installation. Since, the other custom SSRS reports are working, so it proves that SRS Data connector is working correctly.

Any help on this is appreciated.

*This post is locked for comments

  • Suggested answer
    Pranesh M Juwale Profile Picture
    Pranesh M Juwale 1,196 on at
    RE: Fetch XML Reports not working

    Try adding the existing report changes with add new report feature as new report. Check this should be working

  • suresh maurya Profile Picture
    suresh maurya 630 on at
    RE: Fetch XML Reports not working

    For testing of FetchXML, you can test here online http://msxrmtools.com

  • SunilR Profile Picture
    SunilR 5 on at
    RE: Fetch XML Reports not working

    For us it was happening on CRM online 2011, the same error. However in our case the user (or the security role) did not have permission to one of the entities that the report was trying to pull.

  • Shahid H Shaikh Profile Picture
    Shahid H Shaikh 495 on at
    RE: Fetch XML Reports not working

    Hello Amit,

    Most of the times, the reason for issues with fetch based reports is Incorrect/Non Existent service principal names because The FetchXML query needs to be able to resolve to a HTTP SPN in order to fully communicate between the server. In a scenario where the Microsoft Dynamics CRM application pool is being run by a domain account the query will be looking for a HTTP SPN that does not exist by default.

    You can either verify the Service Principal for the service account running the reporting service by following the KB article support.microsoft.com/.../2590774 or you can use the workaround provided in the article, however the work around should be used in short term scenarios where there is a more extensive process in place to get SPNs approved.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fetch XML Reports not working

    the SETSPN - a HTTP/CRMservername domain\account where account = sql reporting service logged on  account name worked for me .  Bit surprised Microsoft doesn't just get 2 of its products to simply talk to each other.

  • Raksheet Koradia Profile Picture
    Raksheet Koradia 45 on at
    RE: Fetch XML Reports not working

    Hi Amit,

    Recently we have  came across a issue where reports created by report wizard may fail when executing.  While   browsing and seraching throught I came across a micorsoft KB article which says this could be issue with all the fetch Xml reports.  Check this link :

    support.microsoft.com/.../2590774

    We have tested the workaround mentioned in the link and it was working fine!!!

    Hope this will help you too!!!

  • Muhammad Adeel Javaid Profile Picture
    Muhammad Adeel Javaid 5,580 on at
    RE: Fetch XML Reports not working

    This could be of help for you:

    social.microsoft.com/.../1fe671ed-ec4e-4773-9029-29120f2872b4

  • Suggested answer
    Joe Woltering Profile Picture
    Joe Woltering 12,159 on at
    RE: Fetch XML Reports not working

    What is the exact rsProcessingAbort error you are getting? I resolved my issue by using the unique systemuserid (GUID) and OrgID (GUID) of the user you want to use as the username and password for the DataSource credentials-- You can get this by running the query against the CRM database:SELECT fullname, systemuserid, organizationid FROM FilteredSystemUser--and then making sure whichever user is actually viewing the report is added to the PrivUserGroup in AD.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fetch XML Reports not working

    Any answer for this...

  • Joe Woltering Profile Picture
    Joe Woltering 12,159 on at
    RE: Fetch XML Reports not working

    Hey guys, I'm having a very similar issue which I started a post about here as well https://community.dynamics.com/crm/f/117/p/105583/205715.aspx#205715

    Very frustrating as they make it seem so simple and the functionality that it could provide is invaluable.

    What I did:

    -Created Shared Data Source in VS 2008 using Windows Integrated Authentication and plugged in my CRM URL. This all worked fine and I was able to create a report using the FetchXML query I pulled from an Advanced Find.

    -Deployed the report and data source to my report server and tried to launch the report and got the rsprocessing error like the OP mentioned. Mine stated that the organization didn't exist. Did some research and changed the data source credentials to use the systeusrid and organizationid as pulled from the SQL table. Got a different error this time stating that the user did not have the privilege to run the report on behalf of the report user. Did some more digging and changed the Reporting Service account to the same user as the CRM service account. This still did not work but then I changed it back to NETWORK SERVICE and miraculously the report pulled up. Great.

    -Now, back to VS, created a new report trying to use the data source w/ the updated credentials and got an error in VS (ID3242) stating that 'ID3242: The security token could not be authenticated or authorized.'

    And that's where I'm at. Completely befuddled.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,514 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans