TerradataParallelTransporter-Load error

Tools
Enthusiast

TerradataParallelTransporter-Load error

Error occured during Initiate

loadop.dll) instance(1): INITIATE method failed with status = Not Found

Type: 0

Driver Terminated with status 3

Deleting objects

*** Load Complete ***

The above error occurs when we execute loadoperation using terradataparallel transporter.

We use jni to connect with c++ below is the source which is used to execute load operation.

TD_PT_OPERATOR='TD_LOAD'\n"+

"TARGET.ATTRIBUTES.UserName = 'dbc'\n"+

"TARGET.ATTRIBUTES.UserPassword = 'dbc'\n"+

"TARGET.ATTRIBUTES.LogTable = 'TiaraDB.Employeeinformation_log'\n"+

"TARGET.ATTRIBUTES.TargetTable = 'TiaraDB.Employeeinformation'\n"+

"TARGET.ATTRIBUTES.TdpId = 'localtd'\n"+

"DML.STATEMENT='INSERT INTO TiaraDB.Employeeinformation (empid,empname,empdesig,empsalary,empmail,empaddress,empzip,empcity,empstate,empcountry) VALUES (:empid,:empname,:empdesig,:empsalary,:empmail,:empaddress,:empzip,:empcity,:empstate,:empcountry);'\n"+

"SOURCE.SCHEMA='EmpId VARCHAR(5),EmpName VARCHAR(30),EmpDesig VARCHAR(10),EmpSalary VARCHAR(50),empmail VARCHAR(50),EmpAddress VARCHAR(50),EmpZip VARCHAR(50),EmpCity VARCHAR(50),EmpState VARCHAR(50),EmpCountry VARCHAR(50))'\n"+

"SOURCE.ATTRIBUTES.FileName = 'TDExportData.txt'\n"+

"SOURCE.ATTRIBUTES.Format = 'FORMATTED'\n"+

"SOURCE.ATTRIBUTES.OpenMode = 'Read'\n"+

"SOURCE.ATTRIBUTES.DirectoryPath = 'C:\eclipse'\n"+

"SOURCE.ATTRIBUTES.IndicatorMode = 'N'\n"+

"SOURCE.ATTRIBUTES.TextDelimiter = ','";

3 REPLIES
Teradata Employee

Re: TerradataParallelTransporter-Load error

I haven't used this JNI / C++ approach, but I suspect backslashes will still need to be doubled within in the resulting script; you may need to enter four in a row in DirectoryPath.

Enthusiast

Re: TerradataParallelTransporter-Load error

What are the possibilities to get this error i.e any missing params will cause this error? or any pblm in dll

Teradata Employee

Re: TerradataParallelTransporter-Load error

The Teradata JDBC Driver is the supported interface for Java applications to transfer data to and from the Teradata Database.

Using JNI with TPT is not supported.