Teradata Parallel Transporter Version 15.00.00.00 Job terminated with status 8. error while trying to export data from teradata table to flat file.
below is the code used;
DEFINE JOB EXPORT_Data_FILE
DESCRIPTION 'Export rows from a Teradata table to a file'
(
DEFINE SCHEMA CE_SCHEMA
(
Nm VARCHAR(50),
Nm1 VARCHAR(50)
);
DEFINE OPERATOR FILE_WRITER()
TYPE DATACONNECTOR CONSUMER
SCHEMA *
ATTRIBUTES
(
VARCHAR PrivateLogName = 'file_writer_privatelog',
VARCHAR FileName = 'CMSample.txt',
VARCHAR IndicatorMode = 'N',
VARCHAR OpenMode = 'Write',
VARCHAR Format = 'formatted'
);
DEFINE OPERATOR EXPORT_OPERATOR()
TYPE EXPORT SCHEMA CE_SCHEMA
ATTRIBUTES
(
VARCHAR PrivateLogName = 'export_privatelog',
INTEGER MaxSessions = 32,
INTEGER MinSessions = 1,
VARCHAR TdpId = Id,
VARCHAR UserName= 'username',
VARCHAR UserPassword='password',
VARCHAR AccountId,
VARCHAR SelectStmt = 'SELECT TRIM(CAST(Nm AS VARCHAR(50))) , TRIM(CAST(Nm1 AS VARCHAR(50))) FROM database.tablename;'
);
STEP export_to_file
(
APPLY TO OPERATOR (FILE_WRITER() )
SELECT * FROM OPERATOR (EXPORT_OPERATOR() [1] );
);
);
command used : C:\tbuild -f <filename.txt> logname.txt
Any Help on this?
you would need to share the two logs to get a chance of an answer:
1. the log logname.txt
2. the tpt log for the job (refered in the logname.txt) - check the tpt manuals how you can access this log
Maybe he should upgrade to a newer patch level first, it's 15.00.00.00 :)
lol - yes, could be worth.
Never the less checking logs is alsways an option...