My Oracle Support Banner

"Invilddm" Return Code 0 Even If SQL Loader Rejected Rows (Doc ID 401258.1)

Last updated on MARCH 26, 2021

Applies to:

Oracle Retail Data Warehouse Back-End - Version 11.2.1 and later
Information in this document applies to any platform.


When running "invilddm.ksh" or some Retail Extract Transform and Load (RETL) Scripts, for some reasons (due to data) SQL loader cannot load all rows and it rejects some rows. However, in this case "invilddm.ksh" always returns a return code 0, causing the Retail Data Warehouse (RDW) batch schedule to continue even if there are missing data .

There are two cases:

  1. The number of rejected rows is under 50; in this case SQL Loader continue with data loading.
  2. The number of rejected rows is over 50; in this case SQL Loader stop with data loading.

In the two cases we want that "invilddm.ksh" returns a diffferent return code than 0 to be able to stop the RDW schedule and correct the original problem.




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

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

In this Document

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