none
SSRS started throwing errors on Windows Server 2008 R2 machine

    Question

  • I'm not sure whats changed on a client server, but now when anyone tries to connect to report manager it no longer works and the below error is logged:

    I have already read this

    http://blogs.msdn.com/b/sql_protocols/archive/2009/03/09/understanding-the-error-an-operation-on-a-socket-could-not-be-performed-because-the-system-lacked-sufficient-buffer-space-or-because-a-queue-was-full.aspx

    but the machine is a 64 bit windows server 2008 R2 machine and the /3GB switch isnt being used.

    I have also read

    http://support.microsoft.com/kb/196271

    but have no idea if that still applies for the version i am using or how to tell if thats even the problem???

    ui!ReportManager_0-1!43e0!07/24/2013-20:54:31:: e ERROR: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full 127.0.0.1:80
       at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
       at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
       --- 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.ReportingServices2010.ReportingService2010.ListItemTypes()
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<ListItemTypes>b__10f()
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod()
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.ListItemTypes()
       at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
       at Microsoft.ReportingServices.UI.FolderItems.InitializeButtons()
       at Microsoft.ReportingServices.UI.SortableItems.Control_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.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.AddedControl(Control control, Int32 index)
       at Microsoft.ReportingServices.UI.FolderContentsPageCtrl.Control_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.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.AddedControl(Control control, Int32 index)
       at Microsoft.ReportingServices.UI.SharedArea.Control_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.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.AddedControl(Control control, Int32 index)
       at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e)
       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)
    ui!ReportManager_0-1!43e0!07/24/2013-20:54:31:: e ERROR: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full 127.0.0.1:80
       at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
       at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
       --- 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.ReportingServices2010.ReportingService2010.ListItemTypes()
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<ListItemTypes>b__10f()
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod()
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.ListItemTypes()
       at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
       at Microsoft.ReportingServices.UI.GlobalLinks.Control_Init(Object sender, EventArgs args)
    ui!ReportManager_0-1!43e0!07/24/2013-20:54:31:: e ERROR: HTTP status code --> 500
    -------Details--------
    System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full 127.0.0.1:80

       at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)

       at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)

       --- 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.ReportingServices2010.ReportingService2010.ListItemTypes()

       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<ListItemTypes>b__10f()

       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)

       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod()

       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.ListItemTypes()

       at Microsoft.ReportingServices.UI.Global.SecureAllAPI()

       at Microsoft.ReportingServices.UI.FolderItems.InitializeButtons()

       at Microsoft.ReportingServices.UI.SortableItems.Control_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.Control.InitRecursive(Control namingContainer)

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

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

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

       at System.Web.UI.Control.AddedControl(Control control, Int32 index)

       at Microsoft.ReportingServices.UI.FolderContentsPageCtrl.Control_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.Control.InitRecursive(Control namingContainer)

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

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

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

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

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

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

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

       at System.Web.UI.Control.AddedControl(Control control, Int32 index)

       at Microsoft.ReportingServices.UI.SharedArea.Control_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.Control.InitRecursive(Control namingContainer)

       at System.Web.UI.Control.AddedControl(Control control, Int32 index)

       at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e)

       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)
    ui!ReportManager_0-1!43e0!07/24/2013-20:54:31:: e ERROR: 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 Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
    library!WindowsService_0!3f30!07/24/2013-21:03:03:: i INFO: Call to CleanBatch()
    library!WindowsService_0!3f30!07/24/2013-21:03:03:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_0!3f30!07/24/2013-21:03:03:: i INFO: Call to CleanBatch() ends
    library!ReportServer_0-2!42b0!07/24/2013-21:03:11:: Call to GetItemTypeAction(/).
    library!ReportServer_0-2!42b0!07/24/2013-21:03:11:: Call to ListParentsAction(/).
    library!ReportServer_0-2!42b0!07/24/2013-21:03:11:: Call to ListChildrenAction(/, False).
    webserver!ReportServer_0-2!42b0!07/24/2013-21:03:11:: i INFO: Processed folder '/'
    library!ReportServer_0-2!42b0!07/24/2013-21:03:18:: Call to ListParentsAction(/Mineware).
    library!ReportServer_0-2!42b0!07/24/2013-21:03:18:: Call to ListParentsAction(/Mineware).
    library!ReportServer_0-2!42b0!07/24/2013-21:03:18:: Call to ListChildrenAction(/Mineware, False).
    webserver!ReportServer_0-2!42b0!07/24/2013-21:03:18:: i INFO: Processed folder '/Mineware'
    library!ReportServer_0-2!43e0!07/24/2013-21:03:24:: Call to ListParentsAction(/Mineware/Draglines).
    library!ReportServer_0-2!43e0!07/24/2013-21:03:24:: Call to ListParentsAction(/Mineware/Draglines).
    library!ReportServer_0-2!43e0!07/24/2013-21:03:24:: Call to ListChildrenAction(/Mineware/Draglines, False).
    webserver!ReportServer_0-2!43e0!07/24/2013-21:03:24:: i INFO: Processed folder '/Mineware/Draglines'

    Thursday, July 25, 2013 3:34 AM

Answers

  • Hi ReportCreator,

    The issue should occur because the SQL Server Reporting Services connections cause TCP ports to be full on the report server. The solution about modifying the MaxUserPort registry entry introduced in http://support.microsoft.com/kb/196271 also applies to Windows Server 2008 R2.

    Alternatively, you can also run the following command line on the Reporting Services server:

    netsh int ipv4 set dynamicport tcp start=1025 num=58975

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support


    Friday, July 26, 2013 3:32 AM
    Moderator

All replies

  • Hi ReportCreator,

    The issue should occur because the SQL Server Reporting Services connections cause TCP ports to be full on the report server. The solution about modifying the MaxUserPort registry entry introduced in http://support.microsoft.com/kb/196271 also applies to Windows Server 2008 R2.

    Alternatively, you can also run the following command line on the Reporting Services server:

    netsh int ipv4 set dynamicport tcp start=1025 num=58975

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support


    Friday, July 26, 2013 3:32 AM
    Moderator
  • Hi there, i'm not an admin on the machine so i will pass this information on to the IT section of the customers company...

    I would have thought given the amount of things using TCP/IP on the box that we would be seeing the error elsewhere though and we dont seem to be.

    Monday, July 29, 2013 5:09 AM