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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: User Was Not Found error - rsProcessingAborted

(0) ShareShare
ReportReport
Posted on by

I am getting rsProcessingAborted error on CRM report that we have created using report wizard. when gone thorugh  log on reporting service I found below

any one I have checked Excesution Account settings on Sql reporting service configuration and its not checked, SrsdataConnector installed , I have restarted reporting service too. no luck. 

Note we have sql database on different server to CRM app server

wcfruntime!ReportServer_0-1!106c!07/26/2016-13:56:07:: i INFO: Entering ExeuteCommand - Command = Render
library!ReportServer_0-1!106c!07/26/2016-13:56:08:: i INFO: RenderForNewSession('/orgname_MSCRM/CustomReports/{74091723-CC4C-E611-80C8-005056BE003C}')
CLR version v4.0.30319 loaded. processing!ReportServer_0-1!106c!07/26/2016-13:56:09:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'CRM'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
Microsoft.Crm.CrmConfigObjectNotFoundException: User Was Not Found ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: User Was Not Found
at Microsoft.Crm.ServerLocatorService.GetCrmUserId(Guid organizationId, String authenticationInfo)
at Microsoft.Crm.Reporting.DataExtension.Server.Fetch.FetchDataExtensionConnection.Initialize(SecurityIdentifier user)
at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.<>c__DisplayClass1.<Open>b__0()
at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
at Microsoft.Crm.ServerLocatorService.GetCrmUserId(Guid organizationId, String authenticationInfo)
at Microsoft.Crm.Reporting.DataExtension.Server.Fetch.FetchDataExtensionConnection.Initialize(SecurityIdentifier user)
at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.<>c__DisplayClass1.<Open>b__0()
at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
--- End of inner exception stack trace ---
at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
at Microsoft.Crm.Reporting.DataExtensionShim.Common.ICrmDbConnectionExtension.Open(String userSid)
at Microsoft.Crm.Reporting.DataExtensionShim.Common.SrsExtConnectionBase.Open()
at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenConnection(IProcessingDataSource dataSourceObj, DataSourceInfo dataSourceInfo, IDbConnection conn)
--- End of inner exception stack trace ---;

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    If I run the report from reporting service http://sqlreportserver/reports then navigate to organization custom reports

    then it shows below error

    An error has occurred during report processing. (rsProcessingAborted)

    Query execution failed for dataset 'DSMain'. (rsErrorExecutingCommand)

    Microsoft.Crm.CrmException: An unexpected error occurred. System.ServiceModel.Security.SecurityNegotiationException: A call to SSPI failed, see inner exception. System.Security.Authentication.AuthenticationException: A call to SSPI failed, see inner exception. System.ComponentModel.Win32Exception: The target principal name is incorrect

    An unexpected error occurred.

    A call to SSPI failed, see inner exception.

    A call to SSPI failed, see inner exception.

    The target principal name is incorrect

  • Simaranjit Profile Picture
    on at

    Hi,

    Can you browse to the report server, open the report and check its connection settings. Also if you can open the report in the browser and execute it.

  • Community Member Profile Picture
    on at

    I have already did and my second post describe that part. I get DSMain 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans