1 Reply Latest reply: Nov 14, 2012 7:31 AM by 972284 RSS

    Problem while loading metadata in HFM

    972284
      hi,

      I am getting following error in loading metadata to HFM application.My versions of ODI 11.1.1.6.0 and HFM 11.1.2.2.0. I have tried multiple options viz. - Loading metadata from Oracle table, - Loading Metadata from Flat File. I have tried tweaking the IKM also and mentioning the java code too but to no avail.
      Please see below the following error in two different scenarios so far:

      Loading through regular IKM:

      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: Error loading resource string for code '121'. Error code: 1813 (x715)

           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):


      Loading through customized IKM:

      org.apache.bsf.BSFException: exception from Jython:
      Traceback (most recent call last):
      File "<string>", line 72, in <module>
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)     at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1110)     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)     at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:2147)     at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:2091)     at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:320)     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)
      java.sql.SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


      Please suggest as the same problem has been mentioned at many different forums but noone has provided any resolution for it.