Tuesday 12 April 2016

OBIEE 12c and Planning

Following on from my last post about configuring OBIEE 12c with HFM I thought I'd give EPM Hyperion Planning a bash.

Integration with EPM Planning was supported in OBIEE 11.1.1.9 and didn't require any configuration. You just had to make sure you used the html character code to replace the colon for the host:port and the Planning metadata imported successfully:

adm:thin:com.hyperion.ap.hsp.HspAdmDriver:ServerName%3A19000:AppName

You would expect that since this worked out of the box in 11.1.1.9 that it would also work in 12c right?

Wrong!

You'll get the following error when trying to import the metadata:

The connection has failed. [nQSError: 77031] Error occurs while calling remote service ADMImportService.
Details: Details: com.hyperion.ap.APException: [1085]
Error: Error creating objectjava.lang.ClassNotFoundException




Many thanks to Ziga who also encountered the same error and blogged the solution here:

http://zigavaupot.blogspot.co.uk/2016/02/obi-12c-series-connecting-obi-with.html.

The solution is hidden in the Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition:

"For Hyperion Planning 11.1.2.4 or later, the installer does not deliver all of the required client driver .jar files. To ensure that you have all of the needed .jar files, go to your instance of Hyperion, locate and copy the adm.jar, ap.jar, and HspAdm.jar files and paste them into
MIDDLEWARE_HOME\oracle_common\modules."

Copy the following files from your Planning install:

  • E:\Oracle\Middleware\EPMSystem11R1\common\ADM\11.1.2.0\lib\adm.jar
  • E:\Oracle\Middleware\EPMSystem11R1\common\ADM\11.1.2.0\lib\ap.jar
  • E:\Oracle\Middleware\EPMSystem11R1\common\ADM\Planning\11.1.2.0\lib\HspAdm.jar

to this location on your OBIEE 12c server:

  • E:\Oracle\OBIEE\Oracle_Home\oracle_common\modules

Restart the services and away you go:


6 comments:

  1. Hi
    We copied the jar files to the mentioned path in OBIEEE server .. but still getting same error.

    ReplyDelete
  2. Hi Guillaume,

    I copied the jar files in BI install from hyperion and getting the below error in admin tool log file while making in connection in OBIEE RPD :

    [tid: 261c] [nQSError: 77027] Failed to find environment variable INSTANCE_NAME on start -- exiting! [[
    file: server\Utility\JavaIntegration\Src\SUJIJavaHostService.cpp; line: 900
    Error Codes: S7B9SSUG
    occurs inside SAW RPC modules when calling ADMImportService.

    Please help!!

    Thanks

    ReplyDelete
    Replies
    1. did you ever figure out this error. We get the same error meesage. The hyperion EPM server is a Windows server. The OBIEE server is a linux server:

      [2017-11-16T15:06:31.636-08:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: service1] [tid: 2164] [nQSError: 77027] Failed to find environment variable INSTANCE_NAME on start -- exiting! [[
      file: server\Utility\JavaIntegration\Src\SUJIJavaHostService.cpp; line: 900
      Error Codes: S7B9SSUG
      occurs inside SAW RPC modules when calling ADMImportService.
      ]]
      [2017-11-16T15:06:31.649-08:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: service1] [tid: 2164] Could not connect to the data source. A more detailed error message has been written to the BI Administrator log file.

      Delete
    2. I got the same error message " [nQSError: 77027] Failed to find environment variable INSTANCE_NAME on start -- exiting! [[
      file: server\Utility\JavaIntegration\Src\SUJIJavaHostService.cpp; line: 900
      Error Codes: S7B9SSUG
      occurs inside SAW RPC modules when calling ADMImportService.
      ]]"

      How did you guys solve it ?

      Delete
    3. Sorry to respond to an older message but i am getting the same error message. After copying the .jar files to both OBIEE server my desktop, i am not able to resolve. Not much help online with this issue either. Anyone with the knowledge..please share:

      =============================================
      [2018-02-05T11:34:50.444-05:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: service1] [tid: 3458] [nQSError: 77027] Failed to find environment variable INSTANCE_NAME on start -- exiting! [[
      file: server\Utility\JavaIntegration\Src\SUJIJavaHostService.cpp; line: 900
      Error Codes: S7B9SSUG
      occurs inside SAW RPC modules when calling ADMImportService.
      ]]
      [2018-02-05T11:34:50.446-05:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: service1] [tid: 3458] Could not connect to the data source. A more detailed error message has been written to the BI Administrator log file.
      =============================================

      Delete
    4. Hi, Did anyone get around that Failed to find environment variable INSTANCE_NAME on start -- exiting issue?

      Delete