Teradata Parallel Transporter Version 15.00.00.00,Job terminated with status 8. error while export

Database

Teradata Parallel Transporter Version 15.00.00.00,Job terminated with status 8. error while export

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?

3 REPLIES
Senior Supporter

Re: Teradata Parallel Transporter Version 15.00.00.00,Job terminated with status 8. error while expo

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

Junior Contributor

Re: Teradata Parallel Transporter Version 15.00.00.00,Job terminated with status 8. error while expo

Maybe he should upgrade to a newer patch level first, it's 15.00.00.00 :)

Senior Supporter

Re: Teradata Parallel Transporter Version 15.00.00.00,Job terminated with status 8. error while expo

lol - yes, could be worth.

Never the less checking logs is alsways an option...