• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Teradata - JDBC Driver - Error 1338

#1 2011-02-16 20:47:16

talendtester
Member
Registered: 2009-07-15
Posts: 99

Teradata - JDBC Driver - Error 1338

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:


[statistics] 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)
[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1338]  [SQLState HY000] 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)
[statistics] disconnected


Any suggestions?
What additional steps can I try to troubleshoot?
Is it possible to use the use batch option with the tTeradataOutput component?

Offline

#2 2011-02-17 17:23:58

talendtester
Member
Registered: 2009-07-15
Posts: 99

Re: Teradata - JDBC Driver - Error 1338

The table I am trying to load the records into has a Primary Index and the records I am trying to load don't have dupes.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Teradata - JDBC Driver - Error 1338

Board footer

Powered by FluxBB