Solved

Reporting Services rsInvalidDataSourceReference with shared DataSource

Posted on 2007-03-27
7
7,338 Views
Last Modified: 2012-06-21
I have a set of Reporting Services reports that use a shared datasource. I don't have Visual Studio installed at the deployment location so I have to deploy the reports using the Report Manager. How do I deploy the datasource and the reports so that the reports will use the datasource? When I try to run the report from the Report Manager I get the following error message: The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference).
0
Comment
Question by:Paracom_Inc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 11

Expert Comment

by:Ved Prakash Agrawal
ID: 18799248
Hi,
have you deploy shared data source before when you are trying to deploy reports.
0
 
LVL 11

Expert Comment

by:Ved Prakash Agrawal
ID: 18799295
you can also create data source through report manager and after then you tried to deploy your report.
But your reports should used the same name which you have created through report manager.

you can also see the dependent objects (depend on data source).
0
 

Author Comment

by:Paracom_Inc
ID: 18799874
On the development system a shared datasource was created with VS in the reports project.  I used VS to deploy the reports. On my dev system, Report Manager shows two folders: Data Sources (which contains the DataSource) and Reports (which contains the reports). Let's say the name of the shared datasource as it appears in both VS and Report Manager is ABC. On the production system I created two folders named Data Sources and Reports. I used the New Data Source button in the Report Manager to create a datasource named ABC in the Data Sources folder. I used the Upload File button in the Report Manager to add the reports to the Reports folder. The DataSources section of the rdl file looks like this (though each report has a different value for DataSourceID):
  <DataSources>
    <DataSource Name="ABC">
      <DataSourceReference>ABC</DataSourceReference>
      <rd:DataSourceID>1d4e3ca8-13c0-4d0d-9d63-6a28709f7a52</rd:DataSourceID>
    </DataSource>
  </DataSources>

When I view the Dependent Items for the datasource, it says: There are no reports that use the "/Data Sources/ABC" data source.  When I try to view the report in Report Manager I get the error I mentioned in the question: The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference).
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Paracom_Inc
ID: 18800060
OK. I figured it out. I went to the properties of the report in Report Manager and clicked the Data Sources tab. It said that the shared data source reference was no longer valid. I clicked Browse and selected the datasource I had created and clicked Apply. Now the dependent items for the datasource shows the report and the report generates properly.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 19013299
PAQed with points refunded (500)

Computer101
EE Admin
0
 

Expert Comment

by:alchemy9
ID: 33208864
There is an application (SSRS Data Source Manager) that can fix missing data sources, and change current data sources for RDL reports and models. It can be used to change a single report / model or allow bulk changes for many reports and models.
 
There is also a health check feature, to detect and correct reports and models that have missing data sources. Multiple data sources for reports and models are also supported.
 
http://www.lecomputing.com/ssrsdatasourcemanager.html 

Other uses can be- changing a selection of reports to another data source, eg moving from UAT/Development to production, or server loading issues.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question