234 | 05 Jan 2012 @ 05:45 PST | Tools | Reply | TPT13103: Error 5 retrieving DML Group Attribute |
If you get a message that "<table-name> is being loaded" it means you started a job and it somehow terminated in an unknown state. It usually means that there are sessions still ... |
233 | 05 Jan 2012 @ 05:42 PST | Tools | Reply | Data byte count error |
To answer your first question:
http://developer.teradata.com/tools/articles/selecting-the-right-operator-to-use-for-your-tpt-job
To answer your 2nd question:
TPTAPI is wri... |
232 | 04 Jan 2012 @ 12:07 PST | Tools | Reply | TPT variables in script itself (Providing a default value that could then be overridden) |
Yes, you should be able to use the job variables anywhere.
|
231 | 26 Dec 2011 @ 04:18 PST | Tools | Reply | Data byte count error |
You cannot use the Export operator to export data in Delimited format.
You need to use the Selector operator and make sure ReportMode is set to 'yes'.
|
230 | 26 Dec 2011 @ 04:16 PST | Tools | Reply | TPT13103: Error 5 retrieving DML Group Attribute |
Your APPLY statement does not have a DML group.
You need an INSERT statement for the Load operator.
It should be:
APPLY
(
'INSERT INTO . . . . ;... |
229 | 20 Dec 2011 @ 04:55 PST | Tools | Reply | TPT_INFRA: TPT01015: Error: Failed to allocate a lock to synchronize access to internal message queue |
This means you have run out of system resources.
How many instances of the operators are you using?
Probably too many.
|
228 | 15 Dec 2011 @ 01:14 PST | Tools | Reply | Teradata TPT Script |
Ok, looked a little further and that error message does not look like it comes from TPT.
Also, in the environment setup you showed me earlier, from what file was that text?
|
227 | 15 Dec 2011 @ 12:16 PST | Tools | Reply | Teradata TPT Script |
Just want to make sure that when you ssh to the remote system, you indeed pick up the correct environment.
I have searched through the code and do not see that particular error message, but ... |
226 | 15 Dec 2011 @ 11:45 PST | Tools | Reply | Problem using RowErrFileName |
Upgrade to the latest patch for 13.10, which should be 13.10.00.07.
That should fix this problem.
|
225 | 14 Dec 2011 @ 06:47 PST | Tools | Reply | MLOAD Error - An invalid statement was found before the .LOGON statement |
Well, we have tried this inhouse and do not have any problems with:
.logtable . . . . ;
.run file . . . . ;
.set maxerror . . . ;
database . . . ;
... |
224 | 14 Dec 2011 @ 01:41 PST | Tools | Reply | TDLoad Hangs when invoked from Python |
Sorry. I do not have an answer for you.
I also do not know who is putting out the very last message, "Teradata Load Utility Version 13.10.00.07".
It is not a normal TPT message... |
223 | 14 Dec 2011 @ 01:37 PST | Tools | Reply | Teradata TPT Script |
Are you sure the entire environment is set up correctly?
Did you make sure that TWB_ROOT is set up and is available in the environment from the Java app that is connecting to the remote mach... |
222 | 13 Dec 2011 @ 03:55 PST | Tools | Reply | TPT DATA CONNECTOR CONSUMER BEHAVING DIFFERENT IN MAINFRAME V/S MIDRANGE/WINDOWS regarding EOR. |
For #4, mainframe I/O is always different from Unix and Windows. Mainframe datasets are record oriented. Not so on Unix and Windows.
For #5, the number of records does not limit the use of t... |
221 | 12 Dec 2011 @ 01:43 PST | Tools | Reply | TDLoad Hangs when invoked from Python |
What is different between the "simple" python program and the "complicated" one?
If you can get TPT to run from within a "simple" python program, I fail to see ... |
220 | 09 Dec 2011 @ 04:10 PST | Tools | Reply | TPT DATA CONNECTOR CONSUMER BEHAVING DIFFERENT IN MAINFRAME V/S MIDRANGE/WINDOWS regarding EOR. |
A couple of things.
1. always provide the version of TPT you are using; we cannot offer any assistance with that information
2. FastExport will always write out a 2-byte length in front ... |
219 | 09 Dec 2011 @ 02:42 PST | Tools | Reply | TPT Licnese on Unix Server |
You will have to talk to whomever is in charge of your licenses and purchases.
I do not think our licenses are on a "per-server" or "per-cpu" type of use. I believe once ... |
218 | 09 Dec 2011 @ 11:20 PST | Tools | Reply | Teradata TPT Script |
TPT is not yet supported on Mac OS X.
That effort is planned (but not committed) for 4Q12.
TdpId/Username/UserPassword is the only mechanism by which TPT can connect to Teradata.
As ... |
217 | 09 Dec 2011 @ 11:13 PST | Tools | Reply | TPT Licnese on Unix Server |
Not sure why you installed TPT on your Teradata box. TPT needs to be installed on your load servers.
|
216 | 09 Dec 2011 @ 09:58 PST | Tools | Reply | TPT - How to format records with fixed length fields () |
The TPT documentation explains the different record formats we support. Look in the Reference Manual in Chapter 4 for the Data Connector operator (that operator is the file reader).
You will... |
215 | 09 Dec 2011 @ 09:51 PST | Tools | Reply | TPT - Problem loading delimited data with multiple files |
That patch has been out for quite a while.
|
214 | 08 Dec 2011 @ 07:34 PST | Tools | Reply | tpt export import |
Our documentation is on the official Teradata Information website. http://www.info.teradata.com/
As for patches, you will have to discuss with your rep about accessing Teradata At Your Servi... |
213 | 08 Dec 2011 @ 07:29 PST | Tools | Reply | Need Help on using TPT with UNICODE characters |
Ok, I will work backwards.
The first thing to understand is that TPT and the older legacy standalone utilities do the exact same thing.
It is called following (and executing) a particula... |
212 | 08 Dec 2011 @ 11:28 PST | Tools | Reply | Teradata TPT Script |
You have 2 choices.
1. use Easy Loader (executable is called "tdload"); in TTU 14.0 we allow you to supply the source table name and target table name (and logon credentials for ea... |
211 | 08 Dec 2011 @ 11:14 PST | Tools | Reply | TPT - Problem loading delimited data with multiple files |
We will support "gz" and "zip" in TTU14.0.
Also, you should consider upgrading to the latest and greatest efix patch for 13.10.
I believe the latest version is 13.10.... |
210 | 07 Dec 2011 @ 01:46 PST | Tools | Reply | TPT - Problem loading delimited data with multiple files |
Please provide me with the "exact" version of the 13.10 release.
This may be an issue we fixed and if I know which version you are running, I can tell you if the fix came in a patc... |