locked
CRM 2011 SSRS reports - An error has occurred during report processing. (rsProcessingAborted) RRS feed

  • Question

  • Hi All,

    SSRS data connector installed successfully on db server. After that we ran the reports and observed that OOB reports are running without any issues. But custom reports(created through CRM 2011 report wizard and developed reports using SQL BI) are not running and gave the following error from CRM front end.

        Error: An error has occurred during report processing. (rsProcessingAborted) 

    Then went to database server and ran the custom reports from SSRS. I got the following error from SSRS.

    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.EndpointNotFoundException: Could not connect to net.tcp://SERVERNAME/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:01.0001000. TCP error code 10061: No connection could be made because the target machine actively refused it XX.X.XX.XX:808. System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it XX.X.XX.XX:808 

    From the above error i understand that port 808 need to open from db to apps servers. After opening the port then all the reports ran successfully. Here my question is why OOB reports worked without any port issue. And for custom reports gave the problem? Anybody having idea?

    Regards,


    • Edited by crmpnk1 Wednesday, April 16, 2014 6:48 AM
    Wednesday, April 16, 2014 6:47 AM

All replies

  • Have you granted permission for the report to access the db? I fell foul of this one.
    Wednesday, April 16, 2014 2:52 PM