Contents of the SQL*Loader Log File

Article #ETMD051

Versions Affected

ETM® System v4.1 and later.


When you use the Import Wizard to import a text file of Listings into the Directory Manager, an Oracle utility called SQL*Loader performs the data transfer. When the transfer is complete, a SQL*Loader log file appears in the SQL*Loader Results dialog box. This article describes the contents of the SQL*Loader log file.

Note: The information in this article is also in the Using the ETM® System user guide and online Help.

More Information

The log file that appears in the SQL*Loader Results dialog box can be printed for reference. The log file contains the following information:

  • The first section provides information about the configuration of the files and database tables that SQL*Loader uses, including the expected format of the data in the import file.
  • The second section lists any records rejected for errors encountered during import, by record number, and provides a description of the error (e.g., non-numeric characters in a numeric field or excessive length of a field value). These records are not inserted and reconciled. You can either cancel the import and address the errors, or continue with the import, then correct the errors and reimport the file.
  • The third section lists:
    • The count of rows in the file that were successfully loaded into the database. SQL*Loader inserts the data into a table called IMPORT_LISTINGS, from which the ETM System performs the reconciliation.
    • The count of entries that were not loaded because of data errors (matches the list in the second section).
    • “Rows not loaded because all WHEN clauses were failed” is unlikely to have a value.
    • “Rows not loaded because all fields were null” does not apply and will never have a value.
  • The fourth section provides internal database information.
  • The next section lists the number of records read and, of those, the number rejected (not loaded).
  • The remaining sections provide time information about the import.

Last Updated


SecureLogix Corporation • 13750 San Pedro, Suite 230 • San Antonio, Texas 78232 • (210) 402-9669 •

Support (877) SLC-4HELP • EMAIL •

ETM, SecureLogix, SecureLogix Corporation, TeleWatch Secure, TWSA, the ETM Emblem, the SecureLogix Diamond Emblem, and the ETM Application Suite Emblems are trademarks or registered trademarks of SecureLogix Corporation in the U.S.A. and other countries. All other trademarks mentioned herein are believed to be trademarks of their respective owners.

© Copyright 2004 SecureLogix Corporation. All Rights Reserved.

U.S. Patents No. US 6,249,575 B1, US 6,320,948 B1, US 6,542,592 B1, US 6,687,353 B1, and US 6,700,964 B1.

U.S. and Foreign Patents Pending.

Published on March 16, 2004  |  Updated on August 19, 2021

Related Articles

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!