All Forums Cloud Computing
teradatauser2 236 posts Joined 04/12
04 Feb 2015
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:

http://developer.teradata.com/database/articles/ teradata-express-14-10-for-vmware-player-user-guide

 

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

Fred 1096 posts Joined 08/04
05 Feb 2015

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

teradatauser2 236 posts Joined 04/12
05 Feb 2015

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

Fred 1096 posts Joined 08/04
05 Feb 2015

On the tdload command line.

teradatauser2 236 posts Joined 04/12
07 Feb 2015
   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

teradatauser2 236 posts Joined 04/12
07 Feb 2015

 

                        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. 

 

Fred 1096 posts Joined 08/04
07 Feb 2015

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

teradatauser2 236 posts Joined 04/12
07 Feb 2015

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. :)

You must sign in to leave a comment.