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

Last updated on MAY 19, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms