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.
A Better Solution Through OneStream Software
At the time of the original publication of this article in January 2015, SmartView was once a premier software tool in the Enterprise Performance Management (EPM) or Corporate Performance Management (CPM) toolbox.
Since our origination in 2012, HollandParker is a CPM software consulting firm that specializes in best-of-breed CPM software implementation solutions for Fortune 500 corporations and global enterprise companies to medium and small businesses across North America. From 2012 to 2017, we supported Oracle performance management products. Now, the market has changed. OneStream Software is the leader in corporate performance management solutions for global organizations of all sizes, providing a single platform, OneStream XF, that replaces fragmented legacy applications.
In 2015, our partnership with OneStream began. And, due to client demand, we made a 100 percent business commitment to the OneStream partnership in 2017. OneStream has created a series of capabilities that all naturally live and work together so that organizations don’t have to do the hard part of integrating or connecting separate technologies together. OneStream built one product that has a full set of capabilities to solve the most sophisticated business problems. We are proud of our 100 percent company dedication to OneStream and to be a top OneStream Implementation Partner with Diamond status. Find out more about migrating to OneStream and our Diamond OneStream Implementation process by contacting HollandParker today.