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