Problem with TPT 12

Tools & Utilities
N/A

Problem with TPT 12

Hi,
I am trying to export data from a Teradata 12 DB using TPT12 but always get the error "[exportop.dll) instance(1): INITIATE method failed with status = Not Found]".
I have also set TD_TRACE_OUTPUT but the trace file is not generated. Any ideas on what could be wrong & also is there some thing else that I need to do to get a more meaningful error.

Thanks
Raam
4 REPLIES
Enthusiast

Re: Problem with TPT 12

Make sure you've set the TD_TARGET_TABLE attribute to the name of the table you're reading from and the TD_SELECT_STMT to the select statement to execute (i.e. "SELECT Col1, Col2, Col3 FROM YourTable;").
Teradata Employee

Re: Problem with TPT 12

You indicated that you are using TPT12.0, but it sounds as if you are
really using TPTAPI (by your use of TD_xxxxxx attribute names).

The Export operator does not support a target table attribute. However,
the "not found" error could be sue to a missing mandatory attribute.

If you are running the script based TPT, please send me your script.
If you are using TPTAPI, please send me the full list of attributes you
are setting in the connection object.

-- SteveF
Teradata Employee

Re: Problem with TPT 12

Hi feinholz

What'a the difference between to use TPT and TPTAPI?

Exactly what's the use of the TD_TRACE_OUTPUT?. Where I can to configure it?

When I use a ETL tool, for example DataStage, where I define the TD_TRACE_OUTPUT? This is a enviorenment variable?

Thanks

Teradata Employee

Re: Problem with TPT 12

"TPT" i used to refer to the script-based tool.

"TPTAPI" is the API-version of TPT.

TD_TRACE_OUTPUT is a method for generating debug information to help diagnose a particular problem.

For DataStage, you would have to refer to the DataStage documentation. I do not know how to set up degugging and diagnostics.

-- SteveF