tCreateTable Error ...Table not created using Teradata as DB
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
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 ?
