My Oracle Support Banner

Smartview is Slow or Unable To Retrieve Data From an Essbase Server Via Analytic Provider Services (Doc ID 1093717.1)

Last updated on SEPTEMBER 19, 2018

Applies to:

Hyperion Essbase - Version 9.3.1.0.00 and later
Microsoft Windows (32-bit)

Symptoms

Delays when retrieving data using SmartView.
Also seeing the following errors:

"OLAP_error (1290002):Network Error [10061]: Unable to connect to [<server>:32768]. The client timed out waiting to connect to Essbase server using TCP/IP. Make sure that the client machine has sufficient number of ports available."

"Analytic Server Error:1042006, Network Error [10061]: Unable to connect to [essbase_hostname:port] The client timeout waiting to connect to the Essbase Agent using TCP/IP"

"#Invalid member 'xxxx' for dimension 'xxxx' " When Refreshing Sheet

Note:
The port number here is the port the Application runs on and may therefore be from the range between 32768 and 33768 (if running on default Essbase ports).

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.