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

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

ReportParameters(0) = New ReportParameter("ProjectKey", 262)
rv.ShowParameterPrompts = False
rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
rv.ServerReport.SetParameters(ReportParameters)

Have you properly granted permission for your web user? Go to the configuration tool, and look for any red X on the left hand side. Open the "Web service identity" and make sure your web user is 'NT AUTHORITY\NETWORK SERVICE". Then go to "Database Setup" panel. I think you are using "Service Credentials". Reapply the settings may fix your problem.|||

I have NT AUTHORITY\NetworkService as the service account (it is grayed out so it is not possible to change), and I have Service Credentials as the credentials type in the database setup. There are no red X's. Still get the same error.

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

|||Netman has both local activation AND execution|||Do you see Network Services part of RSExec role in your report server catalog db and temp db?|||Yes|||Yes, Network Services is RSExec role in report server catalog db and temp db.|||It looks like Network Service account is not allowed to set parameters. I am not sure what is the mininum permission set. Can you try adding the account as a content manager to the home folder?|||If I right-click in design view in VS2005, the report runs fine. It doesn't work when I try to run in a browser and is being served up by my dev IIS server.|||I have added the NetworkService as administrator and still no go.|||That did it. Was confused in the ReportManager. Simple fix. Seems like lots of people having same problem. Thank you for your help|||Sorry--Don't follow what the fix was. What did it?|||

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

ReportParameters(0) = New ReportParameter("ProjectKey", 262)
rv.ShowParameterPrompts = False
rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
rv.ServerReport.SetParameters(ReportParameters)

Have you properly granted permission for your web user? Go to the configuration tool, and look for any red X on the left hand side. Open the "Web service identity" and make sure your web user is 'NT AUTHORITY\NETWORK SERVICE". Then go to "Database Setup" panel. I think you are using "Service Credentials". Reapply the settings may fix your problem.|||

I have NT AUTHORITY\NetworkService as the service account (it is grayed out so it is not possible to change), and I have Service Credentials as the credentials type in the database setup. There are no red X's. Still get the same error.

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

|||Netman has both local activation AND execution|||Do you see Network Services part of RSExec role in your report server catalog db and temp db?|||Yes|||Yes, Network Services is RSExec role in report server catalog db and temp db.|||It looks like Network Service account is not allowed to set parameters. I am not sure what is the mininum permission set. Can you try adding the account as a content manager to the home folder?|||If I right-click in design view in VS2005, the report runs fine. It doesn't work when I try to run in a browser and is being served up by my dev IIS server.|||I have added the NetworkService as administrator and still no go.|||That did it. Was confused in the ReportManager. Simple fix. Seems like lots of people having same problem. Thank you for your help|||Sorry--Don't follow what the fix was. What did it?|||

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

ReportParameters(0) = New ReportParameter("ProjectKey", 262)
rv.ShowParameterPrompts = False
rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
rv.ServerReport.SetParameters(ReportParameters)

Have you properly granted permission for your web user? Go to the configuration tool, and look for any red X on the left hand side. Open the "Web service identity" and make sure your web user is 'NT AUTHORITY\NETWORK SERVICE". Then go to "Database Setup" panel. I think you are using "Service Credentials". Reapply the settings may fix your problem.|||

I have NT AUTHORITY\NetworkService as the service account (it is grayed out so it is not possible to change), and I have Service Credentials as the credentials type in the database setup. There are no red X's. Still get the same error.

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

|||Netman has both local activation AND execution|||Do you see Network Services part of RSExec role in your report server catalog db and temp db?|||Yes|||Yes, Network Services is RSExec role in report server catalog db and temp db.|||It looks like Network Service account is not allowed to set parameters. I am not sure what is the mininum permission set. Can you try adding the account as a content manager to the home folder?|||If I right-click in design view in VS2005, the report runs fine. It doesn't work when I try to run in a browser and is being served up by my dev IIS server.|||I have added the NetworkService as administrator and still no go.|||That did it. Was confused in the ReportManager. Simple fix. Seems like lots of people having same problem. Thank you for your help|||Sorry--Don't follow what the fix was. What did it?|||

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

ReportParameters(0) = New ReportParameter("ProjectKey", 262)
rv.ShowParameterPrompts = False
rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
rv.ServerReport.SetParameters(ReportParameters)

Have you properly granted permission for your web user? Go to the configuration tool, and look for any red X on the left hand side. Open the "Web service identity" and make sure your web user is 'NT AUTHORITY\NETWORK SERVICE". Then go to "Database Setup" panel. I think you are using "Service Credentials". Reapply the settings may fix your problem.|||

I have NT AUTHORITY\NetworkService as the service account (it is grayed out so it is not possible to change), and I have Service Credentials as the credentials type in the database setup. There are no red X's. Still get the same error.

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

|||Netman has both local activation AND execution|||Do you see Network Services part of RSExec role in your report server catalog db and temp db?|||Yes|||Yes, Network Services is RSExec role in report server catalog db and temp db.|||It looks like Network Service account is not allowed to set parameters. I am not sure what is the mininum permission set. Can you try adding the account as a content manager to the home folder?|||If I right-click in design view in VS2005, the report runs fine. It doesn't work when I try to run in a browser and is being served up by my dev IIS server.|||I have added the NetworkService as administrator and still no go.|||That did it. Was confused in the ReportManager. Simple fix. Seems like lots of people having same problem. Thank you for your help|||Sorry--Don't follow what the fix was. What did it?|||

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

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 ReportViewer

Is it possible to use the ReportViewer user control in an ASP.NET 1.1 Web App? All the tutorials I have found integrates the reportviewer control from RS2000 and not RS2005.I don't think so. The Report Viewer Control is new to ASP.NET 2.0.

RS2005 Print Legal

Hello,
I'm trying to automate printing to legal size paper from the web
ReportViewer control.
In my Report Properties / Layout I have Page Width= 14in and Page
Height= 8.5in.
When the report renders I hit the print icon. It shows that the report
will print to landscape,
but the paper size is set to Letter.
Is there a way to programatically set the paper size to legal?
TIA,
JimNo you can not set this on the fly, and there have been bugs regarding the
portrait/landscape issue..
However you may have the settings backward... Width should be 8.5in and
height should be 14in...(myabe you just typed it backward in your post.)
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"jhcorey@.yahoo.com" wrote:
> Hello,
> I'm trying to automate printing to legal size paper from the web
> ReportViewer control.
> In my Report Properties / Layout I have Page Width= 14in and Page
> Height= 8.5in.
> When the report renders I hit the print icon. It shows that the report
> will print to landscape,
> but the paper size is set to Letter.
> Is there a way to programatically set the paper size to legal?
> TIA,
> Jim
>