4 Replies Latest reply on Apr 15, 2014 11:01 AM by user1167443

    Failing to load data to staging area using SAP ABAP ERP Adapter

    user1167443

      Hello

       

      I am new to ODI and facing some challenges. ODI 11g(11.1.1.6.0) I want to move data from a SAP system EHP6 to an oracle warehouse. I have successfully reverse engineered the table that I need, using the SAP Metadata Browser. I then created the interface and on execution this fails on Session/Task 13 - Loding - Srcset0 - Load Data to Staging. I am using a Shared Directory. I set FTP_TRANSFER_METHOD=FSMOUNT_DIRECT. The error message i get is

       

       

      org.apache.bsf.BSFException: exception from Jython:
      Traceback (most recent call last):
        File "<string>", line 14, in <module>
      Load Error: See /home/dwsap/ZODI_13001_11001_GLOBAL.log for details

           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:744)
      Caused by: Traceback (most recent call last):
        File "<string>", line 14, in <module>
      Load Error: See /home/dwsap/ZODI_13001_11001_GLOBAL.log for details

           at org.python.core.PyException.doRaise(PyException.java:219)
           at org.python.core.Py.makeException(Py.java:1166)
           at org.python.core.Py.makeException(Py.java:1170)
           at org.python.pycode._pyx0.f$0(<string>:50)
           at org.python.pycode._pyx0.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


      I checked the log file and it contains the following


      $ more ZODI_13001_11001_GLOBAL.log

      SQL*Loader: Release 11.2.0.4.0 - Production on Thu Mar 27 11:19:17 2014

      Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

      SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
      ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA


      I have checked my tnsnames.ora and it seems to be correct


      # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
      # Generated by Oracle configuration tools.

      XXXXXX =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxx)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = xxxxxx)
            (SID = xxxxxx)
            (GLOBAL_NAME = xxxxxx)
          )
        )


      My listener.ora is as follows


      # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
      # Generated by Oracle configuration tools.
      LISTENER =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
            (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx )(PORT = 1521))
          )
        )
      ADR_BASE_LISTENER = /u01/app/oracle




      What could be the problem?

       

      Regards