Teradata Parallel Transporter error

Tools & Utilities

Teradata Parallel Transporter error

Using Teradata parallel transporter(TPT) wizard, I've set-up as follows in order to export from Teradata v2r5 to local file.

(Job source part)
DB access successful

(Job Destination part)
check create
put in 'save as' file name
check 'FORMATTED' for Format

(Run Job part)
set 'Job name' and 'value;
do not set any other items

We are getting 'NULL pointer error' and 'class not found error' from the TPT screen.
Also we are not able to download any results from the tables in the local files.

Please refer to the script we used, that is attached below.

Your feedback will be greatly appreciated. Thank you!

TPT SCRIPT
===========================
DEFINE JOB Export_to_File
DESCRIPTION 'Export number of # account rows from the MAIL_ADDRESS_test table.'
(
DEFINE SCHEMA Mail_Schema
(

AddressID INTEGER ,
MailAddressLineOne VARCHAR(100),
MailAddressLineTwo VARCHAR(100),
PostalID INTEGER,
CensusBlockID CHAR(10),
MailLatitudeCD DECIMAL(6,0),
MailLongitudeCD DECIMAL(7,0),
MailDwellingTypeCD VARCHAR(240)

);

DEFINE OPERATOR Data_Connector
TYPE DATACONNECTOR CONSUMER
SCHEMA Mail_Schema
ATTRIBUTES
(
VARCHAR FileName = 'tpt_mail_test.txt',
VARCHAR Format = 'FORMATTED',
VARCHAR OpenMode = 'Write',
VARCHAR IndicatorMode = 'Y',
VARCHAR TextDelimiter = '|'
);

DEFINE OPERATOR Export_Mail
TYPE EXPORT
SCHEMA Mail_Schema
ATTRIBUTES
(
VARCHAR UserName = 'upoi',
VARCHAR UserPassword = 'upoi',
VARCHAR SelectStmt = 'SELECT * FROM MAIL_ADDRESS_test;'

);

APPLY
TO OPERATOR
(
Data_Connector[1]
)

SELECT *
FROM OPERATOR
(
Export_mail[1]
);
);
===========================