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

Oracle Community | Njin | 1 year 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

    OWCS installation as delivery is failing

    Oracle Community | 1 year ago | Njin
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  2. 0

    Oracle Materialized View logs cause an exception during cleaning.

    GitHub | 4 years ago | flyway
    com.googlecode.flyway.core.exception.FlywayException: Error executing statement at line 33: DROP TABLE EXAMPLE."MLOG$_T" CASCADE CONSTRAINTS PURGE
  3. 0

    GitHub comment 177#182036155

    GitHub | 1 year ago | alexbarta
    org.waarp.common.database.exception.WaarpDatabaseSqlException: SQL Exception Request:SELECT * FROM CONFIGURATION
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Server Start fails with Oracle 11G backend

    GitHub | 1 year ago | alexbarta
    org.waarp.common.database.exception.WaarpDatabaseSqlException: SQL Exception Request:SELECT * FROM CONFIGURATION
  6. 0

    Fail Deployed application server in EPM  11.1.2.4

    Oracle Community | 2 years ago | 1752932
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
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.SQLSyntaxErrorException

    ORA-00942: table or view does not exist

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OracleStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
    7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
    8. oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:852)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
    11. oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4656)
    12. oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4785)
    13. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1894)
    14. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1855)
    15. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304)
    15 frames
  3. org.apache.tomcat
    DelegatingStatement.execute
    1. org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    2. org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    2 frames
  4. COM.FutureTense.Servlet
    JDBCConn.ExecuteQuery
    1. COM.FutureTense.Servlet.JDBCConn.ExecuteQuery_trans(JDBCConn.java:995)
    2. COM.FutureTense.Servlet.JDBCConn.ExecuteQuery(JDBCConn.java:623)
    2 frames
  5. COM.FutureTense.Common
    ftDBTable.doSQL
    1. COM.FutureTense.Common.ftDBTable.doSQL(ftDBTable.java:2199)
    1 frame
  6. COM.FutureTense.CatalogManager
    CatalogEngine$8.execute
    1. COM.FutureTense.CatalogManager.CatalogEngine.runSQL(CatalogEngine.java:2733)
    2. COM.FutureTense.CatalogManager.CatalogEngine._queryAndCache(CatalogEngine.java:4944)
    3. COM.FutureTense.CatalogManager.CatalogEngine.access$800(CatalogEngine.java:45)
    4. COM.FutureTense.CatalogManager.CatalogEngine$8.execute(CatalogEngine.java:4925)
    4 frames
  7. com.fatwire.cs
    NestedTransactionBlock.execute
    1. com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189)
    1 frame
  8. COM.FutureTense.CatalogManager
    CatalogEngine.processSQL
    1. COM.FutureTense.CatalogManager.CatalogEngine._queryAndCacheTrans(CatalogEngine.java:4931)
    2. COM.FutureTense.CatalogManager.CatalogEngine.processSQL(CatalogEngine.java:4884)
    2 frames
  9. COM.FutureTense.Common
    CS.SQL
    1. COM.FutureTense.Common.CS.SQL(CS.java:1105)
    2. COM.FutureTense.Common.CS.SQL(CS.java:1053)
    2 frames
  10. com.openmarket.visitor
    VisitorDataManager.worker
    1. com.openmarket.visitor.data.AbstractPersistentObject.executeSQL(AbstractPersistentObject.java:1464)
    2. com.openmarket.visitor.data.AbstractPersistentObject.getObjectList(AbstractPersistentObject.java:1119)
    3. com.openmarket.visitor.data.PersistentVisitorDataConnection.getObjectWithPreload(PersistentVisitorDataConnection.java:3088)
    4. com.openmarket.visitor.data.PersistentVisitorDataConnection.getAccessMethod(PersistentVisitorDataConnection.java:336)
    5. com.openmarket.visitor.data.PersistentVisitorDataConnection.createAccessMethod(PersistentVisitorDataConnection.java:310)
    6. com.openmarket.visitor.seed.VisitorDataManager.worker(VisitorDataManager.java:334)
    6 frames
  11. com.openmarket.basic
    BaseSeed.endTag
    1. com.openmarket.basic.seed.BaseSeed.endTag(BaseSeed.java:265)
    1 frame
  12. COM.FutureTense.XML
    XMLEval.run
    1. COM.FutureTense.XML.Template.DynTag.execute(DynTag.java:218)
    2. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    3. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    4. COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
    5. COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
    5 frames
  13. COM.FutureTense.Common
    ContentServer.processElement
    1. COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3290)
    2. COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2551)
    3. COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1999)
    3 frames
  14. COM.FutureTense.XML
    XMLEval.run
    1. COM.FutureTense.XML.Template.CallElement.execute(CallTag.java:253)
    2. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    3. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    4. COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
    5. COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
    6. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    7. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    8. COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
    9. COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
    10. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    11. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    12. COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
    13. COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
    13 frames
  15. COM.FutureTense.Common
    CS.CallElement
    1. COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3290)
    2. COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2551)
    3. COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1999)
    4. COM.FutureTense.Common.CS.CallElement(CS.java:1603)
    4 frames
  16. COM.FutureTense.Apps
    InstallServer.evalPage
    1. COM.FutureTense.Apps.Install.command.ReadURL.exec(ReadURL.java:173)
    2. COM.FutureTense.Apps.Install.command.Command.execute(Command.java:130)
    3. COM.FutureTense.Apps.Install.server.InstallManager.invokeCommand(InstallManager.java:479)
    4. COM.FutureTense.Apps.Install.server.InstallManager.execute(InstallManager.java:104)
    5. COM.FutureTense.Apps.Install.server.InstallServer.evalPage(InstallServer.java:123)
    5 frames
  17. COM.FutureTense.Common
    ContentServer.execute
    1. COM.FutureTense.Common.ContentServer.execute(ContentServer.java:465)
    1 frame
  18. COM.FutureTense.Servlet
    FTServlet.doPost
    1. COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129)
    2. COM.FutureTense.Servlet.FTServlet.doPost(FTServlet.java:61)
    2 frames
  19. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2 frames
  20. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    2 frames
  21. Tomcat WS
    WsFilter.doFilter
    1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    1 frame
  22. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    2 frames
  23. com.fatwire.auth
    RequestAuthenticationFilter.doFilter
    1. com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:193)
    1 frame
  24. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    2 frames
  25. com.fatwire.wem
    SSOFilter.doFilter
    1. com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:701)
    2. com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
    2 frames
  26. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
    6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
    7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
    9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
    10 frames
  27. Grizzly HTTP
    JIoEndpoint$SocketProcessor.run
    1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
    2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
    3. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
    3 frames
  28. Java RT
    ThreadPoolExecutor$Worker.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    2 frames
  29. Tomcat Util
    TaskThread$WrappingRunnable.run
    1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    1 frame
  30. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame