Change ODI Log file folder path

Las071214

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!!

Las071214

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

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

Try changing the path in topology (work schema)

Regards,

Pavan

Las071214

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

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

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

Regards,

Pavan

Las071214

Oh OK.

Thank you for the reply.