Windows: no buffer space available


The problem

Today one of an OBIEE servers installed on MS Windows Server 2008 R2 started to show an HTTP error 500 and to throw the following messages to the Windows event log every 12 seconds:

Message #1


The description for Event ID 33 from source Oracle BI Utility cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:
[nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [nQSError: 12010] Communication error connecting to remote end point: address = >deleted hostname>; port = 9706. [nQSError: 12008] Unable to connect to port 9706 on machine >deleted hostname>.

the message resource is present but the message is not found in the string/message table

Message #2


The description for Event ID 21 from source Oracle BI Utility cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:

[71008] Cluster Controller started. Version: 11.1.1.7.1

the message resource is present but the message is not found in the string/message table


Message #3


The description for Event ID 33 from source Oracle BI Utility cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:

[nQSError: 12008] Unable to connect to port 0 on machine 0.

the message resource is present but the message is not found in the string/message table


The OBIEE logs were showing different connection problems, the default scripts were unable to stop anything. It was impossible to connect from this machine to DB host with ssh. The error was Network Error: no buffer space available. But when I killed the OBIEE processes (using task manager), a network started to work fine. Start OBIEE - a network stops to work, kill OBIEE - it starts to work.

The solution

This problem is described in Microsoft KB When you try to connect from TCP ports greater than 5000 you receive the error 'WSAENOBUFS (10055)'. This a very old problem. I've found this problem mentions in blog posts for 2010 year. The KB offers the solution:

1. Start Registry Editor. 2. Locate the following subkey in the registry, and then click Parameters: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters 3. On the Edit menu, click New, and then add the following registry entry: Value Name: MaxUserPort Value Type: DWORD Value data: 65534 Valid Range: 5000-65534 (decimal) Default: 0x1388 (5000 decimal) Description: This parameter controls the maximum port number that is used when a program requests any available user port from the system. Typically, ephemeral (short-lived) ports are allocated between the values of 1024 and 5000 inclusive. After the release of security bulletin MS08-037, the behavior of Windows Server 2003 was changed to more closely match that of Windows Server 2008 and Windows Vista.

There is also available a Hotfix for the Server 2008 R2 and Windows 7: Kernel sockets leak on a multiprocessor computer that is running Windows Server 2008 R2 or Windows 7. I've added the suggested parameter and everything started to work fine. I don't know why it stopped to work after more than two years of normal operation.

PS. It wasn't a server I am responsible for, so don't blame me for not keeping it actual and updated. :)

windows troubleshooting obiee


Andrew Fomin Profile Picture
Andrew Fomin

OBIEE specialist since 2007 and Oracle Discoverer before. DWH architect, BI enthusiast, blogger. Lazy cats owner. All opinions are my own and not the views of my employer.


Additional Posts
Share This Post
Twitter Google+ Pinterest Facebook
comments powered by HyperComments