Analyze exception and reject Logs - Connect_ETL - Latest

Connect ETL Vertica Load Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
Latest
ft:locale
en-US
Product name
Connect ETL
ft:title
Connect ETL Vertica Load Guide
Copyright
2025
First publish date
2003
ft:lastEdition
2025-05-21
ft:lastPublication
2025-05-21T18:34:10.033000

COPY

When the COPY statement is used within a vsql command, the error log information file and the exception and reject files are written by default to the database administrator’s home directory in the following directory on the Vertica master node: <dbadmin><dbname>/<dbname>_node0001_catalog/CopyErrorLogs.

COPY LOCAL

When the COPY LOCAL statement is used within a vsql command, exception and reject logs are written to the log directory on the ETL server, when the following configuration file environment variables are set: BaseLogDirectory is set to the directory location where the exception, reject, and job log files are written; COPYLOCAL, CAPTUREERRORS, and CAPTUREREJECTS environment variables are set to Yes.