rsItemNotFound for Report Models

I have a Sharepoint integrated Reporting Services server. I have created Report models based on Data Sources. I then created Report Builder Reports to make some BI Charts and Graphs. They look great and work fine for a few days then all of a sudden I get a rsItemNotFound error saying it cannot find the Report Model which is clearly there.

An error has occurred during report processing. (rsProcessingAborted)

The item 'IT Reports/PWPDB_Prod_Model.smdl' cannot be found. (rsItemNotFound)

If I open the Report Model from Report Builder it loads the data fields, but also fails to run reports with the same error

If I try to regenerate the model from the library I get an error stating that the model needs to be a generated model.

The model specified must be a generated model.

(rsModelNotGenerated)

Even after rebooting all of the servers in the farm I get the same messages. I can regenerate a model from the data source and it doesn't work. I am seeing no errors in the logs of my app server at all regarding reporting services.

It looks as though I will have to de-integrate Reporting Services as it is not viable for a business critical application.

Please for th elove of Zeus tell me you were able to solve this?

I am getting the exact same error. I have tried everything under the sun to make this work. Any advice?

rsItemNotFound for Report Models

I have a Sharepoint integrated Reporting Services server. I have created Report models based on Data Sources. I then created Report Builder Reports to make some BI Charts and Graphs. They look great and work fine for a few days then all of a sudden I get a rsItemNotFound error saying it cannot find the Report Model which is clearly there.

An error has occurred during report processing. (rsProcessingAborted)

The item 'IT Reports/PWPDB_Prod_Model.smdl' cannot be found. (rsItemNotFound)

If I open the Report Model from Report Builder it loads the data fields, but also fails to run reports with the same error

If I try to regenerate the model from the library I get an error stating that the model needs to be a generated model.

The model specified must be a generated model.

(rsModelNotGenerated)

Even after rebooting all of the servers in the farm I get the same messages. I can regenerate a model from the data source and it doesn't work. I am seeing no errors in the logs of my app server at all regarding reporting services.

It looks as though I will have to de-integrate Reporting Services as it is not viable for a business critical application.

Please for th elove of Zeus tell me you were able to solve this?

I am getting the exact same error. I have tried everything under the sun to make this work. Any advice?

rsInvalidReportServerDatabase-Error after installing SP2

Hello all,
I have a W2003 Server machine running Sql Server 2000 SP4 and Reporting
Services with *now* installed SP2 (before SP1). After installing the service
pack, I get the following error (sry, its german):
"Die Version der Berichtsserver-Datenbank liegt in einem Format vor, das
nicht gültig ist oder nicht gelesen werden kann. Die gefundene Version ist
'C.0.6.51'; die erwartete Version ist 'C.0.6.54'. Aktualisieren Sie die
Version der Berichtsserver-Datenbank, und überprüfen Sie die Zugriffsrechte,
um den Vorgang fortzusetzen. (rsInvalidReportServerDatabase)"
Can you give me please some advice, what I can do, to get the current
version of the database? I made backups from the report databases, but did
not manage to extract the key for encoding.
Thank you in advance.
Sandra GeislerI found a solution (well, I hope so). I just opened the stored
procedure GetDBVersion in the ReportServer database and exchanged the
last digit of the version number. I then restarted the ReportServer
service and it worked!! I tried to execute a report and it was
produced. If I am noticing some side effects, I will post them here.

rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the error:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

We are using SQL server 2005 CTP and .Net 2005 beta 2.
the OS is Win xp and the reporting server is the local host.

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

Navigate to the database page. If there is a database configured, and you get this error, chances are you somehow chose to use an existing database. If you tried to upgrade from a previous RS deployment, this might occur. The May CTP will support upgrade from SQL 2000 RS to the May CTP version.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

|||we used the reporting service config tool to configure the service also we created new database to be used by the reporting service(both reportingservice & reportingservicetemp) ew had also configured the reporting service to use SA account, tried with windows security and also with the service crediantials. still we are getting the same error, when we try to deploy reporting project. we get the same error when we try to create a new data source from the report manager web application.

Thanks a lot for your help.
Thanks & regards

Jayan|||Hi Lukasz,
Thanks for your help, we deleted the earlier databases, then created new using the tool. still when we tried it gave the same error. then we restarted the service and everything worked fine.

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

the fix is:
1. In reporiting services configuration manager-> database setup, make sure you have the correct reporting database selected. In this case it will throw the same err when you try to initialize the reporting services.|||Hi,

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

XML Parsing Error: not well-formed
Location: http://moor-6ftylksqxm/reports/
Line Number 1, Column 2:<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePage" %>
-^

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!sql

rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the error:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

We are using SQL server 2005 CTP and .Net 2005 beta 2.
the OS is Win xp and the reporting server is the local host.

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

Navigate to the database page. If there is a database configured, and you get this error, chances are you somehow chose to use an existing database. If you tried to upgrade from a previous RS deployment, this might occur. The May CTP will support upgrade from SQL 2000 RS to the May CTP version.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

|||we used the reporting service config tool to configure the service also we created new database to be used by the reporting service(both reportingservice & reportingservicetemp) ew had also configured the reporting service to use SA account, tried with windows security and also with the service crediantials. still we are getting the same error, when we try to deploy reporting project. we get the same error when we try to create a new data source from the report manager web application.

Thanks a lot for your help.
Thanks & regards

Jayan|||Hi Lukasz,
Thanks for your help, we deleted the earlier databases, then created new using the tool. still when we tried it gave the same error. then we restarted the service and everything worked fine.

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

the fix is:
1. In reporiting services configuration manager-> database setup, make sure you have the correct reporting database selected. In this case it will throw the same err when you try to initialize the reporting services.|||Hi,

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

XML Parsing Error: not well-formed
Location: http://moor-6ftylksqxm/reports/
Line Number 1, Column 2:<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePage" %>
-^

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!

rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the error:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

We are using SQL server 2005 CTP and .Net 2005 beta 2.
the OS is Win xp and the reporting server is the local host.

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

Navigate to the database page. If there is a database configured, and you get this error, chances are you somehow chose to use an existing database. If you tried to upgrade from a previous RS deployment, this might occur. The May CTP will support upgrade from SQL 2000 RS to the May CTP version.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

|||we used the reporting service config tool to configure the service also we created new database to be used by the reporting service(both reportingservice & reportingservicetemp) ew had also configured the reporting service to use SA account, tried with windows security and also with the service crediantials. still we are getting the same error, when we try to deploy reporting project. we get the same error when we try to create a new data source from the report manager web application.

Thanks a lot for your help.
Thanks & regards

Jayan|||Hi Lukasz,
Thanks for your help, we deleted the earlier databases, then created new using the tool. still when we tried it gave the same error. then we restarted the service and everything worked fine.

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

the fix is:
1. In reporiting services configuration manager-> database setup, make sure you have the correct reporting database selected. In this case it will throw the same err when you try to initialize the reporting services.|||Hi,

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

XML Parsing Error: not well-formed
Location: http://moor-6ftylksqxm/reports/
Line Number 1, Column 2:<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePage" %>
-^

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!

rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the error:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

We are using SQL server 2005 CTP and .Net 2005 beta 2.
the OS is Win xp and the reporting server is the local host.

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

Navigate to the database page. If there is a database configured, and you get this error, chances are you somehow chose to use an existing database. If you tried to upgrade from a previous RS deployment, this might occur. The May CTP will support upgrade from SQL 2000 RS to the May CTP version.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

|||we used the reporting service config tool to configure the service also we created new database to be used by the reporting service(both reportingservice & reportingservicetemp) ew had also configured the reporting service to use SA account, tried with windows security and also with the service crediantials. still we are getting the same error, when we try to deploy reporting project. we get the same error when we try to create a new data source from the report manager web application.

Thanks a lot for your help.
Thanks & regards

Jayan|||Hi Lukasz,
Thanks for your help, we deleted the earlier databases, then created new using the tool. still when we tried it gave the same error. then we restarted the service and everything worked fine.

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

the fix is:
1. In reporiting services configuration manager-> database setup, make sure you have the correct reporting database selected. In this case it will throw the same err when you try to initialize the reporting services.|||Hi,

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

XML Parsing Error: not well-formed
Location: http://moor-6ftylksqxm/reports/
Line Number 1, Column 2:<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePage" %>
-^

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!

rsInvalidPolicyDefinition - migration to another domain .....

Hi friends,

We have a problem with our RS2005 after migration into another domain.

The problem is that we have got duplicate access rights for the same AD usergroup.
When trying to remove or add a new AD group we get the error msg - "... role assignment is not valid. The role assignment is either empty or it specifies a user or group name that is already used in an existing role assignment for the current item. (rsInvalidPolicyDefinition)"

Books online gives no answers and neither does other serach engines .....

Anyone having a hint or solution .......

We have the same problem. Cannot remove some roles. I'm worried about if we need to make changes later, will we have to destroy the entire folder structure & re-create it in order to get rid of these roles/permissions?

rsInvalidPolicyDefinition - migration to another domain .....

Hi friends,

We have a problem with our RS2005 after migration into another domain.

The problem is that we have got duplicate access rights for the same AD usergroup.
When trying to remove or add a new AD group we get the error msg - "... role assignment is not valid. The role assignment is either empty or it specifies a user or group name that is already used in an existing role assignment for the current item. (rsInvalidPolicyDefinition)"

Books online gives no answers and neither does other serach engines .....

Anyone having a hint or solution .......

We have the same problem. Cannot remove some roles. I'm worried about if we need to make changes later, will we have to destroy the entire folder structure & re-create it in order to get rid of these roles/permissions?sql

rsInvalidPolicyDefinition

Greetings,
I am running SQL Server 2005 Reporting Services on a SQL Server 2000
(sp4) database and am running into an issue after a domain migration
that is preventing me from modifying any of the security settings on
the report server.
When attempting to Delete or Modify security settings on a folder i
receive the following message:
The "<All the users w/ access to the folder>" role assignment is not
valid. The role assignment is either empty or it specifies a user or
group name that is already used in an existing role assignment for the
current item. (rsInvalidPolicyDefinition) Get Online Help.
Has anyone seen this before or have suggestions as to where to start
troubleshooting it?
Thanks in advance,
Ben SullinsI've found a work around by clicking 'Revert to Parent secruty' on
these folders then going back in and modifying them. This only happens
on folders where the same user/group is listed 2x. Not sure how that
happened but I'm guessing it had to do w/ our domain migration...
sullins602 wrote:
> Greetings,
> I am running SQL Server 2005 Reporting Services on a SQL Server 2000
> (sp4) database and am running into an issue after a domain migration
> that is preventing me from modifying any of the security settings on
> the report server.
> When attempting to Delete or Modify security settings on a folder i
> receive the following message:
> The "<All the users w/ access to the folder>" role assignment is not
> valid. The role assignment is either empty or it specifies a user or
> group name that is already used in an existing role assignment for the
> current item. (rsInvalidPolicyDefinition) Get Online Help.
> Has anyone seen this before or have suggestions as to where to start
> troubleshooting it?
> Thanks in advance,
> Ben Sullins

rsInvalidItemPath Error and Jump to URL Issues

I am having a navigation issue with jump to URLs in reports. When I have a report that supports drilldown if I click the drill down then click a Jump To URL to render the next report I get a second toolbar. If the drill down was never clicked the jump to works fine.

My workaround was to try and create a javascript url to reset the url for the top frame. However, the same url that was working before is now throwing an rsInvalidItemPath error. Any thoughts?

Here is my original Jump To URL expression that was causing the second toolbar to appear on drill down:

=Globals!ReportServerUrl + "?/Early Life/Early Life Technician Summary QA&pDate=" + Parameters!pDate.Value.ToString().Replace("&", "%26") + "&pArea=" + Fields!Measures_AreaUniqueName.Value.ToString().Replace("&", "%26") + "&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true"

Renders as:
http://ilschd-sitdev01/ReportServer?/Early%20Life/Early%20Life%20Technician%20Summary%20QA&pDate=%5BOrder%20Finalized%20Date%5D.%5BFiscal%5D.%5BMonth%5D.%5BDecember,%202005%5D&pArea=%5BArea%5D.%5BOffices%5D.%5BArea%5D.%26%5BChicago%20North%5D&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true

I changed the Jump to URL expression to the following to try and fix the toolbar issue:

=top.location.href='" + Globals!ReportServerUrl + "?/Early Life/Early Life Technician Summary QA&pDate=" + Parameters!pDate.Value.ToString().Replace("&", "%26") + "&pArea=" + Fields!Measures_AreaUniqueName.Value.ToString().Replace("&", "%26") + "&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true" + "'"

Renders as:
BLOCKED SCRIPTtop.location.href='http://ilschd-sitdev01/ReportServer?/Early%20Life/Early%20Life%20Technician%20Summary%20QA&pDate=%5BOrder%20Finalized%20Date%5D.%5BFiscal%5D.%5BMonth%5D.%5BDecember,%202005%5D&pArea=%5BArea%5D.%5BOffices%5D.%5BArea%5D.%26%5BChicago%20North%5D&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true'

This version of Jump to URL causing the rsInvalidPath Exception to be thrown.

Reporting Services Error

---

The path of the item "/Early Life/Early Life Technician Summary QA,[Chicago North]" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)

---

SQL Server Reporting Services

Thanks in advance,
Adam

Did you get this problem fixed, Adam? I have a similar problem it sounds like where I have a record containing an "&" but SRS is trying to read it as two parameters instead of one, so I get the same 260 characters long error.|||

You can use POST instead of GET i.e. using a HTML form with hidden fields rather than building up a URL string. This should get you around the 260 character limit.

Check out this article for an example http://blogs.msdn.com/bryanke/articles/73153.aspx

rsInvalidItemPath Error and Jump to URL Issues

I am having a navigation issue with jump to URLs in reports. When I have a report that supports drilldown if I click the drill down then click a Jump To URL to render the next report I get a second toolbar. If the drill down was never clicked the jump to works fine.

My workaround was to try and create a javascript url to reset the url for the top frame. However, the same url that was working before is now throwing an rsInvalidItemPath error. Any thoughts?

Here is my original Jump To URL expression that was causing the second toolbar to appear on drill down:

=Globals!ReportServerUrl + "?/Early Life/Early Life Technician Summary QA&pDate=" + Parameters!pDate.Value.ToString().Replace("&", "%26") + "&pArea=" + Fields!Measures_AreaUniqueName.Value.ToString().Replace("&", "%26") + "&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true"

Renders as:
http://ilschd-sitdev01/ReportServer?/Early%20Life/Early%20Life%20Technician%20Summary%20QA&pDate=%5BOrder%20Finalized%20Date%5D.%5BFiscal%5D.%5BMonth%5D.%5BDecember,%202005%5D&pArea=%5BArea%5D.%5BOffices%5D.%5BArea%5D.%26%5BChicago%20North%5D&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true

I changed the Jump to URL expression to the following to try and fix the toolbar issue:

=top.location.href='" + Globals!ReportServerUrl + "?/Early Life/Early Life Technician Summary QA&pDate=" + Parameters!pDate.Value.ToString().Replace("&", "%26") + "&pArea=" + Fields!Measures_AreaUniqueName.Value.ToString().Replace("&", "%26") + "&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true" + "'"

Renders as:
BLOCKED SCRIPTtop.location.href='http://ilschd-sitdev01/ReportServer?/Early%20Life/Early%20Life%20Technician%20Summary%20QA&pDate=%5BOrder%20Finalized%20Date%5D.%5BFiscal%5D.%5BMonth%5D.%5BDecember,%202005%5D&pArea=%5BArea%5D.%5BOffices%5D.%5BArea%5D.%26%5BChicago%20North%5D&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true'

This version of Jump to URL causing the rsInvalidPath Exception to be thrown.

Reporting Services Error

---

The path of the item "/Early Life/Early Life Technician Summary QA,[Chicago North]" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)

---

SQL Server Reporting Services

Thanks in advance,
Adam

Did you get this problem fixed, Adam? I have a similar problem it sounds like where I have a record containing an "&" but SRS is trying to read it as two parameters instead of one, so I get the same 260 characters long error.|||

You can use POST instead of GET i.e. using a HTML form with hidden fields rather than building up a URL string. This should get you around the 260 character limit.

Check out this article for an example http://blogs.msdn.com/bryanke/articles/73153.aspx

sql

rsInvalidDataSourceReference-Pls help

Hello Everybody:
I have installed SQL Reporting Services for the first time using SQL Login account. After creating a Shared Data Source, and creating the report I am trying to deploy the report to the server. In the project properties I have set the TargetServerURL to http://hostweb01/ReportServer
When I try to deploy the project I get a windows pop up asking for User Name and password. I enter the username and password but the window keeps popping up. I therefore load the report from http://hostweb01/Reports
When I try to run the report I get the error.

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)
Can anyone guide me what could be wrong and what should I do to correct the problem. I have stuck on this problem for hours.

Thanks,

Kapil

For the first item, when you give it a user name and password, are you giving a Windows account known by IIS? What is the security setting on your /reportserver web site (use IIS Manager)?

If you deploy manually (through Report Manager), you will need to create a new data source item (with the correct connection string) on he server before you upload the report. Afterwards, you can go to the report properties page and link the report to the data source object.

|||

Hi rahil,

u need to point the report to the datasource to solve this issue.

The datasource is shared by different reports and u need to have dependent items pointed to the datasource.

I too struggle a lot over this issue and at last found the solution.

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-Pls help

Hello Everybody:
I have installed SQL Reporting Services for the first time using SQL Login account. After creating a Shared Data Source, and creating the report I am trying to deploy the report to the server. In the project properties I have set the TargetServerURL to http://hostweb01/ReportServer
When I try to deploy the project I get a windows pop up asking for User Name and password. I enter the username and password but the window keeps popping up. I therefore load the report from http://hostweb01/Reports
When I try to run the report I get the error.

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)
Can anyone guide me what could be wrong and what should I do to correct the problem. I have stuck on this problem for hours.

Thanks,

Kapil

For the first item, when you give it a user name and password, are you giving a Windows account known by IIS? What is the security setting on your /reportserver web site (use IIS Manager)?

If you deploy manually (through Report Manager), you will need to create a new data source item (with the correct connection string) on he server before you upload the report. Afterwards, you can go to the report properties page and link the report to the data source object.

|||

Hi rahil,

u need to point the report to the datasource to solve this issue.

The datasource is shared by different reports and u need to have dependent items pointed to the datasource.

I too struggle a lot over this issue and at last found the solution.

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

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 Error

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.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.|||Thanks, I also had got a solution last week, though was work-around, was still useful.|||

I am having the same problem.

Would you give me the work around to the problem.

|||

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

sql

rsInvalidDataSourceReference Error

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.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.|||Thanks, I also had got a solution last week, though was work-around, was still useful.|||

I am having the same problem.

Would you give me the work around to the problem.

|||

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

rsInvalidDataSourceReference Error

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.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.|||Thanks, I also had got a solution last week, though was work-around, was still useful.|||

I am having the same problem.

Would you give me the work around to the problem.

|||

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

rsInvalidDataSourceReference Error

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.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.|||Thanks, I also had got a solution last week, though was work-around, was still useful.|||

I am having the same problem.

Would you give me the work around to the problem.

|||

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