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).
All Forums

Covers the world of Teradata Tools & Utilities. This includes topics such as SQL Assistant, BTEQ, TPump, FastLoad, TPT, etc. For articles, blogs and more, see the Tools section of the site.

You must login to post to the forums.
TPT scripting: Escaping characters in Atribute fields Topic by Gabi 14 hours ago tpt, OS COMMAND, escaping special characters, attribute values

Hello guys, I'm new to TPT and I run into 

 

Here is a snippet of my TPT code 

25 views
1 reply, 12 hours ago
TPT User Templates Topic by andydoorey 18 hours ago tpt, user template

I want to create and test some user templates, which I'm going to base on the Teradata provided templates $LOAD and $EXPORT.

23 views
0 replies
TTU 15.0 download yet readme and product list refers to 14.10 Topic by h2oknut 2 days ago

i downloaded 15.0 TTU, opened the zip and readme, product list all have 14.10. is this an oversight or the wrong package? (before i install). thanks

29 views
0 replies
Error while loading data from teradata to SQL Server - TPT registry key cannot be opened Topic by toabhayn 16 Dec 2013 tpt, teradata, sql server, Attunity

Hi all,
I am building an SSIS package in SQL Server BIDS 2008 version to pull data from Teradata and dump to SQL Server.
1. I am able to connect to Teradata sucessfully as Source.
2. Connection to SQL Server as Destination is also good.
2. When I am running the package I am getting the error
*********  ERROR *******

1364 views
11 replies, 3 days ago
MF tpt failing all of the sudden. Topic by rkgudde 3 days ago tpt, TPT04013

On August 27, between the hours of 8:30 and approx 11:30.  something has caused our MF tpt's to go awry.  MF team says nothing changed.  DB team says nothing changed.  the error we are now getting is:
TPT_INFRA: TPT04013: Error: opening temporary job script output file: "EDC5000I No error occurred." (0).
Job script compilation failed.
 

42 views
1 reply, 3 days ago
Mload error: RDBMS failure: 2644, No more room in database abc Topic by Rohit Ranjan 3 days ago

Hi,
I am getting "No more room in database" error whenever i am trying to run a mload script through unix. i tried running it in different database, still getting same error. Below is the script and log.
SCRIPT:
.LOGTABLE logtable001;
.LOGON tdp3/user2,tyler;
.BEGIN MLOAD TABLES abc;
.LAYOUT abc;
(
.FIELD in_eno integer

45 views
1 reply, 3 days ago
Fast load Vs Mload when AMP is down Topic by cheeli 15 Mar 2013 Mload fload when AMP is down

Hello Experts,
No AMPs may go down (i.e., go offline) while fastload is processing,  where as Multiload can work based on the value set through the parameter AMPCHECK.  How is this achieved.  What kind of processing is done by the load utilities in this case.

928 views
4 replies, 3 days ago
TPT: How to forcefully fail the job Topic by AliHammad 3 days ago #TPT, #Locks

Is there any way I can forcefully/manually stop/fail TPT while it is loading (while TPT is in application phase) the staging tables so that the table being loaded is locked and there is no way to access it.
I need to perform some tests on TPT locked tables
 
Thanks

40 views
1 reply, 3 days ago
TD Wallet and TPT Topic by scaster@narus.com 28 Aug 2012 tdwallet tpt tbuild

It's easy enough to get tdwallet working with bteq, but does anyone have instructions for how to reference a wallet string from within a TPT script? I have tried several variations on the syntax used for bteq without success.

Specifically, the TPT script in the DDL operator, for example, requires a value for UserPassword:

 

1967 views
1 reply, 3 days ago
Easy Loader Issue Topic by toadrw 4 days ago tpt easy loader, tdload

I'm trying to load a csv file into a table using TPT Easy Loader.
The error I'm receiving is "Object Addresses2_RL does not exist." on the first run of the below script.
tdload -f "C:\addresses_table.csv" -t "Addresses2" -h tdat15 -u user1 -p *pw* --TargetWorkingDatabase "SQL_CLASS" -d ,

57 views
3 replies, 4 days ago
Exporting to Multiple files in Fast Export Topic by ambuj2k50 1 week ago fast export, Multiple Files in FastExport

Hi  All,

Can we export the output of multiple select statements specified with in .begin export and .end export to multiple outfiles ?
If we create multiple .begin export and .end export blocks with in a single fast export job, are they executed in parallel or sequencially ?
 
Thanks
ambuj

130 views
4 replies, 4 days ago
Teradata Bteq Optimization Topic by ambuj2k50 5 days ago bteq, Teradata Optimization, query tuning

Hi All,
We have a requirement to apply optimization to the exting Bteq Scripts.
What are all possible scope of optimization in a Bteq ?
Is there any best practices document or coding standard guidelines in Teradata Official documentations ?
Thanks,
Ambuj

124 views
6 replies, 4 days ago
Looking for command line versions Teradata Parallel Transporter (TD ->streaming->SQL) Topic by JoopTerwijn 4 days ago tpt, example, command line

Dear colleges,
I want to extract information form a Teradata environment and load it in SQL server ( I know this is not done :-P ). For now my process writs in a file, and then the file is load in SQLserver. Important to tell, I do not want to use SQLserver SSIS but TPT command line version!

66 views
2 replies, 4 days ago
TPT extract failing - TPT10508: RDBMS error 5407: Invalid operation for DateTime or Interval Topic by balaji.bgdev 3 weeks ago

I am getting following error while doing TPT extract.
EXPORT_OPERATOR: connecting sessions
EXPORT_OPERATOR: TPT10508: RDBMS error 5407: Invalid operation for DateTime or Interval.
EXPORT_OPERATOR: disconnecting sessions
 
Problem is only when I export  the SQL in the SelectStmt, only for timestamp columns, it is giving this error.

94 views
2 replies, 5 days ago
TPT Extract - Newline character in data causes number of records mismatch Topic by balaji.bgdev 5 days ago tpt new_line_character oreplace_function

I have written a script which will generate tpt export script based on the parameters passed.
Since I am generating this script it has to be generic in nature it works for all kinds of table and data type.

39 views
1 reply, 5 days ago
Error Starting SQL Assistant v14.10.0.4 Topic by BkAZ 6 days ago special directory, My Documents, sql assistant

I cannot start SQL Assistant, and the error message is:

System.IO.DirectoryNotFoundException: Could not find special directory 'My Documents'.

 

53 views
1 reply, 5 days ago
FASTEXPORT Looping Topic by Jugalkishorebhatt1 3 weeks ago FastExport IF ELSE condition

Hi All,
Can somebody write a simple FastExport script with IF ELSE condition. THe example given in info.teradata.com. I am not able to understand it.
 
THanks in Advance
Jugal

175 views
7 replies, 5 days ago
Error Starting SQL Assistant v13.10 Topic by stansle 06 Apr 2012 sql assistant v13.10, special directory

I receive the following error when starting SQL Assistant v13.10 in Windows 7 Professional. 

Could not find special directory 'My Documents'.  Unexpected Error. ...

Has anyone seen this error and can assist.

Thanks.

Len

 

4392 views
3 replies, 6 days ago
Fastload to non-empty table Topic by padthai_noodles 1 week ago

Hi,
What is the exact reason we can fastload to non-empty tables. I know we cant update the existing tables but what stops in just inserting to the non-empty table.
Regards,
Am

57 views
0 replies
BTEQ Output: Unicode Column wider as defined in DDL or FORMAT Topic by hans-peter 31 Jan 2012 unicode, utf8, bteq export, export width, column width

my question is about the output of a UNICODE column in BTEQ.

If I select a column defined like this...
   txt VARCHAR(11) CHARACTER SET UNICODE CASESPECIFIC,
.. it is not 11 characters wide , but it is 33 characters wide
(3 times the number of VARCHARs)

The bteq session character set is UTF8: .set session charset 'UTF8';

9945 views
11 replies, 1 week ago
FAILURE 2673 SOURCE PARCEL LENGTH DOES NOT MATCH DATA THAT WAS DEFINED Topic by TD_DEV245 14 Feb 2013 bteq, export, bteq dataimport eventlog, oracle to teradata, failure 2673 source parcel length

Hi,
I am trying to export data from oracle to Teradata.I use the following script to load data to flat file
 
 
 
CONNECT usr_id/pwd
SET SPACE 0
SET LINESIZE 300
SET PAGESIZE 500
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING ON
SET COLSEP '|'
Spool /home/dev_team/oracle_test/test.DAT

3689 views
7 replies, 1 week ago
How to read/retain the Western European characters(Windows-1252) Topic by srikanthTD 1 week ago

Our manufacturing client, uses an Informatica ETL tool to extract the data from the SQL Server through ODBC driver setting the IANAAppCodePage to "Western European (WIndows-1252)" and loads the data to Teradata DW. In this method, the extraction and loading of the data preserves the Windows-1252 characters. Data is perfectly matching when validated between these 2 systems.

59 views
0 replies
Bug in SQL Assistant 15.00 Topic by PeterSchwennesen 1 week ago Bug SQL Assistant 15.00

I think you have introduced a bug in SQL Assistant 15.00, changes I am making to the setup are not maintained after a restart.
The (CTRL+D) to toggle the comment on/off are not predefined. Therefore I am manually doing this setup.

48 views
0 replies
TPT scripts Topic by raju197402 2 weeks ago

Currently I have TPT scripts which transfers data from schema1 (Teradata  box1) to schema2 (Teradata box2). There is a plan to move the contents of Teradata Box2 to Oracle.
Will the TPT scripts written can be reused to tranfer data to Oracle. If so does it require any major changes to be done to make it work for Oracle. If not what is the alternate way?
Thanks,

103 views
1 reply, 1 week ago
SQL Assistant v.15.00 Keyboard Shortcut problems - Comment Topic by PeterSchwennesen 1 week ago SQL Assistant 15.00 TTU

I just installed the new TTU 15.00 SQL Assistant, but I having problems with the keyboard shortcuts. In previous versions the (CTRL + D) turned text to and from comments. If no text selected then the line with the curser was transformed to/from single line comment with “--“, if block of text was selected then it was transformed to/from comment block with “/*   */”.

53 views
0 replies

Pages