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

    Error installing webcenter sites delivery in silent mode

    Oracle Community | 3 years ago | PratushA
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  3. 0

    Using Oracle 11g and Hibernate 3 getting error 0972 identifier too long

    Stack Overflow | 4 years ago | user931501
    java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Unable to retrieve records from DB

    openxava | 4 years ago | nirvanam
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
  6. 0

    EDQ integration with QAS

    Oracle Community | 1 year ago | Oliver Lockett
    com.datanomic.director.runtime.data.RecordReadException: Unable to read from staged data "OpenFin.oa_anlysis". (Code: 203,200)
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
    OraclePreparedStatementWrapper.executeQuery
    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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
    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.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:10410)
    13. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3574)
    14. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
    15. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    15 frames
  3. org.apache.tomcat
    DelegatingPreparedStatement.executeQuery
    1. org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    2. org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    2 frames
  4. COM.FutureTense.Servlet
    JDBCTable.SelectRow
    1. COM.FutureTense.Servlet.JDBCTable.executeQuery_trans_logic(JDBCTable.java:1632)
    2. COM.FutureTense.Servlet.JDBCTable.executeQuery_trans(JDBCTable.java:1590)
    3. COM.FutureTense.Servlet.JDBCTable.executeQuery(JDBCTable.java:1430)
    4. COM.FutureTense.Servlet.JDBCTable.SelectRow(JDBCTable.java:1025)
    4 frames
  5. COM.FutureTense.Common
    CatalogManager.execute
    1. COM.FutureTense.Common.ftDBTable.selectTo(ftDBTable.java:2238)
    2. COM.FutureTense.Common.ftSysInfo.get(ftSysInfo.java:371)
    3. COM.FutureTense.Common.ftSysInfo.getDocBase(ftSysInfo.java:207)
    4. COM.FutureTense.Common.ftAppLogic.assetDir(ftAppLogic.java:2665)
    5. COM.FutureTense.Common.ftAppLogic.initBuiltinVars(ftAppLogic.java:1968)
    6. COM.FutureTense.Common.ftAppLogic.init(ftAppLogic.java:1934)
    7. COM.FutureTense.Common.ftAppLogic.init(ftAppLogic.java:1899)
    8. COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:331)
    8 frames
  6. 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
  7. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2 frames
  8. 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
  9. Tomcat WS
    WsFilter.doFilter
    1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    1 frame
  10. 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
  11. com.fatwire.auth
    RequestAuthenticationFilter.doFilter
    1. com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:193)
    1 frame
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. Tomcat Util
    TaskThread$WrappingRunnable.run
    1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    1 frame
  18. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame