topic Re: teradata fastload error in Talend Studio

teradata fastload error

Anonymous — Sat, 16 Nov 2024 13:45:52 GMT

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.

Re: teradata fastload error

Anonymous — Thu, 01 Oct 2009 15:04:04 GMT

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;

Re: teradata fastload error

_AnonymousUser — Tue, 05 Jan 2010 14:47:34 GMT

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

Re: teradata fastload error

Anonymous — Tue, 05 Jan 2010 15:48:03 GMT

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;