I have a job that is tFileInputDelmited > tMap > tTeradataOutput > tLogRow If I load from a file with 5,000 records and I use Commit every 5,000 for the tTeradataOutput component, everything loads and I get no errors. When I attempt to load from a file with more than 5,000 records, I get the following message:
connected
Exception in component tTeradataOutput_1
java.lang.NullPointerException
at com.teradata.jdbc.jdbc_4.ParameterProperties.adjustParameters(ParameterProperties.java:267)
at com.teradata.jdbc.jdbc_3.ifjdbc_4.LocalStatementParameters.buildBatchStatement(LocalStatementParameters.java:112)
at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalPreparedStatement.executeBatch(TeraLocalPreparedStatement.java:302)
at talenddemosjava.myJobName_0_1.myJobName.tFileInputDelimited_1Process(myJobName.java:1720)
A failure occurred while executing a PreparedStatement batch request.
Details of the failure can be found in the exception chain that is accessible with getNextException.
.------------+---------------.
| tLogRow_1 |
| -----------+--------------|
|errorMessage|errorStackTrace|
| -----------+--------------|
'------------+---------------'
at talenddemosjava.myJobName_0_1.myJobName.runJobInTOS(myJobName.java:1956)
at talenddemosjava.myJobName_0_1.myJobName.main(myJobName.java:1827)
disconnected
Any suggestions?
What additional steps can I try to troubleshoot? Is it possible to use the use batch option with the tTeradataOutput component?
