Hi,I have published the data source and the report on the report server programmatically. When i open the report either using URL redirection (programmatically) or from the Report Manager screen, the following error message is displayed.The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)If I change the report properties manually using Report Manager screen and bind the data source to the report, it works fine.Is there any solution to bind it programmatically ?Thanks in advance.
December 1st, 2005 3:36pm
It sounds like the RDL is not set correctly to point to where the datasource is being deployed. You can either change the RDL or call SetItemDatasources (RS 2005) or SetReportDatasources (RS 2000) to set the data source to point to the shared data source.
December 6th, 2005 11:57pm
Thanks, I also had got a solution last week, though was work-around, was still useful.
December 8th, 2005 6:32am
I am having the same problem. Would you give me the work around to the problem.
May 19th, 2007 10:41pm
Hi All, I also got this error today for the very first time and I was wondering how it is created. I have been using RS for nearly 2 years and never seen this message before. When I go into Report->Data Sources it tells me "The shared Data Source Reference is no longer valid" and all I need to do is to reconnect the data source. Also, if I delete a report and redeploy it then it will also connect to the data source correctly even though it is the same data source....but if I redeploy a report without deleting it the message is issued. This seems like a really strange one...I would like to know if anyone knows how this happens...I have two other report projects which are functioning just fine and after I reconnect the data source all is fine... ?? Thanks In Advance Peter
July 19th, 2007 6:19pm
Order is also important. I had the same problem before. if your report was set to use a share ds at VS, you have to either create a new datasource with the same name as the share ds at the report manager or import the share ds from your VS studio FIRST before you upload any reports.
February 1st, 2008 1:53am
I was getting the same error when trying to move my report from visual studio to sharepoint. i was manually uploading the rdl file rather than deploying from within sharepint. the error when away after following instructions: http://msdn2.microsoft.com/en-us/library/bb283155.aspx Kunal BaggaFounderAuraTech Singapore(Custom Software Development, Sharepoint and MS Dynamics CRM customizations)
April 6th, 2008 11:44am
Hi Rajeeb,Can you please post code sample of how you set DataSource programmatically?Rgds, Uday uday shivamurthy
January 19th, 2009 1:33am
The reason it happens is because of different GUIDs in the rdl file. I have posted some details about it athttp://ryandev.com/rsinvaliddatasourcereference-on-a-microsoft-srs-report/but the one way sure to work is to do it manually as proposed by others in this thread.Ryan
March 18th, 2009 7:57pm
Although the solution (article) brought up by RyanB31 there more that causes the message. In coincidence what has been brought up by AJNeuman (April 14th 2010) as reply on this solution, today I faced exactly the same issue. Uploading the same report causes this message while deploying does not. So what’s the purpose of uploading a report to the Report Manager environment (to front from back) while deploying reports from BIDS to the Report Manager (from back to front) environment does not generate this trouble.
April 28th, 2010 3:44pm
Surprisingly, I performed the same action > uploading a report which is not accessible while deploying it is ... however I did something more ... I opened a second browser instantiation made connection to the report manager ... surprisingly ... now I saw in the details pane two extra tabs and extra menu option under the properties tab ( which I did not saw in the first browser instantiation ) ... so going to the properties ... now it was possible to make a new connection to the desired data source ... and ... happy me ... the report could be opened. So, I have the feeling that during uploading because in a uploading session only one file can be uploaded (the related rdl.data file is not updated at the same time) just only the connection between those files is lost where the GUIDs are still the same (this must be true, because deploying did not generated this trouble. So what the lesson/suggestion: if in any case you need to upload a report instead of deploying (for what ever reason deploying is not possible), just open a new browser session (possibly disconnect and reconnect to the remote machine (in my case) where your report manager runs > go to your uploaded report, look for the extra menu items under the properties tab click menu item data sources and perform a new connection to the already existing data source ( http://ryandev.com/rsinvaliddatasourcereference-on-a-microsoft-srs-report/ ).
April 28th, 2010 4:13pm
Another approach ... upload a report ... try to open the report ... get the 'The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference) ' on your screen ... sit back, take a rest, don't start shooting, throwing pencils or whatever ... just look for the properties tab ... ( at that time you'll notice two extra tabs ) ... hit the properties tab ... hit data sources menu item and perform a connection to the desired data source ... you're set!!!
April 28th, 2010 4:32pm
Rather than do this programmatically there is an application (SSRS Data Source Manager) that can fix missing 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 identify only 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.
July 15th, 2010 12:40am
HI there, I m runnign ssrs 2009 in sp integrated mode. when i run the report i got this error: The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference). when i checked the data connection it keeps on losing login details and untick the enable datasource part automatically . then i put my login details and enable data source ,works fine for that day and again next day it keeps on losing the the login details. Any help would be higly appriciated. Many thanks Hari
July 23rd, 2010 12:07pm
January 22nd, 2011 7:39pm