TPT Load Error

Tools & Utilities
Enthusiast

TPT Load Error

I'm trying to execute a TPT script and I get a Status = Not Found error while executing the DataConnector.

Below is my Public log file:
Teradata Parallel Transporter Version 08.02.00.00
Execution Plan generation started.
Execution Plan generation successfully completed.
Job log: C:\Program Files\NCR\Teradata Parallel Transporter\8.2\logs/ctsuser-14.out
Job id is ctsuser-14, running on ctsusnjy10091
Teradata Parallel Transporter DataConnector Version 08.02.00.00
Data_Connector: DataConnector Producer operator Instances: 1
Teradata Parallel Transporter Load Operator Version 08.02.00.00
Load_Operator: private log specified: enames.log
Data_Connector: Operator instance 1 processing file 'enames.csv'.
Operator(loadop.dll) instance(1): INITIATE method failed with status = Not Found

Data_Connector: Total files processed: 0.
Load_Operator: aborting due to the following error:
Error retrieving Target Table attribute 'SYSTEM_TableExternalNameList'
Job step MAIN_STEP terminated (status 8)
Job ctsuser terminated (status 8)


Any one else encountered this error? or Any suggestions on this?

Thanks.
2 REPLIES
Enthusiast

Re: TPT Load Error

You have to specify the attribute TargetTable, and it should match with the table you have used in your APPLY statement.

In the operator definition, if you specify

VARCHAR TargetTable = 'x'

then your APPLY statement should look something like this:

APPLY

'INS X;'

TO OPERATOR (LOAD_OPERATOR)

SELECT * FROM OPERATOR (XXXXX_OPERATOR);

Enthusiast

Re: TPT Load Error

You are right! TargetTable Attribute was missing in my Load Operator definition. Thanks a lot. It works now.