locked
The report cannot be displayed. (rsProcessingAborted) when trying to create a report? RRS feed

  • Question

  • Hi,

    I was looking to create a new report, all I want to do is to run a report that shows a users activities so if they have updated a record, or created/modified notes. 

    I tried the followingbut I got an error of The report cannot be displayed. (rsProcessingAborted)

    Monday, January 19, 2015 3:24 PM

All replies

  • Hello,

    Could you please provide SQL/FetchXml query you use in a report?


    Dynamics CRM MVP/ Technical Evangelist at SlickData LLC
    My blog

    Monday, January 19, 2015 4:22 PM
    Moderator
  • Hi,

    Sorry but how would i do that?

    Monday, January 19, 2015 4:56 PM
  • Hi,

    Have a look at the SQL/Reporting server to see if you have any errors there. You could also turn on tracing on the CRM server to see what the servere thinks is happening.

    This is assuming that this in an on-prem CRM. There are a couple of "standard" errors where you can get this error, one of the more common is some sort of communication/authentication problem which can be solved with SPNs.

    Good luck!


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Tuesday, January 20, 2015 7:32 AM
  • Hi Rickard,

    Sorry for the late reply but I was trying to troubleshoot the error, when the error appeared I logged on to my sql server to check the event viewer and I could see the following error:-

    Report Server (MSSQLSERVER) cannot load the TERADATA extension

    I came across a few sites that say that edit the rsreportserver.config file?  but I have no MSRS10_50.MSSQLSERVER folder in the following location?

    C:\Program Files\Microsoft SQL Server\

    The full path is supposed to be:-

    <C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer>

    I am following the steps on the following site:-

    http://jandho.blogspot.co.uk/2012/06/report-server-cannot-load-teradata.html

    Or, does anyone else know another work around? thanks

    Thursday, January 22, 2015 9:27 AM
  • Hi,

    The Terradata error is a wee bit generic and can mean pretty much anything unfortunately. That you don't have a MSRS-folder could mean that the SSRS is on another server. Can you have a look at that and if possible turn on the CRM tracing.

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Thursday, January 22, 2015 9:46 AM
  • Hi,

    I'm not sure which one is the reporting server as we only have the one server which has CRM installed and the other which has the SQL Database.  I tried running the CRM tracing and all i could see was the following?

        at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)  ilOffset = 0x4B
    >Crm Exception: Message: An error occurred during report rendering. ReportId:{76D6ED67-84A0-E411-B8AD-005056890035}, ErrorCode: -2147187924, InnerException: Microsoft.Reporting.WebForms.ReportServerException: An error has occurred during report processing. (rsProcessingAborted) ---> Microsoft.Reporting.WebForms.ReportServerException: Query execution failed for dataset 'DSMain'. (rsErrorExecutingCommand) ---> Microsoft.Reporting.WebForms.ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors
       --- End of inner exception stack trace ---
       --- End of inner exception stack trace ---

    Thursday, January 22, 2015 10:45 AM
  • Hi Clark,

    Which type of Report is it? FetchXml or SSRS.

    Please download the report and open it in visual studio and share your query here.
    Please run DSMain dataset's query on SQL server and check whether you are getting result.


    Regards, Saad

    Thursday, January 22, 2015 11:03 AM
  • I agree with Saad, the problem seems to be within the report. Have you created it yourself or has someone made it for you?

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Thursday, January 22, 2015 11:12 AM
  • Hi Saad,

    I'm not entirely sure what type of report it is, however i did download the report into an rdl format

    Friday, January 23, 2015 10:57 AM
  • Hi,

    You need to open it in a BIDS (or whatever it's called this week :)), which pretty much is an old VS supplied with SQL Server.


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Friday, January 23, 2015 11:23 AM
  • Hi Clark,

    Create a new Report Project in SQL Server Business Intelligence Development Studio. Click Add existing Item and select your rdl file and click ok.

    After doing this click on Report and it will show your datasets and datasources.


    Regards, Saad

    Friday, January 23, 2015 11:23 AM
  • Hi,

    I dont have the business intelligence development version, i have the SQL Server Management Studio version, I'm not sure how to create a new report? as it does not give me the option?

    Friday, January 23, 2015 11:35 AM
  • Get it installed and then try to open

    Regards, Saad

    Friday, January 23, 2015 11:37 AM
  • Salam Saad,

    is this the only way to troubleshoot it? I downloaded it and tried installing it on one of my test servers but the installation keeps hanging.  I have noticed that on our sql server the sql server reporting services is running and is using the administrator account, i did read somewhere this could cause the error but here its obviously not.

    Tuesday, February 3, 2015 4:51 PM
  • The reporting services log files should give you more information about why it's failing

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Tuesday, February 3, 2015 7:20 PM
    Moderator
  • Thanks David,

    Thanks for your help.

    I can see the following from the logs.

    Application log

    Report Server (MSSQLSERVER) cannot load the TERADATA extension.

    System log

    The Kerberos client received a KRB_AP_ERR_MODIFIED error from the server CRMAPPSVC. The target name used was HTTP/CRMSERVER. This indicates that the target server failed to decrypt the ticket provided by the client. This can occur when the target server principal name (SPN) is registered on an account other than the account the target service is using. Please ensure that the target SPN is registered on, and only registered on, the account used by the server. This error can also happen when the target service is using a different password for the target service account than what the Kerberos Key Distribution Center (KDC) has for the target service account. Please ensure that the service on the server and the KDC are both updated to use the current password. If the server name is not fully qualified, and the target domain (C.LOCAL) is different from the client domain (C.LOCAL), check if there are identically named server accounts in these two domains, or use the fully-qualified name to identify the server.

    Reporting Service log files

    library!WindowsService_142!1c58!02/04/2015-09:27:48:: i INFO: Call to CleanBatch()
    library!WindowsService_142!1c58!02/04/2015-09:27:48:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_142!1c58!02/04/2015-09:27:48:: i INFO: Call to CleanBatch() ends
    processing!ReportServer_0-9!140c!02/04/2015-09:28:02:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DSMain'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
    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 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A call to SSPI failed, see inner exception. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A call to SSPI failed, see inner exception. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The target principal name is incorrect
       --- End of inner exception stack trace ---
       at System.Net.Security.NegoState.StartSendAuthResetSignal(LazyAsyncResult lazyResult, Byte[] message, Exception exception)
       at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.CheckCompletionBeforeNextSend(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.ProcessReceivedBlob(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.CheckCompletionBeforeNextSend(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.ProcessReceivedBlob(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.ProcessAuthentication(LazyAsyncResult lazyResult)
       at System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential credential, String targetName, ProtectionLevel requiredProtectionLevel, TokenImpersonationLevel allowedImpersonationLevel)
       at System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream stream, SecurityMessageProperty& remoteSecurity)
       at System.Net.Security.NegoState.StartSendAuthResetSignal(LazyAsyncResult lazyResult, Byte[] message, Exception exception)
       at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.CheckCompletionBeforeNextSend(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.ProcessReceivedBlob(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.CheckCompletionBeforeNextSend(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.ProcessReceivedBlob(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.StartSendBlob(Byte[] message, LazyAsyncResult lazyResult)
       at System.Net.Security.NegoState.ProcessAuthentication(LazyAsyncResult lazyResult)
       at System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential credential, String targetName, ProtectionLevel requiredProtectionLevel, TokenImpersonationLevel allowedImpersonationLevel)
       at System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream stream, SecurityMessageProperty& remoteSecurity)
       --- End of inner exception stack trace ---

    I do believe the issue to be with authorization account so i will dig further to see if i can fix it.

    Wednesday, February 4, 2015 9:38 AM
  • Based on 'The target principal name is incorrect ', it looks like your problems are with the SPNs somewhere, which is borne out by the Kerberos error in the System Event log. The two most likely causes are either:

    • Active Directory replication issues, which can result in inconsistent SPN information
    • Duplicate SPNs


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Wednesday, February 4, 2015 9:04 PM
    Moderator
  • It looks similar to my problem, which occurred a few days ago.

    As you said "I'm not sure which one is the reporting server as we only have the one server which has CRM installed and the other which has the SQL Database".

    Open your rdl file with BIDS and check your connection string. There Data Source should be given with database url not the CRM url.




    Thursday, February 5, 2015 9:17 AM