Solved

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

Posted on 2008-10-07
6
1,282 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

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.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

751 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