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.

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"
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

Appreciate any help!

Re: Teradata bulk load utilities error

what version of Teradata are you running?
One Star

Re: Teradata bulk load utilities error

Teradata Version
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.

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:

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.

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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey


Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables


How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration



Introduction to Talend Open Studio for Data Integration.