One Star

teradata fastload error

I am getting this message when I try to load a csv file into teradata with the fastload component. I have looked at everything but cannot trace the issue.
Starting job einstein at 11:21 17/09/2009.
connecting to socket on port 4026
connected
Exception in component tTeradataFastLoad_1
com.ncr.teradata.jdbc_4.util.JDBCException: : Name is longer than 30 characters.
at com.ncr.teradata.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:92)
at com.ncr.teradata.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:270)
at com.ncr.teradata.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:161)
at com.ncr.teradata.jdbc_4.statemachine.StatementController.runBody(StatementController.java:100)
at com.ncr.teradata.jdbc_4.statemachine.StatementController.run(StatementController.java:91)
at com.ncr.teradata.jdbc_4.Statement.executeStatement(Statement.java:287)
at com.ncr.teradata.jdbc_4.Statement.prepareRequest(Statement.java:441)
at com.ncr.teradata.jdbc_4.PreparedStatement.<init>(PreparedStatement.java:51)
at com.ncr.teradata.jdbc_4.TDSession.createPreparedStatement(TDSession.java:353)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalPreparedStatement.<init>(TeraLocalPreparedStatement.java:86)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.prepareStatement(TeraLocalConnection.java:323)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.prepareStatement(TeraLocalConnection.java:145)
at com.ncr.teradata.jdbc.fastload.FastLoadManagerConnection.prepareStatement(FastLoadManagerConnection.java:734)
at einsteinload.einstein_0_1.einstein.tFileInputDelimited_1Process(einstein.java:481)
at einsteinload.einstein_0_1.einstein.runJobInTOS(einstein.java:1004)
at einsteinload.einstein_0_1.einstein.main(einstein.java:913)
disconnected
Job einstein ended at 11:21 17/09/2009.
3 REPLIES
Employee

Re: teradata fastload error

Sheridany
What about using the component tTeradataFastLoadUtility.
The tTeradataFastLoad is just using some performance issue integrated to the JDBC driver instead of the tTeradataFastLoadUtility using the pure Teradata binary to bulk load data efficiently.
Best regards;
One Star

Re: teradata fastload error

Hi ,
Tablename are limited to 30 chars and jdbc fastload needs to create its two temp table when you use the bacth size options.
These table will be automaticly named tablename + _ERR1 and _ERR2 thus in this case your table must be less than 25 characters to work .
regards
Employee

Re: teradata fastload error

Hi,
Why don't use the tTeradataFastLoadUtility component instead of the tTeradataFastLoad(using the BatchSize) ?
The tTeradataFastLoadUtility is more efficient than the tTeradataFastLoad. The tTeradataFastLoadUtility executes the script generated by Talend via your Teradata utilities ?
Best regards;