All forum activity

#DateUserForumTypeThreadPost
5829207 Jul 2016 @ 11:13 PDTAVOTViewpointTopicViewpoint SUSE CompatibilityHi Teradata Gurus, We are currently having VP 15.00 hosted on SLES 10. We are planning to upgrade to VP 15.10 . But can anyone please let me know if VP15.10 is compatible with SLES 10, or do we n...
5829107 Jul 2016 @ 10:33 PDTdhiraj_dt121ToolsReplyteradata TPT , all rows in error tableTeradata Parallel Transporter Version 14.10.00.08 No Error in the job, only that all the rows end up in error table. Yes, I found the error iN TABLES are  6706 NOTE 6706 ACCMPNY ...
5829007 Jul 2016 @ 08:33 PDTkchinnadTeradata StudioReplyTerdata Studio - Connection to Hive - Database is not listingit's not a sanbox vm. it's a physical RHEL server where Hortonworks 2.3.4 is installed by hortonworks team for our bank.
5828907 Jul 2016 @ 07:43 PDTmcorsiToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHAlso Steve - Don't get tied up on the quotes wrapping the datetime fields. That was just my last pull/attempt. No matter what I wrap them in (singles, nothing etc...) they will not convert. &n...
5828807 Jul 2016 @ 07:32 PDTmcorsiToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHexample row:   121234 21653 Retail 40.15 "2016-05-27 13:37:08" "2016-05-27 13:37:08"   tab delimited (not that it looks like it on a cust and paste) last two field...
5828707 Jul 2016 @ 07:25 PDTfeinholzToolsReplytpt 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...
5828607 Jul 2016 @ 07:17 PDTmcorsiToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHbtw- it got convoluted because I did not describe the problem correctly. my bad. My issue is that I need to upload a file with a string representing a datetime or timestamp field and import it in...
5828507 Jul 2016 @ 06:59 PDTmcorsiToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHThis whole thread has gotten a little convoluted. I need the last part of that last post (the load_data step) to send Update_Ts and Create_Ts as timestamp objects. (datetime, timestamp(0), timestam...
5828407 Jul 2016 @ 06:43 PDTmcorsiToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHThat was ugly - lets do it in code version:   DEFINE JOB AMR_SCPTv3_f_Channels DESCRIPTION 'Loads f_channels_pub data into a XBI_RADBI_BIZ_APP AMR_SCPTv3_f_Channels Teradata table...
5828307 Jul 2016 @ 06:42 PDTmcorsiToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCH format of the data? It is in the format of the table I am trying to build. I am sucking data from one database, writing to flat file, sending it to teradata and then trying to suck it in. ...
5828207 Jul 2016 @ 06:09 PDTfeinholzToolsReplyTPT 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?  
5828107 Jul 2016 @ 06:06 PDTfeinholzToolsReplyteradata 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 ...
5828007 Jul 2016 @ 03:29 PDTfgrimmerTeradata StudioReplyStudio Express severe keyboard lagNot sure why it would matter having the workspace created in ProgramData? We have seen some customers that have the <USER> driver on a LAN drive and this causes issues when the network is una...
5827907 Jul 2016 @ 02:34 PDTfeinholzToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHPlease provide the whole script. In what format is your data?  
5827807 Jul 2016 @ 01:36 PDTmcorsiToolsTopictpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHI am having difficulty using tpt and bulk loading dates into a table. My define schema looks like: DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHAR(25), ...
5827707 Jul 2016 @ 01:13 PDTN_RaghuToolsReplyTPT Wizard 15.10.01.02 64-Bit: error occurred while accessing the logThank You Steve
5827607 Jul 2016 @ 01:03 PDTfeinholzToolsReplyTPT 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...
5827507 Jul 2016 @ 01:00 PDTN_RaghuToolsReplyTPT Wizard 15.10.01.02 64-Bit: error occurred while accessing the logI think it is defaulting to 64-bit. Do I need to uninstall 64bit and install 32-bit tpt? I remember it installed both the versions..It is just that I don't know how to run a 32bit version wizar...
5827407 Jul 2016 @ 12:43 PDTfeinholzToolsReplyTPT 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...
5827307 Jul 2016 @ 12:39 PDTN_RaghuToolsReplyTPT Wizard 15.10.01.02 64-Bit: error occurred while accessing the logAlso checked the permissions and I do have full control to the Teradata folder on my C drive. 
5827207 Jul 2016 @ 12:34 PDTN_RaghuToolsTopicTPT Wizard 15.10.01.02 64-Bit: error occurred while accessing the logI have installed TD15.10 and using TPT wizard 15.10 to load a file to teradata table. Everything works fine and the job loads the table correctly except that the error messages popping up saying &q...
5827107 Jul 2016 @ 11:37 PDTfeinholzToolsReplyTPT 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...
5827007 Jul 2016 @ 11:32 PDTSNguyenWFTeradata StudioReplyStudio Express severe keyboard lagYes, I'm launching using the desktop shortcut and with -data.  The desktop shortcut launches with the re-located workspace.  It has a "start in" of %HOMEDRIVE%%HOMEPATH...
5826907 Jul 2016 @ 11:26 PDTAkshayKashyapDatabaseReplyExpanding the column size Hi,   After the modification of table: VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC FORMAT 'X(20)' says that it's previous/ex/X length was VARCHAR(20) which has now ...
5826807 Jul 2016 @ 11:04 PDTquestDatabaseTopicAny dynamic lookup concept in teradata?Hi all, Was wondering if there is anything like dynamic lookup concept where duplicates from source can be prevented from loading into target table? Source table col1 | col2 | col3 | col4 | col5...

Pages