All Forums Tools
nithyanandam 65 posts Joined 10/04
17 Jan 2008
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.00Execution Plan generation started.Execution Plan generation successfully completed.Job log: C:\Program Files\NCR\Teradata Parallel Transporter\8.2\logs/ctsuser-14.outJob id is ctsuser-14, running on ctsusnjy10091Teradata Parallel Transporter DataConnector Version 08.02.00.00Data_Connector: DataConnector Producer operator Instances: 1Teradata Parallel Transporter Load Operator Version 08.02.00.00Load_Operator: private log specified: enames.logData_Connector: Operator instance 1 processing file 'enames.csv'.Operator(loadop.dll) instance(1): INITIATE method failed with status = Not FoundData_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.

ratchetandclank 49 posts Joined 01/08
18 Jan 2008

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 specifyVARCHAR TargetTable = 'x'then your APPLY statement should look something like this:APPLY 'INS X;'TO OPERATOR (LOAD_OPERATOR)SELECT * FROM OPERATOR (XXXXX_OPERATOR);

nithyanandam 65 posts Joined 10/04
18 Jan 2008

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

You must sign in to leave a comment.