Solved

ASP.NET Report Viewer Error: Execution 'sveo20ispltbq0iwtgrlliaq' cannot be found

Posted on 2007-11-21
3
1,545 Views
Last Modified: 2013-11-07
Situation:

ASP.NET 2 Website using the ReportViewer control to view a Reporting Services report.

I get an error similar to "Execution 'sveo20ispltbq0iwtgrlliaq' cannot be found" (with the random string changing with each instance of a new error) intermittently when trying to view reports.
0
Comment
Question by:DavidGreenfield
3 Comments
 
LVL 16

Accepted Solution

by:
SQL_SERVER_DBA earned 500 total points
ID: 20329181
Hi,

I am able to resolve my problem. The issue was "When I assign HistoryID to Report Viewer control it was not creating an execution on the server with this HistoryID resulting execution not found error.

The way I resolved it by using ReportExecution2005 web service to load a report based on History ID and then display that report in Report Viwer control.

Here is the code that I used to make it work:

First you need to make web reference to ReportExecution2005 (check this out: http://support.microsoft.com/?kbid=875447)

//***********************************************************

ExecutionInfo execInfo = new ExecutionInfo();

ExecutionHeader execHeader = new ExecutionHeader();

ReportExecutionService re = new ReportExecutionService() ;

re.ExecutionHeaderValue = execHeader;

execInfo = re.LoadReport(reportPath, GetHistorySnapshot(index).HistoryID);

reportViewer.ServerReport.SetExecutionId(execInfo.ExecutionID);

//************************************************************************

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=322915&SiteID=1

0
 
LVL 1

Expert Comment

by:Computer101
ID: 21135866
Forced accept.

Computer101
EE Admin
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question