Update Registry Settings to Avoid SmartView Time Out Errors

SmartView has come a long way over the years, especially the Planning Ad-Hoc capabilities. Even though the developers have added a ton of new features to SmartView, clients and end users still like to use the tried and true HSGetValue and HSSetValue functions.

While there are many performance settings for Analytic Provider Services and Essbase to increase the performance of SmartView retrievals, nothing can prepare an administrator for a power user that shares their 10 MB excel file containing 100’s of HSGetValue functions and calls each user to hit the refresh button at the same time.

This can turn out to be an administrators worst nightmare especially if a company is right in the middle of their planning or forecast cycle.

So hopefully you are being proactive and reading this prior to this issue appearing, but if not the following should help you fix the issue.

Fix Number 1 – Internet Explorer Timeout Setting on Client Machine

See Support Article #744559.1

Internet Explorer has a very low default timeout setting for retrieving data. SmartView uses Internet Explorer to connect to the Analytic Provider Services (APS) server.

The instructions described below will update Registry Settings in order to avoid the following Smart View Time Out error:

“Request Timed Out. Contact your smartview client system administrator to extend your Windows Internet Explorer timeout settings (Receive Timeout, KeepAlive Timeout and ServerInfo Timeout).”

1. Select Start button on Windows > Type “Run” in the “Search programs and files” bar > Enter

2. In the new Run window, type “regedit” as shown in the image below:

3. In the registry editor, navigate to Computer > HKEY_LOCAL_MACHINE > Software > Microsoft > Windows > Current Version > Internet Settings

Note: It is possible you may need administrative rights to change or modify these settings.

As displayed in the error message, the following keys with their corresponding values must be created:

• ReceiveTimeout: 480000
• KeepAliveTimeout: 180000
• ServerInfoTimeout: 180000

In order to create the new keys,

4. Right click on Internet Settings > New > DWORD (32-bit) Value

5. Type in the key name. For instance, “ReceiveTimeout” > Enter

6. Right Click on “ReceiveTimeout” and select Modify

7. Enter the value of the key and select Hexadecimal

8. Repeat the same steps for the other two keys (KeepAliveTimeout, ServerInfoTimeout)

The updated keys and values should be displayed as shown below:

9. Restart your computer to ensure the changes are updated.

Fix Number 2

See Support Article 852716.1

Locate the Analytic Provider Services (APS) server.

Locate the essbase.properties file in the Oracle Home Directory.

<Drive Letter>OracleMiddlewareEPMSystem11R1productsEssbaseapsbin

Add the following entries to the essbase.properties file:

netRetryCount=6000
netConnectRetry=30
netDelay=2000
netSocketTimeOut=20000

Restart the APS service.

Fix Number 3

See Support Article 1096414.1

Locate the Analytic Provider Services (APS) server.

Ask an end user to run the offending SmartView template.

Open a command prompt and type netstat -an.

Check to see if all the ports are being used up. Windows can only open ~64,000 ports. By default, Windows leaves the ports open for two long so when another user tries to run another query, the query errors out.

To decrease the timeout you can modify the TIME_WAIT delay on the APS server to around 30 seconds.