Essbase Studio Cube Deployment Failure, Error: Failed to deploy Essbase cube - Essbase Error(1021001): Failed to Establish Connection With SQL Database Server (Doc ID 1327576.1)

Last updated on OCTOBER 11, 2016

Applies to:

Hyperion Essbase Studio - Version 11.1.2.0.00 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Oct-2013***

Symptoms

When you partially export from Essbase Studio Console metadata a cube schema definition with 'include schema associated Essbase Models' option, the import related to the XML file created fails.

The following error is in the Essbase Studio server.log:

[2011-05-24T14:31:51.178+02:00] [hyperion] [ERROR] [ESSSTD-127004] [com.hyperion.cp.datasources.export.essbase.util] [host: chzrhkessd01.efgz.efg.corp] [nwaddr: 10.30.29.10] [tid: 50] [userId: admin-61] [ecid: 0000Iz^RFPk2jKw5wF_AiW1Dms_D00000d,0] [SRC_CLASS: com.hyperion.cp.datasources.export.essbase.util.EssbaseExportSupport$EssbaseExport] [SRC_METHOD: invoke] Unexpected exception in EssbaseExport prevented cube from being deployed.[[
com.hyperion.cp.datasources.export.essbase.EssbaseDriverException: Failed to deploy Essbase cube.
-
Caused by: com.essbase.api.base.EssException: Cannot get async process state. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server. See log for more information.

Steps to reproduce the issue:
------------------------------------
1. Select a CUBE from Essbase Studio Console Metadata Navigator.
2. Right click select Export. Then keep checked the option 'Include associated Essbase Models with Cube schemas'.
3. Export fails.

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