rsExecutionNotFound error

Hello,

I am developing a report viewer application in ASP.NEt 2.0 and in that I have a page called ReportViewer.aspx page which has a report viewer control. The processing mode is remote and it is a SQL Server 2005. There are a couple of dropdownlists one which defines the names of the different reports and the other the reporting periods. Depending on the selection made by the user, the call is made to the reporting server and reporst are displayed. Initially when the page loads, the reports show up without any problems. But if a user is inactive for a while, and the user tries to the view the report, I get the following error

"Execution 'tmf3wgqtzuasux3trzliwx25' cannot be found (rsExecutionNotFound) "

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Reporting.WebForms.ReportServerException: Execution 'tmf3wgqtzuasux3trzliwx25' cannot be found (rsExecutionNotFound).

I did some research and came across this post which is the exact error which i am getting.

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124525

The above link is not working for some reason but if you click on the link below, it says that the issue has been fixed. But there is no information as to how to fix this. Does anybody have any idea as to what the solution is?This is the exact same error which I am getting and any help to resolve this error would be great.

http://64.233.183.104/search?q=cache:H2UEJj42ypcJ:connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx%3FFeedbackID%3D124525+rsExecutionNotFound+%2B+2005&hl=en&ct=clnk&cd=1&gl=us

There are some posts which advise to add the a guid at the end of the url but if you are using a viewer you cannot add anything else to the .ServerReport.ReportURL property other than the path to the report or else it returns an error.

As per my knowledge, the report veiwer control should be keeping the session alive using keep alive messages. There is also the possibility of IE caching and one can disable it by going to Tools -> Options and disabling the caching. But this is not something which I can tell my customers to do.

Any help would be greatly appreciated.

Regards,

arpan

Arpan,

My team came across this error a while ago, and found that Reporting Services has it's own session that is timing out. In the ReportServer database, there is a table called ConfigurationInfo. In this table there are values for a SessionTimeout and SessionAccessTimeout. I think the default is set to '600'. This value corresponds to the number of seconds that the report session will be open.

Our solution was to bump this number way up, say to a couple of hours or more. The problem with this is then you get a lot of data in the ReportServerTempDB, which may cause headaches. It's not a perfect solution, and this property should be more easily editable.

The other way to set this property is to use some Reporting Service Scripting, .rss files, and run them using the rs.exe utility that was installed with Reporting Services. There is a Good blog about this by John Gallardo (?) I think.

Good Luck,

Mac

blog url: http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

|||

Mac.

Thanks for the quick reply. I shall try it out tomorrow and see if that helps.

Regards.

arpan

rsExecutionNotFound

I wrote a Custom Web App using ASP.NET for reports built using SSRS 2005. The web application uses report viewer control to display the reports. The Report Viewer processing mode is set to "Remote". The session timeout for web application is 30 minutes.

Reports autorefresh property is set to 15 minutes. when the web page thats displaying the reports is running continously, I am occassionally seeing "rsExecutionNotFound" error. The error is not going away even if I refresh the page.

Thanks for u'r help.

Dear NR01,

There could be a possibility that the session of reporting services is timing out.

Try this post

HTH,

Suprotim Agarwal

|||

Hi,

I tried the post you mentioned. when I run the reports continously, still I am seeing rsExecutionNotFound error but not as frequent as before.

I set the timeout to 30 min.

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="1800"

I am refreshing the reports every 15min.

Thanks for u'r help.

-NR01

|||

I also did the same and set the timeout=1800.

I still get many of these failures. I didn't notice any changes going from 600 to 1800.

This is a typical error:

w3wp!ui!7!7/23/2007-04:52:49:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Execution 'c14v5l45yikbbo55d5vk1jj3' cannot be found (rsExecutionNotFound)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

I can't imagine that people are sitting on a page for more than 30 minutes. Could there be another cause?

Neil

|||

I've solved the same issue.

I'm viewing reports with asp.net reportviewer; on production server, my aspx load correctly the report at first time, but any postback returns "rsExecutionNotFound" error.

I realized my aspx code contains hard-coded reportserverurl and reportpath values, which are different for development and production envs. So when I dynamically set up thoses settings in my page, reportviewer kill its client session since I'm changing the report path from one server to another.

So change :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport ReportServerUrl="http://DEVSERVER/ReportServer" ReportPath="/MyPath" />

</rsweb:ReportViewer>

To :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport />

</rsweb:ReportViewer>

sql

rsExecutionNotFound

I wrote a Custom Web App using ASP.NET for reports built using SSRS 2005. The web application uses report viewer control to display the reports. The Report Viewer processing mode is set to "Remote". The session timeout for web application is 30 minutes.

Reports autorefresh property is set to 15 minutes. when the web page thats displaying the reports is running continously, I am occassionally seeing "rsExecutionNotFound" error. The error is not going away even if I refresh the page.

Thanks for u'r help.

Dear NR01,

There could be a possibility that the session of reporting services is timing out.

Try this post

HTH,

Suprotim Agarwal

|||

Hi,

I tried the post you mentioned. when I run the reports continously, still I am seeing rsExecutionNotFound error but not as frequent as before.

I set the timeout to 30 min.

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="1800"

I am refreshing the reports every 15min.

Thanks for u'r help.

-NR01

|||

I also did the same and set the timeout=1800.

I still get many of these failures. I didn't notice any changes going from 600 to 1800.

This is a typical error:

w3wp!ui!7!7/23/2007-04:52:49:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Execution 'c14v5l45yikbbo55d5vk1jj3' cannot be found (rsExecutionNotFound)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

I can't imagine that people are sitting on a page for more than 30 minutes. Could there be another cause?

Neil

|||

I've solved the same issue.

I'm viewing reports with asp.net reportviewer; on production server, my aspx load correctly the report at first time, but any postback returns "rsExecutionNotFound" error.

I realized my aspx code contains hard-coded reportserverurl and reportpath values, which are different for development and production envs. So when I dynamically set up thoses settings in my page, reportviewer kill its client session since I'm changing the report path from one server to another.

So change :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport ReportServerUrl="http://DEVSERVER/ReportServer" ReportPath="/MyPath" />

</rsweb:ReportViewer>

To :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport />

</rsweb:ReportViewer>

rsDataSourceNotFound error in SSRS 2005

As soon as a report is re-deployed a refresh of the report in the viewer shows the following error message:

An error has occurred during report processing. (rsProcessingAborted)

The data source 'xxx' cannot be found. (rsDataSourceNotFound)

This error occurs irrespective of electing to re-deploy or not re-deploy the datasource, and the only solution seems to be to close the report viewer down and restart it.

Under RS2000 any changes that were made to a report, would automatically be shown to the user if the report was refreshed, without having to close the browser/application down and restart it.

How do I get around this error?

Pl let me know if anyone has encountered this error?

rsDataSourceNotFound error in SSRS 2005

As soon as a report is re-deployed a refresh of the report in the viewer shows the following error message:

An error has occurred during report processing. (rsProcessingAborted)

The data source 'xxx' cannot be found. (rsDataSourceNotFound)

This error occurs irrespective of electing to re-deploy or not re-deploy the datasource, and the only solution seems to be to close the report viewer down and restart it.

Under RS2000 any changes that were made to a report, would automatically be shown to the user if the report was refreshed, without having to close the browser/application down and restart it.

How do I get around this error?

Pl let me know if anyone has encountered this error?

rsAccessDenied

The permissions granted to user 'localmachine\ASPNET' are insufficient for performing this operation.

am using a report viewer on an aspx page that i call using javascript. the report work if the url have the port number for examplehttp://localhost:4254/adressofthereport but if i put for examplehttp://localmachinename/adressofthereport i get the permission error.

why this happen to me... please help.

i fix this inserting the localmachine\ASPNET user in the reports permissions

BUILTIN\administrator

localmachine\ASPNET

maybe you need to add dbowner o sysad access level to this user.

|||

Thanks.I am having same problem and i found the solution thanks.

RS2005 Web ReportViewer: Unable to set parameters and ReportServerCredentials

Hey guys,
I'm using the report viewer web control in my web application. I got it
somewhat working but now I'm stuck:
1) I can't set the parameters for the report. When I call SetParameters and
pass a ReportParameter array, it complains that this report doesn't have
parameter 'XYZ'. But in reality it does. My suspicion was that the
ServerReport object is not filled with report data yet.
So I called GetParameters beforehand to see if it would initialize the
parameters collection. Then I found out that the parameters collection is
set to read-only, which means I can't set parameter values in an initialized
parameter collection.
Last try was to call SetParameters after calling GetParameters but I got the
same exception as when calling w/o GetParameters.
2) I need to pass ReportServerCredentials to RS because of course ASPNET
does not have access rights to RS. The only property that is not read-only
underneath the ReportServerCredentials property is the
ReportServerCredentials itself, which is of type IReportServerCredentials.
So far I couldn't find any credentials object that implements this
interface.
Anybody any idea?
Thanks, ChristophI have the same problem, did anyone ever respond to you?
"Christoph Wienands" wrote:
> Hey guys,
> I'm using the report viewer web control in my web application. I got it
> somewhat working but now I'm stuck:
> 1) I can't set the parameters for the report. When I call SetParameters and
> pass a ReportParameter array, it complains that this report doesn't have
> parameter 'XYZ'. But in reality it does. My suspicion was that the
> ServerReport object is not filled with report data yet.
> So I called GetParameters beforehand to see if it would initialize the
> parameters collection. Then I found out that the parameters collection is
> set to read-only, which means I can't set parameter values in an initialized
> parameter collection.
> Last try was to call SetParameters after calling GetParameters but I got the
> same exception as when calling w/o GetParameters.
> 2) I need to pass ReportServerCredentials to RS because of course ASPNET
> does not have access rights to RS. The only property that is not read-only
> underneath the ReportServerCredentials property is the
> ReportServerCredentials itself, which is of type IReportServerCredentials.
> So far I couldn't find any credentials object that implements this
> interface.
> Anybody any idea?
> Thanks, Christoph
>
>

RS2005 viewer control connection problem.

I am using the reporting services reportviewer control from Visual Studio®
2005 Beta 2.
When I run a repmote report I get the following error:
[WebException: The request was aborted: The connection was closed
unexpectedly.]
I can access the report from my browser doing a straight url access.
I am using RS2005 (did not install anything other than that from SQLServer
2005 cd) on Windows 2003 server, and a SQLserver 2000 back end on a different
machine for RS engine.
The report data source is on the same SQL server machine as the RS database.
can anyone explain what is happening.
Thanks Fred
--
FredI'm having the same problem here.
VS 2005 Beta 2, SQL 2005 April CTP.
Have you found what was causing the problem?
Anderson
Fred escreveu:
> I am using the reporting services reportviewer control from Visual Studio==AE
> 2005 Beta 2.
> When I run a repmote report I get the following error:
> [WebException: The request was aborted: The connection was closed
> unexpectedly.]
> I can access the report from my browser doing a straight url access.
> I am using RS2005 (did not install anything other than that from SQLServer
> 2005 cd) on Windows 2003 server, and a SQLserver 2000 back end on a diffe=rent
> machine for RS engine.
> The report data source is on the same SQL server machine as the RS databa=se.
> can anyone explain what is happening.
> > Thanks Fred
> > > > > > > -- > Fred|||No,
due to other we may actually not user RS2005 anyway, so not such a burnig
issue for the moment.
I still would like to know what's going on though.
I'm using SQLServer 2000 as the RS backend, the datasource is on the same
machine as SQL2000. RS sits on its own machine.
--
Fred
"Anderson dos Santos Pimentel" wrote:
> I'm having the same problem here.
> VS 2005 Beta 2, SQL 2005 April CTP.
> Have you found what was causing the problem?
>
> Anderson
>
> Fred escreveu:
> > I am using the reporting services reportviewer control from Visual Studio®
> > 2005 Beta 2.
> >
> > When I run a repmote report I get the following error:
> >
> > [WebException: The request was aborted: The connection was closed
> > unexpectedly.]
> >
> > I can access the report from my browser doing a straight url access.
> >
> > I am using RS2005 (did not install anything other than that from SQLServer
> > 2005 cd) on Windows 2003 server, and a SQLserver 2000 back end on a different
> > machine for RS engine.
> >
> > The report data source is on the same SQL server machine as the RS database.
> >
> > can anyone explain what is happening.
> >
> > Thanks Fred
> >
> >
> >
> >
> >
> >
> > --
> > Fred
>|||I've finally found the problem.
I was dumb enough to mistype the server's name... :-)
Now, it's OK!
Andersonsql

RS2005 insufficient permissions

So when I run the report in the Report Manager, everything is all good. When
I run it in a webform using report viewer for vs.net 2005 the view reports
this error.
"The permissions granted to the user 'NT AUTHORITY\NETWORK SERVICE' are
insufficient for performing this operation(rsAccessDenied)"
What interesting when RS2005 install on XP Professional setting for
webservice identity shows ASPNET and reports work on that machine in report
viewer control. But when running on Windows 2003 Server, it uses default pool
and NETWORK SERVICE ACCOUNT by default which I think is the problem. Any idea
or anyone run into this.Curious if anyone now the bare minimum to run 2005 report in a webform.aspx
using report viewer. ASPNET was enough on XP Pro runnng RS2005 locally. But
it's different on a Server. This is obviously a good thing, wondered how I
can find the bare minimum without assigning Everyone as I discovered fixed
the problem below:
Well thought post the hack on this one. So what I ended testing and showed
success, in report manager I temporarily aded new role, "Everyone" with
browse only rights on the Home directory security roles in report manager,
now the report loads.
----
I would like to let people now, we where in a crunch to get it working, but
would love to hear how RS2005 has maybe been change to use forms
authentication or some solution for people that now danger running ASPNET
identity to access sensitive data, but have their surround website secured.
---
So my next step:
1) revert securty at Home level on report manager to only Administrator role.
2) add folder for reports and deploy the reports to the new folder on the
report server
3) use seperate permissions on folder then the home root. For newbie, you do
this by clicking on the folder in report manager, click properties and
security. Then use new role and choose yes to warning that you want these
roles seperate from home security. This allows the report to run in our
webform.aspx as the website is protect with form authentications.
"Rob G" wrote:
> So when I run the report in the Report Manager, everything is all good. When
> I run it in a webform using report viewer for vs.net 2005 the view reports
> this error.
> "The permissions granted to the user 'NT AUTHORITY\NETWORK SERVICE' are
> insufficient for performing this operation(rsAccessDenied)"
> What interesting when RS2005 install on XP Professional setting for
> webservice identity shows ASPNET and reports work on that machine in report
> viewer control. But when running on Windows 2003 Server, it uses default pool
> and NETWORK SERVICE ACCOUNT by default which I think is the problem. Any idea
> or anyone run into this.
>|||When you were developing before (everything on one machine) you were the
administrator on the machine and that is why everything worked. What I do is
have a local group, I add domain users and groups to that (for instance add
a group called Reports). Give them browse rights at home. The other folders
will inherit. In most cases all the users have rights to all the folders. If
not, change for the specific folder.
You definitely do not want to do anonymous.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob G" <RobG@.discussions.microsoft.com> wrote in message
news:2C5D679B-E5CD-4ECF-8F44-00E47F5DAB3E@.microsoft.com...
> Curious if anyone now the bare minimum to run 2005 report in a
> webform.aspx
> using report viewer. ASPNET was enough on XP Pro runnng RS2005 locally.
> But
> it's different on a Server. This is obviously a good thing, wondered how I
> can find the bare minimum without assigning Everyone as I discovered fixed
> the problem below:
> Well thought post the hack on this one. So what I ended testing and showed
> success, in report manager I temporarily aded new role, "Everyone" with
> browse only rights on the Home directory security roles in report manager,
> now the report loads.
> ----
> I would like to let people now, we where in a crunch to get it working,
> but
> would love to hear how RS2005 has maybe been change to use forms
> authentication or some solution for people that now danger running ASPNET
> identity to access sensitive data, but have their surround website
> secured.
> ---
> So my next step:
> 1) revert securty at Home level on report manager to only Administrator
> role.
> 2) add folder for reports and deploy the reports to the new folder on the
> report server
> 3) use seperate permissions on folder then the home root. For newbie, you
> do
> this by clicking on the folder in report manager, click properties and
> security. Then use new role and choose yes to warning that you want these
> roles seperate from home security. This allows the report to run in our
> webform.aspx as the website is protect with form authentications.
>
>
> "Rob G" wrote:
>> So when I run the report in the Report Manager, everything is all good.
>> When
>> I run it in a webform using report viewer for vs.net 2005 the view
>> reports
>> this error.
>> "The permissions granted to the user 'NT AUTHORITY\NETWORK SERVICE' are
>> insufficient for performing this operation(rsAccessDenied)"
>> What interesting when RS2005 install on XP Professional setting for
>> webservice identity shows ASPNET and reports work on that machine in
>> report
>> viewer control. But when running on Windows 2003 Server, it uses default
>> pool
>> and NETWORK SERVICE ACCOUNT by default which I think is the problem. Any
>> idea
>> or anyone run into this.
>>

RS2000/VS2003 RS2005 Viewer control

We have reports written using Visual Studio 2003, and deployed on a server
running Reporting services 2000. This is OK and working.
Is it possible to write a web page using Visual Studio 2005, and the new
ReportViewer control (Microsoft.Reporting.WebForms.ReportViewer
) to render these reports.
I'm setting the ReportPath and ReportServerUrl but I'm getting the following
error.
Using VS2003 and the RS2000 webservice with the same values worked...
[WebException: The request failed with HTTP status 404: Not Found.]
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +242
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +68
[MissingEndpointException: The attempt to connect to the report server
failed. Check your connection information and that the report server is a
compatible version.]
Microsoft.SqlServer.ReportingServices2005.Execution.MissingEndpointException.ThrowIfEndpointMissing(WebException e) +129
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +147
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean
useCurrentValues) +137
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +184
System.Web.UI.Control.PreRenderRecursiveInternal() +148
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5036
Any help appreciated.
--
FredThe Report Viewer control requires running against RS2005.
There are Server side changes that RS2000 does not have.
--
| Thread-Topic: RS2000/VS2003 RS2005 Viewer control
| thread-index: AcWol1mSmeVTJhrpSOyD8QdgJNzP3g==| X-WBNR-Posting-Host: 62.188.58.81
| From: "=?Utf-8?B?RnJlZA==?=" <Fred@.discussions.microsoft.com>
| Subject: RS2000/VS2003 RS2005 Viewer control
| Date: Wed, 24 Aug 2005 03:34:04 -0700
| Lines: 50
| Message-ID: <2E7C722F-2A27-4176-816E-10517D4B25DC@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:51025
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| We have reports written using Visual Studio 2003, and deployed on a
server
| running Reporting services 2000. This is OK and working.
|
| Is it possible to write a web page using Visual Studio 2005, and the new
| ReportViewer control (Microsoft.Reporting.WebForms.ReportViewer
| ) to render these reports.
|
|
| I'm setting the ReportPath and ReportServerUrl but I'm getting the
following
| error.
|
| Using VS2003 and the RS2000 webservice with the same values worked...
|
|
|
| [WebException: The request failed with HTTP status 404: Not Found.]
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Ge
tSecureMethods() +242
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Is
SecureMethod(String methodname) +86
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Se
tConnectionSSLForMethod(String methodname) +33
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Lo
adReport(String Report, String HistoryID) +68
|
| [MissingEndpointException: The attempt to connect to the report server
| failed. Check your connection information and that the report server is
a
| compatible version.]
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.MissingEndpointException
ThrowIfEndpointMissing(WebException e) +129
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Lo
adReport(String Report, String HistoryID) +147
| Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
| Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
|
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean
| useCurrentValues) +137
| Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +184
| System.Web.UI.Control.PreRenderRecursiveInternal() +148
| System.Web.UI.Control.PreRenderRecursiveInternal() +233
| System.Web.UI.Control.PreRenderRecursiveInternal() +233
| System.Web.UI.Page.ProcessRequestMain(Boolean
| includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5036
|
|
|
|
| Any help appreciated.
|
| --
| Fred
|

rs:SessionID= does not work

I want to render a PDF report and view the copy of the report in the HTML
viewer. What I did is to use rs.Render(...) to get the PDF report and the
SessionID, and then pass the SessionID to the URL string and run the URL.
But the rs:SessionID=xxxxx command does not work, it alway create a new
session for the report.
This part of the code works fine to generate a PDF file for me and save a
session id in m_SessionID:
byte[] results = null;
string historyID = null;
string devInfo = @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
SessionHeader sh = new SessionHeader();
rs.SessionHeaderValue = sh;
results = rs.Render(
this.ReportConfig.ReportName,
"PDF",
historyID,
devInfo,
parameters,
credentials,
showHideToggle, out encoding, out mimeType, out
reportHistoryParameters,
out warnings,
out streamIDs);
m_SessionID = rs.SessionHeaderValue.SessionId;
But when I use the generated sesionid for the URL access like this:
url = "http://guoxp.softbrandsamer.com/reportserver?%2fInvItmb&rs:Command=Render&r
s:SessionID=" + m_SessionID
it will create a new instance. And when I looked at the SessionData table in
the ReportServerTempDB, a new session is created.
How to make it work? Please help. Thanks,
LianghongDid you ever find a work around for this. It doesn't seem to be working for
me either.
"Guo, Lianghong" wrote:
> I want to render a PDF report and view the copy of the report in the HTML
> viewer. What I did is to use rs.Render(...) to get the PDF report and the
> SessionID, and then pass the SessionID to the URL string and run the URL.
> But the rs:SessionID=xxxxx command does not work, it alway create a new
> session for the report.
> This part of the code works fine to generate a PDF file for me and save a
> session id in m_SessionID:
> byte[] results = null;
> string historyID = null;
> string devInfo = @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
> SessionHeader sh = new SessionHeader();
> rs.SessionHeaderValue = sh;
> results = rs.Render(
> this.ReportConfig.ReportName,
> "PDF",
> historyID,
> devInfo,
> parameters,
> credentials,
> showHideToggle, out encoding, out mimeType, out
> reportHistoryParameters,
> out warnings,
> out streamIDs);
> m_SessionID = rs.SessionHeaderValue.SessionId;
> But when I use the generated sesionid for the URL access like this:
> url => "http://guoxp.softbrandsamer.com/reportserver?%2fInvItmb&rs:Command=Render&r
> s:SessionID=" + m_SessionID
> it will create a new instance. And when I looked at the SessionData table in
> the ReportServerTempDB, a new session is created.
> How to make it work? Please help. Thanks,
> Lianghong
>
>|||Hi
I've the same problem with the session an rs:SessionId, anyone knwo a
solution'
Thanks
"debra doty" wrote:
> Did you ever find a work around for this. It doesn't seem to be working for
> me either.
> "Guo, Lianghong" wrote:
> > I want to render a PDF report and view the copy of the report in the HTML
> > viewer. What I did is to use rs.Render(...) to get the PDF report and the
> > SessionID, and then pass the SessionID to the URL string and run the URL.
> > But the rs:SessionID=xxxxx command does not work, it alway create a new
> > session for the report.
> >
> > This part of the code works fine to generate a PDF file for me and save a
> > session id in m_SessionID:
> >
> > byte[] results = null;
> > string historyID = null;
> > string devInfo = @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
> >
> > SessionHeader sh = new SessionHeader();
> > rs.SessionHeaderValue = sh;
> > results = rs.Render(
> > this.ReportConfig.ReportName,
> > "PDF",
> > historyID,
> > devInfo,
> > parameters,
> > credentials,
> > showHideToggle, out encoding, out mimeType, out
> > reportHistoryParameters,
> > out warnings,
> > out streamIDs);
> > m_SessionID = rs.SessionHeaderValue.SessionId;
> >
> > But when I use the generated sesionid for the URL access like this:
> > url => > "http://guoxp.softbrandsamer.com/reportserver?%2fInvItmb&rs:Command=Render&r
> > s:SessionID=" + m_SessionID
> >
> > it will create a new instance. And when I looked at the SessionData table in
> > the ReportServerTempDB, a new session is created.
> >
> > How to make it work? Please help. Thanks,
> >
> > Lianghong
> >
> >
> >

RS, error.

When we have installed the Reporting Services, it leaves an error to us in
event to viewer. This it is the error:
Schedule and delivery processor
Error id event 113
somebody has had this problem?
ThanksWhat if anything do you get in the log files?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_1m61.asp
--
Adrian M.
MCP
"CésarMoM" <cesarantolin@.hotmail.com> wrote in message
news:eXtqEQZHFHA.2936@.TK2MSFTNGP15.phx.gbl...
> When we have installed the Reporting Services, it leaves an error to us in
> event to viewer. This it is the error:
> Schedule and delivery processor
> Error id event 113
> somebody has had this problem?
> Thanks
>

RS Web Part Scrolling

I have installed 4 RS Viewer Web Parts on a share point page. When I
click on the + sign to expand the detail of a report the detail area
scrolls to the top of the sharepoint page. If all four web parts were
viewable and you were on the 2nd one down from the top, the first one
completely disappears. The only way to see it is to use the scroll bar
to move to the top of the page again. This behavior only happens with
RS Web Parts. This is very anoying as you must find your place on the
page everytime you click on a + or - sign. The page is always jumping
around.
Does anybody know how to stop this?Hi
It would be great if anyone can responde to this question since I'm having
the same problem. My end users are getting so anoyed that they have no
interest in using any drill-down reports. As soon as a report is anything
other than a very basic report with only one or two grouping levels,
drill-down functionality is useless.
This is very bad for those of us that recommended SQL RS to our
organizations as an enterprise reporting solution.
Can someone please help us with this?
"Jiles" wrote:
> I have installed 4 RS Viewer Web Parts on a share point page. When I
> click on the + sign to expand the detail of a report the detail area
> scrolls to the top of the sharepoint page. If all four web parts were
> viewable and you were on the 2nd one down from the top, the first one
> completely disappears. The only way to see it is to use the scroll bar
> to move to the top of the page again. This behavior only happens with
> RS Web Parts. This is very anoying as you must find your place on the
> page everytime you click on a + or - sign. The page is always jumping
> around.
> Does anybody know how to stop this?
>

RS asking for credentials

We have SP2 installed.
Our app uses the new viewer control.
Right now every time the app asks for a report the RS is asking to login
credentials.
Prior to today sometimes it would and sometimes it wouldn't.
We're on an intranet so anyone in the domain can run/view a report.
It seems like I've changed or missed some setting so RS doesn't as for
credentials.
Can someone point me in the rightr direction.
Thanks
Kyle!Sorry...meant SP1.
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:OPwU8qDbFHA.464@.TK2MSFTNGP15.phx.gbl...
> We have SP2 installed.
> Our app uses the new viewer control.
> Right now every time the app asks for a report the RS is asking to login
> credentials.
> Prior to today sometimes it would and sometimes it wouldn't.
> We're on an intranet so anyone in the domain can run/view a report.
> It seems like I've changed or missed some setting so RS doesn't as for
> credentials.
> Can someone point me in the rightr direction.
> Thanks
> Kyle!
>

RS 2005 SP2 in Sharepoint integrated mode

Up until an hour ago, I was using the Sql Server Reporting Services Report Viewer webpart in Sharepoint with forms authentication, and was not having an issue. The only thing that I did (or remember doing) before things went sour was upload a new report to the document list and since then whenever I try to access a report, manage the data source on a report, change the report URL in the webpart, I get the following message:

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with the error message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/_layouts/login.aspx?ReturnUrl=%2f_vti_bin%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>

--.

I found some related posts and have tried the following, but none have helped:

Removed all reports and reuploaded only the one that was definitely working.

I changed the application pool for the report server to be the same app pool as Sharepoint (runs under domain admin account).

I changed the application pool for the report server back to it's original (which the Reporting Services Configuration prefers - was running under Network Service acct before the problem started, now running under domain admin acct)

I can browse to http://server/reportserver.

I'm running under forms authentication, which had been working.

I can access the three configs for Reporting Services under Application Management in Central Admin - I've tried changing the settings.

I can access http://server/_vti_bin/reportserver/reportservice2006.asmx as well as http://server/_vti_bin/reportserver/reportserviceauthentication.asmx (that was suggested in one post)

I've restarted IIS numerous times, and also finally rebooted the server.

I've created a new document list and set it for report content, just like the other list.

I also just noticed that even though I've set up my admin account as a site collection administrator, I now no longer see my report options under the New button in the document library (both the old and new). I don't know if this is related.

I'm sure that this is a case of something minor that I did that I forgot about. Any suggestions or other troubleshooting that I can do?

Thanks!

daw

Has anyone seen an error like this? Do I need to reinstall reporting services?

Thanks for any advice that you can give me!

daw

|||Hi Daw,

This is just a shot in the dark but have you tried the last step in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1170221&SiteID=1 :

3. If you've run the

installer multiple times, there may be duplicate entries in the

web.config file. Open web.config which by default should be in

C:\Inetpub\wwwroot\wss\VirtualDirectories\80 . In that file make sure

there is only one entry for "ReportServiceAuthentication.asmx". If

there is more than one entry, delete the extra tag.

Thanks,
Josh
|||

Thanks, Josh! I checked, and there is only one entry in the web.config.

I have determined that it must be something to do with forms authentication. When I changed the authentication provider back to Windows and logged into the site, I'm able to use the report viewer and access the reports. I can also add New data sources in the document library. No permissions have been changed that I'm aware of, so I'm not sure where to check. I've looked at the security on some of the folders, but it appears to be correct. Do you know why forms authentication would not work? It had been working just fine. The forms authentication user is set up as the site administrator, and is in the owners Sharepoint group which has full control.

Thanks!!

daw

|||

It looks like it may not even be related to the RS add-in, unless it's related to SP2. I removed the add-in and I still have the problem in document libraries under forms authentication. I can see the New, Upload, Actions and Settings buttons in the document libraries, but I do not have an option to create a new document (or other content type), however I have the option and can create a new folder. I have the option to upload one document at a time, but not multiple. It's almost like I have partial permissions. This user is the site collection administrator, is in the Owners Sharepoint group which has full control, and I even added the user with full control.

Any ideas on where this permissions issue could be stemming from? Windows authentication works just fine.

daw

|||

<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/_layouts/login.aspx?ReturnUrl=%2f_vti_bin%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>

The above error message happened when you acccess a web site configured with forms auth but your request does not carry the forms auth cookie. Usually browser will automatically add it in after you log in. Did you see frequent timeout happneing?

It should not related to report server itself because the request has not got to report server yet. Can you create a new web app and try to see whether it still repros?

|||

No timeouts, no prompts to login again.

I ran a repair on Sharepoint, but no change. It looks like I may need to uninstall and reinstall Sharepoint since I can't find an answer. I'm just concerned that it may happen again.

Thanks for the help!

daw

|||

The issue with not being able to add a new document or other content type was related to the Authentication Provider setup in Central Admin. By default, the Enable Client Integration? for forms authentication is set to No. When I changed it to Yes, I saw the New Document, etc.

I'm still getting the error when accessing the Reporting Services add-in. I've uninstalled and reinstalled Sharepoint, as well as Reporting Services and the add-in. No change. Has anyone else come across this error?

daw

|||

Reporting Services and Sharepoint both support forms authentication, but they are not compatible. See the Note in this document, http://msdn2.microsoft.com/en-us/library/bb283324.aspx

I'm not sure how it was ever working in the first place.

Hope this helps someone else!

daw