Forum Stats

  • 3,827,547 Users
  • 2,260,791 Discussions
  • 7,897,297 Comments

Discussions

ODI - DataLoad Error to HFM

Dear All,

I'm facing a really strange issue when i try to load data via ODI into HFM.

Here some details:

  • The souce is a simple one row flat file.
  • The target is an HFM App version 11.1.2.3
  • ODI version is 11.1.1.7.0
  • HFMDriver i'm using are the 11.1.2 @ 64bit
  • KM Used is : IKM SQL to Hyperion Financial Management Data
  • I'm using a local agent, and HFM is installed on the same server with ODI.

Here is the log i'm getting:

2014-02-19 18:05:56,019 INFO  [SimpleAsyncTaskExecutor-2]: ODI Hyperion Financial Management Adapter

2014-02-19 18:05:56,019 INFO  [SimpleAsyncTaskExecutor-2]: Load task initialized.

2014-02-19 18:05:56,097 INFO  [SimpleAsyncTaskExecutor-2]: Connecting to Financial Management application [MYAPP] on [MYSERVER] using user-name [admin].

2014-02-19 18:05:56,737 INFO  [SimpleAsyncTaskExecutor-2]: Connected to Financial Management application.

2014-02-19 18:05:56,737 INFO  [SimpleAsyncTaskExecutor-2]: HFM Version: 11.1.2.3.000.

2014-02-19 18:05:56,737 INFO  [SimpleAsyncTaskExecutor-2]: Options for the Financial Management load task are:

<Options>

     <Option name=LOG_FILE_NAME value=D:/ODI_Executions/ODI_Execution_Log/HFM_Loading.log/>

     <Option name=IMPORT_MODE value=Replace/>

     <Option name=CONSOLIDATE_ONLY value=false/>

     <Option name=CONSOLIDATE_PARAMETERS value=""/>

     <Option name=LOG_ENABLED value=true/>

     <Option name=ACCUMULATE_WITHIN_FILE value=false/>

     <Option name=CONSOLIDATE_AFTER_LOAD value=false/>

     <Option name=FILE_CONTAINS_SHARE_DATA value=false/>

</Options>

2014-02-19 18:05:56,737 INFO  [SimpleAsyncTaskExecutor-2]: Load Options validated.

2014-02-19 18:05:56,753 INFO  [SimpleAsyncTaskExecutor-2]: Source data retrieved.

2014-02-19 18:05:56,753 INFO  [SimpleAsyncTaskExecutor-2]: Pre-load tasks completed.

2014-02-19 18:05:56,815 INFO  [SimpleAsyncTaskExecutor-2]: HFM Log file path: "D:\ODI_Executions\ODI_Execution_Log\HFM_LoadingHFM8182413689349064414.log".

2014-02-19 18:05:56,815 ERROR [SimpleAsyncTaskExecutor-2]: Error occurred during load process Error loading resource string for code '120'. Error code: 1813 (x715).

com.hyperion.odi.common.ODIHAppException: Error loading resource string for code '120'. Error code: 1813 (x715)

  at com.hyperion.odi.hfm.ODIHFMDataLoader.execute(ODIHFMDataLoader.java:307)

  at com.hyperion.odi.hfm.ODIHFMAppStatement.executeLoad(ODIHFMAppStatement.java:101)

  at com.hyperion.odi.hfm.ODIHFMAppWriter.loadData(ODIHFMAppWriter.java:225)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

  at java.lang.reflect.Method.invoke(Method.java:597)

  at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)

  at org.python.core.PyObject.__call__(PyObject.java:355)

  at org.python.core.PyMethod.__call__(PyMethod.java:215)

  at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

  at org.python.core.PyMethod.__call__(PyMethod.java:206)

  at org.python.core.PyObject.__call__(PyObject.java:397)

  at org.python.core.PyObject.__call__(PyObject.java:401)

  at org.python.pycode._pyx2.f$0(<string>:6)

  at org.python.pycode._pyx2.call_function(<string>)

  at org.python.core.PyTableCode.call(PyTableCode.java:165)

  at org.python.core.PyCode.call(PyCode.java:18)

  at org.python.core.Py.runCode(Py.java:1204)

  at org.python.core.Py.exec(Py.java:1248)

  at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

  at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

  at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

  at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

  at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

  at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)

  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)

  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)

  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)

  at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)

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

Caused by: com.hyperion.odi.hfm.wrapper.HFMException: Error loading resource string for code '120'. Error code: 1813 (x715)

  at com.hyperion.odi.hfm.wrapper.HFMDriverJNI.executeDataLoad(Native Method)

  at com.hyperion.odi.hfm.wrapper.HFMDataLoader.executeDataLoad(HFMDataLoader.java:175)

  at com.hyperion.odi.hfm.wrapper.HFMStatement.executeDataLoad(HFMStatement.java:93)

  at com.hyperion.odi.hfm.ODIHFMDataLoader.execute(ODIHFMDataLoader.java:253)

  ... 40 more

One thing i can notice, is that the my HFM app is having, in addition to the usual custom dimensions, even the "Custom 5" dimension - but during the reverse ODI is not able to capture this detail.(the HFMData table is having only Custom 1-2-3-4)

Can you please help me on this? I never run in this type of errors.

Thanks an Regards,

Emanuele

This discussion has been closed.