rsExecutionNotFound

I can preview a report I've written in VS (BIDS) without error. However, when I've deployed it to the report server, I'm unable to execute the report. I receive the following error:

Reporting Services Error

---

Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found (rsExecutionNotFound)

---

SQL Server Reporting Services

The report contains a chart that RS is rendering. Does something need to be turned on or is the error unrelated to charting? In any event, I'm stumped. Any ideas would be greatly appreciated!

What are you using to view the report? The HTML viewer? What happens if you close IE and try to render it again?|||i have the same error and when i close IE and try to render it again it's work fine|||

I have the same problem when I attempt to run a report with a non-admin user, when the report has no parameters.

When the error appears on screen, I can refresh and the report loads find.

I am using Forms Authentication with my own report list and report parameters screens. I launch a report via URL. If I copy/paste the URL to a (logged in) browser window (ctrl-N from the report parameters screen) then the report runs fine. If I launch the report from my app (window.open(url)) then I get the error mentioned above.

Any ideas?

Thanks

|||

Can you please provide the URL that you are trying to launch?

These "execution not found" errors occur usually because your session has expired due to inactivity. If you are using the viewer controls, then you shouldn't see this happen in normal circumstances because it should automatically cause postbacks at intervals which are quick enough to keep your session alive. If you aren't using the viewer control, but directly rendering from the ReportServer virtual directory and specifying rc:toolbar=false, then you don't get any of the cool "keepalive" functionality because you have opted out of using the viewer control.

|||

Hi John. Thanks for the post.

Here is the URL I put together in my web form and pass to RS (I broke it out onto seperate lines here because it didn't seem to want to paste correctly):

http://[server name]/ReportServer/Pages/ReportViewer.aspx?

/Galactic%20Delivery%20Services/Chapter06/BusinessTypeDistribution

&rs:Format=HTML4.0

&rc:Parameters=true

&rc:Toolbar=true

I build a custom list of reports (ListChildren), each report name is a link to a custom report parameter form (GetReportParameters) with a dropdown list of extentions (HTML, PDF, etc). If the selected report has no parameters, I bypass the parameters form and launch the report in the same browser window. The parameter-less reports are the problem and the problem has been sporadic. Sometimes the report loads sometimes I get the rsExecutionNotFound error. I seem to have gotten around the problem for the most part by launching the report in a new browser window, now I rarely get the rsExecutionNotFound error. However, when I went to get the report URL (above) I got the rsExecutionNotFound error again. I closed the browser windows and tried again. The report ran fine. Session thing?

The thing I don't quite get is that I execute LogonUser and regenerate the cookie from each page (I pass a unique value that is an GUID used to validate the user in our own security database). Does this not refresh the RS session?

To test, I have a HTML form with a dropdown list of usernames (admin, limited, etc). Most of the time, the "admin" user will work directly after the "limited" user fails (meaning, I click the report link and the report fails: I click the report link again with "admin" selected and it works). Specifying rs:Format=PDF works EVERY time, even directly after a failure (meaning, I click the report link and the report fails: I click the report link again with PDF selected and it works). It appears that the error only occurs when I attempt to run an HTML version of the report.

The report list page and the report parameter page live on the RS server.

Again, thanks for your post. My app (which is still in prototype mode) seems to be working fairly well. I would like to be able to trap this (and other) error so the user doesn't get this nasty message. Better yet, I'd like to understand the error and be able to prevent it.

-- WALL

|||

I talked with a couple other folks here on the team, and we think what you are hitting is that the HTML for the report is being cached by IE, which is causing the session to not be appropriately handled.

You can workaround this issue by adding a parameter to the URL which will be ignored by RS, but will "uniqueify" the URL so that you don't run into the caching problems. Try appending rc:UniqueGuid=<newguid> to the url and see if that works around your problem.

-john

|||

Interesting. I'll try your suggestion as soon as I get a moment.

Thank you for the (very quick) response.

-- wall (I happened to log in to this forum as xguy this time)

|||

We are seeing the same problem in our environment. We have tried adding the GUID parameter and it reduced the frequency of the problem, but we are still seeing the reExecutionNotFound error 8-10 times per day.

Suggestions? A post in another forum suggested that this problem is fixed somewhere, but did not give any info on the solution.

Thanks.

|||

How are you accessing the server? SOAP? URL Access? Are you using the viewer control or a custom application? Are you getting this error when rendering the report, or when retrieving images?

If it is a custom application that is not using the viewer control, then you will need to ensure that your session is not timing out by periodically "touching" the session. The viewer controls do this by calling GetExecutionInfo() on the SOAP endpoint.

|||

Thanks for the reply, John. Here is my developer's response (I'm the DBA in charge of the server):
"We are using the ReportViewer control and accessing remote reports on the reporting server, therefore, I believe it is making SOAP calls. They should know. During rendering, we get the Out Of Memory error within the ReportViewer. I never call GetExecutionInfo() from the ReportViewer control, do we have any examples? When should I call the method, before assigning parameters, after, etc..."

Any guidance is welcome. The web server we are running this on is Windows 2003 Standard SP1, dual 2.8GHz Xeon processors with 2GB of RAM. It is running IIS 6.0 and Reporting Services 2005 (the ReportServer databases are on a different server). We are running web apps with both ASP.NET 1.1.4322 and 2.0.50727, obviously in separate application pools.

Thanks,
Kevin

|||

Out of memory is a different error than execution not found.

If you are using the viewer controls then you don't have to call GetExecutionInfo() yourself, the viewer control does this periodically to "ping" the server and keep your session alive all by itself.

Check Tudor's blog for some tips on improving performance:

http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx

The biggest thing you can do to reduce the amount of memory being used is to reduce the # of rows that your data sets are returning.

|||

Sorry for the confusion, John. We are actually seeing two different problems, one of which is the rsExecutionNotFound which doesn't seem to have any pattern, the other is the OutOfMemory exception that we are seeing on large reports.

Regarding the the rsExecutionNotFound error, after we added the GUID report parameter, we saw the frequency of the error decline, but not disappear completely. Do you have any other suggestions to resolve this?

Thanks again,
Kevin

|||

Hi Kevin. I have not put our reporting services apps into production yet (other projects have taken priority) but we have tested quite a bit and launching the reports in a new browser window seems to have made the rsExecutionNotFound error go away (knock on wood).

We use custom report listing forms and custom (selected) report parameter forms. We launch HTML forms in a new browser window and launch PDF (and other formats) in an iframe on the same form -- each method results in a new window opening.

Hope that helps.

Good luck.

|||

What if you get the rsExecutionNotFound error by just using your web browser to access the report? In this situation it was reporting services that generated the url and we have no way of adding anything to it.

Why can the report not be executed again when the expected execution is missing and the end user did not sepecifically request a particular execution?

Additionally, why is there a nasty exception in response to a "inappropriate handling" of a session? When you said "not be appropriately handled" did you mean that IE is allowing the session to time out and it should not be?

rsExecutionNotFound

I can preview a report I've written in VS (BIDS) without error. However, when I've deployed it to the report server, I'm unable to execute the report. I receive the following error:

Reporting Services Error

---

Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found (rsExecutionNotFound)

---

SQL Server Reporting Services

The report contains a chart that RS is rendering. Does something need to be turned on or is the error unrelated to charting? In any event, I'm stumped. Any ideas would be greatly appreciated!

What are you using to view the report? The HTML viewer? What happens if you close IE and try to render it again?|||i have the same error and when i close IE and try to render it again it's work fine|||

I have the same problem when I attempt to run a report with a non-admin user, when the report has no parameters.

When the error appears on screen, I can refresh and the report loads find.

I am using Forms Authentication with my own report list and report parameters screens. I launch a report via URL. If I copy/paste the URL to a (logged in) browser window (ctrl-N from the report parameters screen) then the report runs fine. If I launch the report from my app (window.open(url)) then I get the error mentioned above.

Any ideas?

Thanks

|||

Can you please provide the URL that you are trying to launch?

These "execution not found" errors occur usually because your session has expired due to inactivity. If you are using the viewer controls, then you shouldn't see this happen in normal circumstances because it should automatically cause postbacks at intervals which are quick enough to keep your session alive. If you aren't using the viewer control, but directly rendering from the ReportServer virtual directory and specifying rc:toolbar=false, then you don't get any of the cool "keepalive" functionality because you have opted out of using the viewer control.

|||

Hi John. Thanks for the post.

Here is the URL I put together in my web form and pass to RS (I broke it out onto seperate lines here because it didn't seem to want to paste correctly):

http://[server name]/ReportServer/Pages/ReportViewer.aspx?

/Galactic%20Delivery%20Services/Chapter06/BusinessTypeDistribution

&rs:Format=HTML4.0

&rc:Parameters=true

&rc:Toolbar=true

I build a custom list of reports (ListChildren), each report name is a link to a custom report parameter form (GetReportParameters) with a dropdown list of extentions (HTML, PDF, etc). If the selected report has no parameters, I bypass the parameters form and launch the report in the same browser window. The parameter-less reports are the problem and the problem has been sporadic. Sometimes the report loads sometimes I get the rsExecutionNotFound error. I seem to have gotten around the problem for the most part by launching the report in a new browser window, now I rarely get the rsExecutionNotFound error. However, when I went to get the report URL (above) I got the rsExecutionNotFound error again. I closed the browser windows and tried again. The report ran fine. Session thing?

The thing I don't quite get is that I execute LogonUser and regenerate the cookie from each page (I pass a unique value that is an GUID used to validate the user in our own security database). Does this not refresh the RS session?

To test, I have a HTML form with a dropdown list of usernames (admin, limited, etc). Most of the time, the "admin" user will work directly after the "limited" user fails (meaning, I click the report link and the report fails: I click the report link again with "admin" selected and it works). Specifying rs:Format=PDF works EVERY time, even directly after a failure (meaning, I click the report link and the report fails: I click the report link again with PDF selected and it works). It appears that the error only occurs when I attempt to run an HTML version of the report.

The report list page and the report parameter page live on the RS server.

Again, thanks for your post. My app (which is still in prototype mode) seems to be working fairly well. I would like to be able to trap this (and other) error so the user doesn't get this nasty message. Better yet, I'd like to understand the error and be able to prevent it.

-- WALL

|||

I talked with a couple other folks here on the team, and we think what you are hitting is that the HTML for the report is being cached by IE, which is causing the session to not be appropriately handled.

You can workaround this issue by adding a parameter to the URL which will be ignored by RS, but will "uniqueify" the URL so that you don't run into the caching problems. Try appending rc:UniqueGuid=<newguid> to the url and see if that works around your problem.

-john

|||

Interesting. I'll try your suggestion as soon as I get a moment.

Thank you for the (very quick) response.

-- wall (I happened to log in to this forum as xguy this time)

|||

We are seeing the same problem in our environment. We have tried adding the GUID parameter and it reduced the frequency of the problem, but we are still seeing the reExecutionNotFound error 8-10 times per day.

Suggestions? A post in another forum suggested that this problem is fixed somewhere, but did not give any info on the solution.

Thanks.

|||

How are you accessing the server? SOAP? URL Access? Are you using the viewer control or a custom application? Are you getting this error when rendering the report, or when retrieving images?

If it is a custom application that is not using the viewer control, then you will need to ensure that your session is not timing out by periodically "touching" the session. The viewer controls do this by calling GetExecutionInfo() on the SOAP endpoint.

|||

Thanks for the reply, John. Here is my developer's response (I'm the DBA in charge of the server):
"We are using the ReportViewer control and accessing remote reports on the reporting server, therefore, I believe it is making SOAP calls. They should know. During rendering, we get the Out Of Memory error within the ReportViewer. I never call GetExecutionInfo() from the ReportViewer control, do we have any examples? When should I call the method, before assigning parameters, after, etc..."

Any guidance is welcome. The web server we are running this on is Windows 2003 Standard SP1, dual 2.8GHz Xeon processors with 2GB of RAM. It is running IIS 6.0 and Reporting Services 2005 (the ReportServer databases are on a different server). We are running web apps with both ASP.NET 1.1.4322 and 2.0.50727, obviously in separate application pools.

Thanks,
Kevin

|||

Out of memory is a different error than execution not found.

If you are using the viewer controls then you don't have to call GetExecutionInfo() yourself, the viewer control does this periodically to "ping" the server and keep your session alive all by itself.

Check Tudor's blog for some tips on improving performance:

http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx

The biggest thing you can do to reduce the amount of memory being used is to reduce the # of rows that your data sets are returning.

|||

Sorry for the confusion, John. We are actually seeing two different problems, one of which is the rsExecutionNotFound which doesn't seem to have any pattern, the other is the OutOfMemory exception that we are seeing on large reports.

Regarding the the rsExecutionNotFound error, after we added the GUID report parameter, we saw the frequency of the error decline, but not disappear completely. Do you have any other suggestions to resolve this?

Thanks again,
Kevin

|||

Hi Kevin. I have not put our reporting services apps into production yet (other projects have taken priority) but we have tested quite a bit and launching the reports in a new browser window seems to have made the rsExecutionNotFound error go away (knock on wood).

We use custom report listing forms and custom (selected) report parameter forms. We launch HTML forms in a new browser window and launch PDF (and other formats) in an iframe on the same form -- each method results in a new window opening.

Hope that helps.

Good luck.

|||

What if you get the rsExecutionNotFound error by just using your web browser to access the report? In this situation it was reporting services that generated the url and we have no way of adding anything to it.

Why can the report not be executed again when the expected execution is missing and the end user did not sepecifically request a particular execution?

Additionally, why is there a nasty exception in response to a "inappropriate handling" of a session? When you said "not be appropriately handled" did you mean that IE is allowing the session to time out and it should not be?

rsExecutionNotFound

I can preview a report I've written in VS (BIDS) without error. However, when I've deployed it to the report server, I'm unable to execute the report. I receive the following error:

Reporting Services Error

---

Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found (rsExecutionNotFound)

---

SQL Server Reporting Services

The report contains a chart that RS is rendering. Does something need to be turned on or is the error unrelated to charting? In any event, I'm stumped. Any ideas would be greatly appreciated!

What are you using to view the report? The HTML viewer? What happens if you close IE and try to render it again?|||i have the same error and when i close IE and try to render it again it's work fine|||

I have the same problem when I attempt to run a report with a non-admin user, when the report has no parameters.

When the error appears on screen, I can refresh and the report loads find.

I am using Forms Authentication with my own report list and report parameters screens. I launch a report via URL. If I copy/paste the URL to a (logged in) browser window (ctrl-N from the report parameters screen) then the report runs fine. If I launch the report from my app (window.open(url)) then I get the error mentioned above.

Any ideas?

Thanks

|||

Can you please provide the URL that you are trying to launch?

These "execution not found" errors occur usually because your session has expired due to inactivity. If you are using the viewer controls, then you shouldn't see this happen in normal circumstances because it should automatically cause postbacks at intervals which are quick enough to keep your session alive. If you aren't using the viewer control, but directly rendering from the ReportServer virtual directory and specifying rc:toolbar=false, then you don't get any of the cool "keepalive" functionality because you have opted out of using the viewer control.

|||

Hi John. Thanks for the post.

Here is the URL I put together in my web form and pass to RS (I broke it out onto seperate lines here because it didn't seem to want to paste correctly):

http://[server name]/ReportServer/Pages/ReportViewer.aspx?

/Galactic%20Delivery%20Services/Chapter06/BusinessTypeDistribution

&rs:Format=HTML4.0

&rc:Parameters=true

&rc:Toolbar=true

I build a custom list of reports (ListChildren), each report name is a link to a custom report parameter form (GetReportParameters) with a dropdown list of extentions (HTML, PDF, etc). If the selected report has no parameters, I bypass the parameters form and launch the report in the same browser window. The parameter-less reports are the problem and the problem has been sporadic. Sometimes the report loads sometimes I get the rsExecutionNotFound error. I seem to have gotten around the problem for the most part by launching the report in a new browser window, now I rarely get the rsExecutionNotFound error. However, when I went to get the report URL (above) I got the rsExecutionNotFound error again. I closed the browser windows and tried again. The report ran fine. Session thing?

The thing I don't quite get is that I execute LogonUser and regenerate the cookie from each page (I pass a unique value that is an GUID used to validate the user in our own security database). Does this not refresh the RS session?

To test, I have a HTML form with a dropdown list of usernames (admin, limited, etc). Most of the time, the "admin" user will work directly after the "limited" user fails (meaning, I click the report link and the report fails: I click the report link again with "admin" selected and it works). Specifying rs:Format=PDF works EVERY time, even directly after a failure (meaning, I click the report link and the report fails: I click the report link again with PDF selected and it works). It appears that the error only occurs when I attempt to run an HTML version of the report.

The report list page and the report parameter page live on the RS server.

Again, thanks for your post. My app (which is still in prototype mode) seems to be working fairly well. I would like to be able to trap this (and other) error so the user doesn't get this nasty message. Better yet, I'd like to understand the error and be able to prevent it.

-- WALL

|||

I talked with a couple other folks here on the team, and we think what you are hitting is that the HTML for the report is being cached by IE, which is causing the session to not be appropriately handled.

You can workaround this issue by adding a parameter to the URL which will be ignored by RS, but will "uniqueify" the URL so that you don't run into the caching problems. Try appending rc:UniqueGuid=<newguid> to the url and see if that works around your problem.

-john

|||

Interesting. I'll try your suggestion as soon as I get a moment.

Thank you for the (very quick) response.

-- wall (I happened to log in to this forum as xguy this time)

|||

We are seeing the same problem in our environment. We have tried adding the GUID parameter and it reduced the frequency of the problem, but we are still seeing the reExecutionNotFound error 8-10 times per day.

Suggestions? A post in another forum suggested that this problem is fixed somewhere, but did not give any info on the solution.

Thanks.

|||

How are you accessing the server? SOAP? URL Access? Are you using the viewer control or a custom application? Are you getting this error when rendering the report, or when retrieving images?

If it is a custom application that is not using the viewer control, then you will need to ensure that your session is not timing out by periodically "touching" the session. The viewer controls do this by calling GetExecutionInfo() on the SOAP endpoint.

|||

Thanks for the reply, John. Here is my developer's response (I'm the DBA in charge of the server):
"We are using the ReportViewer control and accessing remote reports on the reporting server, therefore, I believe it is making SOAP calls. They should know. During rendering, we get the Out Of Memory error within the ReportViewer. I never call GetExecutionInfo() from the ReportViewer control, do we have any examples? When should I call the method, before assigning parameters, after, etc..."

Any guidance is welcome. The web server we are running this on is Windows 2003 Standard SP1, dual 2.8GHz Xeon processors with 2GB of RAM. It is running IIS 6.0 and Reporting Services 2005 (the ReportServer databases are on a different server). We are running web apps with both ASP.NET 1.1.4322 and 2.0.50727, obviously in separate application pools.

Thanks,
Kevin

|||

Out of memory is a different error than execution not found.

If you are using the viewer controls then you don't have to call GetExecutionInfo() yourself, the viewer control does this periodically to "ping" the server and keep your session alive all by itself.

Check Tudor's blog for some tips on improving performance:

http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx

The biggest thing you can do to reduce the amount of memory being used is to reduce the # of rows that your data sets are returning.

|||

Sorry for the confusion, John. We are actually seeing two different problems, one of which is the rsExecutionNotFound which doesn't seem to have any pattern, the other is the OutOfMemory exception that we are seeing on large reports.

Regarding the the rsExecutionNotFound error, after we added the GUID report parameter, we saw the frequency of the error decline, but not disappear completely. Do you have any other suggestions to resolve this?

Thanks again,
Kevin

|||

Hi Kevin. I have not put our reporting services apps into production yet (other projects have taken priority) but we have tested quite a bit and launching the reports in a new browser window seems to have made the rsExecutionNotFound error go away (knock on wood).

We use custom report listing forms and custom (selected) report parameter forms. We launch HTML forms in a new browser window and launch PDF (and other formats) in an iframe on the same form -- each method results in a new window opening.

Hope that helps.

Good luck.

|||

What if you get the rsExecutionNotFound error by just using your web browser to access the report? In this situation it was reporting services that generated the url and we have no way of adding anything to it.

Why can the report not be executed again when the expected execution is missing and the end user did not sepecifically request a particular execution?

Additionally, why is there a nasty exception in response to a "inappropriate handling" of a session? When you said "not be appropriately handled" did you mean that IE is allowing the session to time out and it should not be?

rsExecutionNotFound

I can preview a report I've written in VS (BIDS) without error. However, when I've deployed it to the report server, I'm unable to execute the report. I receive the following error:

Reporting Services Error

---

Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found (rsExecutionNotFound)

---

SQL Server Reporting Services

The report contains a chart that RS is rendering. Does something need to be turned on or is the error unrelated to charting? In any event, I'm stumped. Any ideas would be greatly appreciated!

What are you using to view the report? The HTML viewer? What happens if you close IE and try to render it again?|||i have the same error and when i close IE and try to render it again it's work fine|||

I have the same problem when I attempt to run a report with a non-admin user, when the report has no parameters.

When the error appears on screen, I can refresh and the report loads find.

I am using Forms Authentication with my own report list and report parameters screens. I launch a report via URL. If I copy/paste the URL to a (logged in) browser window (ctrl-N from the report parameters screen) then the report runs fine. If I launch the report from my app (window.open(url)) then I get the error mentioned above.

Any ideas?

Thanks

|||

Can you please provide the URL that you are trying to launch?

These "execution not found" errors occur usually because your session has expired due to inactivity. If you are using the viewer controls, then you shouldn't see this happen in normal circumstances because it should automatically cause postbacks at intervals which are quick enough to keep your session alive. If you aren't using the viewer control, but directly rendering from the ReportServer virtual directory and specifying rc:toolbar=false, then you don't get any of the cool "keepalive" functionality because you have opted out of using the viewer control.

|||

Hi John. Thanks for the post.

Here is the URL I put together in my web form and pass to RS (I broke it out onto seperate lines here because it didn't seem to want to paste correctly):

http://[server name]/ReportServer/Pages/ReportViewer.aspx?

/Galactic%20Delivery%20Services/Chapter06/BusinessTypeDistribution

&rs:Format=HTML4.0

&rc:Parameters=true

&rc:Toolbar=true

I build a custom list of reports (ListChildren), each report name is a link to a custom report parameter form (GetReportParameters) with a dropdown list of extentions (HTML, PDF, etc). If the selected report has no parameters, I bypass the parameters form and launch the report in the same browser window. The parameter-less reports are the problem and the problem has been sporadic. Sometimes the report loads sometimes I get the rsExecutionNotFound error. I seem to have gotten around the problem for the most part by launching the report in a new browser window, now I rarely get the rsExecutionNotFound error. However, when I went to get the report URL (above) I got the rsExecutionNotFound error again. I closed the browser windows and tried again. The report ran fine. Session thing?

The thing I don't quite get is that I execute LogonUser and regenerate the cookie from each page (I pass a unique value that is an GUID used to validate the user in our own security database). Does this not refresh the RS session?

To test, I have a HTML form with a dropdown list of usernames (admin, limited, etc). Most of the time, the "admin" user will work directly after the "limited" user fails (meaning, I click the report link and the report fails: I click the report link again with "admin" selected and it works). Specifying rs:Format=PDF works EVERY time, even directly after a failure (meaning, I click the report link and the report fails: I click the report link again with PDF selected and it works). It appears that the error only occurs when I attempt to run an HTML version of the report.

The report list page and the report parameter page live on the RS server.

Again, thanks for your post. My app (which is still in prototype mode) seems to be working fairly well. I would like to be able to trap this (and other) error so the user doesn't get this nasty message. Better yet, I'd like to understand the error and be able to prevent it.

-- WALL

|||

I talked with a couple other folks here on the team, and we think what you are hitting is that the HTML for the report is being cached by IE, which is causing the session to not be appropriately handled.

You can workaround this issue by adding a parameter to the URL which will be ignored by RS, but will "uniqueify" the URL so that you don't run into the caching problems. Try appending rc:UniqueGuid=<newguid> to the url and see if that works around your problem.

-john

|||

Interesting. I'll try your suggestion as soon as I get a moment.

Thank you for the (very quick) response.

-- wall (I happened to log in to this forum as xguy this time)

|||

We are seeing the same problem in our environment. We have tried adding the GUID parameter and it reduced the frequency of the problem, but we are still seeing the reExecutionNotFound error 8-10 times per day.

Suggestions? A post in another forum suggested that this problem is fixed somewhere, but did not give any info on the solution.

Thanks.

|||

How are you accessing the server? SOAP? URL Access? Are you using the viewer control or a custom application? Are you getting this error when rendering the report, or when retrieving images?

If it is a custom application that is not using the viewer control, then you will need to ensure that your session is not timing out by periodically "touching" the session. The viewer controls do this by calling GetExecutionInfo() on the SOAP endpoint.

|||

Thanks for the reply, John. Here is my developer's response (I'm the DBA in charge of the server):
"We are using the ReportViewer control and accessing remote reports on the reporting server, therefore, I believe it is making SOAP calls. They should know. During rendering, we get the Out Of Memory error within the ReportViewer. I never call GetExecutionInfo() from the ReportViewer control, do we have any examples? When should I call the method, before assigning parameters, after, etc..."

Any guidance is welcome. The web server we are running this on is Windows 2003 Standard SP1, dual 2.8GHz Xeon processors with 2GB of RAM. It is running IIS 6.0 and Reporting Services 2005 (the ReportServer databases are on a different server). We are running web apps with both ASP.NET 1.1.4322 and 2.0.50727, obviously in separate application pools.

Thanks,
Kevin

|||

Out of memory is a different error than execution not found.

If you are using the viewer controls then you don't have to call GetExecutionInfo() yourself, the viewer control does this periodically to "ping" the server and keep your session alive all by itself.

Check Tudor's blog for some tips on improving performance:

http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx

The biggest thing you can do to reduce the amount of memory being used is to reduce the # of rows that your data sets are returning.

|||

Sorry for the confusion, John. We are actually seeing two different problems, one of which is the rsExecutionNotFound which doesn't seem to have any pattern, the other is the OutOfMemory exception that we are seeing on large reports.

Regarding the the rsExecutionNotFound error, after we added the GUID report parameter, we saw the frequency of the error decline, but not disappear completely. Do you have any other suggestions to resolve this?

Thanks again,
Kevin

|||

Hi Kevin. I have not put our reporting services apps into production yet (other projects have taken priority) but we have tested quite a bit and launching the reports in a new browser window seems to have made the rsExecutionNotFound error go away (knock on wood).

We use custom report listing forms and custom (selected) report parameter forms. We launch HTML forms in a new browser window and launch PDF (and other formats) in an iframe on the same form -- each method results in a new window opening.

Hope that helps.

Good luck.

|||

What if you get the rsExecutionNotFound error by just using your web browser to access the report? In this situation it was reporting services that generated the url and we have no way of adding anything to it.

Why can the report not be executed again when the expected execution is missing and the end user did not sepecifically request a particular execution?

Additionally, why is there a nasty exception in response to a "inappropriate handling" of a session? When you said "not be appropriately handled" did you mean that IE is allowing the session to time out and it should not be?

sql

rsExecutionNotFound

I can preview a report I've written in VS (BIDS) without error. However, when I've deployed it to the report server, I'm unable to execute the report. I receive the following error:

Reporting Services Error

---

Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found (rsExecutionNotFound)

---

SQL Server Reporting Services

The report contains a chart that RS is rendering. Does something need to be turned on or is the error unrelated to charting? In any event, I'm stumped. Any ideas would be greatly appreciated!

What are you using to view the report? The HTML viewer? What happens if you close IE and try to render it again?|||i have the same error and when i close IE and try to render it again it's work fine|||

I have the same problem when I attempt to run a report with a non-admin user, when the report has no parameters.

When the error appears on screen, I can refresh and the report loads find.

I am using Forms Authentication with my own report list and report parameters screens. I launch a report via URL. If I copy/paste the URL to a (logged in) browser window (ctrl-N from the report parameters screen) then the report runs fine. If I launch the report from my app (window.open(url)) then I get the error mentioned above.

Any ideas?

Thanks

|||

Can you please provide the URL that you are trying to launch?

These "execution not found" errors occur usually because your session has expired due to inactivity. If you are using the viewer controls, then you shouldn't see this happen in normal circumstances because it should automatically cause postbacks at intervals which are quick enough to keep your session alive. If you aren't using the viewer control, but directly rendering from the ReportServer virtual directory and specifying rc:toolbar=false, then you don't get any of the cool "keepalive" functionality because you have opted out of using the viewer control.

|||

Hi John. Thanks for the post.

Here is the URL I put together in my web form and pass to RS (I broke it out onto seperate lines here because it didn't seem to want to paste correctly):

http://[server name]/ReportServer/Pages/ReportViewer.aspx?

/Galactic%20Delivery%20Services/Chapter06/BusinessTypeDistribution

&rs:Format=HTML4.0

&rc:Parameters=true

&rc:Toolbar=true

I build a custom list of reports (ListChildren), each report name is a link to a custom report parameter form (GetReportParameters) with a dropdown list of extentions (HTML, PDF, etc). If the selected report has no parameters, I bypass the parameters form and launch the report in the same browser window. The parameter-less reports are the problem and the problem has been sporadic. Sometimes the report loads sometimes I get the rsExecutionNotFound error. I seem to have gotten around the problem for the most part by launching the report in a new browser window, now I rarely get the rsExecutionNotFound error. However, when I went to get the report URL (above) I got the rsExecutionNotFound error again. I closed the browser windows and tried again. The report ran fine. Session thing?

The thing I don't quite get is that I execute LogonUser and regenerate the cookie from each page (I pass a unique value that is an GUID used to validate the user in our own security database). Does this not refresh the RS session?

To test, I have a HTML form with a dropdown list of usernames (admin, limited, etc). Most of the time, the "admin" user will work directly after the "limited" user fails (meaning, I click the report link and the report fails: I click the report link again with "admin" selected and it works). Specifying rs:Format=PDF works EVERY time, even directly after a failure (meaning, I click the report link and the report fails: I click the report link again with PDF selected and it works). It appears that the error only occurs when I attempt to run an HTML version of the report.

The report list page and the report parameter page live on the RS server.

Again, thanks for your post. My app (which is still in prototype mode) seems to be working fairly well. I would like to be able to trap this (and other) error so the user doesn't get this nasty message. Better yet, I'd like to understand the error and be able to prevent it.

-- WALL

|||

I talked with a couple other folks here on the team, and we think what you are hitting is that the HTML for the report is being cached by IE, which is causing the session to not be appropriately handled.

You can workaround this issue by adding a parameter to the URL which will be ignored by RS, but will "uniqueify" the URL so that you don't run into the caching problems. Try appending rc:UniqueGuid=<newguid> to the url and see if that works around your problem.

-john

|||

Interesting. I'll try your suggestion as soon as I get a moment.

Thank you for the (very quick) response.

-- wall (I happened to log in to this forum as xguy this time)

|||

We are seeing the same problem in our environment. We have tried adding the GUID parameter and it reduced the frequency of the problem, but we are still seeing the reExecutionNotFound error 8-10 times per day.

Suggestions? A post in another forum suggested that this problem is fixed somewhere, but did not give any info on the solution.

Thanks.

|||

How are you accessing the server? SOAP? URL Access? Are you using the viewer control or a custom application? Are you getting this error when rendering the report, or when retrieving images?

If it is a custom application that is not using the viewer control, then you will need to ensure that your session is not timing out by periodically "touching" the session. The viewer controls do this by calling GetExecutionInfo() on the SOAP endpoint.

|||

Thanks for the reply, John. Here is my developer's response (I'm the DBA in charge of the server):
"We are using the ReportViewer control and accessing remote reports on the reporting server, therefore, I believe it is making SOAP calls. They should know. During rendering, we get the Out Of Memory error within the ReportViewer. I never call GetExecutionInfo() from the ReportViewer control, do we have any examples? When should I call the method, before assigning parameters, after, etc..."

Any guidance is welcome. The web server we are running this on is Windows 2003 Standard SP1, dual 2.8GHz Xeon processors with 2GB of RAM. It is running IIS 6.0 and Reporting Services 2005 (the ReportServer databases are on a different server). We are running web apps with both ASP.NET 1.1.4322 and 2.0.50727, obviously in separate application pools.

Thanks,
Kevin

|||

Out of memory is a different error than execution not found.

If you are using the viewer controls then you don't have to call GetExecutionInfo() yourself, the viewer control does this periodically to "ping" the server and keep your session alive all by itself.

Check Tudor's blog for some tips on improving performance:

http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx

The biggest thing you can do to reduce the amount of memory being used is to reduce the # of rows that your data sets are returning.

|||

Sorry for the confusion, John. We are actually seeing two different problems, one of which is the rsExecutionNotFound which doesn't seem to have any pattern, the other is the OutOfMemory exception that we are seeing on large reports.

Regarding the the rsExecutionNotFound error, after we added the GUID report parameter, we saw the frequency of the error decline, but not disappear completely. Do you have any other suggestions to resolve this?

Thanks again,
Kevin

|||

Hi Kevin. I have not put our reporting services apps into production yet (other projects have taken priority) but we have tested quite a bit and launching the reports in a new browser window seems to have made the rsExecutionNotFound error go away (knock on wood).

We use custom report listing forms and custom (selected) report parameter forms. We launch HTML forms in a new browser window and launch PDF (and other formats) in an iframe on the same form -- each method results in a new window opening.

Hope that helps.

Good luck.

|||

What if you get the rsExecutionNotFound error by just using your web browser to access the report? In this situation it was reporting services that generated the url and we have no way of adding anything to it.

Why can the report not be executed again when the expected execution is missing and the end user did not sepecifically request a particular execution?

Additionally, why is there a nasty exception in response to a "inappropriate handling" of a session? When you said "not be appropriately handled" did you mean that IE is allowing the session to time out and it should not be?

RS2005: Datetime-Parameter-Problem, only(!) on server

Hello,
we are facing a datetime-parameter-problem, that does not occur during
preview but when the report is deployed to the server:
We have the following situation:
Report A:
Parameter: Date (Datetime with picker), some other string parameters
Report B:
Parameter: Date (Datetime with picker), some other string parameters
Now wie navigate from some table field from ReportA to ReportB with the
following parameter-mapping:
Date=Parameters!Date.Value
In the preview and the local debug, everything works fine, but as soon as
the reports are executed on the server, day and month are swapped!
On the client there is a german WindowsXP and on the server an english
WindowsXP. What is the problem and what can we do?
Regards,
RalphCan you change the client from German to English? It sure sounds like
that's your problem. If you can't, then you'll need to find a way to
format your date in the English-US (mmddyyy) instead of (ddmmyyyy).|||Hi tool man,
many thanks for your reply.
The problem is that I can't tell in advance if the server system, the sql
server 2005 on the system are german or english, and we have definitely
clients with different language settings and different browsers in different
languages...
Any ideas? Many thanks in advance,
Ralph
"toolman" <timd@.infocision.com> schrieb im Newsbeitrag
news:1142441749.516338.297680@.u72g2000cwu.googlegroups.com...
> Can you change the client from German to English? It sure sounds like
> that's your problem. If you can't, then you'll need to find a way to
> format your date in the English-US (mmddyyy) instead of (ddmmyyyy).
>

RS2005 Parameter value persists

I have a simple RS2005 report with 2 parameters, one with a default value
defined and one without.
When the report is viewed in designer "Preview" mode the second parameter
must be selected before "View Report" will run.
When deployed and viewed through Report Manager and IE6, the second
parameter comes up with the old value and the report fills automatically (I
can then select another value for the parameter and things work OK).
I've cleared temp files, restarted, etc. to no avail.
How can I get the deployed version to forget the default value?OK-I seem to have solved this.
Looking in SQL Server's Report Server database, table dbo.Catalog, in the
row for my report, in the Parameter field, I found the erroneous default
value stored. Changing the Default Value in the Report Parameters screen had
no effect on this SQL Server value. Only after removing the parameter,
re-deploying, adding the parameter back and deploying again could I remove
the erroneous default value.
"Paul" wrote:
> I have a simple RS2005 report with 2 parameters, one with a default value
> defined and one without.
> When the report is viewed in designer "Preview" mode the second parameter
> must be selected before "View Report" will run.
> When deployed and viewed through Report Manager and IE6, the second
> parameter comes up with the old value and the report fills automatically (I
> can then select another value for the parameter and things work OK).
> I've cleared temp files, restarted, etc. to no avail.
> How can I get the deployed version to forget the default value?

RS Printing Questions

1. When creating a report,In the preview tab i have the ability to print out
the report (using the print button) however once the report is deployed to
the report server the user doesnt get the print button and can only print
from the browser.Is there any way to print from the report (as opposed to the
browser) after the report has been deployed?
2.When printing from the browser,only the first page prints out,even though
'All' pages has been selected in the print dialog.This only occurs when
printing out a report,If i print out another web page all the pages print
out.Does anyone know of a fix for this?Vinny,
This is annoying. I found one way around this - the report prints
beautifully (if you set it up correctly) from PDF. You can provide a
'Printable Report' link to the user to the PDF version - that will work. To
do that you append ''&rs%3AFormat=PDF" to the end of the regular report URL.
This works pretty well - obviously it would be ideal if Reporting Services
didnt have this problem, but here's one work around. Hope this helps.
Derek
"Vinny Vinn" wrote:
> 1. When creating a report,In the preview tab i have the ability to print out
> the report (using the print button) however once the report is deployed to
> the report server the user doesnt get the print button and can only print
> from the browser.Is there any way to print from the report (as opposed to the
> browser) after the report has been deployed?
> 2.When printing from the browser,only the first page prints out,even though
> 'All' pages has been selected in the print dialog.This only occurs when
> printing out a report,If i print out another web page all the pages print
> out.Does anyone know of a fix for this?|||Derek,
Thank you,How can i provide a 'Printable Report' link,(i dont have a
link in my toolbox- the user can export the report to PDF.)?
Vinny
"Derek Fisher" wrote:
> Vinny,
> This is annoying. I found one way around this - the report prints
> beautifully (if you set it up correctly) from PDF. You can provide a
> 'Printable Report' link to the user to the PDF version - that will work. To
> do that you append ''&rs%3AFormat=PDF" to the end of the regular report URL.
> This works pretty well - obviously it would be ideal if Reporting Services
> didnt have this problem, but here's one work around. Hope this helps.
> Derek
> "Vinny Vinn" wrote:
> > 1. When creating a report,In the preview tab i have the ability to print out
> > the report (using the print button) however once the report is deployed to
> > the report server the user doesnt get the print button and can only print
> > from the browser.Is there any way to print from the report (as opposed to the
> > browser) after the report has been deployed?
> >
> > 2.When printing from the browser,only the first page prints out,even though
> > 'All' pages has been selected in the print dialog.This only occurs when
> > printing out a report,If i print out another web page all the pages print
> > out.Does anyone know of a fix for this?|||Keep in mind that SP2 will have client side printing (if you are using
Report Manager or URL integration, not sure what happens with web services).
SP2 will hopefully be out this month. Soon, anyway.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vinny Vinn" <VinnyVinn@.discussions.microsoft.com> wrote in message
news:2E283D92-05EB-46A4-9DE6-8703A9DE5E81@.microsoft.com...
> Derek,
> Thank you,How can i provide a 'Printable Report' link,(i dont have a
> link in my toolbox- the user can export the report to PDF.)?
> Vinny
> "Derek Fisher" wrote:
> > Vinny,
> >
> > This is annoying. I found one way around this - the report prints
> > beautifully (if you set it up correctly) from PDF. You can provide a
> > 'Printable Report' link to the user to the PDF version - that will work.
To
> > do that you append ''&rs%3AFormat=PDF" to the end of the regular report
URL.
> > This works pretty well - obviously it would be ideal if Reporting
Services
> > didnt have this problem, but here's one work around. Hope this helps.
> >
> > Derek
> >
> > "Vinny Vinn" wrote:
> >
> > > 1. When creating a report,In the preview tab i have the ability to
print out
> > > the report (using the print button) however once the report is
deployed to
> > > the report server the user doesnt get the print button and can only
print
> > > from the browser.Is there any way to print from the report (as opposed
to the
> > > browser) after the report has been deployed?
> > >
> > > 2.When printing from the browser,only the first page prints out,even
though
> > > 'All' pages has been selected in the print dialog.This only occurs
when
> > > printing out a report,If i print out another web page all the pages
print
> > > out.Does anyone know of a fix for this?

RS Layout and Preview Tab - SLOW

Hello, I have been working with Reporting Services for several months and really like it. I am using Visual Studio .net for developing reports. I have noticed a long delay when changing between the 'Layout Tab' and the 'Preview Tab'. The delay is between 10 and 15 seconds which may not seem like much but adds up over time. Does anyone know if this is an issue with RS or the .net environment? Are there settings to change to make this change quicker? I know each time you change from one tab to another a new .rdl file has to be built but I have witnessed several demos from Microsoft and their setups appear to be instantaneous. Any ideas would be helpful!!! Thanks, Dave
--
Message posted via http://www.sqlmonster.comIf you report has paramters then you are just seeing building the report, no
parameters then it is also executing the report. Once it has executed it
though, it then caches the data (look in your directory and you will see
reportname.rdl.data). Even a pretty complicated report takes only a couple
of seconds to build the report. Ususally a second or less. How much RAM do
you have. It seems to me like you might be getting some thrashing going on.
"David Cymbala via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:b664fdd433c94909a44639deb1c12d91@.SQLMonster.com...
> Hello, I have been working with Reporting Services for several months and
really like it. I am using Visual Studio .net for developing reports. I
have noticed a long delay when changing between the 'Layout Tab' and the
'Preview Tab'. The delay is between 10 and 15 seconds which may not seem
like much but adds up over time. Does anyone know if this is an issue with
RS or the .net environment? Are there settings to change to make this
change quicker? I know each time you change from one tab to another a new
.rdl file has to be built but I have witnessed several demos from Microsoft
and their setups appear to be instantaneous. Any ideas would be helpful!!!
Thanks, Dave
> --
> Message posted via http://www.sqlmonster.com|||Thank you for your response. My client station is a 3Ghz Pentium with 256 megs of ram. I consistently see this delay regardless of whether the report has parameters or not. The delay occurs before the 'Processing Report...' dialogue appears. The same query in query analyzer takes fractions of a second to complete. Any additional insight would be greatly appreciated. Thanks, Dave
--
Message posted via http://www.sqlmonster.com|||That is faster than my machine but I have 512MB more RAM than you. Besides
adding RAM if you can, how do you have your data source setup, is it a
shared datasource or are you doing it per report. I use shared data source.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Cymbala via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8c91c4a235784ec4b6a9e8de4b04f06d@.SQLMonster.com...
> Thank you for your response. My client station is a 3Ghz Pentium with 256
megs of ram. I consistently see this delay regardless of whether the report
has parameters or not. The delay occurs before the 'Processing Report...'
dialogue appears. The same query in query analyzer takes fractions of a
second to complete. Any additional insight would be greatly appreciated.
Thanks, Dave
> --
> Message posted via http://www.sqlmonster.com|||I am using a shared datasource. I wish I knew if increasing memory would solve this problem before upgrading. Thanks for your responses. Dave
--
Message posted via http://www.sqlmonster.com|||I don't know what else it could be. I have a slower computer and don't see
this. Do you have SQL Server and IIS locally as well? If so then SQL Server,
IIS, VS is a lot in 256 MB. Bring up task manager and see what is going on,
you should be able to see memory usage.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Cymbala via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:d3fba556874c4760b739831eb8e33089@.SQLMonster.com...
> I am using a shared datasource. I wish I knew if increasing memory would
solve this problem before upgrading. Thanks for your responses. Dave
> --
> Message posted via http://www.sqlmonster.com