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 | 3 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 | 10 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 | 10 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

    3 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.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