Reports: An error has occurred during report processing(rsProcessingAborted) CRM 4.0

http://groups.google.com/group/microsoft.public.crm.deployment/browse_thread/thread/e37b4c7297d14b81

Error :

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source ‘xyz’.
(rsErrorOpeningConnection)
For more information about this error navigate to the report server on the
local server machine, or enable remote errors .
solution :

1 = change the datasource to the “Real” database on the reporting
services . Click properties of a single report and then click on data
source and edit the connection string . after that run it . If it
works then reset the IIS and run the report from CRM interface .
2 =You need to  publish your reports again (PublishReports.exe) . Find the
following exe on the crm server , it should be at (C:\Program Files
\Microsoft CRM\Reports) or search on drive.

About these ads

21 Responses to “Reports: An error has occurred during report processing(rsProcessingAborted) CRM 4.0”


  1. 1 efren November 26, 2008 at 5:00 am

    Hi Aamir ,

    I already try all your proposed solution. but still I get this error on our CRM 4.0 Reports :

    An error has occurred during report processing.
    Cannot create a connection to data source ‘CRMQaDS’.
    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    Thanks and Best REgards,
    EFren

  2. 2 Aamir Bashir November 26, 2008 at 8:19 am

    Hi Efren.

    Use this url to access report on server where reports are installed . url (http:///Reports

    click on the organizationName_MSCRM

    now click on single report and then click on Properities and then Data source from left panel.

    Here you have different option

    1. shared data source
    2.A custom data source

    choose A custom data source and connection Type = Microsoft SQL Server
    Connection string = plz check your connection string it shuld be like(DataSource=; InitialCatalog= NP_MSCRM.

    Choose window integrated security.

    2. When you are done then reset the IIS.

    3. Please on IIS click on Default website and then right click the Reports and click on Brows.

  3. 3 efren January 29, 2009 at 9:21 pm

    Hi!

    Thanks for your reply.

    Your suggestion is working only if you RUN the report on RS server.
    But accessing report in other machine gives my same error message.

    Best REgards,
    efren

  4. 4 Aamir Bashir January 30, 2009 at 7:30 am

    Hi erfan,

    You should search google for The Connector for Microsoft SQL Server Reporting Services.

    Regards
    Aamir

  5. 5 efren February 1, 2009 at 12:42 pm

    What do you mean?

    We already have a MS CRM data connector installed in our RS server.

    Thanks!

  6. 6 kiran February 26, 2009 at 1:25 pm

    not understanding anything

  7. 8 Test July 3, 2009 at 7:34 pm

    I had the same problem but found out it there was no connection string in the data source plus I did change column type.

  8. 9 Newuser November 15, 2011 at 11:24 am

    Actually I need some info about RS Scripter.

    I am using RS Scripter.
    1. To Creating report deployment script.
    2. Deploying the report.

    I understood first point. But I stuck in second point. I am following all your steps to deploy the reports. But after doing the modification in the batch file (RS Scripter Load All item cmd). I am executing this batch. This batch file published the report to the report server. But it is not publishing the reports to the report server. I am getting some below error.

    1 .Running script “C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\TestReports\SMReports\SMReports.fldr.rss”
    Folder /SMReports already exists and cannot be overwritten

    2. Running script “C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\TestReports\SMReports\CPU_Monthly.rdl.rss”
    The data set `DataSource1′ refers to the shared data source `DataSource1′, which is not published on the report server.
    Report DataSources set successfully
    Unhandled exception:
    Unable to connect to the remote server

  9. 10 http://67.227.180.140/ April 26, 2013 at 8:27 am

    With havin so much content do you ever run into any problems
    of plagorism or copyright infringement? My site has a lot of completely
    unique content I’ve either authored myself or outsourced but it looks like a lot of it is popping it up all over the web without my agreement. Do you know any solutions to help stop content from being ripped off? I’d truly appreciate it.

  10. 11 www.youtube.com/watch?v=u_2OfUyBz5U May 8, 2013 at 12:15 am

    Wonderful site. A lot of helpful information here.
    I am sending it to a few pals ans additionally sharing in delicious.
    And naturally, thank you in your sweat!

  11. 12 Need Cash Now May 28, 2013 at 10:23 am

    This will likely be helpful for you in future if in but
    the you appear with a few monetary requirement once again.
    Within twenty four hours financial institution will review your application and revert back you by way of a affirmation
    mail in your email inbox or call.

  12. 13 nationwide home warranty June 8, 2013 at 8:42 am

    It’s amazing to pay a quick visit this web page and reading the views of all mates regarding this article, while I am also zealous of getting experience.

  13. 14 http://www.nexopia.com/users/lupepisces0/blog/1-dvd-format-pilate-classes July 16, 2013 at 2:34 pm

    It’s wonderful that you are getting thoughts from this paragraph as well as from our discussion made here.

  14. 15 ramadan 2013 prayer schedule July 28, 2013 at 11:48 am

    I’ve been exploring for a little bit for any high quality articles or blog posts in this sort of space . Exploring in Yahoo I at last stumbled upon this site. Reading this info So i’m glad to
    exhibit that I’ve an incredibly excellent uncanny feeling I found out just what I needed. I such a lot undoubtedly will make sure to don?t put out of your mind this web site and give it a glance regularly.

  15. 16 site July 30, 2013 at 11:53 am

    is laser hair removal painful yag laser (1064 nm, q-switched) – permanent hair removal has not been demonstrated – it can
    temporarily remove light hairs. A Ruby lasers operate on a shorter wavelength system of only 694 nanometers.

    They will be able to give you an estimate on how many sessions you are likely to need and the approximate cost.

  16. 17 Cheap Laser Hair Removal Sydney July 30, 2013 at 8:16 pm

    Which is why many women seek for more permanent solution or methods of hair removal,
    and the most popular is laser hair removal. People who have undergone it report that
    it’s similar to gently snapping rubber band against the skin. The FDA has always been stringent on allowing new products to reach the market, and the process for pharmaceutical companies to release new remedies is grueling and cumbersome.

  17. 18 how to get rid of bags under eyes at home August 1, 2013 at 5:57 am

    Excellent blog here! Also your site loads up fast!
    What web host are you using? Can I get your affiliate link to
    your host? I wish my web site loaded up as quickly as yours lol

  18. 19 how to get rid of bags under eyes quickly August 1, 2013 at 6:23 am

    It’s hard to find knowledgeable people about this topic, however, you seem like you know what you’re talking about!
    Thanks


  1. 1 is lava hotter than magma Trackback on June 9, 2014 at 5:23 am
  2. 2 click this link Trackback on August 13, 2014 at 7:21 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s





Follow

Get every new post delivered to your Inbox.

%d bloggers like this: