#DateForumTypeThreadPost
95921 Aug 2015 @ 04:17 PDTToolsReplyTPT Script - Not all records loaded from a file with SkipRowsEveryFile optionDid you check the table to see how many rows are actually in the table? When you do a SELECT COUNT(*), the default result is an integer value. To get the true value you will have to CAST the resu...
95819 Aug 2015 @ 03:14 PDTToolsReplyLoad fileMy post was directed at someone who was "new to Teradata". Thus, that implies they have not used the legacy utilities. For those customers, they should be using TPT and not even start u...
95719 Aug 2015 @ 01:46 PDTToolsReplyLoad fileIf you are new to Teradata, then you should be using TPT to load data into Teradata and not FastLoad. TPT (Teradata Parallel Transporter) is the load/unload utility moving forward. FastLoad is a ...
95619 Aug 2015 @ 11:52 PDTToolsReplyMload Error. Load was terminated by signal 1073741819Does this happen every time you run that job? Or is this an intermittent problem? If this happens every time for this particular job, please open an incident with the GSC and let them help you wo...
95518 Aug 2015 @ 09:02 PDTToolsReplyTPT - Delimited Data Parsing error: Invalid multi-byte characterMost emoji/emoticon characters are not supported by Teradata. If your data contains invalid multi-byte characters, you can try to set RecordErrorFileName to a valid file and the DataConnector oper...
95417 Aug 2015 @ 08:56 PDTToolsReplyFastload ErrorI do not see any error. Please provide the error you receive.  
95314 Aug 2015 @ 11:05 PDTToolsReplyTPT error: Teradata CLI Error and Teradata PT API ErrorA CLI220 error is a DBS crash message.   After the DBS came back up, you might have been able to resume the job but I do not know how Informatica would handle that.   You dropped the ...
95211 Aug 2015 @ 03:44 PDTToolsReplyError 2673 with TPT from WherescapeThe _E table will show you the name of the column and the database error. I am not sure how CLOB data will cause a 2673 unless the driver is actually changing the data. And TPT does not support L...
95111 Aug 2015 @ 11:55 PDTToolsReplyTPT Stream failure with tbuild 14.10.00.03 on HPPlease send me your script and job variable file and command line and anything else that might help diagnose this issue.   Thanks!
95011 Aug 2015 @ 10:48 PDTToolsReplyTPT error 13 in finalizing the table schema definition(SELECTOR OPERATOR)I believe in the other posts, it was point out that if you want the Selector operator to return data in VARCHAR format, you need to enable the ReportModeOn feature. Please check the documentation ...
94911 Aug 2015 @ 09:45 PDTToolsReplyTPT Question: Read two files simultaneously and write to TableJust to clarify, you are saying that the exact same INSERT statement, with the exact same command line options, results in a successful run with the Update operator but not the Load operator. &nbs...
94811 Aug 2015 @ 08:26 PDTToolsReplyTPT error in loading from an external fileIn TPT 13.0 you cannot use the Export operator to write out data in DELIMITED format. The Export operator can only retrieve the data in binary format and thus the schema must match the output from...
94711 Aug 2015 @ 08:21 PDTToolsReplyError 2673 with TPT from WherescapeThe message: L_AR1_GL_DETAILED_DATA_READ_OPERATOR: TPT17175: Warning: Message received from ODBC driver: STATE=S1C00, CODE=0, MSG='[Oracle][ODBC]Driver not capable.'   is not an e...
94610 Aug 2015 @ 11:15 PDTToolsReplyTPT error in loading from an external fileI would be able to help if I have all of the information, instead of a little at a time. If you are reading data from a file with the DataConnector operator, and the format is "delimited"...
94510 Aug 2015 @ 09:52 PDTToolsReplyTPT error in loading from an external fileIf the column is defined as varchar(20) in the database: - if you are using the client session character set of ASCII (there is no ANSI), then the column must be defined as varchar(20) in the scri...
94410 Aug 2015 @ 08:01 PDTToolsReplyTPT error in loading from an external fileSometimes when data files are generated, the EOF (end of file character) comes right after the last byte of data, instead of the end-of-line marker.   What version of TPT are you using? We ...
94307 Aug 2015 @ 08:59 PDTToolsReplyMload ScriptYou will need to write a program to pre-process the data.
94206 Aug 2015 @ 05:03 PDTToolsReplyMload ScriptMultiLoad is unable to strip out characters from data.  
94105 Aug 2015 @ 06:51 PDTToolsReplyTPT Question: Read two files simultaneously and write to TableTPT is a parallel application meaning it can read multiple files at the same time. However, the files are read asynchronously. What you are asking for is for a single process to read 2 files at t...
94004 Aug 2015 @ 11:49 PDTToolsReplyLoad UtilitiesTPT (Teradata Parallel Transporter) is the load utility suite you should be using. TPT can load Teradata with data from flat files, queues, access modules and even from Teradata and non-Teradata d...
93904 Aug 2015 @ 10:59 PDTToolsReplyTPT - Scripts from 13.10 doesn't work with 15.10 using named pipesThese messages:   The RDBMS retryable error code list was not found RetentionLogSelect: The RDBMS retryable error code list was not found **** 05:29:00 The job will use its internal retrya...
93829 Jul 2015 @ 10:25 PDTToolsReplyunloaded Date value issue by tpt scriptWhat does the output file for that row look like? Also, have you tried Export-to-Load without writing the data to a file to see the results?  
93728 Jul 2015 @ 09:02 PDTToolsReplyTeradata tptCheck the number of sessions you are trying to connect versus the max number of sessions allowed in the CLI config file "clispb.dat". You may need to increase the value for max_num_sess ...
93627 Jul 2015 @ 11:46 PDTToolsReplyunloaded Date value issue by tpt scriptI will check the development schedule tomorrow if I have a chance (if not Tuesday, then Wednesday). I imagine it will be a few months. We do not release an efix for every release in each month (we ...
93527 Jul 2015 @ 10:26 PDTToolsReplyunloaded Date value issue by tpt scriptPossible workaround: Add another atribute to the DC operator: AppendDelimiter='Y' (check to see if it is in the DC operator template file for your version of TPT) This will force a deli...

Pages