Solved

Reporting Services rsInvalidDataSourceReference with shared DataSource

Posted on 2007-03-27
7
7,213 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Need to Sort Grouped Data in SSRS Report 2 67
SSRS keeping tablix together 13 166
oracle report not displaying body data 4 74
CRM 2011 Error Connecting to Report Datasource 7 65
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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now