topic Re: Simple Teradata Load does not work in Talend Studio

Simple Teradata Load does not work

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

I am trying to load a simple excel file to teradata and it will not work. I have defined the database where to create the object in the t_teradataoutput. I specifically state that it should create the object test but for some reason it does not.
The job stream is
create schema for excel file
connect to t_teradata_input
create table test
insert into table
close job.
Starting job einstein at 13:52 25/09/2009.
connecting to socket on port 4084
connected
Exception in component tTeradataOutput_1
com.ncr.teradata.jdbc_4.util.JDBCException: : Object 'test' does not exist.
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.execute(Statement.java:199)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalStatement.execute(TeraLocalStatement.java:392)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalStatement.execute(TeraLocalStatement.java:356)
at einsteinload.einstein_0_1.einstein.tFileInputExcel_1Process(einstein.java:602)
at einsteinload.einstein_0_1.einstein.runJobInTOS(einstein.java:1151)
at einsteinload.einstein_0_1.einstein.main(einstein.java:1060)
disconnected
Job einstein ended at 13:52 25/09/2009.
I also get this message because it is trying to load the data to my user spool space even though I specify the database on teradata where the data should be loaded.
Starting job einstein at 17:11 25/09/2009.
connecting to socket on port 3905
connected
connecting to socket on port 4382
connected
Exception in component tTeradataOutput_1
com.ncr.teradata.jdbc_4.util.JDBCException: : No more room in database youngs.
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.execute(Statement.java:199)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalStatement.execute(TeraLocalStatement.java:392)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalStatement.execute(TeraLocalStatement.java:356)
at einsteinload.einstein_0_1.einstein.tFileInputExcel_1Process(einstein.java:621)
at einsteinload.einstein_0_1.einstein.tTeradataConnection_1Process(einstein.java:258)
at einsteinload.einstein_0_1.einstein.runJobInTOS(einstein.java:1214)
disconnected
disconnected
at einsteinload.einstein_0_1.einstein.main(einstein.java:1116)
Job einstein ended at 17:11 25/09/2009.

Re: Simple Teradata Load does not work

Anonymous — Wed, 30 Sep 2009 00:00:28 GMT

is it possible to buy support for this problem? How do we get in touch with Talend Support?

Re: Simple Teradata Load does not work

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

Hi Sheridany;
Let's try this expression instead of "test" in the TABLE field.
"DUISG2\".\"test"
Best regards;

Re: Simple Teradata Load does not work

_AnonymousUser — Thu, 08 Sep 2011 15:01:19 GMT

I tried what you suggested and got this error message. using terdata v13
i used "test\".\"TESTBUILD"
Exception in component tTeradataOutput_1
com.teradata.jdbc.jdbc_4.util.JDBCException: Syntax error, expected something like '(' between the word 'test' and '.'.
at

Re: Simple Teradata Load does not work

_AnonymousUser — Thu, 08 Sep 2011 16:21:06 GMT

I am trying to create a table in Teradata from a data source. I have selected to drop if exists and create. This is using teradata v13. this is the error message.
Exception in component tTeradataOutput_1
com.teradata.jdbc.jdbc_4.util.JDBCException: Only an ET or null statement is legal after a DDL Statement.
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:317)
at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:104)
at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:286)
at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:177)
at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:111)
at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:102)
at com.teradata.jdbc.jdbc_4.Statement.executeStatement(Statement.java:339)
at com.teradata.jdbc.jdbc_4.Statement.prepareRequest(Statement.java:506)
at com.teradata.jdbc.jdbc_4.PreparedStatement.<init>(PreparedStatement.java:65)
disconnected
disconnected
at com.teradata.jdbc.jdbc_4.TDSession.createPreparedStatement(TDSession.java:694)
at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalPreparedStatement.<init>(TeraLocalPreparedStatement.java:88)
at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.prepareStatement(TeraLocalConnection.java:331)
at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.prepareStatement(TeraLocalConnection.java:150)
at testingtalend.test_0_1.test.tMSSqlInput_3Process(test.java:638)
at testingtalend.test_0_1.test.runJobInTOS(test.java:1439)
at testingtalend.test_0_1.test.main(test.java:1300)

Re: Simple Teradata Load does not work

_AnonymousUser — Fri, 30 Sep 2011 16:00:15 GMT

I got the answer. Need to set Commit in the advanced setting to 0