You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Essbase ASO retrieve

Received Response
11
Views
2
Comments
edited Aug 2, 2018 2:42AM in Essbase 2 comments

Content

On-Prem Essbase 11.1.2.4.014

Windows 2012 Environment

Essbase ASO database with 1.5GB dat file, 1.5GB pending cache size.

 

At times, simple retrieves from this ASO database which usually take less than 10 secs run for about 20mins or higher and we end up with stuck threads on the APS side (cluster of 3 managed servers) in WebLogic. When users realize the request is taking lot longer, they simply close Excel and re-launch it with a new session, which further adds to the problem. We see around 50 concurrent retrieve requests in EAS.

Are there any settings or other intricate stuff that we need to be focusing on to be able to figure out a root cause? Appreciate any and all your help.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!