You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » tCreateTable Error ...Table not created using Teradata as DB
Post a reply
Topic review (newest first)
- asa436
- 2011-10-05 10:25:06
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 ?
- asa436
- 2011-10-05 09:29:45
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.
[statistics] connecting to socket on port 4066
[statistics] 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: [Teradata Database] [TeraJDBC 13.00.00.16] [Error 3807] [SQLState 42S02] 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
[statistics] disconnected
Job STG_ ended at 12:19 05/10/2011. [exit code=1]
.....
urgent response require