Recently I have been tearing my hair out with SmartView as whenever I perform a large query against my Essbase cube I receive a timeout that suggests I should up the NetRetryCount.
“Fine” I thought, so I updated the Essbase.cfg file with the following (just to be sure):
NETDELAY 8000
NETRETRYCOUNT 8000
and restarted Essbase and re-tried my query.
Same Error! That config change seems to have done nothing.
A little hunting around later, I discovered there was another setting I need to change (in APS essbase.properties file). Of course! I am connecting through provider services to connect to Essase. It is APS that is timing out. So I update essbase.properties to:
olap.server.netConnectRetry=8000
olap.server.netDelay=8000
olap.server.netSocketTimeOut=800
restarted Provider Services (and Essbase for good measure) and re-tried my query.
Grrr! Same error! What is going on?
Some more hunting around and reading endless posts of making sure you restart the services after changing the config settings I stumbled across this forum http://www.network54.com/Forum/58296/message/1212599342/Hyperion+figured+out+my+issue
It seems Internet Explorer has a default timeout, and it seems that SmartView uses these settings:
http://support.microsoft.com/kb/813827
http://support.microsoft.com/kb/181050
IE 6 has a default of timeout of 60 seconds and 7 has a default of 30 seconds. I added the following registry settings
[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]
"ReceiveTimeout"=dword:00075300
"KeepAliveTimeout"=dword:000493e0
"ServerInfoTimeout"=dword:000493e0
Where 000493e0 = 5 minutes and 00075300 = 8 minutes.
I restarted Excel and I no longer received the timeout Increase NetRetryCount issue. I will now include this in any install I do of SmartView
I hope this helps someone else. I feel your pain!