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