This content has been marked as final. Show 10 replies
Please see known issue #11772464 => http://docs.oracle.com/cd/E17236_01/epm.1112/readme/aps_1112100_readme.html
Thanks for your reply Todd
In the same readme provided look under #9404387, they state that is is resolved or am I mis-reading it?
Also do you know what they mean by a XMLA stateless session? I am pretty sure I am just running a SmartView session as I can see the session under the Essbase Provider Server and its states it is a SmartView session.
Did you apply the settings to the APS server too? This is the information Oracle sent to me for an unrelated but similar issue.
If on Windows, please check the following reg key values:
Another possible culprit I can think of is heap size.
With regards to where to set Java Heap, please refer to the following doc:
Did you apply the reg settings to both client, as well as APS server?
Please also apply the following:
Reg Settings: Local Machine\System\CurrentControlSet\Services\TCPIP\Parameters
Add/amend NETDELAY 1000 and NETRETRYCOUNT 1500 - in essbase.cfg and stop/start Essbase/APS
I haven't fully applied the settings (it's for a client I won't get the chance until next week) so can't say if it works or not, but your certainly sounds like a timeout error.
Hope it helps.
Chapter: Increasing the JVM Memory Allocation
Hi Jasmine / Steve
We have applied Patch 11823281 and since then we are getting that error. However rolling back to the original 126.96.36.199 version of APS we got a similar problem but a different error.
We were getting Invalid Pointer decompression error. This is after we have disabled compression in the APS server. However after more investigation we were getting this error after SmartView runs for 5mins as well.
Currently I just don't seem to be able to execute a SmartView query over 5mins with 188.8.131.52. The query is still running in Essbase, however we get the error from the client end. This is happening both to an ASO and BSO cube.
I thought at a previous client I was able to execute a 40min query via SmartView. The only thing that is difference is that they were on Excel 2003 as oppose to Excel 2007.
I have also updated the java heap size via the Windows Registry and updated a number of settings in the registry both at the client and server. However I will review the registry setting that you have recommended and see what results I get.
Just incase it helps someone, Oracle advised me to update the weblogic configuration file and updated the APS provider timeout. Once that was updated, we could execute queries in SmartView over 5mins.
I'm having the same issue, can you give me the configuration file name and setting you changed.
Depending if you have a distributed environment setup locate the configuration mod_wl_ohs.conf on the server hosting the Provider Service and Oracle HTTP server.
Edit the file and add the following 2 lines highlighted in bold and restart your Oracle HTTP and APS services. The timeout is set to 60mins.
Let me know how you go.
Thanks for the additional details. I tried changing those settings and re-starting APS and OHS service but I still got the same error at exactly 5 minutes. I have opened an SR with Oracle, I'll update this thread if I get more information.
If you have a distributed environment trying changing what I suggested on all the servers that contain Weblogic.
We had the case raised as a Sev 1 and after going through development, they told us it was just our setup and that something in the Weblogic file needed to be updated.
Edited by: myjim on 20/03/2012 18:14