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!