java.sql.SQLException: ORA-00942: table or view does not exist

Atlassian JIRA | Stephan Janssen | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    When pressing next after Setup Admin - step 6 following expeption is thrown: Cause: org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [null] in task 'HibernateAccessor'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist Stack Trace: [hide] org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [null] in task 'HibernateAccessor'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:877) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2513) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2857) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536) at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:80) at bucket.util.ResettableIncrementGenerator.getNext(ResettableIncrementGenerator.java:73) at bucket.util.ResettableIncrementGenerator.generate(ResettableIncrementGenerator.java:39) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:747) at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:720) at net.sf.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:1359) at org.springframework.orm.hibernate.HibernateTemplate$10.doInHibernate(HibernateTemplate.java:259) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:150) at org.springframework.orm.hibernate.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:257) at bucket.core.persistence.hibernate.HibernateObjectDao.saveRaw(HibernateObjectDao.java:151) at bucket.core.persistence.hibernate.HibernateObjectDao.save(HibernateObjectDao.java:121) at com.atlassian.confluence.security.DefaultSpacePermissionManager.savePermission(DefaultSpacePermissionManager.java:70) at com.atlassian.confluence.security.CachingSpacePermissionManager.savePermission(CachingSpacePermissionManager.java:17) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:118) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:191) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148) at $Proxy76.savePermission(Unknown Source) at com.atlassian.confluence.setup.actions.SetupAdministrator.createDefaultGroupsAndPermissions(SetupAdministrator.java:48) at com.atlassian.confluence.setup.actions.SetupAdministrator.execute(SetupAdministrator.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:166) at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:73) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:88) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:971) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:402) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:146) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6356) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3635) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2585) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170) Referer URL: Unknown Build Information: Uptime: 8 minutes, 26 seconds Version: 1.1 Build Number: 53 Server Information: Application Server: WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.Oracle9Dialect Memory Information: Total Memory: 510 MB Free Memory: 355 MB Used Memory: 155 MB System Information: System Date: Thursday, 10 Jun 2004 System Time: 02:20:16 System Favourite Colour: Almond Java Version: 1.4.1_05 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.1_05-b01 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: root User Timezone: MET Operating System: SunOS 5.9 OS Architecture: sparc Request Logging: 0 log statements generated by this request:

    Atlassian JIRA | 1 decade ago | Stephan Janssen
    java.sql.SQLException: ORA-00942: table or view does not exist
  2. 0

    When pressing next after Setup Admin - step 6 following expeption is thrown: Cause: org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [null] in task 'HibernateAccessor'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist Stack Trace: [hide] org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [null] in task 'HibernateAccessor'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:877) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2513) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2857) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536) at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:80) at bucket.util.ResettableIncrementGenerator.getNext(ResettableIncrementGenerator.java:73) at bucket.util.ResettableIncrementGenerator.generate(ResettableIncrementGenerator.java:39) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:747) at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:720) at net.sf.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:1359) at org.springframework.orm.hibernate.HibernateTemplate$10.doInHibernate(HibernateTemplate.java:259) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:150) at org.springframework.orm.hibernate.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:257) at bucket.core.persistence.hibernate.HibernateObjectDao.saveRaw(HibernateObjectDao.java:151) at bucket.core.persistence.hibernate.HibernateObjectDao.save(HibernateObjectDao.java:121) at com.atlassian.confluence.security.DefaultSpacePermissionManager.savePermission(DefaultSpacePermissionManager.java:70) at com.atlassian.confluence.security.CachingSpacePermissionManager.savePermission(CachingSpacePermissionManager.java:17) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:118) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:191) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148) at $Proxy76.savePermission(Unknown Source) at com.atlassian.confluence.setup.actions.SetupAdministrator.createDefaultGroupsAndPermissions(SetupAdministrator.java:48) at com.atlassian.confluence.setup.actions.SetupAdministrator.execute(SetupAdministrator.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:166) at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:73) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:88) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:971) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:402) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:146) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6356) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3635) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2585) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170) Referer URL: Unknown Build Information: Uptime: 8 minutes, 26 seconds Version: 1.1 Build Number: 53 Server Information: Application Server: WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.Oracle9Dialect Memory Information: Total Memory: 510 MB Free Memory: 355 MB Used Memory: 155 MB System Information: System Date: Thursday, 10 Jun 2004 System Time: 02:20:16 System Favourite Colour: Almond Java Version: 1.4.1_05 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.1_05-b01 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: root User Timezone: MET Operating System: SunOS 5.9 OS Architecture: sparc Request Logging: 0 log statements generated by this request:

    Atlassian JIRA | 1 decade ago | Stephan Janssen
    java.sql.SQLException: ORA-00942: table or view does not exist
  3. 0

    table or view does not exist error when calling webservice

    Oracle Community | 1 decade ago | 666705
    java.sql.SQLException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle install problem

    oreports | 1 decade ago | thileg
    java.sql.SQLException: ORA-00942: table or view does not exist
  6. 0

    WebLogic 5.1/JMS tables not found/Persistant Store not initialized

    Google Groups | 2 decades ago | Daniel
    java.sql.SQLException: ORA-00942: table or view does not exist

  1. rp 1 times, last 2 months ago
26 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-00942: table or view does not exist

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteDescribe
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:877)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2513)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2857)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
    4 frames
  5. weblogic.jdbc.wrapper
    PreparedStatement.executeQuery
    1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:80)
    1 frame
  6. bucket.util
    ResettableIncrementGenerator.generate
    1. bucket.util.ResettableIncrementGenerator.getNext(ResettableIncrementGenerator.java:73)
    2. bucket.util.ResettableIncrementGenerator.generate(ResettableIncrementGenerator.java:39)
    2 frames
  7. net.sf.hibernate
    SessionImpl.saveOrUpdate
    1. net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:747)
    2. net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:720)
    3. net.sf.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:1359)
    3 frames
  8. Hibernate
    HibernateTemplate.saveOrUpdate
    1. org.springframework.orm.hibernate.HibernateTemplate$10.doInHibernate(HibernateTemplate.java:259)
    2. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:150)
    3. org.springframework.orm.hibernate.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:257)
    3 frames
  9. bucket.core.persistence
    HibernateObjectDao.save
    1. bucket.core.persistence.hibernate.HibernateObjectDao.saveRaw(HibernateObjectDao.java:151)
    2. bucket.core.persistence.hibernate.HibernateObjectDao.save(HibernateObjectDao.java:121)
    2 frames
  10. com.atlassian.confluence
    CachingSpacePermissionManager.savePermission
    1. com.atlassian.confluence.security.DefaultSpacePermissionManager.savePermission(DefaultSpacePermissionManager.java:70)
    2. com.atlassian.confluence.security.CachingSpacePermissionManager.savePermission(CachingSpacePermissionManager.java:17)
    2 frames
  11. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:324)
    4 frames
  12. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:59)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:118)
    3 frames
  13. com.atlassian.confluence
    SpringProfilingInterceptor.invoke
    1. com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17)
    1 frame
  14. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
    1 frame
  15. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:191)
    1 frame
  16. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148)
    2 frames
  17. Unknown
    $Proxy76.savePermission
    1. $Proxy76.savePermission(Unknown Source)
    1 frame
  18. com.atlassian.confluence
    SetupAdministrator.execute
    1. com.atlassian.confluence.setup.actions.SetupAdministrator.createDefaultGroupsAndPermissions(SetupAdministrator.java:48)
    2. com.atlassian.confluence.setup.actions.SetupAdministrator.execute(SetupAdministrator.java:37)
    2 frames
  19. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:166)
    1 frame
  20. com.atlassian.confluence
    SetupCheckInterceptor.intercept
    1. com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:27)
    1 frame
  21. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  22. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
    1 frame
  23. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  24. com.opensymphony.xwork
    DefaultWorkflowInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55)
    1 frame
  25. com.atlassian.confluence
    ConfluenceWorkflowInterceptor.intercept
    1. com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:34)
    1 frame
  26. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  27. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
    1 frame
  28. com.atlassian.confluence
    ConfluenceValidationInterceptor.intercept
    1. com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16)
    1 frame
  29. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  30. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
    1 frame
  31. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  32. com.atlassian.confluence
    PermissionCheckInterceptor.intercept
    1. com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40)
    1 frame
  33. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  34. com.atlassian.confluence
    PageAwareInterceptor.intercept
    1. com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:73)
    1 frame
  35. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  36. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
    1 frame
  37. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  38. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
    1 frame
  39. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  40. com.atlassian.confluence
    ConfluenceAutowireInterceptor.intercept
    1. com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25)
    1 frame
  41. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  42. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
    1 frame
  43. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  44. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
    1 frame
  45. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  46. com.atlassian.confluence
    XWorkTransactionInterceptor.intercept
    1. com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:88)
    1 frame
  47. XWork Tiger Extensions
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    1 frame
  48. com.opensymphony.xwork
    AroundInterceptor.intercept
    1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
    1 frame
  49. XWork Tiger Extensions
    DefaultActionProxy.execute
    1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
    2. com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
    2 frames
  50. WebWork
    ServletDispatcher.service
    1. com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278)
    2. com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248)
    2 frames
  51. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    1 frame
  52. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:971)
    2. weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:402)
    3. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
    4. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    4 frames
  53. Sitemesh
    PageFilter.parsePage
    1. com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145)
    1 frame
  54. com.atlassian.confluence
    ProfilingPageFilter.parsePage
    1. com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:146)
    1 frame
  55. Sitemesh
    PageFilter.doFilter
    1. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61)
    1 frame
  56. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  57. com.atlassian.seraph
    SecurityFilter.doFilter
    1. com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:84)
    1 frame
  58. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  59. com.atlassian.seraph
    LoginFilter.doFilter
    1. com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:95)
    1 frame
  60. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  61. com.atlassian.johnson
    JohnsonFilter.doFilter
    1. com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
    1 frame
  62. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  63. Hibernate
    OpenSessionInViewFilter.doFilterInternal
    1. org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117)
    1 frame
  64. bucket.custom
    FlushingSpringSessionInViewFilter.doFilterInternal
    1. bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30)
    1 frame
  65. Spring
    OncePerRequestFilter.doFilter
    1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73)
    1 frame
  66. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  67. com.atlassian.util
    ProfilingFilter.doFilter
    1. com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
    1 frame
  68. com.atlassian.confluence
    ProfilingAndErrorFilter.doFilter
    1. com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25)
    1 frame
  69. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    1 frame
  70. com.atlassian.core
    AbstractEncodingFilter.doFilter
    1. com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38)
    1 frame
  71. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6356)
    2 frames
  72. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
    1 frame
  73. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
    1 frame
  74. Atmosphere weblogic
    ServletRequestImpl.execute
    1. weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3635)
    2. weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2585)
    2 frames
  75. weblogic.kernel
    ExecuteThread.run
    1. weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
    2. weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
    2 frames