#DateForumTypeThreadPost
53405 Dec 2013 @ 05:45 PSTToolsReplyFLoad , trying to load spaces to decimalDECIMAL is a data type that requires values in the proper format. "spaces" are not valid data bytes for a DECIMAL column.  
53305 Dec 2013 @ 03:28 PSTToolsReplyTPT job fails, Log refers to a completely seperate unrelated jobI have just been told by engineering that this is a known problem and was fixed in efix #12 of TPT 13.00. Therefore, please upgrade to the latest and greatest patch for TPT 13.00. Right now, that...
53204 Dec 2013 @ 12:42 PSTToolsReplyTPT load script fails with incompatible messageNever seen that message before. The OLE-DB Access module has no knowledge of who is calling it (that I know of). Please reply with the full TPT script. Thanks!  
53104 Dec 2013 @ 12:27 PSTToolsReplyTPT job fails, Log refers to a completely seperate unrelated jobThe console output you provided does not show anything specific other than the job terminated with an exit code of 12 and there is no error message. Can you please provide more detailed informatio...
53004 Dec 2013 @ 12:19 PSTToolsReplyTDLOAD status log issue Unfortunately, without a screenshot or more detailed information, we do not have enough information to assist with the diagnosis. If we take the following line and run it inhouse:   tdload ...
52902 Dec 2013 @ 10:47 PSTToolsReplyTDLOAD status log issue Changing what name? Is it possible to take a screenshot and send it to steven.feinholz@teradata.com?
52802 Dec 2013 @ 09:31 PSTToolsReplyTDLOAD status log issue In order to help you, you must provide more information. At a minimum, you need to provide an exact copy of the output you get on the console.  
52722 Nov 2013 @ 03:21 PSTToolsReplyTPT17122: Error: unable to connect to data source(oracle using TPT script)Incidentally, you will need to use TPT for this.  
52621 Nov 2013 @ 07:36 PSTToolsReplyTPT17122: Error: unable to connect to data source(oracle using TPT script)This particular thread is discussing TPT, not MultiLoad. Please open a new thread to discuss MultiLoad.  
52521 Nov 2013 @ 10:06 PSTToolsReplyTPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- WeirdAh, ok it is not an ODBC driver from Teradata. We only certify with DataDirect, but this is not the cause of the issue. We are still looking into it.
52420 Nov 2013 @ 12:56 PSTToolsReplyTPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- WeirdWhat ODBC driver from Teradata? Teradata's ODBC driver is only to be used against Teradata.  
52314 Nov 2013 @ 12:11 PSTToolsReplyTPT Parallel Connection LimitPlease elaborate on the question. Not sure what you mean by "parallel connection limit". For the FastLoad, MultiLoad and FastExport protocols, the max session connect limit is 1-per-ava...
52211 Nov 2013 @ 10:29 PSTToolsReplyTPT17122: Error: unable to connect to data source(oracle using TPT script)We already delivered 64-bit on Windows in 14.10.   In our next release (sometime next year) we will deliver a native 64-bit TPT on the rest of the platforms.  
52111 Nov 2013 @ 09:19 PSTToolsReplyLoading using Teradata Parallel Transporter Load utility.No.
52007 Nov 2013 @ 03:36 PSTToolsReplyNot able to export data from SQL Server using TPT ODBC OperatorYeah, we know about that row count problem and are still investigating.
51907 Nov 2013 @ 12:01 PSTToolsReplyNot able to export data from SQL Server using TPT ODBC OperatorTPT is only certified with ODBC drivers from DataDirect. You can download a free 15-day evaluation copy. Try that and see if your job runs successfully.  
51806 Nov 2013 @ 07:29 PSTToolsReplyTPT with MULTILOAD INMOD on z/OS - Error TPT_INFRA: TPT01036The only thing I can suggest right now is to upgrade to the latest TPT 13.10 set of patches (for all components of TPT). Then re-run the same job and provide the results.  
51706 Nov 2013 @ 12:12 PSTToolsReplyProblem Loading Multibyte Characters In Teradata Using FastloadFrom a colleague:     F09F94B0 looks like valid utf8, unicode U+1F530, 'Japanese symbol for beginner'.  But Teradata does not support 4 byte utf8, only 1 (7...
51606 Nov 2013 @ 12:08 PSTToolsReplyTeradata Parallel Transporter Wizard 14.10 IssueThis product will be discontinued in the not-too-distant future, and so allocating resources for this tool is not currently a high priority.  
51505 Nov 2013 @ 11:29 PSTToolsReplyProblem Loading Multibyte Characters In Teradata Using FastloadWhen you use FastLoad to load a delimited file, the schema is made up of all VARCHAR fields. Thus, the characters <dd30> just represent a character string. There is no way for FastLoad to con...
51404 Nov 2013 @ 07:53 PSTToolsReplyProblem Loading Multibyte Characters In Teradata Using FastloadFirst, why are you trying to load UTF8 data using a character set of ASCII? And why would you want a staging table with Latin columns?   The UTF8 code points will most likely all be out of t...
51331 Oct 2013 @ 01:33 PDTToolsReplyTPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- WeirdActually hold off. We see the problem inhouse and are investigating. Thanks!
51231 Oct 2013 @ 12:49 PDTToolsReplyTPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- WeirdIn the target table, how many rows are there? What are the contents of that target table? Please show the contents of a SELECT against the source table and target table so we can see what is goin...
51131 Oct 2013 @ 12:42 PDTToolsReplyMultiload with date in where conditionHave you tried treating the value as a string (put quotes around it)?
51030 Oct 2013 @ 01:51 PDTToolsReplyTPT usage with COBOL INMOD functionsIn theory, it should, although it has never been tested. All INMODs that work with FastLoad and MultiLoad should work with TPT as well.  

Pages