At the end of my rope!

Question

At the end of my rope!

TeraByteMe

SSCarpal Tunnel

Points: 4171
More actions
July 22, 2011 at 9:07 pm

#244836

Next step is either the noose or the food kitchen. I am getting this error in reporting services when trying to connect to my reporting server. The configuration manager says every this is working. But when I goto http://localhost/reports this is what I get...
The item '/' cannot be found. (rsItemNotFound) Get Online Help
BTW, Get Online Help is like useless.
Help desperately needed!
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Jeff Moden SSC Guru Points: 1003913 More actions · Answer 1

MuchLearnSoLittleTime (7/22/2011)
Next step is either the noose or the food kitchen. I am getting this error in reporting services when trying to connect to my reporting server. The configuration manager says every this is working. But when I goto http://localhost/reports this is what I get...
The item '/' cannot be found. (rsItemNotFound) Get Online Help
BTW, Get Online Help is like useless.
Help desperately needed!

I don't know squat about reporting servers but I've seen something similar happen with SQL Server. If there's more than one instance, you need to precisely name the instance instead of using "local host". Even if you don't have multiple instances, I've seen the same problem. Use the named instance, instead.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

MuchLearnSoLittleTime (7/22/2011)
Next step is either the noose or the food kitchen. I am getting this error in reporting services when trying to connect to my reporting server. The configuration manager says every this is working. But when I goto http://localhost/reports this is what I get...
The item '/' cannot be found. (rsItemNotFound) Get Online Help
BTW, Get Online Help is like useless.
Help desperately needed!

You can get the "correct" url by using the ssrs configuration tool. It should be in your ms sql windows [start] menu.

mister.magoo SSC-Forever Points: 47068 More actions · Answer 3

Just to make sure you get the correct URL, open IIS Administrator, navigate the treeview to your Reports web application , right click on the Reports node and choose Browse...see what that does for you.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

TeraByteMe SSCarpal Tunnel Points: 4171 More actions · Answer 4

There is only one instance on the server. When I goto IIS Admin and Browse the site it's url is http://localhost/reports/Pages/Folder.aspx and comes up with the same error message. This is what comes up in the log:

Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)

at Microsoft.ReportingServices.WebServer.ReportingService2005.GetPermissions(String Item, String[]& Permissions)

w3wp!ui!1!7/23/2011-17:35:15:: e ERROR: HTTP status code --> 200

-------Details--------

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The item '/' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/' cannot be found.

at Microsoft.ReportingServices.Library.GetPermissionsAction.PerformActionNow()

at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()

at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)

Any other suggestions would be greatly appreciated. Thanks.

A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))

TeraByteMe SSCarpal Tunnel Points: 4171 More actions · Answer 5

Thanks but I am only using one instance and when I use the hostname in place of the localhost it produces same result.

A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))

TeraByteMe SSCarpal Tunnel Points: 4171 More actions · Answer 6

Just a thought but I notice there is one row entry in the ReportServer Catalog table on another server that has just been configured with Reporting Services but on this one I don't have any entries. Is there some kind of communication between the website and this Catalog table that could be causing the issue?

A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))

mister.magoo SSC-Forever Points: 47068 More actions · Answer 7

Is this a new installation?

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

TeraByteMe SSCarpal Tunnel Points: 4171 More actions · Answer 8

It is a new installation but when I first accessed it I was able to open the default website and naviage it. There were no reports yet but the site opened. Don't know what has changed since then that is causing this error?

A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))

mister.magoo SSC-Forever Points: 47068 More actions · Answer 9

I asked if it was new, because if it is new, I would recommend running through the Report Server Database Configuration Wizard from the Database section of the Reporting Services Configuration Manager - first to try connecting to the existing database - to test that, then if that fails, to try creating a new RS database.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

TeraByteMe SSCarpal Tunnel Points: 4171 More actions · Answer 10

I have done that. Everything is green checked on the Report Configuration Manager. It can communicate with the sql server.

The configuration is:

Report Server Virtual Directory = ReportServer

Report Manager Virtual Directory = Reports

A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))

mister.magoo SSC-Forever Points: 47068 More actions · Answer 11

I would say that if you have connectivity and the catalog is empty, then it is worth creating a new RS database.

It sounds like someone has messed with the existing one and it's going to be quicker to create a new one.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

TeraByteMe SSCarpal Tunnel Points: 4171 More actions · Answer 12

I have done that. The Configure Report Server is all green checked.

The configuration is:

Report Server Virtual Directory = ReportServer

Report Manager Virtual Directory = Reports

IIS Manager shows:

Default Web Site

- ReportServer

- Reports

A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))

TeraByteMe SSCarpal Tunnel Points: 4171 More actions · Answer 13

I have done that. The Configure Report Server is all green checked.

The configuration is:

Report Server Virtual Directory = ReportServer

Report Manager Virtual Directory = Reports

IIS Manager shows:

Default Web Site

- ReportServer

- Reports

A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))

mister.magoo SSC-Forever Points: 47068 More actions · Answer 14

have you tried deploying a report to it ?

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);