[SchemaUpdate] could not complete schema update

[Anbarasan Gangadaran]

There may be some cases when you deploy the model for the first time in a server, and try to save a new record in the model.  IE will show unknown error while saving in the status bar...  and in hibernate sequences will get updated with the model and next increment information...  But no record will be created.   and the proper error message which states that table creation failed will occur only once (only on the first attempt).  Any subsequent attempts to save a record will yield you an error in the server log stating that the table does not exist......  and the table creation failed error message will not appear.  There may be many reasons.  of which two are know.....

Either dimension may generate a create table query which is wrong or the user with which dimension's database is running does not have the required permissions to create a table.  The following log was obtained for the later case, with MYSQL database. 
------------------------------------------------------------------------------------------------------------
14:19:10,703 INFO  [save] invoking the save command
14:19:10,843 INFO  [CsWebHCEComponent] in the component session initialising the dmsjava/statefuldms:fhojj1oe-p
14:19:11,171 WARN  [JDBCExceptionReporter] SQL Error: 1, SQLState: HY000
14:19:11,171 ERROR [JDBCExceptionReporter] Can't create/write to file 'C:\WINNT\TEMP\#sql_4ac_0.MYD' (Errcode: 17)
14:19:11,187 ERROR [SchemaUpdate] could not complete schema update
org.hibernate.exception.GenericJDBCException: could not get table metadata: hibernate_sequences
    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
---------------------------------------------------------------------------------------------------------------

Thanks to adhi and siva who helped out in solving the problem....