TPT17204: Driver Manager load error

Tools & Utilities
Enthusiast

TPT17204: Driver Manager load error

Hi All,

 

I have started using TPT recently.  I am trying to load the data from SQL Server to Teradata using TPT ODBC operator and getting the below error.  Please help me to resolve this error.

 

ODBC_Operator: TPT17204: Driver Manager load error: 'lib_Ticu27.so: cannot open shared object file: No such file or directory

 

Thanks in advance,

Meta

15 REPLIES
Teradata Employee

Re: TPT17204: Driver Manager load error

What version of TPT are you using?

Please provide the value of your PATH environment variable.

 

-- SteveF
Enthusiast

Re: TPT17204: Driver Manager load error

Hi Steve, We are using Teradata 15.10 and below is the linux path and output log generated. I have also tried on windows and getting Microsoft Driver Manager error. Path: ----- /y/teradata/client/15.10/tbuild Below is the Log: --------------------- Teradata Parallel Transporter Executor Version 15.10.01.07 Teradata Parallel Transporter ODBC Operator Version 15.10.01.07 ODBC_Operator: private log specified: odbclog ODBC_Operator: TPT17204: Driver Manager load error: 'lib_Ticu27.so: cannot open shared object file: No such file or directory' TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0 ODBC_Operator: Total processor time used = '0.004999 Second(s)' ODBC_Operator: Start : Fri Oct 20 20:43:33 2017 ODBC_Operator: End : Fri Oct 20 20:43:34 2017 Thank you, -meta
Teradata Employee

Re: TPT17204: Driver Manager load error

Please provide the entire content of the PATH environment variable.

I would also need to see the content of the script and job variable file (if you are using one).

Did you also check to see if the file "lib_Ticu27.so" actually exists in the .../client/15.10/tbuild/odbc directory?

 

 As a workaround, on Unix/Linux, try setting LD_LIBRARY_PATH to .../teradata/client/<version>/tbuild/odbc/<lib or lib64>.

-- SteveF
Enthusiast

Re: TPT17204: Driver Manager load error

 

lib_ticu27.so is available in both lib & lib64
/teradata/client/15.10/tbuild/odbc/lib & /teradata/client/15.10/tbuild/odbc/lib64


/teradata/client/15.10/tbuild
bin checkpoint inc jar license logs mmap odbc sample template tptapi twbcfg.ini twboper.ini version

CONTENT
---------------
[xxxxxx@xxxxxxx]/y/teradata/client/15.10> tbuil
Teradata Parallel Transporter Version 15.10.01.07 64-Bit

Usage: tbuild -f ScriptFile [-C] [-d] [-e ScriptFileEncoding]
[-h MemorySize | -h MemorySizeK | -h MemorySizeM]
[-j JobName | JobName ]
[-l LatencyInterval] [-L LogFilePath]
[-m StatisticsInterval] [-n] [-o] [-r CheckpointDirectory]
[-R RetryLimit] [-s JobStepID]
[-S DD:ddname | -S DatasetName | -S SYSOUTClass]
[-t] [-u JobVariables] [-v JobVariablesFile] [-V]
[-z CheckPointInterval] [JobName]

Options description:
-f ScriptFile - Read Teradata Parallel Transporter script file
-C - Cyclic (round robin) data delivery
-d - Debug trace from all tasks
-e ScriptFileEncoding - Specify character set encoding of script file
-h MemorySize - Shared memory size specified in bytes
-h MemorySizeK - Shared memory size specified in kilobytes
-h MemorySizeM - Shared memory size specified in megabytes
-j JobName - The name to be assigned to this job
-l LatencyInterval - Seconds between latency processing
-L LogFilePath - Log file directory path (non-MVS only)
-m StatisticsInterval - Seconds between statistics collections
-n - Continue job even if a step returns an error
-o - Write the consumer private logs to stdout
-r CheckpointDirectory - Directory for checkpoint files (non-MVS only)
-R RetryLimit - Number of automatic retries after restart
-s JobStepID - Start job execution at this job step
-S DD:ddname - Log report ddname (MVS only)
-S DatasetName - Log report Dataset name (MVS only)
-S SYSOUTClass - Log report SYSOUT class (MVS only)
-t - Trace all tasks
-u JobVariables - String of job variables
-v JobVariablesFile - Name of a file containing job variables
-V - Display Teradata Parallel Transporter version
-z CheckpointInterval - Seconds between checkpoints
JobName - The name to be assigned to this job

 

--TPT SCRIPT USING
-------------------
DEFINE JOB SQLSRCTBL_Load_J
DESCRIPTION 'SQL SERVER TO TD LOAD'
(
DEFINE SCHEMA SQLSERVER_Schema
DESCRIPTION 'Schema of SQLSERVER Data Source'
(
A VARCHAR(150),
B VARCHAR(24),
C VARCHAR(150),
1 INTEGER
);

DEFINE OPERATOR ODBC_Operator
DESCRIPTION 'TPT ODBC Operator'
TYPE ODBC
SCHEMA SQLSERVER_Schema
ATTRIBUTES
(
VARCHAR PrivateLogName = @ODBCPrivateLogName,
VARCHAR DSNName = @DSNName,
VARCHAR UserName = @ODBCUserName,
VARCHAR UserPassword = @ODBCPassword,
VARCHAR SelectStmt = @SelectStmt
);

APPLY
( 'INSERT INTO ' || @TargetTable || ' (
:A,
:B,
:C,
:1
);'
)
TO OPERATOR ( $LOAD [@LoadInstances] )

SELECT * FROM OPERATOR ( ODBC_Operator [@ODBCInstances] );
);
);

--JOB VARIABLE FILE
---------------------
/**********************************/
/* Values for ODBC operator */
/**********************************/
ODBCInstances = 1,
ODBCPrivateLogName = 'odbclog',
DSNName = 'XXXXXXSQLSRVR.com',
ODBCUserName = 'XXXXXX',
ODBCPassword = 'XX123123',
SelectStmt = 'SELECT * FROM SQLSRVRSRCTBL;'
/**********************************/
/* Values for LOAD operator */
/*********************************/
LoadInstances = 1,
LoadPrivateLogName = 'loadlog',
TargetWorkingDatabase = 'TGTTDDB'
TargetTable = 'TGTTDTBL',
TargetTdpId = 'dev.xxxx.com',
TargetUserName = 'xxxxxx',
TargetUserPassword = 'xxxxxx',
LogTable = 'SQLSRCTBL_TPT_Log'


--LOG OUTPUT
----------------------
Teradata Parallel Transporter Version 15.10.01.07 64-Bit
Job log: /y/teradata/client/15.10/tbuild/logs/td_loader-14.out
Job id is td_loader-14, running on xxxxxx
Found CheckPoint file: /y/teradata/client/15.10/tbuild/checkpoint/td_loaderLVCP
This is a restart job; it restarts at step MAIN_STEP.
Teradata Parallel Transporter Load Operator Version 15.10.01.07
$LOAD: private log specified: loadlog
Teradata Parallel Transporter ODBC Operator Version 15.10.01.07
ODBC_Operator: private log specified: odbclog
ODBC_Operator: TPT17204: Driver Manager load error: 'lib_Ticu27.so: cannot open shared object file: No such file or directory'
$LOAD: connecting sessions
$LOAD: TPT10508: RDBMS error 3524: The user does not have CREATE TABLE access to database DBC.
ODBC_Operator: Total processor time used = '0.004999 Second(s)'
ODBC_Operator: Start : Wed Oct 25 13:42:26 2017
ODBC_Operator: End : Wed Oct 25 13:42:26 2017
$LOAD: disconnecting sessions
$LOAD: Total processor time used = '0.055992 Second(s)'
$LOAD: Start : Wed Oct 25 13:42:26 2017
$LOAD: End : Wed Oct 25 13:42:26 2017
Job step MAIN_STEP terminated (status 12)
Job td_loader terminated (status 12)
Job start: Wed Oct 25 13:42:25 2017
Job end: Wed Oct 25 13:42:26 2017

 

 

Teradata Employee

Re: TPT17204: Driver Manager load error

Did you try setting LD_LIBRARY_PATH?

-- SteveF
Enthusiast

Re: TPT17204: Driver Manager load error

Hi Steve,

 

I am not sure where to set LD_LIBRARY_PATH.  Is it in twbcfg.ini file?

Teradata Employee

Re: TPT17204: Driver Manager load error

It is an environment variable (like PATH).

-- SteveF
Enthusiast

Re: TPT17204: Driver Manager load error

Thanks Steve.  Some good news.  I have set up LD_LIBRARY_PATH to lib64 as export variable in shell script and executed the script.  The Driver Manager Load error resolved but I have the " ODBC_Operator: TPT17122: Error: unable to connect to data source" .  Below is the log...

 

Teradata Parallel Transporter Version 15.10.01.07 64-Bit
Job log: /y/teradata/client/15.10/tbuild/logs/td_loader-17.out
Job id is td_loader-17, running on XXXXXX
Found CheckPoint file: /y/teradata/client/15.10/tbuild/checkpoint/td_loaderLVCP
This is a restart job; it restarts at step MAIN_STEP.
Teradata Parallel Transporter Load Operator Version 15.10.01.07
$LOAD: private log specified: loadlog
Teradata Parallel Transporter ODBC Operator Version 15.10.01.07
ODBC_Operator: private log specified: odbclog
$LOAD: connecting sessions
ODBC_Operator: connecting sessions
ODBC_Operator: TPT17122: Error: unable to connect to data source
$LOAD: TPT10508: RDBMS error 3524: The user does not have CREATE TABLE access to database DBC.
ODBC_Operator: Total processor time used = '0.007998 Second(s)'
ODBC_Operator: Start : Wed Oct 25 21:50:07 2017
ODBC_Operator: End : Wed Oct 25 21:50:08 2017
$LOAD: disconnecting sessions
$LOAD: Total processor time used = '0.059991 Second(s)'
$LOAD: Start : Wed Oct 25 21:50:07 2017
$LOAD: End : Wed Oct 25 21:50:08 2017
Job step MAIN_STEP terminated (status 12)
Job td_loader terminated (status 12)
Job start: Wed Oct 25 21:50:03 2017
Job end: Wed Oct 25 21:50:08 2017

 

Ofcourse I will still need to resolve the user create table access, which I will do later.

 

Thanks,

Meta.

Teradata Employee

Re: TPT17204: Driver Manager load error

Hi,

 

"ODBC_Operator: TPT17122: Error: unable to connect to data source" this error indicates that there seems to be a problem with your DSN settings.

Can you post the contents of your odbc.ini file? (ofcourse you have to trim away any sensitive information like ip address/username/password etc..)

 

Thanks,
Vishnu Vardhan