topic Re: Teradata bulk load utilities error in Talend Studio

Teradata bulk load utilities error

Anonymous — Mon, 10 Jun 2013 16:47:20 GMT

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!

Re: Teradata bulk load utilities error

Anonymous — Mon, 10 Jun 2013 17:17:38 GMT

what version of Teradata are you running?

Re: Teradata bulk load utilities error

Anonymous — Mon, 10 Jun 2013 21:22:12 GMT

Teradata Version 13.10.06.03

Re: Teradata bulk load utilities error

Anonymous — Mon, 10 Jun 2013 21:44:04 GMT

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

Anonymous — Tue, 18 Jun 2013 19:00:08 GMT

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

Re: Teradata bulk load utilities error

Anonymous — Mon, 24 Jun 2013 14:07:00 GMT

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

Anonymous — Wed, 26 Jun 2013 13:55:00 GMT

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.