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

Last updated on AUGUST 03, 2023

Applies to:

Hyperion Essbase - Version 11.1.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

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

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

Applies to:

Symptoms

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!