#DateForumTypeThreadPost
103404 Jan 2016 @ 11:11 PSTToolsReplyTPT - Delimited Data Parsing error: Invalid multi-byte characterWas record number 276 the first record with an invalid character? Can you provide me with all of the attribute values you set up in the script (or job variable file) for the DataConnector operator?
103304 Jan 2016 @ 10:19 PSTToolsReplyTPT - Delimited Data Parsing error: Invalid multi-byte characterSome errors will cause the DataConnector operator to terminate if it feels it cannot continue because the parsing would not allow it to find the end-of-record character reliably.   However, ...
103204 Jan 2016 @ 10:15 PSTToolsReplyunloaded Date value issue by tpt scriptWe do not currently support that feature. It is being considered for a future release.  
103104 Jan 2016 @ 10:14 PSTToolsReplyTPT Inserter OperatorThe TPT Inserter operator does not support PACK and there are no plans to add that feature. Please use the Stream operator for that type of functionality.  
103004 Jan 2016 @ 10:09 PSTToolsReplyLoading a timestamp column with FastloadThat just looks like a scripting issue. Looks like you may not have escaped single-quotes correctly. If you post the entire script (or at least the complete section that results in this error) I ...
102904 Jan 2016 @ 10:04 PSTToolsReplyProblem with Fast Load scriptTo answer your original question, the error in FastLoad occurred because you did not have a DEFINE statement in the script.   FastLoad is used (primarily) to load data from a flat file into ...
102823 Dec 2015 @ 11:39 PSTToolsReplyHow to set '0x0001' as delimeter in tdload command?What version of TPT are you using?
102722 Dec 2015 @ 09:33 PSTToolsReplyTPT Error Message - Delimiter did not immediately follow close quote mark in row 109785, col 8.Please send everything to steven.feinholz@teradata.com. Thanks!  
102621 Dec 2015 @ 11:01 PSTToolsReplyTPT Error Message - Delimiter did not immediately follow close quote mark in row 109785, col 8.We are looking into this. A few questions need answering please: * You mention having the problems in 15.10.00.03.  Did the same jobs work on a previous TPT installation? * Are you using a ...
102521 Dec 2015 @ 09:20 PSTToolsReplyHow to call TPT scripts from Shell ScriptsIf you are running 15.10 on Windows, you do NOT want to put: C:\Program Files\Teradata\client\nn.nn\Teradata Parallel Transporter\bin64 in your PATH. In 15.10, the binaries are located in: C:\P...
102415 Dec 2015 @ 02:06 PSTToolsReplyFASTLAOD on TTU15 - Empty file on read open Well, 32-bit FastLoad should be able to read a 5GB file. I will have someone look into that. On the flip-side, I am glad you will move to TPT. It is the best solution. To move data from one data...
102315 Dec 2015 @ 12:34 PSTToolsReplyFASTLAOD on TTU15 - Empty file on read open FastLoad is only delivered as a 32-bit app. All of the older utilities remain 32-bit. TPT has both but defaults to 64-bit. I am curious about this statement: "a lot of FASTEXPORTS And FASTL...
102215 Dec 2015 @ 11:24 PSTToolsReplyFASTLAOD on TTU15 - Empty file on read open What version of FastLoad were you running when you get the error? And just to confirm, when you upgraded to TTU15, FastLoad 15.0 works fine with the large file?
102115 Dec 2015 @ 11:07 PSTToolsReplyTPT Error Message - Delimiter did not immediately follow close quote mark in row 109785, col 8.On which platform are you running TPT? How many rows are in the file? The end-of-record delimiter must be appropriate for the platform on which the job is being executed. If TPT is running on th...
102015 Dec 2015 @ 07:52 PSTToolsReplyHow to set '0x0001' as delimeter in tdload command?What version of TPT are you using?  
101910 Dec 2015 @ 12:22 PSTToolsReplyRecord Rejected to Error Table if String contains untranslatable character while doing TPT extract/Load in BINARY modeAs Fred mentioned, the term "Binary Mode" only refers to the format of the data located in a flat file. When you use the term "TPT EXTRACT/LOAD", I interpret that to mean you a...
101809 Dec 2015 @ 01:21 PSTToolsReplyTPT Oracle JDBC connectionTDThrottle,   You posted a question on the DevX article thread: "Use Teradata Parallel Transporter to Move Data Without Landing the Data to Disk"   I am assuming you do not...
101708 Dec 2015 @ 09:34 PSTToolsReplyRecord rejected to error table if date feild is enclosed with double quotes Ok, I understand about the option needing to be "optional". Since you sent me data that was all quoted, I thought maybe all data would be that way. Is it possible to upgrade to 14.00.00...
101607 Dec 2015 @ 11:41 PSTToolsReplyRecord rejected to error table if date feild is enclosed with double quotes Actually, can you try 2 things?   1. Change QuotedData = 'optional'   to  QuotedData = 'yes' (since all of your fields are quoted, it will not cause a problem,...
101507 Dec 2015 @ 09:50 PSTToolsReplyRecord rejected to error table if date feild is enclosed with double quotes Yes, you are correct, that in earlier versions of TPT there was no way to distinguish between BLANK and NULL.   However, when QuotedData is enabled, the rules are simple. The existence of 2 ...
101404 Dec 2015 @ 06:18 PSTToolsReplyTPT Oracle JDBC connectionMy post said:   Could it be that the ODBCINI environment variable is pointing to a valid odbc.ini file, but the contents of the odbc.ini file are actually pointing to non-branded drivers? &...
101303 Dec 2015 @ 02:50 PSTToolsReplyRecord rejected to error table if date feild is enclosed with double quotes All of my jobs were run against TD 15.10. Can you please try running TPT 14.0 against your TD 15.00? I have a feeling this might be a DBS issue, not a TPT issue.  
101203 Dec 2015 @ 02:47 PSTToolsReplyRecord rejected to error table if date feild is enclosed with double quotes I just tried the exact same data you gave me using TPT 14.00.00.08, 14.10.00.13 and 15.10.00.04 and all versions of TPT complete with the same result.   All jobs result in both rows being lo...
101103 Dec 2015 @ 02:07 PSTToolsReplyRecord rejected to error table if date feild is enclosed with double quotes Not sure if this was a typo, but in one of your responses you indicated you tried 14.10. Is this true? If so, which specific version of 14.10 did you try?  
101003 Dec 2015 @ 01:28 PSTToolsReplyRecord rejected to error table if date feild is enclosed with double quotes We are investigating.

Pages