Solved

Reporting Services rsInvalidDataSourceReference with shared DataSource

Posted on 2007-03-27
7
7,250 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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
How to increase the row limit in Jasper Server.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

785 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