Solved

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

Posted on 2007-11-21
3
1,541 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now