emilan
Reputation: 13075
Oracle table creation issue
I use activity plugin in my grails application. When I try to run my application I getting this error. Tables are not created. I don't understand why.
| Error 2012-04-20 18:30:24,746 [pool-6-thread-1] ERROR interceptor.CommandContext - Error while closing command context
Message:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Line | Method
->> 8 | wrapException in org.apache.ibatis.exceptions.ExceptionFactory
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
| 77 | selectList in org.apache.ibatis.session.defaults.DefaultSqlSession
| 69 | selectList . . . . . . . . . . . . . . . in ''
| 40 | selectOne in ''
| 217 | selectById . . . . . . . . . . . . . . . in org.activiti.engine.impl.db.DbSqlSession
| 629 | dbSchemaUpdate in ''
| 885 | performSchemaOperationsProcessEngineBuild in ''
| 25 | execute in org.activiti.engine.impl.SchemaOperationsProcessEngineBuild
| 24 | execute . . . . . . . . . . . . . . . . . in org.activiti.engine.impl.interceptor.CommandExecutorImpl
| 42 | execute in org.activiti.engine.impl.interceptor.CommandContextInterceptor
| 40 | execute . . . . . . . . . . . . . . . . . in org.activiti.spring.SpringTransactionInterceptor
| 33 | execute in org.activiti.engine.impl.interceptor.LogInterceptor
| 77 | <init> . . . . . . . . . . . . . . . . . in org.activiti.engine.impl.ProcessEngineImpl
| 271 | buildProcessEngine in org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl
| 60 | buildProcessEngine . . . . . . . . . . . in org.activiti.spring.SpringProcessEngineConfiguration
| 56 | getObject in org.activiti.spring.ProcessEngineFactoryBean
| 32 | getObject . . . . . . . . . . . . . . . . in ''
| 334 | innerRun in java.util.concurrent.FutureTask$Sync
| 166 | run . . . . . . . . . . . . . . . . . . . in java.util.concurrent.FutureTask
| 1110 | runWorker in java.util.concurrent.ThreadPoolExecutor
| 603 | run . . . . . . . . . . . . . . . . . . . in java.util.concurrent.ThreadPoolExecutor$Worker
^ 722 | run in java.lang.Thread
Caused by SQLSyntaxErrorException: ORA-00942: table or view does not exist
->> 91 | newSQLException in oracle.jdbc.driver.SQLStateMapping
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
| 112 | newSQLException in oracle.jdbc.driver.DatabaseError
| 173 | throwSqlException . . . . . . . . . . . . in ''
| 455 | processError in oracle.jdbc.driver.T4CTTIoer
| 413 | processError . . . . . . . . . . . . . . in ''
| 1030 | receive in oracle.jdbc.driver.T4C8Oall
| 194 | doOall8 . . . . . . . . . . . . . . . . . in oracle.jdbc.driver.T4CPreparedStatement
| 785 | executeForDescribe in ''
| 860 | executeMaybeDescribe . . . . . . . . . . in ''
| 1186 | doExecuteWithTimeout in oracle.jdbc.driver.OracleStatement
| 3381 | executeInternal . . . . . . . . . . . . . in oracle.jdbc.driver.OraclePreparedStatement
| 3482 | execute in ''
| 1373 | execute . . . . . . . . . . . . . . . . . in oracle.jdbc.driver.OraclePreparedStatementWrapper
| 172 | execute in org.apache.commons.dbcp.DelegatingPreparedStatement
| 39 | query . . . . . . . . . . . . . . . . . . in org.apache.ibatis.executor.statement.PreparedStatementHandler
| 55 | query in org.apache.ibatis.executor.statement.RoutingStatementHandler
| 41 | doQuery . . . . . . . . . . . . . . . . . in org.apache.ibatis.executor.SimpleExecutor
| 216 | queryFromDatabase in org.apache.ibatis.executor.BaseExecutor
| 95 | query . . . . . . . . . . . . . . . . . . in ''
| 72 | query in org.apache.ibatis.executor.CachingExecutor
| 75 | selectList . . . . . . . . . . . . . . . in org.apache.ibatis.session.defaults.DefaultSqlSession
| 69 | selectList in ''
| 40 | selectOne . . . . . . . . . . . . . . . . in ''
| 217 | selectById in org.activiti.engine.impl.db.DbSqlSession
| 629 | dbSchemaUpdate . . . . . . . . . . . . . in ''
| 885 | performSchemaOperationsProcessEngineBuild in ''
| 25 | execute . . . . . . . . . . . . . . . . . in org.activiti.engine.impl.SchemaOperationsProcessEngineBuild
| 24 | execute in org.activiti.engine.impl.interceptor.CommandExecutorImpl
| 42 | execute . . . . . . . . . . . . . . . . . in org.activiti.engine.impl.interceptor.CommandContextInterceptor
| 40 | execute in org.activiti.spring.SpringTransactionInterceptor
| 33 | execute . . . . . . . . . . . . . . . . . in org.activiti.engine.impl.interceptor.LogInterceptor
| 77 | <init> in org.activiti.engine.impl.ProcessEngineImpl
| 271 | buildProcessEngine . . . . . . . . . . . in org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl
| 60 | buildProcessEngine in org.activiti.spring.SpringProcessEngineConfiguration
| 56 | getObject . . . . . . . . . . . . . . . . in org.activiti.spring.ProcessEngineFactoryBean
| 32 | getObject in ''
| 334 | innerRun . . . . . . . . . . . . . . . . in java.util.concurrent.FutureTask$Sync
| 166 | run in java.util.concurrent.FutureTask
| 1110 | runWorker . . . . . . . . . . . . . . . . in java.util.concurrent.ThreadPoolExecutor
| 603 | run in java.util.concurrent.ThreadPoolExecutor$Worker
^ 722 | run . . . . . . . . . . . . . . . . . . . in java.lang.Thread
| Error 2012-04-20 18:30:24,927 [pool-6-thread-1] ERROR context.GrailsContextLoader - Error executing bootstraps: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Message: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Line | Method
->> 334 | innerRun in java.util.concurrent.FutureTask$Sync
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
| 166 | run in java.util.concurrent.FutureTask
| 1110 | runWorker in java.util.concurrent.ThreadPoolExecutor
| 603 | run in java.util.concurrent.ThreadPoolExecutor$Worker
^ 722 | run . . . in java.lang.Thread
Caused by PersistenceException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
->> 8 | wrapException in org.apache.ibatis.exceptions.ExceptionFactory
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
| 77 | selectList in org.apache.ibatis.session.defaults.DefaultSqlSession
| 69 | selectList in ''
| 40 | selectOne in ''
| 217 | selectById in org.activiti.engine.impl.db.DbSqlSession
| 629 | dbSchemaUpdate in ''
| 885 | performSchemaOperationsProcessEngineBuild in ''
| 25 | execute in org.activiti.engine.impl.SchemaOperationsProcessEngineBuild
| 24 | execute . in org.activiti.engine.impl.interceptor.CommandExecutorImpl
| 42 | execute in org.activiti.engine.impl.interceptor.CommandContextInterceptor
| 40 | execute . in org.activiti.spring.SpringTransactionInterceptor
| 33 | execute in org.activiti.engine.impl.interceptor.LogInterceptor
| 77 | <init> . in org.activiti.engine.impl.ProcessEngineImpl
| 271 | buildProcessEngine in org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl
| 60 | buildProcessEngine in org.activiti.spring.SpringProcessEngineConfiguration
| 56 | getObject in org.activiti.spring.ProcessEngineFactoryBean
| 32 | getObject in ''
| 334 | innerRun in java.util.concurrent.FutureTask$Sync
| 166 | run . . . in java.util.concurrent.FutureTask
| 1110 | runWorker in java.util.concurrent.ThreadPoolExecutor
| 603 | run . . . in java.util.concurrent.ThreadPoolExecutor$Worker
^ 722 | run in java.lang.Thread
Caused by SQLSyntaxErrorException: ORA-00942: table or view does not exist
->> 91 | newSQLException in oracle.jdbc.driver.SQLStateMapping
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
| 112 | newSQLException in oracle.jdbc.driver.DatabaseError
| 173 | throwSqlException in ''
| 455 | processError in oracle.jdbc.driver.T4CTTIoer
| 413 | processError in ''
| 1030 | receive in oracle.jdbc.driver.T4C8Oall
| 194 | doOall8 . in oracle.jdbc.driver.T4CPreparedStatement
| 785 | executeForDescribe in ''
| 860 | executeMaybeDescribe in ''
| 1186 | doExecuteWithTimeout in oracle.jdbc.driver.OracleStatement
| 3381 | executeInternal in oracle.jdbc.driver.OraclePreparedStatement
| 3482 | execute in ''
| 1373 | execute . in oracle.jdbc.driver.OraclePreparedStatementWrapper
| 172 | execute in org.apache.commons.dbcp.DelegatingPreparedStatement
| 39 | query . . in org.apache.ibatis.executor.statement.PreparedStatementHandler
| 55 | query in org.apache.ibatis.executor.statement.RoutingStatementHandler
| 41 | doQuery . in org.apache.ibatis.executor.SimpleExecutor
| 216 | queryFromDatabase in org.apache.ibatis.executor.BaseExecutor
| 95 | query . . in ''
| 72 | query in org.apache.ibatis.executor.CachingExecutor
| 75 | selectList in org.apache.ibatis.session.defaults.DefaultSqlSession
| 69 | selectList in ''
| 40 | selectOne in ''
| 217 | selectById in org.activiti.engine.impl.db.DbSqlSession
| 629 | dbSchemaUpdate in ''
| 885 | performSchemaOperationsProcessEngineBuild in ''
| 25 | execute . in org.activiti.engine.impl.SchemaOperationsProcessEngineBuild
| 24 | execute in org.activiti.engine.impl.interceptor.CommandExecutorImpl
| 42 | execute . in org.activiti.engine.impl.interceptor.CommandContextInterceptor
| 40 | execute in org.activiti.spring.SpringTransactionInterceptor
| 33 | execute . in org.activiti.engine.impl.interceptor.LogInterceptor
| 77 | <init> in org.activiti.engine.impl.ProcessEngineImpl
| 271 | buildProcessEngine in org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl
| 60 | buildProcessEngine in org.activiti.spring.SpringProcessEngineConfiguration
| 56 | getObject in org.activiti.spring.ProcessEngineFactoryBean
| 32 | getObject in ''
| 334 | innerRun in java.util.concurrent.FutureTask$Sync
| 166 | run in java.util.concurrent.FutureTask
| 1110 | runWorker in java.util.concurrent.ThreadPoolExecutor
| 603 | run in java.util.concurrent.ThreadPoolExecutor$Worker
^ 722 | run . . . in java.lang.Thread
Upvotes: 2
Views: 2148
Answers (2)
sf_jeff
Reputation: 384
I just ran into the same symptoms in my Grails project.
I caused the error by adding a new date variable and a default value in a format that didn't exist.
A date format that worked for me after the object-oriented version failed was:
static mapping = {
myVar defaultValue: "'01-JAN-1970'"
}
You probably have a different error, but the point is that the create table statement fails, probably due to some aspect of database interaction that is a little bit "off the beaten path" and recently added.
To troubleshoot, I would take the following steps:
1) Validate that you are running with the DataSource.groovy configuration that you think you are (eg. change your password and ensure that you fail to log in) and that your dbCreate variable is set to "create" or "create-drop" as appropriate. If there is a good reason to use update or validate, then either create the same object in a different env and move or just create the table appropriately. If you aren't sure, use create-drop in the very beginning of a new project to play with the tools, and then never again.
2) When you have verified that grails should be creating the table as above, then turn on logging to see what is actually happening during restart. To do so, add "logSql = true" and "formatSql" = true to your datasource config at the same level as the username and password. You should see the flawed create statement in your standard out.
3) If you can't see what is wrong immediately, then run the statement directly in sqlplus to isolate the offending cause. This likely will point to recent changes.
Upvotes: 0
DCookie
Reputation: 43533
3 possibilities come to mind for this error message:
- The table/view being referenced actually does not exist.
- The table/view being referenced does exist, but you don't have permissions to SELECT from it.
- The table/view exists, you have permissions to SELECT from it, but the table/view is in a different schema and is not referenced with a qualified name (e.g., SCHEMA.TABLE_NAME) or is not aliased via a synonym.
Fixes for the issue should be fairly obvious:
- Create the table/view
- Get permissions to the table/view via the GRANT command
- Create a synonym or fully qualify the table/view name in your SELECT statement
Upvotes: 3
Related Questions
- Grails: cant create tables on mysql
- Exception in connecting grails app with Oracle db
- Grails with Postgresql : can't create table in appropriate schema
- grails h2 database create table
- Table not being created in Grails 3
- New Grails domain class is not creating a table in the database
- Grails dbCreate='validate' fails to recognize existing table
- Grails or Hibernate not creating missing table
- Unsuccessful creation of table in Oracle
- Table creation fails