2 Replies Latest reply: Mar 15, 2013 2:26 PM by Ayush Ganeriwal-Oracle RSS

    Error while loading metadata into HFM

    972284
      Hi,

      We are loading metadata from SAP to HFM through ODI and getting following error message in the final stage of data load.


      Under the Code Tab: # Load the data
      rs = None
      stats = hfmWriter.loadData(rs)

      # End load
      hfmWriter.endLoad()

      and the main error log message is:

      org.apache.bsf.BSFException: exception from Jython:
      Traceback (most recent call last):
      File "<string>", line 3, in <module>
           at com.hyperion.odi.hfm.ODIHFMAppWriter.loadData(ODIHFMAppWriter.java:265)

           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)


      com.hyperion.odi.common.ODIHAppException: com.hyperion.odi.common.ODIHAppException: Invalid metadata column name: C1_MEMBER

           at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
           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:558)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
           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: Traceback (most recent call last):
      File "<string>", line 3, in <module>
           at com.hyperion.odi.hfm.ODIHFMAppWriter.loadData(ODIHFMAppWriter.java:265)

           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)


      com.hyperion.odi.common.ODIHAppException: com.hyperion.odi.common.ODIHAppException: Invalid metadata column name: C1_MEMBER

           at org.python.core.PyException.fillInStackTrace(PyException.java:70)
           at java.lang.Throwable.<init>(Throwable.java:181)
           at java.lang.Exception.<init>(Exception.java:29)
           at java.lang.RuntimeException.<init>(RuntimeException.java:32)
           at org.python.core.PyException.<init>(PyException.java:46)
           at org.python.core.PyException.<init>(PyException.java:43)
           at org.python.core.Py.JavaError(Py.java:455)
           at org.python.core.Py.JavaError(Py.java:448)
           at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:177)
           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._pyx18.f$0(<string>:6)
           at org.python.pycode._pyx18.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)
           ... 19 more
      Caused by: com.hyperion.odi.common.ODIHAppException: Invalid metadata column name: C1_MEMBER
           at com.hyperion.odi.hfm.ODIHFMAppWriter.loadData(ODIHFMAppWriter.java:265)
           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)
           ... 33 more
      Caused by: com.hyperion.odi.common.ODIHAppException: Invalid metadata column name: C1_MEMBER
           at com.hyperion.odi.hfm.ODIHFMMetadataLoader.execute(ODIHFMMetadataLoader.java:139)
           at com.hyperion.odi.hfm.ODIHFMAppStatement.executeLoad(ODIHFMAppStatement.java:95)
           at com.hyperion.odi.hfm.ODIHFMAppWriter.loadData(ODIHFMAppWriter.java:242)
           ... 38 more
      Caused by: com.hyperion.odi.hfm.wrapper.HFMException: Invalid metadata column name: C1_MEMBER
           at com.hyperion.odi.hfm.wrapper.HFMMetaDataLoader.executeMetaDataLoad(HFMMetaDataLoader.java:1094)
           at com.hyperion.odi.hfm.wrapper.HFMStatement.executeMetaDataLoad(HFMStatement.java:117)
           at com.hyperion.odi.hfm.ODIHFMMetadataLoader.execute(ODIHFMMetadataLoader.java:126)
           ... 40 more


      Can you please suggest something to resolve it?

      Thanks
      Abhi