3 Replies Latest reply on Nov 14, 2019 11:19 AM by Ollie MS

    ORA-29913: error in executing ODCIEXTTABLEOPEN callout

    Ollie MS

      Hi,

      I've tried to do a simple implementation of CDC, where a journaled table passes updated contents to another one. However, when ODI is creating and accessing an external table (datapump), there's an error opening a .log file. I copied the generated code and managed to compile it successfully on SQL Developer, once I commented this code:

       

      /*ORGANIZATION EXTERNAL (

      TYPE oracle_datapump

      DEFAULT DIRECTORY dat_dir

      ACCESS PARAMETERS ( LOGFILE 'XC_1DATASET.log'

               )

             LOCATION ('C_1DATASET.exp')  

      )*/

       

      The session's error message contains this:

      KUP-04001: error opening file C:\Users\nb25999/XC_1DATASET.log

       

      I'm still learning but I believe the datapump is the log file saved on my own computer, and ODI has no permissions to write and read on it (correct me if I'm wrong please). Is there a way ODI can write these external tables elsewhere? Thank you.