#DateForumTypeThreadPost
118415 Jul 2016 @ 12:27 PDTToolsReplyZero records are fetching when using where statement in TPTThat is the console output. The log itself will have the output from the Export operator. However, before looking at the log, you should try the exact same SELECTG request with BTEQ just to make ...
118315 Jul 2016 @ 09:55 PDTToolsReplyZero records are fetching when using where statement in TPTThank you for providing the TPT version information! Have you tried the exact same query using BTEQ to see if there is a result set? I am assuming from the information you provided that the job d...
118215 Jul 2016 @ 09:49 PDTToolsReplyTPT Export vs Fast ExportWell, not exactly. Yes, TPT is the product that everyone should be using going forward. We are not adding any features to FastExport, and that utility will also most likely not support new DBS fe...
118114 Jul 2016 @ 12:55 PDTToolsReplyTPT deadlock Issue.I see that you are using the Inserter operator. Are you using multiple instances? Multiple sessions? In order to cut down on the deadlocks on the target table, you will need to restrict your Ins...
118014 Jul 2016 @ 12:12 PDTToolsReplyTeradata Tool and Utilities package for LinuxFastExport is not a free utility. It requires a license (part of the Basic or Enterprise license for TTU).
117914 Jul 2016 @ 11:57 PDTToolsReplyEncryted Password File for FastExportCheck out the .RUN FILE command in the documentation. You cannot encrypt the contents, but you can restrict its usage through access rights settings. DataEncryption is for the data going across t...
117812 Jul 2016 @ 10:13 PDTToolsReplyTPT output from ODBC includes Indicator Bytes?Can you look at the content of the error table and make sure the rows are placed in the error table due to the column that you defined as INTEGER? And let me know the error code?  
117708 Jul 2016 @ 01:06 PDTToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHTPT 13.10 does not support quoted data. That went into TPT 14.0. And TPT 13.10 is not a supported release anymore. You will have to upgrade your version of TPT, or pre-process the data to remove...
117608 Jul 2016 @ 10:48 PDTToolsReplyNeed Help regarding TPT ODBC OperatorSince you are using LoadInst as the variable for the file writer, yes you just need to set LoadInst=7.   Yes, Total processor time is the CPU time for that operator.  
117508 Jul 2016 @ 10:43 PDTToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHYes, that is correct.
117408 Jul 2016 @ 10:20 PDTToolsReplyTPT02639 - Conflicting data type error for columnPlease provide the script and version of TPT. Did you use VARCHAR in the schema for that column? If so, then you need to change that to match the source table definition. And with a character se...
117308 Jul 2016 @ 10:17 PDTToolsReplyTPT output from ODBC includes Indicator Bytes?The schema must match the source. We must know what the data looks like as it comes to TPT. Oracle is a little challenging because of the different formatting of some of the data types. INTEGER ...
117208 Jul 2016 @ 10:07 PDTToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHThe version of TPT is present when you run TPT. As for the timestamp, whether there are quotes or not is very important. Unless you tell us otherwise, every character is considered part of the da...
117107 Jul 2016 @ 07:25 PDTToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHOk, so you have a TAB-delimited text file. Can you provide a sample row so that I can see the format of the data that is destined for the timestamp columns? Teradata is very picky about the forma...
117007 Jul 2016 @ 06:09 PDTToolsReplyTPT export to delimited files ErrorA 6706 is: "6706 The string contains an untranslatable character."   What client session character set are you using in the script?  
116907 Jul 2016 @ 06:06 PDTToolsReplyteradata TPT , all rows in error tableWhat version of TPT are you using? Do you get any errors? Or just that all rows end up in the error table? Did you look at the error table to see on which column the error is occurring? Just a ...
116807 Jul 2016 @ 02:34 PDTToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHPlease provide the whole script. In what format is your data?  
116707 Jul 2016 @ 01:03 PDTToolsReplyTPT Wizard 15.10.01.02 64-Bit: error occurred while accessing the logThere is no 64-bit version of the Wizard. We have stopped all enhancements and bug fixes to that tool. We are planning on discontinuing it someday soon. So, there is only a 32-bit version of the...
116607 Jul 2016 @ 12:43 PDTToolsReplyTPT Wizard 15.10.01.02 64-Bit: error occurred while accessing the logAre you running 32-bit TPT or 64-bit TPT? If you are defaulting to 64-bit, I do believe we have an issue when running the Wizard because the Wizard is 32-bit and thus may be looking in a different...
116507 Jul 2016 @ 11:37 PDTToolsReplyTPT output from ODBC includes Indicator Bytes?Your schema has 3 columns. Your sample data had 4 fields. The schema does not match the source table. Also, remove the -C from the command line; you do not want to round-robin your data to the i...
116406 Jul 2016 @ 12:53 PDTToolsReplyTPT output from ODBC includes Indicator Bytes?If you are reading data from Oracle with the ODBC operator, there are no indicator bytes coming from Oracle. They are added to the data when the rows are moved from the ODBC operator to the loadin...
116306 Jul 2016 @ 12:48 PDTToolsReplyTPT export to delimited files ErrorBy default, TPT is supporting a DECIMAL precision of 18 (8 bytes). Since your source column is defined as DECIMAL with a precision of 22 (needing 16 bytes), you need to add the MaxDecimalDigits=31...
116206 Jul 2016 @ 12:45 PDTToolsReplyTPT EXPORT OPERATOR job structureOur documentation describes the Export operator, the mandatory attributes and the optional ones. Our User Guide has examples of Export operator job scripts as well. We also ship sample scripts wi...
116105 Jul 2016 @ 10:44 PDTToolsReplyTPT load failure on Interval datatype - Error code 7452I am not sure why users fail to provide us with the version of TPT they are using when reporting issues, but since you are loading data into Teradata 15.10, I am assuming that the version of TPT is...
116005 Jul 2016 @ 10:35 PDTToolsReplyTPT Failure: TPT Data connector Error "TPT_DATACONNECTOR_OPERATOR[1]: TPT19015 TPT Exit code set to 4." for FastLoad JobThe messages to which you refer are not "errors":   TPT_DATACONNECTOR_OPERATOR[1]: TPT19015 TPT Exit code set to 4. TPT_DATACONNECTOR_OPERATOR[1]: TPT19229 406 error rows sent to...

Pages