Monday, February 27, 2012

Help!

Hi
I have beening trying to build a report with 2 parameters. When I run it
under VS.net preview, it all went well, but after I deploy it to the
server, I got
the message as following: **Reporting Services Error--The path of the item ''
is not valid. The full path must be less than 260 characters long, must start
with slash; other restrictions apply. Check the documentation for complete
set of restrictions. (rsInvalidItemPath) Get Online Help **
what went wrong, please help.
the URL for the report as following:
http://localhost/ReportServer?%2fMyReports%2fORSchedule&rs:Command=Render
TIAIT sounds like the URL of the report is too long, even though the URL you
post isn't that long...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"wd1153" <wd1153@.discussions.microsoft.com> wrote in message
news:72710497-4078-44FE-94D7-307B737B15EF@.microsoft.com...
> Hi
> I have beening trying to build a report with 2 parameters. When I run it
> under VS.net preview, it all went well, but after I deploy it to the
> server, I got
> the message as following: **Reporting Services Error--The path of the item
> ''
> is not valid. The full path must be less than 260 characters long, must
> start
> with slash; other restrictions apply. Check the documentation for complete
> set of restrictions. (rsInvalidItemPath) Get Online Help **
> what went wrong, please help.
> the URL for the report as following:
> http://localhost/ReportServer?%2fMyReports%2fORSchedule&rs:Command=Render
> TIA
>
>|||how might be the solution? thanks
"Wayne Snyder" wrote:
> IT sounds like the URL of the report is too long, even though the URL you
> post isn't that long...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "wd1153" <wd1153@.discussions.microsoft.com> wrote in message
> news:72710497-4078-44FE-94D7-307B737B15EF@.microsoft.com...
> > Hi
> >
> > I have beening trying to build a report with 2 parameters. When I run it
> > under VS.net preview, it all went well, but after I deploy it to the
> > server, I got
> > the message as following: **Reporting Services Error--The path of the item
> > ''
> > is not valid. The full path must be less than 260 characters long, must
> > start
> > with slash; other restrictions apply. Check the documentation for complete
> > set of restrictions. (rsInvalidItemPath) Get Online Help **
> > what went wrong, please help.
> >
> > the URL for the report as following:
> >
> > http://localhost/ReportServer?%2fMyReports%2fORSchedule&rs:Command=Render
> >
> > TIA
> >
> >
> >
>
>|||Maybe the parameter values are too long?
"wd1153" wrote:
> how might be the solution? thanks
> "Wayne Snyder" wrote:
> > IT sounds like the URL of the report is too long, even though the URL you
> > post isn't that long...
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "wd1153" <wd1153@.discussions.microsoft.com> wrote in message
> > news:72710497-4078-44FE-94D7-307B737B15EF@.microsoft.com...
> > > Hi
> > >
> > > I have beening trying to build a report with 2 parameters. When I run it
> > > under VS.net preview, it all went well, but after I deploy it to the
> > > server, I got
> > > the message as following: **Reporting Services Error--The path of the item
> > > ''
> > > is not valid. The full path must be less than 260 characters long, must
> > > start
> > > with slash; other restrictions apply. Check the documentation for complete
> > > set of restrictions. (rsInvalidItemPath) Get Online Help **
> > > what went wrong, please help.
> > >
> > > the URL for the report as following:
> > >
> > > http://localhost/ReportServer?%2fMyReports%2fORSchedule&rs:Command=Render
> > >
> > > TIA
> > >
> > >
> > >
> >
> >
> >|||I don't think the length of it is an issue. I have many that are longer that
what you post below. How are you trying to run the report? From Report
Manager? Or from you own app, using URL integration?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"wd1153" <wd1153@.discussions.microsoft.com> wrote in message
news:C1FDEE83-1A0B-4259-8BF6-9802039A66D1@.microsoft.com...
> how might be the solution? thanks
> "Wayne Snyder" wrote:
>> IT sounds like the URL of the report is too long, even though the URL you
>> post isn't that long...
>> --
>> Wayne Snyder, MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> www.mariner-usa.com
>> (Please respond only to the newsgroups.)
>> I support the Professional Association of SQL Server (PASS) and it's
>> community of SQL Server professionals.
>> www.sqlpass.org
>> "wd1153" <wd1153@.discussions.microsoft.com> wrote in message
>> news:72710497-4078-44FE-94D7-307B737B15EF@.microsoft.com...
>> > Hi
>> >
>> > I have beening trying to build a report with 2 parameters. When I run
>> > it
>> > under VS.net preview, it all went well, but after I deploy it to the
>> > server, I got
>> > the message as following: **Reporting Services Error--The path of the
>> > item
>> > ''
>> > is not valid. The full path must be less than 260 characters long, must
>> > start
>> > with slash; other restrictions apply. Check the documentation for
>> > complete
>> > set of restrictions. (rsInvalidItemPath) Get Online Help **
>> > what went wrong, please help.
>> >
>> > the URL for the report as following:
>> >
>> > http://localhost/ReportServer?%2fMyReports%2fORSchedule&rs:Command=Render
>> >
>> > TIA
>> >
>> >
>> >
>>|||Thank for replay
I am going to run this at report manager. The report itself should not be a
problem, right? because it runs fine in Visual Studio?
"Bruce L-C [MVP]" wrote:
> I don't think the length of it is an issue. I have many that are longer that
> what you post below. How are you trying to run the report? From Report
> Manager? Or from you own app, using URL integration?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "wd1153" <wd1153@.discussions.microsoft.com> wrote in message
> news:C1FDEE83-1A0B-4259-8BF6-9802039A66D1@.microsoft.com...
> > how might be the solution? thanks
> >
> > "Wayne Snyder" wrote:
> >
> >> IT sounds like the URL of the report is too long, even though the URL you
> >> post isn't that long...
> >>
> >> --
> >> Wayne Snyder, MCDBA, SQL Server MVP
> >> Mariner, Charlotte, NC
> >> www.mariner-usa.com
> >> (Please respond only to the newsgroups.)
> >>
> >> I support the Professional Association of SQL Server (PASS) and it's
> >> community of SQL Server professionals.
> >> www.sqlpass.org
> >>
> >> "wd1153" <wd1153@.discussions.microsoft.com> wrote in message
> >> news:72710497-4078-44FE-94D7-307B737B15EF@.microsoft.com...
> >> > Hi
> >> >
> >> > I have beening trying to build a report with 2 parameters. When I run
> >> > it
> >> > under VS.net preview, it all went well, but after I deploy it to the
> >> > server, I got
> >> > the message as following: **Reporting Services Error--The path of the
> >> > item
> >> > ''
> >> > is not valid. The full path must be less than 260 characters long, must
> >> > start
> >> > with slash; other restrictions apply. Check the documentation for
> >> > complete
> >> > set of restrictions. (rsInvalidItemPath) Get Online Help **
> >> > what went wrong, please help.
> >> >
> >> > the URL for the report as following:
> >> >
> >> > http://localhost/ReportServer?%2fMyReports%2fORSchedule&rs:Command=Render
> >> >
> >> > TIA
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>|||Thanks for replay. But the parameters are only a couple of integers, and it
runs fine in VS .net.
"Mary Bray [SQL Server MVP]" wrote:
> Maybe the parameter values are too long?
> "wd1153" wrote:
> > how might be the solution? thanks
> >
> > "Wayne Snyder" wrote:
> >
> > > IT sounds like the URL of the report is too long, even though the URL you
> > > post isn't that long...
> > >
> > > --
> > > Wayne Snyder, MCDBA, SQL Server MVP
> > > Mariner, Charlotte, NC
> > > www.mariner-usa.com
> > > (Please respond only to the newsgroups.)
> > >
> > > I support the Professional Association of SQL Server (PASS) and it's
> > > community of SQL Server professionals.
> > > www.sqlpass.org
> > >
> > > "wd1153" <wd1153@.discussions.microsoft.com> wrote in message
> > > news:72710497-4078-44FE-94D7-307B737B15EF@.microsoft.com...
> > > > Hi
> > > >
> > > > I have beening trying to build a report with 2 parameters. When I run it
> > > > under VS.net preview, it all went well, but after I deploy it to the
> > > > server, I got
> > > > the message as following: **Reporting Services Error--The path of the item
> > > > ''
> > > > is not valid. The full path must be less than 260 characters long, must
> > > > start
> > > > with slash; other restrictions apply. Check the documentation for complete
> > > > set of restrictions. (rsInvalidItemPath) Get Online Help **
> > > > what went wrong, please help.
> > > >
> > > > the URL for the report as following:
> > > >
> > > > http://localhost/ReportServer?%2fMyReports%2fORSchedule&rs:Command=Render
> > > >
> > > > TIA
> > > >
> > > >
> > > >
> > >
> > >
> > >|||I know the URL which you show is not too long, but the error seemed to
indicate it...
I wonder if there is an image or other item in the report, which may have a
URL which is longer than 260 chars... I do think that the way images are
referenced is different in the dev env than in prod... check to see if
there are any long object references...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"wd1153" <wd1153@.discussions.microsoft.com> wrote in message
news:72710497-4078-44FE-94D7-307B737B15EF@.microsoft.com...
> Hi
> I have beening trying to build a report with 2 parameters. When I run it
> under VS.net preview, it all went well, but after I deploy it to the
> server, I got
> the message as following: **Reporting Services Error--The path of the item
> ''
> is not valid. The full path must be less than 260 characters long, must
> start
> with slash; other restrictions apply. Check the documentation for complete
> set of restrictions. (rsInvalidItemPath) Get Online Help **
> what went wrong, please help.
> the URL for the report as following:
> http://localhost/ReportServer?%2fMyReports%2fORSchedule&rs:Command=Render
> TIA
>
>|||Good idea. This will show up from Report Manager. Right now he has only
tried it from his web app, not from Report Manager.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OINwq$QZFHA.3864@.TK2MSFTNGP10.phx.gbl...
>I know the URL which you show is not too long, but the error seemed to
>indicate it...
> I wonder if there is an image or other item in the report, which may have
> a URL which is longer than 260 chars... I do think that the way images are
> referenced is different in the dev env than in prod... check to see if
> there are any long object references...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "wd1153" <wd1153@.discussions.microsoft.com> wrote in message
> news:72710497-4078-44FE-94D7-307B737B15EF@.microsoft.com...
>> Hi
>> I have beening trying to build a report with 2 parameters. When I run it
>> under VS.net preview, it all went well, but after I deploy it to the
>> server, I got
>> the message as following: **Reporting Services Error--The path of the
>> item ''
>> is not valid. The full path must be less than 260 characters long, must
>> start
>> with slash; other restrictions apply. Check the documentation for
>> complete
>> set of restrictions. (rsInvalidItemPath) Get Online Help **
>> what went wrong, please help.
>> the URL for the report as following:
>> http://localhost/ReportServer?%2fMyReports%2fORSchedule&rs:Command=Render
>> TIA
>>
>

No comments:

Post a Comment