#DateForumTypeThreadPost
38409 Dec 2012 @ 08:35 PSTToolsReplyWhere would I be able to download TPT API for Windows?TPTAPI should be aailable on the TTU media.
38304 Dec 2012 @ 02:37 PSTToolsReplytbuild, failures of EXPORT operator on linuxYou must upgrade to the latest efix first. Then, if the problem still exists, post that information.  
38203 Dec 2012 @ 10:40 PSTToolsReplySQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definitionDid you try it?  :) The best option is to upgrade to the latest and greatest efix. That is always preferable. Aside from that, the CASE should work (it might have been better to just try it...
38130 Nov 2012 @ 12:19 PSTToolsReplyTpump Error:code 3807:Object ''SysAdmin.TPumpStatusTbl'' does not exist.You need to use SQL script shipped with TPump to create a Monitor table (''SysAdmin.TPumpStatusTbl'') in the database where Teradata TPump maintains Information about an import in o...
38026 Nov 2012 @ 03:18 PSTToolsReplyWhy I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?I do not know why you do not have libloadop.so in your "lib" directory. You may want to try to re-install the product.
37926 Nov 2012 @ 11:30 PSTToolsReplyTPT installation guidehttp://www.info.teradata.com/Datawarehouse/eBrowseBy.cfm?page=TeradataToolsandUtilities  
37826 Nov 2012 @ 11:27 PSTToolsReplyTeradata PT 12.0 error output schema does not matchThe ODBC operator cannot be loaded because the ODBC driver manager library cannot be loaded. And it looks like that is occurring because you are attempting to use the 64-bit driver manager, not th...
37726 Nov 2012 @ 11:25 PSTToolsReplyMload table locks cannot be released because NUSI existsI was just forwarding the information from the DBS engineer. I do not work in the DBS organization and thus do not have that information. You will have to consult with database engineers to obtain ...
37626 Nov 2012 @ 11:15 PSTToolsReplyInserting\Loading Data to User Define Type (UDT) through TPTTPT does not support UDTs. You must load the data by using the native data types.  
37521 Nov 2012 @ 04:23 PSTToolsReplyWhy I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?Looks like someone may have copied library files around, or you are pointing to the wrong directories. Script-based TPT is a 32-bit application. However, we also provide 64-bit versions of some o...
37421 Nov 2012 @ 10:49 PSTToolsReplyMload table locks cannot be released because NUSI existsAccording to the DBS engineer: Here is the explanation of error 7446. We process the primary data, the fallback data, and the NUSI data separately in the application phase. If there is an abort du...
37321 Nov 2012 @ 09:07 PSTToolsReplyTeradata PT 12.0 error output schema does not matchYou only have an APPLY statement with no accompanying SELECT. You have only defined a consumer operator but no producer operator.
37219 Nov 2012 @ 10:14 PSTToolsReplyParameterize source & target table name and also schema details in TPT scriptPlease take a look at the templates that came with 13.10. I think the "Load...." job variables names used to be known by "Target....". We had to change the names in 14.0 to su...
37114 Nov 2012 @ 12:28 PSTToolsReplyLoading using Teradata Parallel Transporter Load utility.By the way, why are you exporting the data to a file on a non-mainframe platform, and then loading the data from a mainframe? If I am misunderstanding your test scenario, please correct me.
37014 Nov 2012 @ 11:22 PSTToolsReplyLoading using Teradata Parallel Transporter Load utility.Instead of binary, trying exporting the data in "unformatted" format. That record format will not add the 2-byte row length to the front of every row. It will just write out the raw dat...
36908 Nov 2012 @ 07:51 PSTToolsReplyUse TPT to load a million flat filesI had a customer several years ago that had to load 25 8GB files. He found that the best performance game from using 12 file reader instances. YMMV (your mileage may vary). You will have to experim...
36808 Nov 2012 @ 07:50 PSTToolsReplyUse TPT to load a million flat filesAre you checkpointing? If so, how often? You have all 1 million files in a single directory? What is your row size (trying to get an idea how many rows per file)? Are you using the Load operato...
36708 Nov 2012 @ 03:38 PSTToolsReplyUsing name of Flat File in TPT Load My typo. It was added in TPT13.10, not TPT13.0.
36608 Nov 2012 @ 01:20 PSTToolsReplyLoading XML file into empty terdata table using TPTXML is not supported in TPT until TTU14.10. And we will treat XML the same as we treat LOBs.
36508 Nov 2012 @ 11:22 PSTToolsReplyFast Export producing unreadable text fileI am not quite sure I understand the question.
36408 Nov 2012 @ 11:22 PSTToolsReplyUse TPT to load a million flat filesWe have not had any customer try to read 1 million files. We have customers who are processing between 10,000 and 50,000 files. Are you using the wildcard syntax for the FileName attribute for th...
36307 Nov 2012 @ 06:20 PSTToolsReplyParameterize source & target table name and also schema details in TPT scriptWhat version of TPT are you using? We have made great improvements to the simplification of our script language, such that you do not need to be so verbose. Also, we can obtain the schema automat...
36207 Nov 2012 @ 11:47 PSTToolsReplyUse TPT to load a million flat filesThis is a bug that we had previously discovered and is being fixed in an upcoming efix/patch. The version will be 13.10.00.12. It will take about 4-6 weeks to appear on the Teradata At Your Servi...
36107 Nov 2012 @ 10:31 PSTToolsReplyTPT: error 2972: No table header exists for table.I spoke with the database engineers and they told me that you will need to open an incident with the GSC. Database engineers will only be able to analyze the cause of this internal error by either...
36007 Nov 2012 @ 10:07 PSTToolsReplyFast Export producing unreadable text fileWe will not be making any changes to FastExport for delimited data output. If you would like this functionality, we offer it in TPT.  

Pages