Teradata bulk load utilities error

One Star

Teradata bulk load utilities error

We?ve the TOS V5.2.2 installed to evaluate the bulk loading components available through TOS for Teradata database. And tried to plug a simple source into the following components, unsuccessfully.
tTeradataFastLoad

Exception in component tTeradataFastLoad_1
java.sql.BatchUpdateException: A failure occurred while inserting the batch of rows destined for database table "D01_SB"."PV_NTWK". Details of the failure can be found in the exception chain that is accessible with getNextException.
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeBatchUpdateException(ErrorFactory.java:146)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeBatchUpdateException(ErrorFactory.java:130)
at com.teradata.jdbc.jdbc.fastload.FastLoadManagerPreparedStatement.executeBatch(FastLoadManagerPreparedStatement.java:2173)
at nr_per.test_fload_3_0_1.Test_Fload_3.tFileInputDelimited_1Process(Test_Fload_3.java:2316)
at nr_per.test_fload_3_0_1.Test_Fload_3.runJobInTOS(Test_Fload_3.java:2612)
at nr_per.test_fload_3_0_1.Test_Fload_3.main(Test_Fload_3.java:2468)
Caused by: com.teradata.jdbc.jdbc_4.util.JDBCException: The next failure(s) in the exception chain occurred while beginning FastLoad of database table "D01_SB"."PV_NTWK"
disconnected
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:92)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:67)
at com.teradata.jdbc.jdbc.fastload.FastLoadManagerPreparedStatement.beginFastLoad(FastLoadManagerPreparedStatement.java:821)
at com.teradata.jdbc.jdbc.fastload.FastLoadManagerPreparedStatement.executeBatch(FastLoadManagerPreparedStatement.java:2041)
Likewise other Teradata components listed below, throw similar error
tTeradataFastLoadUtility
tTeradataMultiLoad
tTeradataTPTutility

Appreciate any help!
Employee

Re: Teradata bulk load utilities error

what version of Teradata are you running?
One Star

Re: Teradata bulk load utilities error

Teradata Version 13.10.06.03
Seventeen Stars

Re: Teradata bulk load utilities error

Usually it helps to disable the batch mode in the Advances attributes. This way, you receive the actual error message for the dataset.
Employee

Re: Teradata bulk load utilities error

I am sure that you have done this already but if not, please review the on-line component reference for the components tTeradataFastLoad and tTeradataFastLoadUtility to verify that you are using them correctly. Also, please try to check the "Die on error" option so that you will get the detailed failure exception for your job.
Another thing you may want to try is to use the tTeradataTPump to insert data, this will verify that your Teradata connectivity is working correctly.
The online link to the Component References is:
https://help.talend.com/search/all?query=tTeradataFastLoadUtility&content-lang=en
Employee

Re: Teradata bulk load utilities error

Also, please make sure that fastload is installed on the machine and it is in the path. This is an external command line utility from Teradata.
Employee

Re: Teradata bulk load utilities error

Received this answer from cantoine:
Where is the Job being executed ? from the Talend Studio machine or from a JobServer machine or from another server somewhere ?
Where the JOB is being executed is key because that machine then needs to have the Teradata UTILITIES installed on it.
You job using Multiload or FastExport or FastLoad will call a Binary on the local machine where your JOB is run.
Make sure those BINARIES are in the PATH.
This means that if you open a cmd on the machine which execute this Talend Job, you should have a response to the execution C:/fastload ; C:/fexp ; C:/tpump.
Same thing if you're using the TPT module.
Most of the time, the TPT and Utilities from Teradata are installed if you've installed the Client from Teradata on your workstation.