OAC: BI Repository Will Not Import Data From OAC Essbase Cube (Doc ID 2355857.1)

Last updated on OCTOBER 18, 2019

Applies to:

Symptoms

On : NA version, BI

OAC BI Repository will not import data from OAC Essbase Cute

ERROR
-----------------------

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open the OAC BI Repository via Admin Tool and created a new Database using Database type: Essbase 11.1.2.3500.
2. Create a connection string and try to import the data.  Recieve error: Physical database already exists, but it is not the same provider type.
3. Found a workaround to change the database type to Essbase 9.
4. On occasion, an error is still produced - Essbase Error 1042006, Network error [10060], failed to connect to [oacessbase.servername.net:1423].


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import the data.

Changes

Cause

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