Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Aug 1st, 2012  |  syntax: None  |  size: 12.35 KB  |  hits: 22  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Oracle table creation issue
  2. | Error 2012-04-20 18:30:24,746 [pool-6-thread-1] ERROR interceptor.CommandContext  - Error while closing command context
  3. Message:
  4. ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  5.  
  6. ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline
  7. ### The error occurred while setting parameters
  8. ### Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  9.  
  10.     Line | Method
  11. ->>    8 | wrapException                             in org.apache.ibatis.exceptions.ExceptionFactory
  12. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  13. |     77 | selectList                                in org.apache.ibatis.session.defaults.DefaultSqlSession
  14. |     69 | selectList . . . . . . . . . . . . . . .  in     ''
  15. |     40 | selectOne                                 in     ''
  16. |    217 | selectById . . . . . . . . . . . . . . .  in org.activiti.engine.impl.db.DbSqlSession
  17. |    629 | dbSchemaUpdate                            in     ''
  18. |    885 | performSchemaOperationsProcessEngineBuild in     ''
  19. |     25 | execute                                   in org.activiti.engine.impl.SchemaOperationsProcessEngineBuild
  20. |     24 | execute . . . . . . . . . . . . . . . . . in org.activiti.engine.impl.interceptor.CommandExecutorImpl
  21. |     42 | execute                                   in org.activiti.engine.impl.interceptor.CommandContextInterceptor
  22. |     40 | execute . . . . . . . . . . . . . . . . . in org.activiti.spring.SpringTransactionInterceptor
  23. |     33 | execute                                   in org.activiti.engine.impl.interceptor.LogInterceptor
  24. |     77 | <init> . . . . . . . . . . . . . . . . .  in org.activiti.engine.impl.ProcessEngineImpl
  25. |    271 | buildProcessEngine                        in org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl
  26. |     60 | buildProcessEngine . . . . . . . . . . .  in org.activiti.spring.SpringProcessEngineConfiguration
  27. |     56 | getObject                                 in org.activiti.spring.ProcessEngineFactoryBean
  28. |     32 | getObject . . . . . . . . . . . . . . . . in     ''
  29. |    334 | innerRun                                  in java.util.concurrent.FutureTask$Sync
  30. |    166 | run . . . . . . . . . . . . . . . . . . . in java.util.concurrent.FutureTask
  31. |   1110 | runWorker                                 in java.util.concurrent.ThreadPoolExecutor
  32. |    603 | run . . . . . . . . . . . . . . . . . . . in java.util.concurrent.ThreadPoolExecutor$Worker
  33. ^    722 | run                                       in java.lang.Thread
  34.  
  35. Caused by SQLSyntaxErrorException: ORA-00942: table or view does not exist
  36.  
  37. ->>   91 | newSQLException                           in oracle.jdbc.driver.SQLStateMapping
  38. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  39. |    112 | newSQLException                           in oracle.jdbc.driver.DatabaseError
  40. |    173 | throwSqlException . . . . . . . . . . . . in     ''
  41. |    455 | processError                              in oracle.jdbc.driver.T4CTTIoer
  42. |    413 | processError . . . . . . . . . . . . . .  in     ''
  43. |   1030 | receive                                   in oracle.jdbc.driver.T4C8Oall
  44. |    194 | doOall8 . . . . . . . . . . . . . . . . . in oracle.jdbc.driver.T4CPreparedStatement
  45. |    785 | executeForDescribe                        in     ''
  46. |    860 | executeMaybeDescribe . . . . . . . . . .  in     ''
  47. |   1186 | doExecuteWithTimeout                      in oracle.jdbc.driver.OracleStatement
  48. |   3381 | executeInternal . . . . . . . . . . . . . in oracle.jdbc.driver.OraclePreparedStatement
  49. |   3482 | execute                                   in     ''
  50. |   1373 | execute . . . . . . . . . . . . . . . . . in oracle.jdbc.driver.OraclePreparedStatementWrapper
  51. |    172 | execute                                   in org.apache.commons.dbcp.DelegatingPreparedStatement
  52. |     39 | query . . . . . . . . . . . . . . . . . . in org.apache.ibatis.executor.statement.PreparedStatementHandler
  53. |     55 | query                                     in org.apache.ibatis.executor.statement.RoutingStatementHandler
  54. |     41 | doQuery . . . . . . . . . . . . . . . . . in org.apache.ibatis.executor.SimpleExecutor
  55. |    216 | queryFromDatabase                         in org.apache.ibatis.executor.BaseExecutor
  56. |     95 | query . . . . . . . . . . . . . . . . . . in     ''
  57. |     72 | query                                     in org.apache.ibatis.executor.CachingExecutor
  58. |     75 | selectList . . . . . . . . . . . . . . .  in org.apache.ibatis.session.defaults.DefaultSqlSession
  59. |     69 | selectList                                in     ''
  60. |     40 | selectOne . . . . . . . . . . . . . . . . in     ''
  61. |    217 | selectById                                in org.activiti.engine.impl.db.DbSqlSession
  62. |    629 | dbSchemaUpdate . . . . . . . . . . . . .  in     ''
  63. |    885 | performSchemaOperationsProcessEngineBuild in     ''
  64. |     25 | execute . . . . . . . . . . . . . . . . . in org.activiti.engine.impl.SchemaOperationsProcessEngineBuild
  65. |     24 | execute                                   in org.activiti.engine.impl.interceptor.CommandExecutorImpl
  66. |     42 | execute . . . . . . . . . . . . . . . . . in org.activiti.engine.impl.interceptor.CommandContextInterceptor
  67. |     40 | execute                                   in org.activiti.spring.SpringTransactionInterceptor
  68. |     33 | execute . . . . . . . . . . . . . . . . . in org.activiti.engine.impl.interceptor.LogInterceptor
  69. |     77 | <init>                                    in org.activiti.engine.impl.ProcessEngineImpl
  70. |    271 | buildProcessEngine . . . . . . . . . . .  in org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl
  71. |     60 | buildProcessEngine                        in org.activiti.spring.SpringProcessEngineConfiguration
  72. |     56 | getObject . . . . . . . . . . . . . . . . in org.activiti.spring.ProcessEngineFactoryBean
  73. |     32 | getObject                                 in     ''
  74. |    334 | innerRun . . . . . . . . . . . . . . . .  in java.util.concurrent.FutureTask$Sync
  75. |    166 | run                                       in java.util.concurrent.FutureTask
  76. |   1110 | runWorker . . . . . . . . . . . . . . . . in java.util.concurrent.ThreadPoolExecutor
  77. |    603 | run                                       in java.util.concurrent.ThreadPoolExecutor$Worker
  78. ^    722 | run . . . . . . . . . . . . . . . . . . . in java.lang.Thread
  79. | 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:
  80. ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  81.  
  82. ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline
  83. ### The error occurred while setting parameters
  84. ### Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  85.  
  86. Message: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException:
  87. ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  88.  
  89. ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline
  90. ### The error occurred while setting parameters
  91. ### Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  92.  
  93.     Line | Method
  94. ->>  334 | innerRun  in java.util.concurrent.FutureTask$Sync
  95. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  96. |    166 | run       in java.util.concurrent.FutureTask
  97. |   1110 | runWorker in java.util.concurrent.ThreadPoolExecutor
  98. |    603 | run       in java.util.concurrent.ThreadPoolExecutor$Worker
  99. ^    722 | run . . . in java.lang.Thread
  100.  
  101. Caused by PersistenceException:
  102. ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  103.  
  104. ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline
  105. ### The error occurred while setting parameters
  106. ### Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  107.  
  108. ->>    8 | wrapException in org.apache.ibatis.exceptions.ExceptionFactory
  109. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  110. |     77 | selectList in org.apache.ibatis.session.defaults.DefaultSqlSession
  111. |     69 | selectList in     ''
  112. |     40 | selectOne in     ''
  113. |    217 | selectById in org.activiti.engine.impl.db.DbSqlSession
  114. |    629 | dbSchemaUpdate in     ''
  115. |    885 | performSchemaOperationsProcessEngineBuild in     ''
  116. |     25 | execute   in org.activiti.engine.impl.SchemaOperationsProcessEngineBuild
  117. |     24 | execute . in org.activiti.engine.impl.interceptor.CommandExecutorImpl
  118. |     42 | execute   in org.activiti.engine.impl.interceptor.CommandContextInterceptor
  119. |     40 | execute . in org.activiti.spring.SpringTransactionInterceptor
  120. |     33 | execute   in org.activiti.engine.impl.interceptor.LogInterceptor
  121. |     77 | <init> .  in org.activiti.engine.impl.ProcessEngineImpl
  122. |    271 | buildProcessEngine in org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl
  123. |     60 | buildProcessEngine in org.activiti.spring.SpringProcessEngineConfiguration
  124. |     56 | getObject in org.activiti.spring.ProcessEngineFactoryBean
  125. |     32 | getObject in     ''
  126. |    334 | innerRun  in java.util.concurrent.FutureTask$Sync
  127. |    166 | run . . . in java.util.concurrent.FutureTask
  128. |   1110 | runWorker in java.util.concurrent.ThreadPoolExecutor
  129. |    603 | run . . . in java.util.concurrent.ThreadPoolExecutor$Worker
  130. ^    722 | run       in java.lang.Thread
  131.  
  132. Caused by SQLSyntaxErrorException: ORA-00942: table or view does not exist
  133.  
  134. ->>   91 | newSQLException in oracle.jdbc.driver.SQLStateMapping
  135. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  136. |    112 | newSQLException in oracle.jdbc.driver.DatabaseError
  137. |    173 | throwSqlException in     ''
  138. |    455 | processError in oracle.jdbc.driver.T4CTTIoer
  139. |    413 | processError in     ''
  140. |   1030 | receive   in oracle.jdbc.driver.T4C8Oall
  141. |    194 | doOall8 . in oracle.jdbc.driver.T4CPreparedStatement
  142. |    785 | executeForDescribe in     ''
  143. |    860 | executeMaybeDescribe in     ''
  144. |   1186 | doExecuteWithTimeout in oracle.jdbc.driver.OracleStatement
  145. |   3381 | executeInternal in oracle.jdbc.driver.OraclePreparedStatement
  146. |   3482 | execute   in     ''
  147. |   1373 | execute . in oracle.jdbc.driver.OraclePreparedStatementWrapper
  148. |    172 | execute   in org.apache.commons.dbcp.DelegatingPreparedStatement
  149. |     39 | query . . in org.apache.ibatis.executor.statement.PreparedStatementHandler
  150. |     55 | query     in org.apache.ibatis.executor.statement.RoutingStatementHandler
  151. |     41 | doQuery . in org.apache.ibatis.executor.SimpleExecutor
  152. |    216 | queryFromDatabase in org.apache.ibatis.executor.BaseExecutor
  153. |     95 | query . . in     ''
  154. |     72 | query     in org.apache.ibatis.executor.CachingExecutor
  155. |     75 | selectList in org.apache.ibatis.session.defaults.DefaultSqlSession
  156. |     69 | selectList in     ''
  157. |     40 | selectOne in     ''
  158. |    217 | selectById in org.activiti.engine.impl.db.DbSqlSession
  159. |    629 | dbSchemaUpdate in     ''
  160. |    885 | performSchemaOperationsProcessEngineBuild in     ''
  161. |     25 | execute . in org.activiti.engine.impl.SchemaOperationsProcessEngineBuild
  162. |     24 | execute   in org.activiti.engine.impl.interceptor.CommandExecutorImpl
  163. |     42 | execute . in org.activiti.engine.impl.interceptor.CommandContextInterceptor
  164. |     40 | execute   in org.activiti.spring.SpringTransactionInterceptor
  165. |     33 | execute . in org.activiti.engine.impl.interceptor.LogInterceptor
  166. |     77 | <init>    in org.activiti.engine.impl.ProcessEngineImpl
  167. |    271 | buildProcessEngine in org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl
  168. |     60 | buildProcessEngine in org.activiti.spring.SpringProcessEngineConfiguration
  169. |     56 | getObject in org.activiti.spring.ProcessEngineFactoryBean
  170. |     32 | getObject in     ''
  171. |    334 | innerRun  in java.util.concurrent.FutureTask$Sync
  172. |    166 | run       in java.util.concurrent.FutureTask
  173. |   1110 | runWorker in java.util.concurrent.ThreadPoolExecutor
  174. |    603 | run       in java.util.concurrent.ThreadPoolExecutor$Worker
  175. ^    722 | run . . . in java.lang.Thread
create a new version of this paste RAW Paste Data