Error while running tpt on vmware TD13.10

Teradata Express Software
Formerly this board name was Cloud Computing. The name was changed to better represent the product areas covered.
Junior Supporter

Error while running tpt on vmware TD13.10

Hi,

I installed TD 13.10 on vm ware. When i run - 

/opt/teradata/client/13.0/tbuild/bin/tdload -f test -u vmtest -p vmtest -t test


to load a test file as mentioned in the article below:


i get below error :

Got CLI error 224 while connecting a session.  'MTDP: EM_NOHOST(224): name not in HOSTS file or names database.'

I know it has to take something with Logon command that is fired as i got the same error in bteq. But when i used .logon locolhost/dbc, it worked in bteq. Here while running where do we specify this paramater ? or there is some other problem here ?

Thanks !

Samir

7 REPLIES
Teradata Employee

Re: Error while running tpt on vmware TD13.10

Specify the TDPID using the -h option, e.g. append -h localhost

Junior Supporter

Re: Error while running tpt on vmware TD13.10

Hi Fred,

Where do i specify this option ? I am sure TPT would be using some file to specify TDPID, but i am not sure in which module ? Yes, you are correct i used localhost while loging in Bteq and it worked.

Thanks !

Samir

Teradata Employee

Re: Error while running tpt on vmware TD13.10

On the tdload command line.

Junior Supporter

Re: Error while running tpt on vmware TD13.10

   DEFINE OPERATOR DDL_OPERATOR - my ddl operator
TYPE DDL
ATTRIBUTES
(
VARCHAR PrivateLogName = 'ddl_log',
VARCHAR TdpId = 'localhost',
VARCHAR UserName = 'vmtest',
VARCHAR UserPassword = 'vmtest',
VARCHAR ErrorList = '3807'
);

DEFINE OPERATOR EXPORT_OPERATOR() - my export operator
DESCRIPTION 'TERADATA PARALLEL TRANSPORTER EXPORT OPERATOR'
TYPE EXPORT
SCHEMA EMPLOYEE_SCHEMA
ATTRIBUTES
(
VARCHAR PrivateLogName = 'GT44_exportoper_privatelog',
INTEGER MaxSessions = 32,
INTEGER MinSessions = 1,
VARCHAR TdpId = 'localhost',
VARCHAR UseName = 'dbc',
VARCHAR UserPassword = 'dbc',
VARCHAR AccountId,
VARCHAR SelectStmt = 'SELECT * FROM vmtest.EMPLOYEE;'
);

STEP Setup_Tables
(
APPLY
('DROP TABLE vmtest.Employee;'),
('CREATE TABLE vmtest.Employee(
emp_id integer,
emp_name CHAR(10));'),
('insert into vmtest.employee values(1,''samir'');'),
('insert into vmtest.employee values(2,''abc'');'),
('insert into vmtest.employee values(3,''Def'');'),
('insert into vmtest.employee values(4,''ijk'');')
TO OPERATOR (DDL_OPERATOR);
);

STEP export_to_file
(
APPLY TO OPERATOR (FILE_WRITER() )
SELECT * FROM OPERATOR (EXPORT_OPERATOR() [1] );
);

Hi Fred, Thanks for your reply, it worrked. I am experimenting with tpt as i am new to it, hence i might have some basic question, sorry about that.

I tested the above code to drop and create a table named-employee, it works fine. But when i try to export is using the export operator, i get below error :

EXPORT_OPERATOR: connecting sessions Job step export_to_file terminated (status 12)

Job root terminated (status 12)

EXPORT_OPERATOR: TPT10508: RDBMS error 8017: The UserId, Password or Account is invalid.

I am surprised here as i am using the same userid and password in DDL, it works fine. But it fails here. I tried with vmtest and dbc both. i tested the passwords in bteq, password for both of them are correct. Could you please help me here.

--Samir

Junior Supporter

Re: Error while running tpt on vmware TD13.10


                        VARCHAR PrivateLogName    =  'GT44_exportoper_privatelog',
INTEGER MaxSessions = 32,
INTEGER MinSessions = 1,
VARCHAR SourceTdpId = 'localhost',
VARCHAR SourceUseName = 'dbc',
VARCHAR SourceUserPassword = 'dbc',
VARCHAR AccountId,
VARCHAR SelectStmt = 'SELECT * FROM vmtest.EMPLOYEE;'

When i added Source to tdpid,id and password, i get below error :

EXPORT_OPERATOR: TPT10507: CLI Error 224: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.

This should have gone as i have specified localhost in tdpid. I also tried -h localhost during build, but didn't help. 

Teradata Employee

Re: Error while running tpt on vmware TD13.10

You don't want the Source prefix, just fix the typo in UserName.

Junior Supporter

Re: Error while running tpt on vmware TD13.10

Hi Fred, that was a silly one, sorry abt that. it worked. I remember one dialog from series "How i met your mother". Ted said that his mother used to say him not to take any decision/work late in the nights as they are wrong most of the times. It was too late night for me as well. :)