Solved

SQL Server 2005 Reporting services sometimes subscriptions don't run or don't deliver

Posted on 2008-10-07
6
1,280 Views
Last Modified: 2013-12-07
I'm having an issue with running subscription reports on SQL Server 2005 Reporting Services.  When i set up a subscription for a report to run, sometimes it runs, and sometimes it doesn't.  It appears to be totally random...when i look at the error logs on the server, i get 2 different errors...i'll post them here...

ERROR #1

Source:: ASP.NET 2.0.50727.0
Category:Web Event
Event ID:1309

Code snippet is attached...

ERROR #2

Source: Report Server (MSSQLSERVER)
Category:Extension
Event ID: 108

Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary extension.

Any help would be appreciated!
Event code: 3005 
Event message: An unhandled exception has occurred. 
Event time: 10/6/2008 5:04:18 PM 
Event time (UTC): 10/7/2008 12:04:18 AM 
Event ID: 285c9257e007424a889590111832e39e 
Event sequence: 448 
Event occurrence: 1 
Event detail code: 0 
 
Application information: 
    Application domain: /LM/W3SVC/1/Root/Reports-1-128677690827483586 
    Trust level: RosettaMgr 
    Application Virtual Path: /Reports 
    Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\ 
    Machine name: WAREHOUSE 
 
Process information: 
    Process ID: 4840 
    Process name: w3wp.exe 
    Account name: NT AUTHORITY\NETWORK SERVICE 
 
Exception information: 
    Exception type: ReportServerException 
    Exception message: Execution 'vugphuuihuzhs5552eli4j45' cannot be found (rsExecutionNotFound) 
 
Request information: 
    Request URL: http://warehouse.nearbynow.com/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=vugphuuihuzhs5552eli4j45&ControlID=146e87d6613946dc9ca57be6329816fb&Culture=1033&UICulture=9&ReportStack=1&OpType=ReportArea&Controller=ctl139&PageNumber=1&ZoomMode=Percent&ZoomPct=100&ReloadDocMap=true&SearchStartPage=0&LinkTarget=_top 
    Request path: /Reports/Reserved.ReportViewerWebControl.axd 
    User host address: 172.28.2.65 
    User: NEARBYNOW\lenny 
    Is authenticated: True 
    Authentication Type: NTLM 
    Thread account name: NT AUTHORITY\NETWORK SERVICE 
 
Thread information: 
    Thread ID: 9 
    Thread account name: NT AUTHORITY\NETWORK SERVICE 
    Is impersonating: True 
    Stack trace:    at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
   at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
   at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
   at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
   at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
   at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Open in new window

0
Comment
Question by:webd88
  • 2
6 Comments
 
LVL 1

Author Comment

by:webd88
ID: 22683297
Anyone have any thoughts on this?  
0
 
LVL 1

Author Comment

by:webd88
ID: 22717053
could i please have an expert look at this question?  
0
 
LVL 22

Accepted Solution

by:
PedroCGD earned 500 total points
ID: 22784844
look to cumulative package 7 or 9... not only install but see all the bugs that these versions fix.
regards!!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Code works but breaks when I add one section 4 27
ASP.NET MVC - Views 3 38
asp web application 3 37
Can I skip a node in XML? 9 30
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

740 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