All Forums Tools
dilsere2 1 post Joined 12/11
10 Dec 2012
TPT17122: Error: unable to connect to data source(oracle using TPT script)

I am getting below error while trying to connect to Oracle DB using DataDirect 7.1 ODBC drivers from TPT script. I am able to test the connection using the example executable program in DataDirect and it works fine.
TeraData Version:  13.10
DataDirect Driver: 7.1 (64 bit trial for testing purpose)
Below is the Log.
 
 

Job step Setup_Into_Tables completed successfully

Teradata Parallel Transporter Executor Version 13.10.00.02

Teradata Parallel Transporter Executor Version 13.10.00.02

Teradata Parallel Transporter Coordinator Version 13.10.00.02

Teradata Parallel Transporter Update Operator Version 13.10.00.02

Load_Operator: private log specified: project_load_log

Teradata Parallel Transporter ODBC Operator Version 13.10.00.02

ODBC_Operator: private log specified: project_odbc_log

ODBC_Operator: connecting sessions

ODBC_Operator: TPT17122: Error: unable to connect to data source

ODBC_Operator: TPT17101: Fatal error received from ODBC driver:

              STATE=81, CODE=0,

              MSG='523 80'

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0

ODBC_Operator: disconnecting sessions

ODBC_Operator: TPT17124: Error: unable to disconnect from data source

ODBC_Operator: TPT17101: Fatal error received from ODBC driver:

              STATE=53, CODE=0,

              MSG='523 52'

ODBC_Operator: Total processor time used = '0 Second(s)'

ODBC_Operator: Start : Mon Dec 10 13:28:22 2012

ODBC_Operator: End   : Mon Dec 10 13:28:22 2012

 

feinholz 1234 posts Joined 05/08
20 Dec 2012

Are you using the 32-bit or 64-bit versions of the driver?
TPT is a 32-bit application and you must use the 32-bit versions of the drivers.
 

--SteveF

Willimoa 63 posts Joined 10/09
11 Nov 2013

Are there any plans for TPT to move to 64-bit ?   I have 64bit servers available with 64bit ODBC drivers already installed - it would be ideal to use what's there with the TPT ODBC Operator without having to purchase additional 32 bit drivers.

feinholz 1234 posts Joined 05/08
11 Nov 2013

We already delivered 64-bit on Windows in 14.10.
 
In our next release (sometime next year) we will deliver a native 64-bit TPT on the rest of the platforms.
 

--SteveF

Willimoa 63 posts Joined 10/09
12 Nov 2013

Thanks !  I'm using Windows, good news.

bbdd.tsunix 2 posts Joined 04/13
20 Nov 2013

Hi,
I need load date from oracle database to teradata in linux machine. Do you know, how i can do this with mload script??
Someboy can tell me a example od how i can to connect to oracle database directly from the mload script??
 
Regards

feinholz 1234 posts Joined 05/08
21 Nov 2013

This particular thread is discussing TPT, not MultiLoad.
Please open a new thread to discuss MultiLoad.
 

--SteveF

feinholz 1234 posts Joined 05/08
22 Nov 2013

Incidentally, you will need to use TPT for this.
 

--SteveF

jammy19031989 8 posts Joined 07/13
16 Dec 2015

Hi, I am trying to move data from Oracle to Teradata using the TPT Script below but unable to connect to Oracle database as it throws an CLI 224 error like "name not in HOSTS file or names database"

Define job TPT_Load_Source

DESCRIPTION 'MOVE DATA WITHOUT LANDING THE DATA TO DISK'

 

(

 

   /*** Schema Definition ***/

 

  

 

   DEFINE SCHEMA EMPLOYEE_SCHEMA

 

   DESCRIPTION 'SAMPLE EMPLOYEE SCHEMA'

 

   (

Col1 VARCHAR(30),

Col2 VARCHAR(40)

 

);

 

  

 

   /*** Export Operator Definition ***/

 

  

 

   DEFINE OPERATOR EXPORT_OPERATOR

 

   DESCRIPTION 'TERADATA PARALLEL TRANSPORTER EXPORT OPERATOR'

 

   TYPE EXPORT

 

   SCHEMA EMPLOYEE_SCHEMA

 

   ATTRIBUTES

 

   (

 

      VARCHAR PrivateLogName = 'exportoper_privatelog',

 

      INTEGER MaxSessions    =  8,

 

      INTEGER MinSessions,

 

      VARCHAR DSNName          = 'as3p1.secs.com',

 

      VARCHAR UserName       = 'discvr',

 

      VARCHAR UserPassword   = '***',

 

      VARCHAR SelectStmt     = 'select * from database.tablename;'

 

   );

 

  

 

   /*** Load Operator Definition ***/

 

  

 

   DEFINE OPERATOR LOAD_OPERATOR

 

   DESCRIPTION 'TERADATA PARALLEL TRANSPORTER LOAD OPERATOR'

 

   TYPE LOAD

 

   SCHEMA EMPLOYEE_SCHEMA

 

   ATTRIBUTES

 

   (

 

      VARCHAR PrivateLogName = 'loadoper_privatelog',

 

      INTEGER MaxSessions    = 16,

 

      INTEGER MinSessions,

 

 

      VARCHAR TargetTable    = 'db.tb',

 

      VARCHAR TdpId          = '10.12.10.21',

 

      VARCHAR UserName       = 'sac_dlfetltd1',

 

      VARCHAR UserPassword   = '******',

 

      VARCHAR ErrorTable1    = 'db.tb_et1',

 

      VARCHAR ErrorTable2    = 'db.tb_et2',

 

      VARCHAR LogTable       = 'db.tb_log'

 

   );

 

  

 

   /*** Apply Statement ***/

 

  

 

   APPLY

 

   ('INSERT INTO db.tb (

:col1,

:col2

 

);')

 

   TO OPERATOR (LOAD_OPERATOR [1])

 

  

 

   SELECT * FROM OPERATOR (EXPORT_OPERATOR [2]);

 

);

 

 

 

I guess some the issue is while connecting to oracle RDBMS. 

 

 

 

Fred 1096 posts Joined 08/04
16 Dec 2015

Please start a new topic for new questions.
The EXPORT operator only reads from Teradata, so uses a Tdpid not a DSN. If you want to read from Oracle via a DSN, you need to use the ODBC operator.

You must sign in to leave a comment.