Solved

Reporting Services rsInvalidDataSourceReference with shared DataSource

Posted on 2007-03-27
7
7,296 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
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

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…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

840 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