My Oracle Support Banner

"dataobject '/[PATH]/[FILE].lst' not found" Error Loading Data from File to Netezza Using ODI LKM File to Netezza (EXTERNAL TABLE) (Doc ID 780588.1)

Last updated on OCTOBER 20, 2023

Applies to:

Oracle Data Integrator - Version 10.1.3.4.0 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Symptoms

An Oracle Data Integrator (ODI) Integration Interface was set up to load data from a File to a Netezza table using LKM File to Netezza (EXTERNAL TABLE) and IKM Netezza Control Append.

When the Integration Interface is executed, it fails at Insert New Rows step of the IKM with an error like the  following:

The error is complaining the source file can not be found but the Integration Interface Create External Table step that creates the Netezza External Table using this file did not signal any error.

The error occurs at the next step, the Insert New Rows step which inserts the data from the External table to the target Netezza table. Why?

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.