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