Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to connect to HFM 11.1.2.4.0 using OBIEE 11.1.1.7.0 Admintool

Lamin JJun 18 2015 — edited Aug 24 2015

Hi!

Im trying to import a HFM cube trough OBIEE's admintool but im getting the error below.

The RPD is generated by the OFMA config_utility and its connection pool.

The connection looks as following :

adm:thin:com.oracle.hfm.HsvADMDriver:FMCLUSTER:APP2015

Has anyone come across this issue where OBIEE ins't able to connect to HFM 11.1.2.4.0 using OBIEE's Admintool ?

I read John's amazing blog post but in that case he was using OBIEE 11.1.1.9.0 against HFM 11.1.2.4.0

More to life than this...: HFM 11.1.2.4 as a data source in OBIEE

<OBIEEVersion>11.1.1.7.0

<HFM_VERSION>11.1.2.4.0

[2015-06-18T15:56:18.000+02:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 16f0]  [nQSError: 77031] Error occurs while calling remote service ADMImportService. Details: Details:  [[

Failed to connect to ADM.

com.hyperion.ap.APException: [0] EPMHFM-69052 : Systemet kunde inte öppna applikationen.

  at oracle.adm.session.ADMDriverSession.openApplication(ADMDriverSession.java:3260)

  at oracle.adm.session.ADMDriverSession.connect(ADMDriverSession.java:128)

  at com.oracle.hfm.HsvADMDriver.openConnection(HsvADMDriver.java:95)

  at com.oracle.hfm.HsvADMDriver.HssConnOpenConnection(HsvADMDriver.java:67)

  at com.hyperion.ap.adm.HssConnSessionWrapper.HssConnOpenConnection(HssConnSessionWrapper.java:1483)

  at com.hyperion.ap.adm.HssAdm.openConnection(HssAdm.java:912)

  at com.hyperion.ap.adm.HssAdm.internal_openConnection(HssAdm.java:1799)

  at com.hyperion.ap.adm.HssAdm.openConnection(HssAdm.java:1065)

  at oracle.bi.integration.admimport.service.ADMImportClient.openConnection(ADMImportClient.java:64)

  at oracle.bi.integration.admimport.service.ADMImportService.openConnection(ADMImportService.java:159)

  at oracle.bi.integration.admimport.service.ADMImportService.executeDataSources(ADMImportService.java:146)

  at oracle.bi.integration.admimport.service.ADMImportService.execute(ADMImportService.java:67)

  at oracle.bi.integration.javahost.ServiceRpcCall.processMessageInternal(ServiceRpcCall.java:55)

  at com.siebel.analytics.javahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:251)

  at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:193)

  at com.siebel.analytics.javahost.Listener$Job.run(Listener.java:223)

  at com.siebel.analytics.javahost.standalone.SAJobManagerImpl.threadMain(SAJobManagerImpl.java:207)

  at com.siebel.analytics.javahost.standalone.SAJobManagerImpl$1.run(SAJobManagerImpl.java:155)

  at java.lang.Thread.run(Thread.java:662)

]]

Any help is greatly appreciated

Thanks in advance!

//Lamin

This post has been answered by Lamin J on Jun 24 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2015
Added on Jun 18 2015
8 comments
2,867 views