Showing posts with label files. Show all posts
Showing posts with label files. Show all posts

Friday, March 30, 2012

rsinvaliddataSourceReference problem

Hi,
I have some rdl files to be deployed using RS 2005. I have 3 folders viz., ReportFolder1, ReportFolder2 and System Files.
ReportFolder1 - contains soem reports
ReportFolder2 - contains some other types of reports
System Files - Contains the shared Data source
All the above folders are present in a main folder called ReportMain
In all my rdl files I have given the value of DataSourceReference element as 'ReportMain/System Files/MyDatabase'.
Still when the reports are deployed and i try to view any report, I get the following error:
The report server cannot process the report. The data source connection information has been deleted.(rsInvalidDataSourceReference).

Why do I get this error still? Can anyoen help?
Thanks.

Hi SandyJ,

This is because ur not pointing the reports to the required data source

I am giving u step by step solution for this issue.

1. go to Report Manager(http://<servername>/reports/pages/Folder.aspx)

2. Click on the Folder in which u have reports

3. U will be directed into contents tab where u will find Show Details at the right top corner

4. Click on Show Details

5. Check in the particular report and click the edit button corresponding to it

6. Go to the properties tab and click on it

7. U will find a menu on left hand side, click on Data Sources link

8. There u will find radio button selected for A share data source(by default) and a browse button.

9. Click on the browse button u will find the tree structure of the datasource and the reports folder.

10. select the datasource in the datasource folder and select OK.

by this way u will be able to point the report to the datasource.

Regards,

Vamsi Krishna Korasiga

rsinvaliddataSourceReference problem

Hi,
I have some rdl files to be deployed using RS 2005. I have 3 folders viz., ReportFolder1, ReportFolder2 and System Files.
ReportFolder1 - contains soem reports
ReportFolder2 - contains some other types of reports
System Files - Contains the shared Data source
All the above folders are present in a main folder called ReportMain
In all my rdl files I have given the value of DataSourceReference element as 'ReportMain/System Files/MyDatabase'.
Still when the reports are deployed and i try to view any report, I get the following error:
The report server cannot process the report. The data source connection information has been deleted.(rsInvalidDataSourceReference).

Why do I get this error still? Can anyoen help?
Thanks.

Hi SandyJ,

This is because ur not pointing the reports to the required data source

I am giving u step by step solution for this issue.

1. go to Report Manager(http://<servername>/reports/pages/Folder.aspx)

2. Click on the Folder in which u have reports

3. U will be directed into contents tab where u will find Show Details at the right top corner

4. Click on Show Details

5. Check in the particular report and click the edit button corresponding to it

6. Go to the properties tab and click on it

7. U will find a menu on left hand side, click on Data Sources link

8. There u will find radio button selected for A share data source(by default) and a browse button.

9. Click on the browse button u will find the tree structure of the datasource and the reports folder.

10. select the datasource in the datasource folder and select OK.

by this way u will be able to point the report to the datasource.

Regards,

Vamsi Krishna Korasiga

Wednesday, March 21, 2012

RS2005 Crashed After Editing and Restoring Config Files

Dear Anyone,

Here's what happened. We backed up the web.config and the rsreportserver.config. We messed around with it trying to make an assumption worked. When we finally gave up, we deleted these files and renamed back the web.config and the rsreportserver.config files. To our surprise when we tried to open our report manager, the error below showed up. We tried to reconfigure the report server using the reporting services configuration tool to no avail.

Any insights to what had happened and how to resolve it?

Thanks,
Joseph

Error message:

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

check that reportserver service is running|||Yup, report service is running.|||

Hi Joseph,

I have seen something similar if the xml in the config files were mal formed. Open the config file in IE and see if there is a tag missing or something.

David

|||

Thanks for the reply. I have been told that one of the config files is not really an xml file. We've verified this with all of our reporting services installations. Aparently they have some sort of an encrypted data within it. I wonder if this is really true?

|||

We rely on ASP.NET and CLR Security to parse config files (rsReportServer.Config and rssrvpolicy.config).
Unfortunately these things use simplified xml parsers that may not properly handle some of xml features. It is a known fact that rssrvpolicy.config does not handle xml comments.
So whenever you modify config file make sure it is well formed.

RSReportServer.Config contains credentials for connecting to the RS Catalog database. These credentials are encrypted. To change them use Reporting Services Configuration Manager.