Report Formatting: countless

Showing posts with label countless. Show all posts

Monday, March 12, 2012

Report Manager not responding

Hi,

I'm hoping to get some help here. I've spend countless hours trying to get Reporting Services running without success.

When I run the Report Manager it does not respond. Coming up with Opening page http://localhost/reports/Pages/Folder.aspx. . . The progress bar ticks along but the page never actually loads. The Configuration tool shows green icons everywhere. No errors in the Event viewer.

I am running Windows XP Professional with SP2. I have uninstalled and re-installed IIS, ASP.NET and SQL2005 numerous times. Varying the order, all without success. What else is involved ?

I have loaded Service Pack 1 and the latest hotfixes. What else can I try ?

Thanks in advance,
Claude

Hi,

are you running IE7 Beta 3 ? Then have a look here: http://www.sqlserver2005.de/sqlserver2005/MyBlog/tabid/56/EntryID/10/Default.aspx

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks Jens. I'm using IE 6.

|||Are you able to browse the report server directly (http://servername/reportserver)?|||

Thanks Brain, gives the same non-response.

|||

Some further clues . . .

When I tried connecting to the Report Server with the Management Studio, the following messages appear:

The underlying connection was closed: An unexpected error occurred on a send. (System.Web.Services)

Authentication failed because the remote party has closed the transport stream. (System)

Any ideas ?

|||

Hi,

there should be a more detailed log in the directory of Reporting Services, perhaps you could try to investigate that and send the relevant portion to the forum, thanks.

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I have a similar problem as Claude. I have two instances of SQL Server (2000 and 2005) installed locally. I am using the Developer version of 2005 running under XP Pro. I dont have administrator rights on my machine.

For some reason I just cannot connect to Report Manager, directly from the browser or from Management Studio. It just hangs and eventually tells you that 'cannot find server'. I tried evrything that Claude has done but no luck.

Any ideas please ?

Thanks

|||Are the services started ? What are the logs telling you ? (event log and log in the log directory)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks Jens.

This is the content of the ReportServerWebApp Logfile:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>New Zealand Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServerWebApp__08_18_2006_18_32_46.log</Path>
<SystemName>ACKCSABATIER01</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!1!8/18/2006-18:32:47:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
aspnet_wp!ui!1!18/08/2006-18:33:20:: e ERROR: The underlying connection was closed: An unexpected error occurred on a send.
aspnet_wp!ui!1!18/08/2006-18:33:21:: e ERROR: HTTP status code --> 500
-Details--
System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. > System.IO.IOException: Authentication failed because the remote party has closed the transport stream.

at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)

at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)

at System.Net.TlsStream.CallProcessAuthentication(Object state)

at System.Threading.ExecutionContext.runTryCode(Object userData)

at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)

at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result)

at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size)

at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size)

at System.Net.ConnectStream.WriteHeaders(Boolean async)

End of inner exception stack trace

at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)

at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetWebResponse(WebRequest request)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
aspnet_wp!ui!1!18/08/2006-18:33:22:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

|||

Did you get any resolution on this? I can deploy reports from Visual Studio, but I cant manage them. I am having a terrible time trying to get the Server Mangement Studio to connect to Reporting Services. I get the same errors in my logs:System.Net.WebException:

The underlying connection was closed: An unexpected error occurred on a send. > System.IO.IOException: Authentication failed because the remote party has closed the transport stream.