TPT17204: Driver Manager load error

Tools & Utilities
Enthusiast

Re: TPT17204: Driver Manager load error

Here is my odbc.ini file ...

 

[ODBC Data Sources]
DB2 Wire Protocol=Teradata 7.1 DB2 Wire Protocol
Oracle Wire Protocol=Teradata 7.1 Oracle Wire Protocol
Oracle=Teradata 7.1 Oracle
SQL Server Legacy Wire Protocol=Teradata 7.1 SQL Server Legacy Wire Protocol
SQL Server Wire Protocol=Teradata 7.1 SQL Server Wire Protocol

[ODBC]
IANAAppCodePage=4
InstallDir=/y/teradata/client/15.10/tbuild/odbc
Trace=0
TraceFile=odbctrace.out
TraceDll=/y/teradata/client/15.10/tbuild/odbc/lib64/_Ttrc27.so

[DB2 Wire Protocol]
Driver=/y/teradata/client/15.10/tbuild/odbc/lib64/_Tdb227.so
Description=Teradata 7.1 DB2 Wire Protocol
AccountingInfo=
AddStringToCreateTable=
AlternateID=
AlternateServers=
ApplicationName=
ApplicationUsingThreads=1
AuthenticationMethod=0
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadFieldDelimiter=
BulkLoadRecordDelimiter=
CatalogSchema=
CharsetFor65535=0
ClientHostName=
ClientUser=
#Collection applies to z/OS and iSeries only
Collection=
ConcurrentAccessResolution=0
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
CurrentFuncPath=
#Database applies to DB2 UDB only
Database=<database_name>
DefaultIsolationLevel=1
DynamicSections=1000
EnableBulkLoad=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
GrantAuthid=PUBLIC
GrantExecute=1
GSSClient=native
HostNameInCertificate=
IpAddress=<DB2_server_host>
KeyPassword=
KeyStore=
KeyStorePassword=
LoadBalanceTimeout=0
LoadBalancing=0
#Location applies to z/OS and iSeries only
Location=<location_name>
LogonID=
MaxPoolSize=100
MinPoolSize=0
Password=
PackageCollection=NULLID
PackageNamePrefix=DD
PackageOwner=
Pooling=0
ProgramID=
QueryTimeout=0
ReportCodePageConversionErrors=0
TcpPort=50000
TrustStore=
TrustStorePassword=
UseCurrentSchema=0
ValidateServerCertificate=1
WithHold=1
XMLDescribeType=-10

[Oracle Wire Protocol]
Driver=/y/teradata/client/15.10/tbuild/odbc/lib64/_Tora27.so
Description=Teradata 7.1 Oracle Wire Protocol
AlternateServers=
ApplicationUsingThreads=1
AccountingInfo=
Action=
ApplicationName=
ArraySize=60000
AuthenticationMethod=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadFieldDelimiter=
BulkLoadRecordDelimiter=
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
ClientHostName=
ClientID=
ClientUser=
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
DataIntegrityLevel=0
DataIntegrityTypes=MD5,SHA1
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EditionName=
EnableBulkLoad=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
EncryptionLevel=0
EncryptionMethod=0
EncryptionTypes=AES128,AES192,AES256,DES,3DES112,3DES168,RC4_40,RC4_56,RC4_128,RC4_256
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
GSSClient=native
HostName=<Oracle_server>
HostNameInCertificate=
InitializationString=
KeyPassword=
KeyStore=
KeyStorePassword=
LoadBalanceTimeout=0
LoadBalancing=0
LocalTimeZoneOffset=
LockTimeOut=-1
LoginTimeout=15
LogonID=
MaxPoolSize=100
MinPoolSize=0
Module=
Password=
Pooling=0
PortNumber=<Oracle_server_port>
ProcedureRetResults=0
ProgramID=
QueryTimeout=0
ReportCodePageConversionErrors=0
ReportRecycleBin=0
ServerName=<server_name in tnsnames.ora>
ServerType=0
ServiceName=
SID=<Oracle_System_Identifier>
TimestampeEscapeMapping=0
TNSNamesFile=<tnsnames.ora_filename>
TrustStore=
TrustStorePassword=
UseCurrentSchema=1
ValidateServerCertificate=1
WireProtocolMode=2

[Oracle]
Driver=/y/teradata/client/15.10/tbuild/odbc/lib64/_Tor827.so
Description=Teradata 7.1 Oracle
AlternateServers=
ApplicationUsingThreads=1
ArraySize=60000
CatalogIncludesSynonyms=1
CatalogOptions=0
ClientVersion=9iR2
ConnectionRetryCount=0
ConnectionRetryDelay=3
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
LoadBalancing=0
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=
OptimizeLongPerformance=0
Password=
ProcedureRetResults=0
ReportCodePageConversionErrors=0
ReportRecycleBin=0
ServerName=<Oracle_server>
TimestampEscapeMapping=0
UseCurrentSchema=1

[SQL Server Legacy Wire Protocol]
Driver=/y/teradata/client/15.10/tbuild/odbc/lib64/_Tmsss27.so
Description=Teradata 7.1 SQL Server Legacy Wire Protocol
Address=<SQLServer_host, SQLServer_server_port>
AlternateServers=
AnsiNPW=Yes
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=<database_name>
FetchTSWTZasTimestamp=0
FetchTWFSasTime=0
LoadBalancing=0
LogonID=
Password=
QuotedId=No
ReportCodepageConversionErrors=0
SnapshotSerializable=0

[SQL Server Wire Protocol]
Driver=/y/teradata/client/15.10/tbuild/odbc/lib64/_Tsqls27.so
Description=Teradata 7.1 SQL Server Wire Protocol
AlternateServers=
AlwaysReportTriggerResults=0
AnsiNPW=1
ApplicationName=
ApplicationUsingThreads=1
AuthenticationMethod=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadFieldDelimiter=
BulkLoadOptions=2
BulkLoadRecordDelimiter=
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=<database_name>
EnableBulkLoad=0
EnableQuotedIdentifiers=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
FetchTWFSasTime=1
GSSClient=native
HostName=<SQL_Server_host>
HostNameInCertificate=
InitializationString=
Language=
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=
MaxPoolSize=100
MinPoolSize=0
PacketSize=-1
Password=
Pooling=0
PortNumber=<SQL_Server_server_port>
QueryTimeout=0
ReportCodePageConversionErrors=0
SnapshotSerializable=0
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1
WorkStationID=
XMLDescribeType=-10

 

Thanks,

Meta

Teradata Employee

Re: TPT17204: Driver Manager load error

Hi,

 

Please try the following: 

1) export the ODBCINI env variable as follows:

    export ODBCINI=<your odbc.ini file path>

 

2) export LD_LIBRARY_PATH env variable as follows:

   export LD_LIBRARY_PATH=/y/teradata/client/15.10/tbuild/odbc/lib64:$LD_LIBRARY_PATH

 

3) If you have a sample ODBC application to test the connection, please try it and see if you are able to make a connection to the database you are intending to.

If not, if you have TDODBC installed on your machine, then you can run this sample to test the connection :

/y/teradata/client/16.10/odbc_64/samples/C/adhoc

Enter Data Source Name: <provide the DSN name used in the odbc.ini file>
Enter UserID: <your user name to the database>
Enter Password: <your password>

 

Now if you are able to establish the connection, please go ahead and run the TPT job and let me know how it went.

 

Note: the following pointers are provided only based on the details provided above and might not be exactly the same for everyone.

 

Thanks,
Vishnu Vardhan
Enthusiast

Re: TPT17204: Driver Manager load error

Thanks for the detailed suggestions. 

Sorry  I am not familiar with this process.  I dont see any DSN Name in my ODBC.ini file.  Should I create one for the SQL Server I wanted to use? or can use host name?

Enthusiast

Re: TPT17204: Driver Manager load error

Hi Experts,

 

It has been a while working on this issue as I was busy with other priorities.   I dont have access to modify odbc.ini file to add DSN Name but able to create a separate odbc.ini file and directed the script use this file.  I guess now the connectivity issue is resolved but I have the below error.  Please help.

 

Teradata Parallel Transporter Version 15.10.01.07 64-Bit
Job log: /y/teradata/client/15.10/tbuild/logs/SQLSERVER_TBL_TEST_Load.tpt-56.out
Job id is SQLSERVER_TBL_TEST_Load.tpt-56, running on pxnhm338
Found CheckPoint file: /y/teradata/client/15.10/tbuild/checkpoint/SQLSERVER_TBL_TEST_Load.tptLVCP
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: connecting sessions
$LOAD: connecting sessions
ODBC_Operator: TPT17176: Info: Message received from ODBC driver:
STATE=01000, CODE=5701,
MSG='[TPT][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Changed database context to 'DM_ASSET'.'
ODBC_Operator: TPT17176: Info: Message received from ODBC driver:
STATE=01000, CODE=5703,
MSG='[TPT][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Changed language setting to us_english.'
$LOAD: preparing target table
$LOAD: entering Acquisition Phase
TPT_INFRA: TPT02263: Error: Operator restart error, status = Multi Phase Error
ODBC_Operator: TPT12106: Cannot restart !!! Please resubmit the job.
ODBC_Operator: disconnecting sessions
ODBC_Operator: Total processor time used = '1.24881 Second(s)'
ODBC_Operator: Start : Mon Nov 6 15:22:59 2017
ODBC_Operator: End : Mon Nov 6 15:23:10 2017
$LOAD: disconnecting sessions
Warning:
[TPT][ODBC SQL Server Wire Protocol driver]You are not licensed to use this DataDirect Technologies product under the license you have purchased. If you wish to purchase a license for use with this application, then you may use this product for a period of 15 days, during which time you are required to obtain a license.
[TPT][ODBC SQL Server Wire Protocol driver]You can order a license for a DataDirect Technologies product for use with this application by calling DataDirect Technologies at 800-876-3101 in North America and +44 (0) 1753-218 930 elsewhere. Thank you for your cooperation. Reason Code: 000000000000000000000001
$LOAD: Total processor time used = '0.441933 Second(s)'
$LOAD: Start : Mon Nov 6 15:22:59 2017
$LOAD: End : Mon Nov 6 15:23:10 2017
Job step MAIN_STEP terminated (status 12)
Job SQLSERVER_TBL_TEST_Load.tpt terminated (status 12)
Job start: Mon Nov 6 15:22:58 2017
Job end: Mon Nov 6 15:23:11 2017

 

Thanks,

Meta

Teradata Employee

Re: TPT17204: Driver Manager load error

Do you have the license files installed?

 

-- SteveF
Teradata Employee

Re: TPT17204: Driver Manager load error

Hi,

 

There are a couple of isues here:

1) From the following error:

          Job id is SQLSERVER_TBL_TEST_Load.tpt-56, running on pxnhm338
          Found CheckPoint file: /y/teradata/client/15.10/tbuild/checkpoint/SQLSERVER_TBL_TEST_Load.tptLVCP
          This is a restart job; it restarts at step MAIN_STEP.

 

The job is a restart job and hence it results in the following error:

               TPT_INFRA: TPT02263: Error: Operator restart error, status = Multi Phase Error
               ODBC_Operator: TPT12106: Cannot restart !!! Please resubmit the job.

This is because the ODBC operator does not have restart capability and hence it asks you to resubmit the job. To avoid the job to be considered a restart job, please give a new job name with -j option or clear the checkpoint file in the checkpoint directory.

In your case, you can do this by using the following command:

 

                 #twbrmcp SQLSERVER_TBL_TEST_Load.tpt

 

2) The license issue:

 

This is a result of missing License file to use the ODBC drivers provided by Teradata Parallel Transporter. Please get a valid license file and place it in the folder /y/teradata/client/15.10/tbuild/odbc/lib64

 

Thanks,
Vishnu Vardhan