#DateForumTypeThreadPost
55920 Jan 2014 @ 09:52 PSTToolsReplyTPT Template operators with LDAP authenticationNo. It has not been scheduled yet.  
55817 Jan 2014 @ 12:11 PSTToolsReplyTPT Error - Not able to get rows having incorrect format Please send the complete .out file to steven.feinholz@teradata.com.
55717 Jan 2014 @ 11:38 PSTToolsReplyTPT Error - Not able to get rows having incorrect format As "ratchet" mentioned, if you set the RowErrFileName attribute to a valid file name, the file reader will place the error rows into the file and continue processing.   When the jo...
55616 Jan 2014 @ 06:21 PSTToolsReplyOLELoad and FastLoad on LinuxPlease refer to the TPT documentation. Everything you need should be explained there.  
55516 Jan 2014 @ 06:18 PSTToolsReplyTPT15105: Error 13 in finalizing the table schema definitionI notice you tripled the size of each column in the schema (probably because you will be using a client session character set of UTF8?), except for the last one (active_ind).   Was this on p...
55415 Jan 2014 @ 11:12 PSTToolsReplyTPT Error - Not able to get rows having incorrect format May I ask where you got these attribute names from?   VARCHAR RecordErrorFilePrefix='tablename_err.dat', VARCHAR RecordErrorVerbosity ='Med',
55315 Jan 2014 @ 11:06 PSTToolsReplyTPT load script fails with incompatible messageNo. MLOAD does not support that functionality. You will need to use TPT.  
55214 Jan 2014 @ 09:27 PSTToolsReplyTPT load script fails with incompatible messageThe error you are receiving is this:   TPT10508: RDBMS error 3857: Cannot use value (or macro parameter) to match 'Name_6'.   (the other messages are warnings because you are...
55113 Jan 2014 @ 09:33 PSTToolsReplyTPT error - TPTRight now, the only thing I can suggest is for you to install the latest patches for TPT 13.10, which is 13.10.00.17. But you must install the patches for all of the TPT packages.   The issu...
55013 Jan 2014 @ 09:31 PSTToolsReplyTPT - new line in data - export to file has issuesThose newline characters are probably the end-of-record markers. As the other posted noted, the script would help. So would a copy of the console output you received when you ran the job.
54909 Jan 2014 @ 01:34 PSTToolsReplyOLELoad and FastLoad on LinuxI need to state here that TPT is only "certified" with ODBC drivers from DataDirect.   However, you are free to try to use any ODBC drivers you want.  
54808 Jan 2014 @ 02:18 PSTToolsReplyDelimiter Issue With TPT on Linux PlatformPlease do the following: add the following to the file writer operator definition: VARCHAR TraceLevel = 'all' Re-run the job (until it fails), and then please send me the .out file for t...
54708 Jan 2014 @ 02:06 PSTToolsReplyTPT Template operators with LDAP authenticationThe automatic schema generation part of TPT's "simplicity" does not currently support LDAP. You will have to provide the schema in the script until this can be fixed.  
54608 Jan 2014 @ 01:17 PSTToolsReplyDelimiter Issue With TPT on Linux PlatformI tried running the exact same test inhouse and do not get the same results. I get:   test1|One Time Data Migration|One Time Data Migration test2|One Time Data Migration|One Time Data Mig...
54508 Jan 2014 @ 11:42 PSTToolsReplyBTET/ANSI Transaction in TPT/FASTLOADWhat you are seeing is a difference in behavior between our special load/unload protocols, and generic SQL insert/select. FastLoad (and TPT Load) are "bulk" loaders. They were designed t...
54408 Jan 2014 @ 11:34 PSTToolsReplyDelimiter Issue With TPT on Linux PlatformPlease provide the script and a sample of data, and a detailed explanation of the problem. It is not clear what "incorrect data" means. Are there any errors being shown? What version o...
54308 Jan 2014 @ 11:17 PSTToolsReplyVariant records and TPTIf you are talking about the MultiLoad feature whereby you can specify the byte position in the input stream for the various columns, such as:        COL1  1  I...
54227 Dec 2013 @ 10:22 PSTToolsReplyTPT Template operators with LDAP authenticationTake a look at <install_dir>/templates (where <install_dir> is the top level directory where TPT is installed).   You will see the templates. Each template file will contain the...
54127 Dec 2013 @ 09:27 PSTToolsReplyTPT Template operators with LDAP authenticationI believe when you use templates, you need to use the template job variable names.   For example:   TargetTdpId TargetUserName TargetUserPassword TargetLogonMech TargetLogonMe...
54027 Dec 2013 @ 08:44 PSTToolsReplyTPT Template operators with LDAP authenticationPlease provide your script and job variable file (and command line contents, if you entered job variable information there as well).   Thanks!  
53916 Dec 2013 @ 04:36 PSTToolsReplyTPT error - TPTIn TPT13.10, while processing the script we create some temporary files in the current working directory.   Please make sure the user has the proper access rights to that directory.  
53816 Dec 2013 @ 01:45 PSTToolsReplyTPT (14.00), executing tbuild causes underlying UNIX machine to crashWhen you state this:   "I have been able to run the very same tpt script locally from my windows machine that has a TPT version 14.00 as well."   Does that mean the job ran ...
53716 Dec 2013 @ 01:17 PSTToolsReplyConvert NULL to Blank TPT Fast LoadThe FastLoad protocol (used by FastLoad and the TPT Load operator) does not support that syntax in the INSERT statement.   Try the TPT Update operator for that type of operation.  
53611 Dec 2013 @ 12:22 PSTToolsReplyTPT with UDF.The SELECT clause of the APPLY-SELECT statement is supposed to contain column names. There are several issues with the script:   1. You enclosed the CASE logic in double-quotes, which is be...
53511 Dec 2013 @ 12:15 PSTToolsReplyTPT SelectStmtWe strip newlines from within the requests so it should not be a problem. (I have seen SELECT requests in TPT scripts that span pages.)  

Pages