web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Custom reports won'...
Microsoft Dynamics CRM (Archived)

Custom reports won't run

(0) ShareShare
ReportReport
Posted on by J Matlon 1,465

We are running CRM 2016 with the latest updates.

All of our out-of-box reports, such as the Account Overview or Sales History work just fine. But any custom report we create fails to run. They all throw an error with "Invalid User Authentication. The user authentication passed to the platform is not valid."

I've double-checked the permissions on SSRS, and our CRM service account appears to have the correct permissions set, and they are also a member of the PrivReportingGroup and SQLAccessGroup AD groups.

Does anyone have any ideas for why all the standard CRM reports would function just fine, but all custom reports would fail?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello Joe,

    To discover why that happens you have 2 places to check.

    1. CRM Log - support.microsoft.com/.../how-to-enable-tracing-in-microsoft-dynamics-crm

    2. Reporting Services log - technet.microsoft.com/.../cc512029.aspx

  • ashlega Profile Picture
    ashlega 34,477 on at

    Wondering if you are using fetchxml reports or SQL reports for those custom reports?

  • J Matlon Profile Picture
    J Matlon 1,465 on at

    If I try to create any basic report using the Report Wizard within CRM, I get our error.

    Even if I'm just trying to display all of our Account Names. (single entity, single column)

    Andrii,

    I'm looking through our logs, but nothing is jumping out yet. Thanks for the links.

  • J Matlon Profile Picture
    J Matlon 1,465 on at

    So the error thrown within CRM is:

    System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #C6123F5B: System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Microsoft.Crm.CrmException: An error occurred during report rendering. ReportId:{389D7185-2E3B-E711-80D0-005056944EDA} ---> Microsoft.Reporting.WebForms.ReportServerException: An error has occurred during report processing. (rsProcessingAborted) ---> Microsoft.Reporting.WebForms.ReportServerException: Query execution failed for dataset 'DSMain'. (rsErrorExecutingCommand) ---> ..

    Everything I've read so far on the "Query execution failed for dataset 'DSMain', mentions a problem with either the filter or the result set returning data from other entities. But I can reproduce with no filter, and a single entity/field.

    I've been able to reproduce this same error by creating another new CRM organization within deployment manager, adding a single account record, and trying to create a report through the report wizard to return that record.

    Any other ideas out there?

  • Verified answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Have you checked Reporting Services log?

  • Verified answer
    Chadi Tannous Profile Picture
    Chadi Tannous 1,039 on at

    are you using crm on premise? if yes this might be a security issue, you have to setup the SPN records on the servers

  • Suggested answer
    MNarmeen Profile Picture
    MNarmeen 1,848 on at

    Check your roles and permissions in settings

    4073.Capture.PNG

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    First check your SSRS Log to know the exact error.Refer this:

    www.inogic.com/.../rsprocessingaborted-error-for-dynamics-crm-custom-reports

    crmbusiness.wordpress.com/.../crm-2011-custom-reports-not-working

  • J Matlon Profile Picture
    J Matlon 1,465 on at

    Thanks everyone for their suggestions!

    It turned out to be a combination of things. I didn't have SPN's set for my CRM server, and I also needed to add a firewall rule to allow inbound TCP traffic on port 808.

    The goldmine of a reference I found: www.cobalt.net/4-steps-that-will-help-you-conquer-the-rsprocessingaborted-error

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans