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