This is on version 11.1.1.3
Increased netRetryCount and netDelay in Essbase.cfg
NetDelay 2000
NetRetryCount 6000
Increased the timeout and network settings in the \Hyperion\Products\Essbase\aps\bin\essbase.properties file:
netRetryCount=600 TO 6000
netConnectRetry=3 TO 30
netDelay=200 TO 2000
netSocketTimeOut=200 TO 20000
But still getting the error "Cannot connect to the provider because: The request timed out. Contact your administrator to increase netRetryCount and netRetryInterval
Implemented the below steps to resolve this issue
i) Add the Provider server details under the provider servers tab and the Essbase server as a standalone server in EAS console.
ii) Implement the below in both APS and Essbase server:
1. Open the Windows Registry.
2. Navigate to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\TCPIP\Parameters.
3. Add new
DWORD Value named "TcpTimedWaitDelay"
Select "decimal" radio button, type in 30.
The default value forTcpTimedWaitDelay is 2 minutes. This is how long it will take for a TCP/IP port that was used by the network for a connection to be released and made available again. 30 seconds is the minimum allowed by Microsoft
4. Add new
DWORD Value named MaxUserPort
Select "decimal" radio button, type in 65534.
The default value forMaxUserPort is 5000. This determines the highest port number TCP can assign when an application requests an available user port from the system.
5. Add new
DWORD Value named MaxFreeTcbs
Select decimal radio button, type in 6250.
The default value for MaxFreeTcbs is 2000. This determines the number of TCP control blocks(TCBs) the system creates to support active connections. Since each connection requires a control block, this value determines how many active connections TCP can support simultaneously. If all control blocks are used and more connection requests arrive, TCP can prematurely release connections in the TIME_WAIT state in order to free a control block for a new connection
6. Re-start the machine.
7. Re-start the Hyperion Services including the Analytic Provider Services Service.
iii) On the client machine, update/add the following registry keys:
1. Open the Registry, Start -> Run -> Regedit.
2. Locate the following section:
[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]\
3.Create the following new DWORD keys with decimal values:
ReceiveTimeout=480000
KeepAliveTimeout=180000
ServerInfoTimeout=180000
In this example, the ReceiveTimeout setting is 8 minutes. The KeepAliveTimeout and ServerInfoTimeout settings are 3 minutes. Set these to greater than the longest running request.
4. Restart the machine for the new settings to take effect.
Now "Cannot connect to the provider" issue has been resolved.
NetDelay 2000
NetRetryCount 6000
Increased the timeout and network settings in the \Hyperion\Products\Essbase\aps\bin\essbase.properties file:
netRetryCount=600 TO 6000
netConnectRetry=3 TO 30
netDelay=200 TO 2000
netSocketTimeOut=200 TO 20000
But still getting the error "Cannot connect to the provider because: The request timed out. Contact your administrator to increase netRetryCount and netRetryInterval
Implemented the below steps to resolve this issue
i) Add the Provider server details under the provider servers tab and the Essbase server as a standalone server in EAS console.
ii) Implement the below in both APS and Essbase server:
1. Open the Windows Registry.
2. Navigate to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\TCPIP\Parameters.
3. Add new
DWORD Value named "TcpTimedWaitDelay"
Select "decimal" radio button, type in 30.
The default value forTcpTimedWaitDelay is 2 minutes. This is how long it will take for a TCP/IP port that was used by the network for a connection to be released and made available again. 30 seconds is the minimum allowed by Microsoft
4. Add new
DWORD Value named MaxUserPort
Select "decimal" radio button, type in 65534.
The default value forMaxUserPort is 5000. This determines the highest port number TCP can assign when an application requests an available user port from the system.
5. Add new
DWORD Value named MaxFreeTcbs
Select decimal radio button, type in 6250.
The default value for MaxFreeTcbs is 2000. This determines the number of TCP control blocks(TCBs) the system creates to support active connections. Since each connection requires a control block, this value determines how many active connections TCP can support simultaneously. If all control blocks are used and more connection requests arrive, TCP can prematurely release connections in the TIME_WAIT state in order to free a control block for a new connection
6. Re-start the machine.
7. Re-start the Hyperion Services including the Analytic Provider Services Service.
iii) On the client machine, update/add the following registry keys:
1. Open the Registry, Start -> Run -> Regedit.
2. Locate the following section:
[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]\
3.Create the following new DWORD keys with decimal values:
ReceiveTimeout=480000
KeepAliveTimeout=180000
ServerInfoTimeout=180000
In this example, the ReceiveTimeout setting is 8 minutes. The KeepAliveTimeout and ServerInfoTimeout settings are 3 minutes. Set these to greater than the longest running request.
4. Restart the machine for the new settings to take effect.
Now "Cannot connect to the provider" issue has been resolved.
