OBIEE 11g Error Occurs While Calling Remote Service ADMImportService. Details:Failed To Connect To ADM. (Doc ID 1570586.1)

Last updated on JANUARY 23, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 and later
Hyperion Financial Management - Version 11.1.2.1.000 and later
Information in this document applies to any platform.

Symptoms

Trying to use Hyperion ADM driver to connect to HFM, receive an error:


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

Oracle BI Administration Tool
The connection has failed.
[nQSError: 77031] Error occurs while calling remote service ADMImportService. Details: Details:
Failed to connect to ADM.
com.hyperion.ap.APException: [1033] Native: -2147220966 Error reference number: {CA2C736E-53A9-4ACA-B8C4-6AC074F71D8F}
Svr: SGDCHARISHKUM02:File: CHsxClient.cpp


ADDITINAL ERRORS IN LOGS
-----------------------

[2013-07-05T12:52:46.000+08:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 23cc]  [nQSError: 77031] Error occurs while calling remote service ADMImportService. Details: Details:  [[
Failed to connect to ADM.
com.hyperion.ap.APException: [1033] Native: -2147220966 Error Reference Number: {6D3B0A16-E097-489B-9BF0-020A99B719D6}
Num: 0x8004021a;Type: 0;DTime: 7/5/2013 12:52:46 PM;Svr: SGDCHARISHKUM02;File: CHsxClient.cpp;Line: 2417;Ver: 11.1.2.1.000.3082;ExErr: Unknown Error;
Num: 0x8004021a;Type: 0;DTime: 7/5/2013 12:52:46 PM;Svr: SGDCHARISHKUM02;File: HsvADMDriverSessionInternal.cpp;Line: 305;Ver: 11.1.2.1.000.3082;
at com.hyperion.ap.adm.HssEnvironment.createException(HssEnvironment.java:195)


jh.log
---------

[2013-07-05T12:52:46.273+08:00] [init] [ERROR] [] [saw.init.application] [tid: 14] [ecid: 0000JyhBDpq5yW^5xV_AiW1HpZYH00004g,0]  [Thread 20] Service failed - ADMImportService. Details:Failed to connect to ADM.[[
com.hyperion.ap.APException: [1033] Native: -2147220966 Error Reference Number: {6D3B0A16-E097-489B-9BF0-020A99B719D6}
Num: 0x8004021a;Type: 0;DTime: 7/5/2013 12:52:46 PM;Svr: SGDCHARISHKUM02;File: CHsxClient.cpp;Line: 2417;Ver: 11.1.2.1.000.3082;ExErr: Unknown Error;
Num: 0x8004021a;Type: 0;DTime: 7/5/2013 12:52:46 PM;Svr: SGDCHARISHKUM02;File: HsvADMDriverSessionInternal.cpp;Line: 305;Ver: 11.1.2.1.000.3082;
at com.hyperion.ap.adm.HssEnvironment.createException(HssEnvironment.java:195)



STEPS
--------------

  1. Ran through the steps in the section 'For Hyperion Financial Management 11.1.2' in this document to set this up:
    http://docs.oracle.com/cd/E21764_01/bi.1111/e10540/datasource.htm#CHDCHBJA
  2. While doing import Metadata , and keying in all the details and clicking next button, receive the error above stated.


FURTHER INFO
-------------------------

  • - Customers opmn.xml contains the following (so it is referencing the 64 bit ADM_HOME path):
  • - In the HFM client configuration, this has been set: Start -> All programs -> Hyperion -> Financial Management -> Server and Web configuration. Then go to server/cluster registration tab. Then click on the Enable DCOM button on the right side. Now enter the IP address of the HFM server in the text box. Then click "use one server only" and then click add. Then click ok to exit the window.
  • - there is no space in the alias name for any of the HFM dimensions.
  • - using weblogic user
  • - HFM client is able to connect to remote server. So is UDL file
  • - There is only one JavaHost Process

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