OBIEE 11g: Error: "[NQSEerror:77031] Error occurs while calling remote service ADMImportService." when Importing HFM (Hyperion) Metadata into a Repository (Doc ID 1573578.1)

Last updated on MARCH 09, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.9 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.6.9 and later
Information in this document applies to any platform.

Symptoms

You import data from Hyperion Financial Manager (HFM) into a repository in the OBIEE 11g Administration tool.  When you move View Source (HFM) into the physical layer, using the Hyperion ADM driver, you get the following error:

[NQSEerror:77031] Error occurs while calling remote service ADMImportService. Details: Details: Failed to read ADM.com.hyperion.ap.APException: (1047) Error: syntax error at 1,28 on input channel...

Also, you see the following error in the nQSAdmin.log file:

[init] [ERROR] [] [saw.init.application] [tid: 15] [ecid: 0000K0qA4kK4YrbLxI4EyW1HyGqx00002p,0]  [Thread 22] Service failed - ADMImportService. Details:Failed to read ADM.[[
com.hyperion.ap.APException: [1047] Error: syntax error at 1, 28 on input Channel
at com.hyperion.ap.adm.HssQryExprALEInterpreter.normalize(HssQryExprALEInterpreter.java:611)
at com.hyperion.ap.adm.HssQryMemberSelection.normalize(HssQryMemberSelection.java:2681)
at com.hyperion.ap.adm.HssQryMemberSelection.internalSetExpressionString(HssQryMemberSelection.java:1533)
at com.hyperion.ap.adm.HssQryMemberSelection.setExpressionString(HssQryMemberSelection.java:190)
at com.hyperion.ap.adm.HssQryMemberSelection.execute(HssQryMemberSelection.java:996)
at oracle.bi.integration.admimport.service.ADMImportClient.getDimensionProperties(ADMImportClient.java:157)
at oracle.bi.integration.admimport.service.ADMImportClient.readDimension(ADMImportClient.java:112)

 

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