tCreateTable Error ...Table not created using Teradata as DB

Abdus_Saboor — Sat, 16 Nov 2024 12:38:34 GMT

while creating table whose schema is defined in file ...give error while run job..below DB is database and MD is metadata
Starting job STG_ at 12:19 05/10/2011.
connecting to socket on port 4066
connected
Exception in component tCreateTable_2
java.lang.RuntimeException: Creating table failed
at mercury.stg__0_2.STG_.tCreateTable_2Process(STG_.java:498)
at mercury.stg__0_2.STG_.runJobInTOS(STG_.java:1533)
at mercury.stg__0_2.STG_.main(STG_.java:1347)
Caused by: com.teradata.jdbc.jdbc_4.util.JDBCException: Object 'DB.MD' does not exist.
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.executeStatement(Statement.java:281)
at com.teradata.jdbc.jdbc_4.Statement.execute(Statement.java:254)
at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalStatement.execute(TeraLocalStatement.java:365)
at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalStatement.execute(TeraLocalStatement.java:329)
at mercury.stg__0_2.STG_.tCreateTable_2Process(STG_.java:475)
... 2 more
disconnected
Job STG_ ended at 12:19 05/10/2011.
.....
urgent response require

Re: tCreateTable Error ...Table not created using Teradata as DB

Abdus_Saboor — Wed, 05 Oct 2011 09:25:06 GMT

The problem is caused by table name already exist in other database with same name ,also tCreateTable Component option ->Drop table if exists and Create .... so used option Create table ....
why we not use same table name which is present in other database with more-less same structure? on which drop if exists and create not work,why is so?
is it TOS Bug ?

topic tCreateTable Error ...Table not created using Teradata as DB in Talend Studio

tCreateTable Error ...Table not created using Teradata as DB

Re: tCreateTable Error ...Table not created using Teradata as DB