April 28, 2010 at 2:44 pm
Hello,
Recently upgraded my home development pc to Windows 7 x64.
Its running SQL Server 2005 SP3 developer version.
I'm having trouble accessing my reports using IE8 via the Report Manager, http://servername/Reports
the "Report is being generated" message runs for a v. long time until eventually I get:
The underlying connection was closed: An unexpected error occurred on a receive.
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
An existing connection was forcibly closed by the remote host
I can render the reports via Report Server, http://servername/Reportserver and also via BIDS.
It also works using firefox, so I believe its something to do with IE8.
Can anyone shed any light on this?
many thanks,
Dom
April 29, 2010 at 10:43 am
by the way, the PC is also running IIS 7.0
----------
Update.....I've tried altering settings for my Network card driver, namely enabling/disabling TCP offload as someone had suggested but to no avail.
What puzzles me is that this error only seems to occur when using Report Manager in IE8 (also tried with the browser mode to IE7).
Report Server works fine and I can view Reports using Report Manager in, for example Firefox.
I've tried with various 'test reports, one querying a local db, one simply returning text and one with a simple parameter. None render but the paramater values are returned!
Could it be my IIS settings? Anyone familiar with IIS???
Thanks,
Dom
April 30, 2010 at 7:16 am
Looking thru the reporting services log files I have found:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__04_30_2010_10_40_33.log</Path>
<SystemName>DOM-PC</SystemName>
<OSName>Microsoft Windows NT 6.1.7600.0</OSName>
<OSVersion>6.1.7600.0</OSVersion>
</Header>
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!30/04/2010-10:40:34:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!4!30/04/2010-10:40:34:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!4!30/04/2010-10:40:34:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!library!8!30/04/2010-10:40:40:: i INFO: Catalog SQL Server Edition = Developer
ReportingServicesService!crypto!8!30/04/2010-10:40:40:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!8!30/04/2010-10:40:40:: i INFO: Exporting public key
ReportingServicesService!crypto!8!30/04/2010-10:40:40:: i INFO: Performing sku validation
ReportingServicesService!crypto!8!30/04/2010-10:40:40:: i INFO: Importing existing encryption key
ReportingServicesService!dbpolling!8!04/30/2010-10:40:40:: i INFO: EventPolling polling service started
ReportingServicesService!dbpolling!8!04/30/2010-10:40:40:: i INFO: NotificationPolling polling service started
ReportingServicesService!dbpolling!8!04/30/2010-10:40:40:: i INFO: SchedulePolling polling service started
ReportingServicesService!dbpolling!8!04/30/2010-10:40:40:: i INFO: UpgradePolling polling service started
ReportingServicesService!dbpolling!b!30/04/2010-10:40:40:: i INFO: NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!a!30/04/2010-10:40:40:: i INFO: EventPolling heartbeat thread started.
ReportingServicesService!dbpolling!c!30/04/2010-10:40:40:: i INFO: Polling started
ReportingServicesService!runningjobs!8!04/30/2010-10:40:40:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!8!04/30/2010-10:40:40:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!8!04/30/2010-10:40:40:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!8!04/30/2010-10:40:40:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 55159 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!8!04/30/2010-10:40:40:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!8!04/30/2010-10:40:40:: i INFO: SQM timer timer enabled: Next Event: 58759 seconds. Cycle: 86400 seconds
ReportingServicesService!dbpolling!c!30/04/2010-10:49:21:: e ERROR: Polling caught an exception, restarting polling. Error Message System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteReader()
at Microsoft.ReportingServices.Library.DBPoll.PollingFunction()
at Microsoft.ReportingServices.Library.DBPoll.PollingStartFunction().
I've also restarted reporting services, replicated the error but can't find the above error repeated in more recent logs.....
May 4, 2010 at 11:11 am
anyone?
May 11, 2010 at 6:14 am
Dom,
I don't have an answer for you. I just wanted to chime in that I've been experiencing plenty of sporadic problems with IE8 and Report Manager as well (on Windows XP with sp3): timeout errors and 'Internet Explorer cannot display the webpage' error.
I can't even reliably get a report to have its execution property set to a report snapshot, either, when I'm using IE8. Are you able to create a report snapshot, specifcally when choosing the option "Create a report snapshot when you click the Apply button on this page"?
Too bad the discussion forum on MSDN for reporting services isn't much help either...
--pete
June 13, 2010 at 10:11 pm
Dom
I have the same problem, did you figure it out?
Cheers
June 14, 2010 at 3:25 am
Pete, Iain
I think I may have figured it out. I'm running the free edition of AVG 9.0 and by disabling the 'LinkScanner' component I've got things to work. Funny thing was that I was sure I'd tried disabling the anti-virus software as part of my process of elimination!
cheers,
dom
June 14, 2010 at 3:58 am
That worked for me too.
Thanks Dom.
I would never have found that out on my own.
Cheers
June 14, 2010 at 5:49 am
No problem....it took me a while to suss it out!
I've notified AVG of the issue too.
June 14, 2010 at 5:57 am
Dom:
Interesting solution -- is your problem situation based on a local (development) setup (IE8, SSRS, and AVG all on the same box)?
In my case, I have to connect to a vendor's instance of SSRS. Turning LinkScanner off in my PC didn't yield success.
--pete
June 14, 2010 at 6:01 am
Hi Pete,
yes its a development setup all on one box
June 24, 2010 at 5:40 am
Thanks for pointing me in the right diection. Turning off Link Scanner didnt resolve it but it now works after turning off AVG’s Online Web Protection AND Active Surf Shield
Cheers
Alan
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply