#DateForumTypeThreadPost
85922 Apr 2015 @ 11:44 PDTToolsReplyError Number : 120801 Error Message : Teradata WB tlogview failed when reading You will need to address this with the ETL vendor. The message they are providing is not coming from TPT. You need to find out the TPT-specific error message.  
85822 Apr 2015 @ 11:42 PDTToolsReplyTPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>';TPT supports obtaining the schema from a table in multiple ways. The user can specify this in a script:   DEFINE SCHEMA <name> FROM TABLE '<tablename>';   and eve...
85720 Apr 2015 @ 04:23 PDTToolsReplyCalling tbuild.exe directly via command prompt (Windows)Technically, TTU does not support "multiple versions" of the same products on the same machine. This means you need to manipulate environment variables to achieve your goal.   We ...
85617 Apr 2015 @ 04:52 PDTToolsReplyFastload error-Kindly Help!!There is no snapshot visible. Please cut and paste the information.  
85516 Apr 2015 @ 05:51 PDTToolsReplyFastexport with MLOAD optionIf the resulting data file is binary, you can do one of 2 things:   1. look at the binary data file and see if it is correct. 2. take the output file and re-load it into a new database tabl...
85416 Apr 2015 @ 05:45 PDTToolsReplyTPT Stream Loader - Create Macro Access error on target database (not working database).The restart log table database (unless the restart log table name is fully qualified) will be the logon database.  
85313 Apr 2015 @ 05:09 PDTToolsReplyTPT Stream Loader - Create Macro Access error on target database (not working database).The restart log table database is not the working database (thus the confusion).   The behavior comes from the old TPump utility, whose restart log table name was specified prior to the .log...
85208 Apr 2015 @ 12:24 PDTToolsReplyFastexport with MLOAD optionBy default, data exported from the Teradata database is output in binary format. If you would like to know more about this, please refer to the FastExport Reference Manual. The FastExport utility...
85130 Mar 2015 @ 09:56 PDTToolsReplyFASTLOAD: Can it skip blank lines?No, FastLoad cannot skip blank lines.  
85024 Mar 2015 @ 10:39 PDTToolsReplyTPT Stream Loader - Create Macro Access error on target database (not working database).You might want to look at the Stream operator information in the TPT reference manual for the use of the MacroDatabase attribute.
84924 Mar 2015 @ 10:36 PDTToolsReplyTPT - Delimited Data Parsing error: Invalid multi-byte characterWhen you want assistance, it is always a good idea to provide: 1. the version of TPT you are using 2. the actual failure (is it a DBS failure? a TPT failure)   The word "fail" ca...
84817 Mar 2015 @ 03:51 PDTToolsReplyFastload Logtable errorGood Question!   I wish I could say with a definitive answer that you can query the restart log as the solution for determining which tables are locked by a FastLoad job.   However, I...
84713 Mar 2015 @ 04:03 PDTToolsReplyTPT LoadingBTW, I just ran some tests using 05JAN2003 (and several other combinations) and TPT completed successfully without issuing the same error. You say you are running TPT 15.0. Please provide the exa...
84613 Mar 2015 @ 10:38 PDTToolsReplyODBCOperator: TPT17187: Failed to obtain shared memory segment for for column data buffer, due to error 48.For some reason, TPT needs more memory for the job (do not know why at this point). Please try running the job again, and add -h 25M to the command line and see if that helps.  
84512 Mar 2015 @ 11:56 PDTToolsReplyMLOAD - UTILITYTPT can move data from SQLServer to Teradata without landing data to disk. The Teradata load/unload tools cannot move data in the other direction. You will have to use another tool for that. &nb...
84411 Mar 2015 @ 02:06 PDTToolsReplyCan we pass schema and sql statement as variables to tpt scriptSymbol substitution in TPT is exactly that. A "substitution". It is not "substitution and execute". Thus, having "cat" in the string will not actually execute the &q...
84310 Mar 2015 @ 03:57 PDTToolsReplyError Number : 120801 Error Message : Teradata WB tlogview failed when reading Which ETL tool are you using? You may have to speak to someone from the ETL vendor.  
84210 Mar 2015 @ 09:54 PDTToolsReplyMLOAD - UTILITYIf you are new to Teradata, you should be using TPT, not MultiLoad. TPT is the load/unload tool moving forward. TPT has the ability to move data from SQL Server to Teradata without landing the da...
84106 Mar 2015 @ 09:54 PSTToolsReplyTPT LoadingThank you for trying. Can you please send me your data, and your script? Did the rows end up in the DataConnector operator's Error File? Or the error table on the DBS? If the error file, pl...
84006 Mar 2015 @ 10:24 PSTToolsReplyODBCOperator: TPT17187: Failed to obtain shared memory segment for for column data buffer, due to error 48.Please send the scripts to me: steven.feinholz@teradata.com. Thanks!  
83906 Mar 2015 @ 10:22 PSTToolsReplyLoad data from Oracle to Teradata with correct character setOn Windows you will have to use the ODBC administrator. I am not familiar with Windows settings. I can ask around; the person in my group who might know is out until next week.  
83805 Mar 2015 @ 05:36 PSTToolsReplyLoad data from Oracle to Teradata with correct character setThe character set type to be used by the ODBC driver must be specified through the driver settings (odbc.ini file on Unix/Linux), not through the TPT script.  
83705 Mar 2015 @ 09:29 PSTToolsReplyTPT LoadingOne thing you can try (while I am researching the error you are getting) is to set the "RowErrFileName" attribute in the DataConnector operator. Provide a valid file name in which we can ...
83627 Feb 2015 @ 10:26 PSTToolsReplyTPT - source data enclosed with double quotes and delimited by pipe (|)I will not be able to address all of the questions, but will try my best:   1. when you say you are loading a Teradata table defined with all VARCHAR fields, does that mean you defined your ...
83523 Feb 2015 @ 09:26 PSTToolsReplyTPT script to load data with embedded qualifiersRow placed in the ET table are performed by the DBS, not by TPT. TPT has no control over which rows end up in the ET table. And rows placed in the ET table are rows containing data conversion err...

Pages