SSRS 2008 Report error in ASP.Net Application

Hi all,

while displaying report in my ASP.net application it shows the below error mesaage.

But while viewing on Reports server, it works fine.

Kindly let me know How to fix this.?

Note: SQL server 2008.

Timestamp: 26/07/2017 09:54:45

Message: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at ReportExecutionServiceAPI.ReportExecutionService.LoadReport(String Report, String HistoryID)

at ShowReport.RenderReportInPdfFormat(String reportName, String historyID, String reportPath)

at ShowReport.Page_Load(Object sender, EventArgs e)

Description:System.Web.Services.Protocols.SoapException: The report snapshot '2017-07-26T09:54:44' cannot be found for report '/XXXXXXReports/xxxxxdetails'. The snapshot identifier cannot be located in the report server database. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportHistoryNotFoundException: The report snapshot '2017-07-26T09:54:44' cannot be found for report '/XXXXXXReports/xxxxxdetails'. The snapshot identifier cannot be located in the report server database.

at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo2& executionInfo)

at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)

Category: General

Priority: -1

EventId: 0

Severity: Information

Title:

Machine: XXXXXXXXXXX

Application Domain: /LM/W3SVC/1/ROOT/hram_dev-1-131455364677067156

Process Id: support1

Process Name: c:\windows\system32\inetsrv\w3wp.exe

Win32 Thread Id: 8060

Thread Name:

Extended Properties:

The report snapshot does not exist on the SSRS Report Server when the ASP.NET application tries to access it. While it works on the Report Server directly, it fails in the application because:

The snapshot identifier is incorrect, missing, or expired.
The application is trying to load a snapshot instead of an on-demand report.
The report is set to use caching or snapshots, but no valid snapshot is available.

Check if the report is set to use snapshots

Go to SSRS Report Manager (http:///Reports).
Navigate to the report and check its execution properties.
If it's set to always use a report snapshot, ensure at least one snapshot exists.
Try disabling snapshots and running the report on-demand.

If the report is configured to use snapshots:

Open Report Manager → Find the report.
Go to Manage > History.
Delete old snapshots.
Manually create a new snapshot.

If you want to avoid snapshot-related issues, modify your ASP.NET code to execute the report without relying on snapshots.

Instead of:

reportExecutionService.LoadReport(reportName, historyID);

Use:

reportExecutionService.LoadReport(reportName, null);

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amira Bedhiafi1y ago
The report snapshot does not exist on the SSRS Report Server when the ASP.NET application tries to access it. While it works on the Report Server directly, it fails in the application because:
1. The snapshot identifier is incorrect, missing, or expired.
2. The application is trying to load a snapshot instead of an on-demand report.
3. The report is set to use caching or snapshots, but no valid snapshot is available.
Check if the report is set to use snapshots
- Go to SSRS Report Manager (http:///Reports).
- Navigate to the report and check its execution properties.
- If it's set to always use a report snapshot, ensure at least one snapshot exists.
- Try disabling snapshots and running the report on-demand.
If the report is configured to use snapshots:
- Open Report Manager → Find the report.
- Go to Manage > History.
- Delete old snapshots.
- Manually create a new snapshot.
If you want to avoid snapshot-related issues, modify your ASP.NET code to execute the report without relying on snapshots.

Instead of:
```
reportExecutionService.LoadReport(reportName, historyID);
```
Use:
```
reportExecutionService.LoadReport(reportName, null);
```