Solved

Reporting Services rsInvalidDataSourceReference with shared DataSource

Posted on 2007-03-27
7
7,368 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
Industry Leaders: 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

Industry Leaders: 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!

Question has a verified solution.

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

Suggested Solutions

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 …
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…
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…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

739 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