Analyze exception and reject Logs - Connect_ETL - 9.13

Connect ETL Vertica Load Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
9.13
Language
English
Product name
Connect ETL
Title
Connect ETL Vertica Load Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-11
ft:lastPublication
2023-09-11T19:09:11.694437

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.