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

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