0 Replies Latest reply on Jul 3, 2013 1:41 AM by Dicksam

    Load Error with return code 7000 when call sqlldr in interface.

    Dicksam

      Hi All,

       

      I have created a interface to load data from 'File' to 'Oracle' in ODI 11g.

      Below are the running order of this interface.

      1 - Loading - SrcSet0 - Drop work view

      2 - Loading - SrcSet0 - Drop Temp Table

      3 - Loading - SrcSet0 - Create Temp table

      4 - Loading - SrcSet0 - Create Work View

      5 - Loading - SrcSet0 - Generate CTL file

      6 - Loading - SrcSet0 - Call sqlldr

      We are getting the following error while running the step 6.

       

      org.apache.bsf.BSFException: exception from Jython:

      Traceback (most recent call last):

        File "<string>", line 22, in <module>

      Load Error: See C:\home\oracle\joc\odi/AIM.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)

      .

      .

      .

      .

       

      And it return code 7000 indicated in 'Execution Statistics'.

       

       

      If anyone has encountered a similar issue and able to solve it, please share your thoughts with me.

       

      Thanks in advance for your help.



      Dicksam