Error message

User error: Failed to connect to memcache server: rpc4010:11222 in dmemcache_object() (line 415 of /appl2/devx/drupal/sites7/all/modules/memcache/dmemcache.inc).
#DateForumTypeThreadPost
61224 Jul 2013 @ 06:45 PDTConnectivityReplyLogin OK with teradata Assistant, KO with BTEQthe message is indicating that BTEQ reached the server but either user or password is wrong. Are you 100% sure of not having a typo?
61124 Jul 2013 @ 06:42 PDTDatabaseReplyUntranslatable character at any position in a field.did you check the TRANSLATE function and checked the WITH ERROR option?
61024 Jul 2013 @ 06:38 PDTDatabaseReplyCan I do select from fallback table?system will read the fallback data if a node or diskarray is going down but you can't influence this with a SQL. What would be the benifit if direct accessing it?  
60924 Jul 2013 @ 06:36 PDTDatabaseReplyUnicode vs Latinlatin is just the system default at your system if you are not specifing something in your ddl. space savings - an unicode varchar/char will use 2 times the space. 
60812 Jun 2013 @ 05:55 PDTData ModelingReplyEffect of reversing the order of columns in mutli-column statsat least up to 13.10 - I am not 100% sure about 14.0. see http://developer.teradata.com/blog/carrie/2012/04/teradata-13-10-statistics-collection-recommendations Only the 16 bytes of the conc...
60704 Jun 2013 @ 06:00 PDTDatabaseReplyIs there any way to handle single digit's in date?Try SEL TO_TIMESTAMP('May 10 2013 10:58:04:3934PM', 'Month dd yyyy hh:mi:ss:ssssAM')
60604 Jun 2013 @ 04:37 PDTGeneralReplySame hash for different valuesThe hashrow has to few bits, so hash collissions are common. It doesn't have the same properties as a SHA1 hash.
60530 May 2013 @ 10:59 PDTDatabaseReplyTransposing the data - QUERYyou could do the same with min and the change_log_from column  build two derived tables (one with the max one with the min)  and join the results together and coalesce the max, min...
60430 May 2013 @ 10:58 PDTAnalyticsReplyteradataR package and R 3.0.0I know - but why doesn't TD release a new version?  Or release the source code as open source and someone could move this forward?
60330 May 2013 @ 08:42 PDTDatabaseReplyTransposing the data - QUERYAre you looking for something like  select ID, change_id, update_time, substr(max(case when columnname = 'change_col_1' then cast(update_time as char(30)) ...
60230 May 2013 @ 07:11 PDTDatabaseReplyView validity checkits not possible to get this info out of dbc it can change any time and maybe in 5 min the view is valid again. try the following bteq script .logon system/user,passwd; .set width 500; cre...
60129 May 2013 @ 03:36 PDTToolsReplyUnable to open Teradata SQL assistantTeradata SQL assistant on Mac OS? At least I never saw a Mac version Teradata SQL assistant is a windows program. Or do you mean Teradata Studio (Express)?
60029 May 2013 @ 01:28 PDTDatabaseReplyTransposing the data - QUERYHi, your timestamps values are not valid. As you expect specific results it would be good if you can review the data. timestamp need to be of format 'YYYY-MM-DD HH:Mi:SS.ssssss' - I guess...
59929 May 2013 @ 01:13 PDTToolsReplyTD utilities and JAVA.Still very unclear what you want. In BTEQ you can use the OS command to run scripts on OS level - like rm to remove files. This could be used to call a java programm as well.  But what woul...
59822 May 2013 @ 08:23 PDTDatabaseReplyACCOUNTING CPU usage fpr UDFWhich TD version do you run? And which UDF language do you use? To my knowledge does 13.10 account for C UDFs but I am not sure about JAVA. At least in the past Java UDF CPU usage was not capture...
59721 May 2013 @ 10:00 PDTToolsReplyTPT: Moving tables from One TD box to other TD box using TPT You are funny. Harpreet given you the right answer and where to lock for the sample scripts. They are also available in the R13.10 TPT documentation. If you just wane play arround with it try htt...
59616 May 2013 @ 04:43 PDTDatabaseReplyImplicit conversion of Integer to VARCHARBut as the explain states it will try to do the coversion for all values of order_key in the table. The message you get is indicating that at least one value of order_key can be converted to a flo...
59515 May 2013 @ 11:33 PDTDatabaseReplySUBSTR without explicitly coding the length parmI can't reproduce the issue. select top 100 substring(myvar from 4), substr(myvar,4), substr(myvar,14,CHARACTER_LENGTH(myvar)) from mytbl; but as you can see abov...
59415 May 2013 @ 04:54 PDTDatabaseReplyGenerating Sequence NumberP.S. read the documentation carefully before using identity columns. There are other issues as well which need to be considered...
59315 May 2013 @ 04:52 PDTDatabaseReplyGenerating Sequence Numberbecaus the increment by 1 is handled vproc local. Identity columns are not guarantee a sequence - they only quarantee unique ids. Each vproc request a range of numbers he can assign next. The siz...
59224 Apr 2013 @ 05:31 PDTDatabaseReplyThere is another way to remove a volatile table?you can simply drop the VT table within the SP
59124 Apr 2013 @ 02:43 PDTAnalyticsReplyTeradataR Question about kemans analysisCan't test it right now as teradataR is not working for R3.0.0 :-( What should work is that you create a view with your two columns and call td.kmeans with this view.
59020 Mar 2013 @ 08:33 PDTDatabaseReplySQL SyntaxIt's like Dieter suggested try  replace view test_db _uli.v_test1 as select a.col1, a.col2, a.col3, b.col4 from ( select calendar_date as col1, mo...
58920 Mar 2013 @ 01:41 PDTConnectivityReplyOnly an ET or null statement is legal after a DDL StatementAs you wanne use the query band setting only for the one sql try BT;   SET QUERY_BAND = 'Project=Example2;Report=0315-17.11;MSTRUser=MSTRPORTAL_EXXXX;' FOR transaction; select * fr...
58820 Mar 2013 @ 01:11 PDTDatabaseReplySQL Syntaxdid you try to create a view like Create view VW2 as SEL a.col1, a.col2, a.col3, b.col4 from ( sel col1, col2, col3 from tab1 where col2 = '...

Pages