Forum Stats

  • 3,827,925 Users
  • 2,260,839 Discussions
  • 7,897,407 Comments

Discussions

Change ODI Log file folder path

Las071214
Las071214 Member Posts: 69
edited Mar 29, 2018 7:30AM in Data Integrator

Hello

We have a odi interface which loads data from a flat file to a oracle table with one-one mapping . This is put in a package with fail mail option.

LKM - LKM File to Oracle (SQLLDR)

IKM -  IKM Oracle Incremental Update

When the interface fails due to any reason, the log file is generated at a path with interface name .

We couldnot find any particular option to change the log file path and log file name in KMs.

Could any one please help us know the process to change the odi log folder path.

Thank You!!

Tagged:

Answers

  • Las071214
    Las071214 Member Posts: 69
    edited Mar 29, 2018 1:18AM

    In addition to the above information,

    We see that in LKM File to Oracle( SQLLDR), at Callsqlldr step the log file folders are given as below:

    ctlfile = r"""<%=odiRef.getSrcTablesList("[WORK_SCHEMA]/[TABLE_NAME].ctl","")%>"""

    logfile = r"""<%=odiRef.getSrcTablesList("[WORK_SCHEMA]/[TABLE_NAME].log", "")%>"""

    outfile = r"""<%=odiRef.getSrcTablesList("[WORK_SCHEMA]/[TABLE_NAME].out", "")%>"""

    If we change the path in LKM, we assume it is going to effect other interfaces logs aswell.

    Please let us know if theres any otherway to change the path of logs without modifying IKM. Thank You!!

  • Adrian_Popescu-Oracle
    Adrian_Popescu-Oracle RomaniaPosts: 1,984 Employee
    edited Mar 29, 2018 1:24AM

    Hi,

    For LKM File to Oracle( SQLLDR),

    ctlfile = r"""<%=odiRef.getSrcTablesList("[WORK_SCHEMA]/[TABLE_NAME].ctl","")%>"""

    logfile = r"""<%=odiRef.getSrcTablesList("[WORK_SCHEMA]/[TABLE_NAME].log", "")%>"""

    outfile = r"""<%=odiRef.getSrcTablesList("[WORK_SCHEMA]/[TABLE_NAME].out", "")%>"""

    will be created/stored in the same location as source file.

    These are created by Sql Loader component.

    These are not related to IKM, but only with LKM File to Oracle( SQLLDR).

    When the interface is executed with an agent, log execution are stored in agent logs.

    Is not clear to what logs do you refer.

    Adrian

  • Pavan8u
    Pavan8u Member Posts: 278 Silver Badge
    edited Mar 29, 2018 1:41AM

    Try changing the path in topology (work schema)

    Regards,

    Pavan

  • Las071214
    Las071214 Member Posts: 69
    edited Mar 29, 2018 6:18AM

    Thanks I got that

    I am looking for a log or err file generated which are related to a particular session if that session fails.

    We are looking to have separate log folders for different packages. Is it possible ?

  • Las071214
    Las071214 Member Posts: 69
    edited Mar 29, 2018 6:15AM

    Thanks for the reply.

    Correct , but this changes the paths of already existing packages log folder location as well.

    we are looking to have separate log folders for each package. Is it possible ?

  • Pavan8u
    Pavan8u Member Posts: 278 Silver Badge
    edited Mar 29, 2018 6:20AM

    Then the only option is to have different topology per mapping/interface. This involves so many code changes.

    Regards,

    Pavan

    Las071214
  • Las071214
    Las071214 Member Posts: 69
    edited Mar 29, 2018 7:30AM

    Oh OK.

    Thank you for the reply.

This discussion has been closed.