Introduction to the Teradata Parallel Transporter Operators

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Teradata Employee

Re: Introduction to the Teradata Parallel Transporter Operators

VetriSlevan,

Yes, it's possible to connect only by using the ConnectString attribute (without the DSNName attribute).

I have already provided you with a sample ConnectString attribute:

'DSN=MYDSN;UID=username;PWD=Secret'

Enthusiast

Re: Introduction to the Teradata Parallel Transporter Operators

I have resolved the data source name issue and have assigned all the environment variables. I am using DataDirect 7.0 Oracle Wire Protocol driver and my OS is "SunOS 5.10 Generic_141444-09 sun4v sparc SUNW,SPARC-Enterprise-T5220". When I execute the script am getting the below error:-

Teradata Parallel Transporter Load Operator Version 14.00.00.08

LOAD_OPERATOR: private log specified: loadoper_privatelog

LOAD_OPERATOR: connecting sessions

Teradata Parallel Transporter ODBC Operator Version 14.00.00.08

EXPORT_OPERATOR: private log specified: odbclog.txt-1

EXPORT_OPERATOR: connecting sessions

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

EXPORT_OPERATOR: TPT17101: Fatal error received from ODBC driver:

              STATE=IM003, CODE=0,

              MSG='[DataDirect][ODBC lib] Specified driver could not be loaded'

EXPORT_OPERATOR: disconnecting sessions

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

EXPORT_OPERATOR: TPT17101: Fatal error received from ODBC driver:

              STATE=08003, CODE=0,

              MSG='[DataDirect][ODBC lib] Connection not open'

EXPORT_OPERATOR: Total processor time used = '0.11 Second(s)'

EXPORT_OPERATOR: Start : Wed May 28 10:04:13 2014

EXPORT_OPERATOR: End   : Wed May 28 10:04:13 2014

LOAD_OPERATOR: preparing target table

LOAD_OPERATOR: entering Acquisition Phase

LOAD_OPERATOR: disconnecting sessions

LOAD_OPERATOR: Total processor time used = '19.33 Second(s)'

LOAD_OPERATOR: Start : Wed May 28 10:04:13 2014

LOAD_OPERATOR: End   : Wed May 28 10:04:41 2014

Could you please help me on this?

Teradata Employee

Re: Introduction to the Teradata Parallel Transporter Operators

VetriSlevan,

You might be not setting the LD_LIBRARY_PATH or might be pointing it to a wrong location.

 The LD_LIBRARY_PATH should point to the lib folder of the DataDirect Drivers.

Since you are using the DataDirect Drivers, have you tried to use the sample application provided by the DataDirect in its install path to see if you are able to make a connection using the DSN?

Also, can you send me the output of the ldd command on the libodbcop.so file and also the Driver file that you are using?

Enthusiast

Re: Introduction to the Teradata Parallel Transporter Operators

Hi Tony,

I dont find any file named libodbcop.so in the lib path. However, I can see the file with the name libodbc.so. Please find the output for the command ldd, libodbc.so file

-bash-3.00$ ldd <odbc_lib_path>/libodbc.so

        libDWicu26.so =>         <odbc_lib_path>/libDWicu26.so

        libodbcinst.so =>        <odbc_lib_path>/libodbcinst.so

        libsocket.so.1 =>        /usr/lib/sparcv9/libsocket.so.1

        libdl.so.1 =>    /usr/lib/sparcv9/libdl.so.1

        libCrun.so.1 =>  /usr/lib/sparcv9/libCrun.so.1

        libnsl.so.1 =>   /usr/lib/sparcv9/libnsl.so.1

        librt.so.1 =>    /usr/lib/sparcv9/librt.so.1

        libm.so.1 =>     /usr/lib/sparcv9/libm.so.1

        libc.so.1 =>     /usr/lib/sparcv9/libc.so.1

        libmp.so.2 =>    /usr/lib/sparcv9/libmp.so.2

        libmd.so.1 =>    /usr/lib/sparcv9/libmd.so.1

        libscf.so.1 =>   /usr/lib/sparcv9/libscf.so.1

        libaio.so.1 =>   /usr/lib/sparcv9/libaio.so.1

        libdoor.so.1 =>  /usr/lib/sparcv9/libdoor.so.1

        libuutil.so.1 =>         /usr/lib/sparcv9/libuutil.so.1

        libgen.so.1 =>   /usr/lib/sparcv9/libgen.so.1

        libm.so.2 =>     /usr/lib/sparcv9/libm.so.2

        /platform/SUNW,SPARC-Enterprise-T5220/lib/sparcv9/libc_psr.so.1

        /platform/SUNW,SPARC-Enterprise-T5220/lib/sparcv9/libmd_psr.so.1

-bash-3.00$

I am using the driver file "DWora26.so" and its located in <odbc_lib_path> and I have set the same in LD_LIBRARY_PATH variable before executing the TPT script.

Thanks,

Vetri Selvan

Teradata Employee

Re: Introduction to the Teradata Parallel Transporter Operators

Vetri,

The libodbcop.so file should be in the /opt/teradata/client/14.00/tbuild/lib directory. Check and send me the ldd output for the libodbcop.so file.

Thanks.

Enthusiast

Re: Introduction to the Teradata Parallel Transporter Operators

Hi Tony,

Please see ldd output below:

-bash-3.00$ ldd libodbcop.so

       libodbc.so =>    /apps/teradata/client/14.00/odbc_32/lib/libodbc.so

       libodbcinst.so =>        /apps/teradata/client/14.00/odbc_32/lib/libodbcinst.so

       libopcommon.so =>        /apps/teradata/client/14.00/tbuild/lib/libopcommon.so

       libpxicu.so =>   /apps/teradata/client/14.00/tbuild/lib/libpxicu.so

       libnsl.so.1 =>   /lib/libnsl.so.1

       libivicu25.so =>         /apps/teradata/client/14.00/odbc_32/lib/libivicu25.so

       libsocket.so.1 =>        /usr/lib/libsocket.so.1

       libdl.so.1 =>    /usr/lib/libdl.so.1

       libCrun.so.1 =>  /usr/lib/libCrun.so.1

       libcliv2.so =>   /apps/teradata/client/14.00/lib/libcliv2.so

       libmp.so.2 =>    /lib/libmp.so.2

       libmd.so.1 =>    /lib/libmd.so.1

       libscf.so.1 =>   /lib/libscf.so.1

       libc.so.1 =>     /lib/libc.so.1

       librt.so.1 =>    /usr/lib/librt.so.1

       libm.so.1 =>     /usr/lib/libm.so.1

       libCstd.so.1 =>  /usr/lib/libCstd.so.1

       libdoor.so.1 =>  /lib/libdoor.so.1

       libuutil.so.1 =>         /lib/libuutil.so.1

       libgen.so.1 =>   /lib/libgen.so.1

       libaio.so.1 =>   /lib/libaio.so.1

       /platform/SUNW,SPARC-Enterprise-T5220/lib/libmd_psr.so.1

       libm.so.2 =>     /lib/libm.so.2

       /platform/SUNW,SPARC-Enterprise-T5220/lib/libc_psr.so.1

       /usr/lib/cpu/sparcv8plus/libCstd_isa.so.1

-bash-3.00$

Regards

Highlighted
Enthusiast

Re: Introduction to the Teradata Parallel Transporter Operators

Vetri,

Your LD_LIBRARY_PATH should point to the DataDirect lib folder and the ODBCINI should point to the odbc.ini file. and even after doing this, if you are unable to  run the tests, then i suggest you try to connect to the DSN you are using through the sample application in the  "/opt/Progress/DataDirect/Connect_for_ODBC_71/samples/example" folder. If this does not work, then please check your entries in the odbc.ini file to make sure the entries are correct.

Enthusiast

Re: Introduction to the Teradata Parallel Transporter Operators

Vetriselvan, 

Please use the same odbc.ini file, and execute the sample program (of data direct) and see whether you are able to connect to the desired DSN. 

Enthusiast

Re: Introduction to the Teradata Parallel Transporter Operators

Hi Vishnu,

We don’t have Progress DataDirect driver installed in the server separately. So I am using the datadirect odbc driver that came along with informatica installation and hence my lib path is "/apps/informatica/Informatica951/ODBC7.0/lib" and the driver "DWora26.so" for connecting to oracle from TPT script. Will that be causing the connection issue?

Regards