error while extrating data from ORACLE using TPT ODBC_OPERATOR

Database
N/A

error while extrating data from ORACLE using TPT ODBC_OPERATOR

Hi,

I am extracting data into a file from ORACLE database using odbc_operator in TPT. But i am facing below error,

Teradata Parallel Transporter Version 14.00.00.10

Job log: /opt/teradata/client/14.00/tbuild/logs/whupbit-95.out

Job id is whupbit-95, running on tide1a08

Found CheckPoint file: /opt/teradata/client/14.00/tbuild/checkpoint/whupbitLVCP

This is a restart job; it restarts at step export_to_file.

TPT_INFRA: TPT02192: Error: Cannot load shared library

           dlopen error: Could not load module /opt/teradata/client/14.00/tbuild/lib/libodbcop.so.

        Dependent module libodbc.a(odbc.so) could not be loaded.

Could not load module libodbc.a(odbc.so).

System error: No such file or directory

Could not load module /opt/teradata/client/14.00/tbuild/lib/libodbcop.so.

        Dependent module /opt/teradata/client/14.00/tbuild/lib/libodbcop.so could not be loaded.

TPT_INFRA: TPT02109: Cannot open shared library libodbcop.so, status = Open Error

TPT_INFRA: TPT02240: Error: Cannot create operator object, status = Operator Error

TPT_INFRA: TPT02103: Executor unable to set up its table object

Job step export_to_file terminated (status 8)

Job whupbit terminated (status 8)

should i get execute access on file "libodbcop.so"

-r--r--r--    1 root     system       306993 15 Sep 2013  libodbcop.so

My odbc.ini is as below. Should i have to add anything in it??

[ODBC]

InstallDir=/opt/teradata/client/14.00/odbc_32

Trace=0

TraceDll=/opt/teradata/client/14.00/odbc_32/lib/odbctrac.so

TraceFile=/usr/joe/odbcusr/trace.log

TraceAutoStop=0

[ODBC Data Sources]

default=tdata.so

testdsn=tdata.so

[testdsn]

Driver=/opt/teradata/client/14.00/odbc_32/lib/tdata.so

Description=Teradata running Teradata V1R5.2

DBCName=208.199.59.208

LastUser=

Username=

Password=

Database=

DefaultDatabase=

[default]

Driver=/opt/teradata/client/14.00/odbc_32/lib/tdata.so

Description=Default DSN is Teradata 5100

DBCName=208.199.59.208

LastUser=

Username=

Password=

Database=

DefaultDatabase=

Please help.

2 REPLIES
N/A

Re: error while extrating data from ORACLE using TPT ODBC_OPERATOR

Hi,

can anyone please help me on this?

N/A

Re: error while extrating data from ORACLE using TPT ODBC_OPERATOR

Hi,

Please anyone help me in resolving this issue.