TPT17122: Error: unable to connect to data source(oracle using TPT script)

Tools

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

Tags (4)
9 REPLIES
Teradata Employee

Re: TPT17122: Error: unable to connect to data source(oracle using TPT script)

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
Enthusiast

Re: TPT17122: Error: unable to connect to data source(oracle using TPT script)

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.

Teradata Employee

Re: TPT17122: Error: unable to connect to data source(oracle using TPT script)

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
Enthusiast

Re: TPT17122: Error: unable to connect to data source(oracle using TPT script)

Thanks !  I'm using Windows, good news.

Enthusiast

Re: TPT17122: Error: unable to connect to data source(oracle using TPT script)

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

Teradata Employee

Re: TPT17122: Error: unable to connect to data source(oracle using TPT script)

This particular thread is discussing TPT, not MultiLoad.

Please open a new thread to discuss MultiLoad.

-- SteveF
Teradata Employee

Re: TPT17122: Error: unable to connect to data source(oracle using TPT script)

Incidentally, you will need to use TPT for this.

-- SteveF
Enthusiast

Re: TPT17122: Error: unable to connect to data source(oracle using TPT script)

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. 

Teradata Employee

Re: TPT17122: Error: unable to connect to data source(oracle using TPT script)

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.