#DateForumTypeThreadPost
83419 Feb 2015 @ 05:14 PSTToolsReplyIssue with TPT named pipes on windowsIn your script, you must have indicated that you wanted to use 3 instances of the DataConnector operator.   If you are using an access module, you can only use one instance of the DataConnec...
83319 Feb 2015 @ 04:27 PSTToolsReplyTPT Operator Template error "Output Schema does not match data from SELECT statement"It turns out this issue was fixed in a later version of 13.10 than you are using. Please upgrade all of the TPT packages to the latest 13.10 efixes. Your job should run fine just after that.
83218 Feb 2015 @ 11:55 PSTToolsReplyTPT Operator Template error "Output Schema does not match data from SELECT statement"Write to me offline at steven.feinholz@teradata.com. I need you to run something for me with trace enabled and then send me the debug output.  
83117 Feb 2015 @ 03:25 PSTToolsReplyFileds shifted in the database using TPTThis script has a lot of steps, so not always clear which step is the culprit, but I would have asked eventually.   In following the "trail", I see that the first load comes from a...
83017 Feb 2015 @ 12:20 PSTToolsReplyFileds shifted in the database using TPTThank you! This helps. One thing I would like you to add to the script. If you are using the SQL Selector operator to pull data out of Teradata and you want to write the data out in a delimited r...
82916 Feb 2015 @ 12:12 PSTToolsReplyTeradata Parallel Transporter (TPT) wizard error TPT19003, TPT19008, TPT19119,TPT19003I see that you specified this: VARCHAR FileName = 'Untitled',   That FileName attribute must contain the name of the .amj file created for the access module to use for the job. &nb...
82816 Feb 2015 @ 10:21 PSTToolsReplyFailed to obtain shared memory segment for for column data buffer, due to error 48.Please provide the exact version number of TPT (including the patch version). If you are running 15.00.00.00 then I would first suggest that you upgrade to the latest patch level of TPT 15. Next,...
82716 Feb 2015 @ 10:16 PSTToolsReplyFileds shifted in the database using TPTIt would help if you could provide the script. Just remove the sensitive information like TdpId, UserName and UserPassword. Otherwise we will have to continue asking questions to get more informati...
82611 Feb 2015 @ 11:41 PSTToolsReplyFastload Inserting Default User and DateHave you tried DEFAULT instead of :DEFAULT? Also, since you have defaults assigned on the CREATE TABLE, if you leave out the column references from the INSERT and the VALUES clauses, it should wor...
82506 Feb 2015 @ 03:27 PSTToolsReplyTPT DataConnector Error : Delimited Data Parsing error: Input record exceeds allocated storagePlease read:    http://developer.teradata.com/tools/articles/large-object-loading-with-teradata-parallel-transporter   It describes how to load LOBS into Teradata using TPT.
82406 Feb 2015 @ 09:54 PSTToolsReplyTPT and Unix/Linux Environment VariablesThe environment variable support never made it into 15.0 or 15.10. It is (once again) on our list of features for 16.0. (And do not confuse "TD15" with "TPT15.0". "TD15&q...
82305 Feb 2015 @ 05:30 PSTToolsReplyTPT DataConnector Error : Delimited Data Parsing error: Input record exceeds allocated storageDelimited data processing reads in a record made up of VARCHAR data. Thus, the max column size is 64000 bytes. Plus, you specified the CLOB column as "deferred by name" which means your...
82204 Feb 2015 @ 11:11 PSTToolsReplyFAST LOAD Failing in mainframe jobAs always, it would be very helpful to know the version of the tool you are using.  
82103 Feb 2015 @ 10:39 PSTToolsReplyTPT - source data enclosed with double quotes and delimited by pipe (|)With delimited data (also known as CSV data), the data is all character, and the fields are varying in length. Thus, by definition, the data is VARCHAR.   If the user wants the utility to re...
82002 Feb 2015 @ 02:49 PSTToolsReplyunable to varchar(max) / nvarchar(max) data from sql server to Teradata using TPTRight now, the only way is to export the LOB-sized data from SQLServer via some other tool, write the data out to a file, and then load from that file into Teradata with TPT.  
81930 Jan 2015 @ 11:13 PSTToolsReplyTPT 15.00 Teradata <> HDP Sanbox data movementThe TPT User Guide has sample scripts.  
81830 Jan 2015 @ 11:12 PSTToolsReplyLoading data files from hadoop to teradata using TPTTPT - Hadoop integration is supported in TPT 15.0. The TPT documentation User Guide has sample scripts.  
81730 Jan 2015 @ 11:06 PSTToolsReplyEXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statementYou will have to contact Informatica. If both source and target tables are the same, I do not see how (or why) TPTAPI would report that they are not.   BTW, TPTAPI does not do any conversion...
81629 Jan 2015 @ 06:16 PSTToolsReplyunable to varchar(max) / nvarchar(max) data from sql server to Teradata using TPTIn TPT (and Teradata) the max size of a VARCHAR column is 64000 bytes. If you have a column holding character data that exceeds 64000 bytes, it seems as though yuo are referring to a CLOB. The TP...
81529 Jan 2015 @ 11:29 PSTToolsReplyTPT - BUFFERMAX errorThat should be supported.  
81429 Jan 2015 @ 11:26 PSTToolsReplyTPT - source data enclosed with double quotes and delimited by pipe (|)1. TPT is the load/unload product that we would like everyone t use. 2. The table can have any data types as long as a conversion from VARCHAR to that data type is supported by Teradata. There is ...
81320 Jan 2015 @ 11:27 PSTToolsReplyTPT - source data enclosed with double quotes and delimited by pipe (|)Compress file supprot was implemented in 14.10.  
81219 Jan 2015 @ 07:51 PSTToolsReplyTPT - source data enclosed with double quotes and delimited by pipe (|)The only way is to upgrade to a newer version of TPT. (TPT 13.0 is not a supported release anymore.) Or pre-process the data and strip the quotes.  
81119 Jan 2015 @ 11:41 PSTToolsReplyTPT ODBC OperatorThey are bundled for most of the platforms we support (there are a few platforms that we support that DataDirect does not).   The bundled drivers cover Oracle, SQLServer and DB2 right now. ...
81019 Jan 2015 @ 11:40 PSTToolsReplyTPT Loading DateTime (SQL Server) with UTF-16 char setI just brought it up because we enforce that the data must match the schema.   If the data is coming back as VARCHAR but the schema is defined as CHAR, that can sometimes cause issues becaus...

Pages