?
Solved

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

Posted on 2008-10-07
6
Medium Priority
?
1,291 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
3 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 2000 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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
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.
This video shows how to recover a database from a user managed backup
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

600 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