Troubleshooting connectivity issues between ODI and HFM

Hi all! We are very happy with the feedbacks that we are having about HFM KMs for ODI. People are downloading them and giving them a try, which is awesome! However, we know that this ODI and HFM integration process is not as simple and straight forward as we would like it to be and we generally fall into environment issues to setup the jar files, ODI agent, connect to HFM using the new Java API and so on. In order to make it easier for people to troubleshoot their issues, we are creating this post to hold all known issues that people are having with our KMs and try to help the best we can. We will keep updating it, so please keep checking.

If you have any issues with our KMs usage, please send us an email ( so we may try to help you and all the others that may be facing the same issue. Thanks all!

Error WSSERVLET11: failed to parse runtime descriptor: java.lang.NullPointerException

As we wrote in our blog post, we have two options to setup the necessary HFM Jar files:

1) Install the ODI agent on the HFM server;
2) Copy the necessary jar files to the agent folder;

Some people are getting the above WSSERVLET11 error when performing the first option, which is to install the ODI agent on the HFM server and just point the jar file locations on ODI_ADDITIONAL_CLASSPATH. They change the ODI parameters to point to the right location, but when they start the agent it fails with this error.

We are not sure exactly why it happens, but we suspect that the “absolute file path” gets too big for ODI to handle and then the path gets “truncated” at some point, making ODI to throw this error. Our suggestion is to go with our second approach and add all the jar files to oracledi\agent\drivers folders. If are not sure how to locate the correct jar files, send us an email and we will provide them for you.

Also, if you are not sure if the problem resides on your ODI agent or the Jar files, you may do a test using ODI Local (No Agent) by copying the HFM jar files to C:\Users\\AppData\Roaming\odi\oracledi\userlib (don’t forget to restart the ODI client after that). Then you may try to reverse a HFM model using Local (No Agent). If it works, the Jar files are good to go and your problem resides in the ODI agent itself.

HFMException: EPMHFM-65536

This error is happening when people want to reverse the ODI objects using the new ODI RKM, more specifically when the ODI code tries to connect/get the connection token from your HFM application. EPMHFM-65536 is a very generic error message and can be caused by a number of different factors; ranging from an improper install to application processes crashing.

One of the users (thanks Kevin!) solved his issue with the following:

I needed to copy the file “” from Oracle\Middleware\user_projects\config\foundation\ to path Oracle\Middleware\user_projects\epmsystem1\config\foundation\ and then the KM is running with success.

This blog post gives some other suggestions for the issue:

Since this error is too generic, each HFM application may have its own kind of fix.

IKM Data Load does not load any data (and does not throw any error either)

One user found a bug where the data interface would run without any error but would not load any data. This happened due to a bug in the RKM that may create the datastore with a wrong column order in some cases. As workaround, please change your HFMData datastore to the following order before loading data to HFM:


We will work to fix the RKM code to avoid this issue and to create the columns in the correct order.

I get a parse error when I have more than one filter in the interface

We noticed that if you add more than one filter in the ODI interface, the IKM throws a parse error. As a workaround, just group all filter criteria in one single filter component. We will fix the IKM code to avoid this issue and we will let you know once it is released.

Slashes vs Backslashes (Token Parsing Error: Lexical error)

Some people stated that they were getting some errors like this” Token Parsing Error: Lexical error at line 34, column 34.  Encountered: “O” (79), after : “\”C:\\”: “. This error is probably due to the backslashes. All the paths that you add in your KM options needs to be using / (slashes). e.g: C:/Temp/<%=snpRef.getTable(“L”,”TARG_NAME”,”A”)%>_Load.log

Isolate the components to see what may be wrong

We are seeing that generally the errors may happen on the ODI agent (that does not load the Jar files correctly or does not have access to the HFM application) or on the HFM installation installation. In order get it easier to identify where the issue may be happening, it is a good advice to install a Java IDE (like Eclipse) in the HFM server and try to create a small code just to connect to your HFM app. If it connects, then the problem is likely to be in the ODI agent. If it does not connect at all, then you have a problem in you HFM application that is not accepting Java API calls.

Here you may find some examples on Java codes that you may copy from and try to create a sample app:

Running a simple connect Java code first against your HFM application “eliminates” ODI from the possible points of failure. In other words, if you are not able to connect using standard Java code, ODI will not be able to connect as well.

Thanks all!


22 Responses to “Troubleshooting connectivity issues between ODI and HFM”

  1. […] If you guys are having errors with our KMs, please check our troubleshooting post here. […]

  2. […] Please feel free to download and use our KMs. They do not have official Oracle Support, but we try our best to answer and fix any issues that you may find (don’t forget to take a look on our “debug” post here). […]

  3. Álvaro Santos Says:

    This error WSSERVLET11: failed to parse runtime descriptor: java.lang.NullPointerException appears when ODI find the Weblogic JAR files in the location directory.

    I has unable to use RKM is always returning the same generic error in ODI, I have the HFM server in a different Machine.

    Can you help me ?

    • Yeah, this is a hard one to debug because it seems to be related on the archtecture that you are in. Did you already tried to test without the ODI agent? You may do a test using ODI Local (No Agent) by copying the HFM jar files to C:\Users\\AppData\Roaming\odi\oracledi\userlib (don’t forget to restart the ODI client after that). Then you may try to reverse a HFM model using Local (No Agent). If it works, the Jar files are good to go and your problem resides in the ODI agent itself, which is hard for us to debug since every environment has its own characteristics.

      • Álvaro Santos Says:

        I tried everything even install ODI in HFM server but I receive always the same error using ODI local or agent.

        I follow all the steps in the article, can you confirm the physical Topology for the HFM data Server I’m using the following :


        I’m using Build ODI_11., it’s like the issue is interpreting the KM.


        ODI-26066: Na unexpected error has ocurred

        at javax.swing.AbstractButton.fireActionPerformed(
        at javax.swing.DefaultButtonModel.setPressed(
        at java.awt.AWTEventMulticaster.mouseReleased(
        at java.awt.Component.processMouseEvent(
        at javax.swing.JComponent.processMouseEvent(
        at java.awt.Component.processEvent(
        at java.awt.Container.processEvent(
        at java.awt.Component.dispatchEventImpl(
        at java.awt.Container.dispatchEventImpl(
        at java.awt.Component.dispatchEvent(
        at java.awt.LightweightDispatcher.retargetMouseEvent(
        at java.awt.LightweightDispatcher.processMouseEvent(
        at java.awt.LightweightDispatcher.dispatchEvent(
        at java.awt.Container.dispatchEventImpl(
        at java.awt.Window.dispatchEventImpl(
        at java.awt.Component.dispatchEvent(
        at java.awt.EventQueue.dispatchEventImpl(
        at java.awt.EventQueue.access$200(
        at java.awt.EventQueue$
        at java.awt.EventQueue$
        at Method)
        at java.awt.EventQueue$
        at java.awt.EventQueue$
        at Method)
        at java.awt.EventQueue.dispatchEvent(
        at java.awt.EventDispatchThread.pumpEvents(
        at java.awt.EventDispatchThread.pumpEvents(

        I’m using JAVA any issue on that?

  4. Álvaro Santos Says:

    Thanks I finally find the issue, is now working both agent and local in odi in hfm machine and in different servers machines.

    • Great news!

    • Hector H Avila Says:

      What was the issue. I’m having the same error with the jar files using the stand alone agent and No agent as well. When I remove the jar files, everything works OK for everything else but when I paste the jar files, I keep getting the same error: WSSERVLET11: failed to parse runtime descriptor:

    • Johnson Says:

      Hello, dear frient. How you resolve the problem. Now, I don’t use agent to extract from HFM,but failed when extract data.
      The error log like above :
      org.apache.bsf.BSFException: The application script threw an exception: java.lang.Exception: java.lang.StringIndexOutOfBoundsException: String index out of range: -1 BSF info: Extract Data from HFM at line: 0 column: columnNo
      at bsh.util.BeanShellBSFEngine.eval(Unknown Source)
      at bsh.util.BeanShellBSFEngine.exec(Unknown Source)
      at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(
      at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(
      at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(
      at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(
      at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(
      at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(
      at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(
      at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(
      at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(
      at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(
      at com.sunopsis.dwg.dbobj.SnpSession.treatSession(
      at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(
      at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(
      at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(
      at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(
      at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(
      at oracle.odi.runtime.agent.processor.task.AgentTask.execute(

  5. Diogo Dias Says:

    Hi there,

    I’m looking for LKM HFM members to SQL, since old version isn’t working anymore. Could you please tell me some way to get it?

    Thanks in advance

  6. […] Please feel free to download and use our KMs. They do not have official Oracle Support, but we try our best to answer and fix any issues that you may find (don’t forget to take a look on our “debug” post here). […]

  7. Qiang Yue Says:

    HI,the error WSSERVLET11: failed to parse runtime descriptor: java.lang.NullPointerException appears when i restart odi agent after copy the jars to oracledi\agent\ fact ,I get 376 jars from hfm server.
    If I remove two jars(weblogic.jar,epm_jrf.jar) and don’t change ojdbc6dms.jar,the odi agent can be restarted, but when reverse the ODI objects I meet EPMHFM-65536.
    it happened again during test using ODI Local by all hfm jars.
    In ODI log,I found the error is happened on

    ssoToken = HSSUtilManager.getSecurityManager().authenticateUser(hfmUser, hfmPass);
    sessionOM = new SessionOM();

    finally ,i create a small java code on hfmserver by same user and password with ,it returns the clustername”hfmcluster”.

    My hfm version is HYPERION
    odi version is ODI_11.

    So can i do anything else to find the reason??

  8. Hello

    great job.

    For the WSSERVLET11 issue, it can be solved by adding this additional class path

    set ODI_ADDITIONAL_CLASSPATH=%ODI_ADDITIONAL_CLASSPATH%;D:\Oracle\Middleware\EPMSystem11R1\common\jlib\\epm_*.jar

    Then, you don’t have to copy all jar files.


  9. JasonChen Says:

    WHEN I IMPORT KM TRT_Extract_Data_from_HFM.xml,raise error following: Odi-14070: Import failed. The parent object could not be found in the archive.
    at com.sunopsis.dwg.DwgDuplicationTools.batchDuplication(
    at com.sunopsis.dwg.DwgObject.importFromObjectLst(
    at com.sunopsis.dwg.DwgObject.internalImportObjectList(
    at com.sunopsis.dwg.DwgObject.doImport(
    at com.sunopsis.dwg.DwgObject.importFromXml(
    at com.sunopsis.dwg.DwgObject.importFromXmlWithCommit(
    at com.sunopsis.dwg.DwgObject.importFromXmlWithCommit(
    at com.sunopsis.graphical.dialog.SnpsDialogImportXml.doInternalImport(
    at com.sunopsis.graphical.dialog.SnpsDialogImportXml.access$10(
    at com.sunopsis.graphical.dialog.SnpsDialogImportXml$2.doAction(
    at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(
    at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(
    at com.sunopsis.graphical.dialog.SnpsDialogImportXml.doImport(
    at com.sunopsis.graphical.dialog.SnpsDialogImportXml$6.doInBackground(
    at java.util.concurrent.FutureTask$Sync.innerRun(
    Caused by: com.sunopsis.core.SnpsInexistantObjectException: SnpFolder.getObjectByIdent : SnpFolder does not exist
    at com.sunopsis.dwg.dbobj.generated.GeneratedSnpFolder.getObjectByIdent(
    at com.sunopsis.dwg.dbobj.SnpTrt.checkParentExists(
    at com.sunopsis.dwg.DwgDuplicationTools.batchDuplication(
    … 19 more

    • Did you try to import as “Insert/Update”? Please try with “Duplication”. I just tried to import in ODI 12 with Duplication and it worked fine. Thanks!

      • Anonymous Says:

        my odi is China version£¬the result following£ºi search your blog£¬say extract from hfm km is to do list£¿

      • Anonymous Says:

        my odi is 11.1.9,is it not compatible with your km?it must use 12C?

      • No, it should work on both versions. It was originally created in 11.1.9, but I tested again in ODI 12 just to make sure it was working. If you are not able to import as “Duplication”, you may open the XML in a text editor and copy/paste the code from it. Its a totally manual work, but you may use it as a last resource…

      • Anonymous Says:

        I’m your fans,I also love your blog.
        I’d like to ask you about you develope km:TRT_Extract_Data_from_HFM.xml
        if importing it to ODI,how to use it?
        I understand that this function is the same as THE EA function of HFM,so How do I set up such an interface using this km at ODI

        I’m Looking forward to your reply!

Leave a Reply to ODI KMs for HFM | DEV EPM Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: