0 Replies Latest reply on Nov 14, 2019 8:22 PM by Comet

    Debugging an ODI mapping


      I migrated a collection of mappings from OWB to ODI 12.2.1.  When I run one of the mappings I get an ORA-01722:
      invalid number error message. I would like to debug the sql code generated by
      the mapping using the ODI debug function. I click Run/Debug/Start debug Session,
      accept the defaults on the Debug dialog and click okay.  The system displays an error ‘…ensure that there
      is one step in the in the session execution.’


      I would like to know how to get started on using the debug
      tool to debug a mapping.  What is the session execution and how do I add steps?