I have a VS2005 Windows application that displays a reportviewer (SQL 2005) report in a tab control, then displays a second report in a second tab with reportviewer, and so on. The really strange thing is that I had this application working for about 3 months. I even had up to 30 reports in 30 tabs at one point. BUT, for some reason now all I get is the first report and the second, third, etc. tabs show a reportviewer with "Report being generated" that never displays the report. Even worse, another user is able to run this application and DOES get all the reports displayed. So what could have been updated on my PC that is causing this problem?
Thanks in advance.
The obvious question to ask is what's changed? Have you installed any service packs or updates recently? Maybe it was some new software?|||I was hoping someone else could tell me what installations might cause this problem, because I can't be 100% sure what updates have been done to my PC. Our Network Services group pushes updates and with MS always forcing updates, it's difficult nowadays to know what's going on on your own PC. Anyway, in January, I installed Red Gate's SQL Prompt 3 and Net Services pushed McAfee OAS. I don't know the exact day Report Viewer stopped working, but I'm pretty sure it was working after these installs. The SQL Server/SSRS 2005 is running on SP1, my client SQL is on SP1. Here's the header info in the most recent SSRS log:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\ReportServer__02_22_2007_21_43_20.log</Path>
<SystemName>BNTRA</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
Here are the last few lines in this log, that show me trying to run 2 reports. It looks like it does the same processing for both reports here, but it just can't display the report in the viewer.
w3wp!library!5!02/22/2007-22:08:11:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!library!1!02/22/2007-22:08:12:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!webserver!5!02/22/2007-22:08:12:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!webserver!1!02/22/2007-22:08:13:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!library!5!2/22/2007-22:13:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!library!a!2/22/2007-22:23:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!5!2/22/2007-22:29:04:: i INFO: Reporting Web Server stopped
Need more info? THANKS.
|||After a lot of searching and matching dlls, it looks like that VS 2005 SP1 is my problem. I've started another thread here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1279959&SiteID=1
No comments:
Post a Comment