Solved

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

Posted on 2008-10-07
6
1,277 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to recover a database from a user managed backup

786 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