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

Oracle Community | 1001235 | 4 years ago
  1. 0

    Essbase Analytics Link : Analytics Link Data not availble

    Oracle Community | 4 years ago | 1001235
    java.sql.SQLException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  2. 0

    Not able to create the standalone agent in ODI 12c

    Oracle Community | 1 year ago | apu
    com.oracle.cie.servicetable.external.ServiceTableException: Failed to query contents of table SERVICETABLE. ORA-00942: table or view does not exist
  3. 0

    dbunit - SQL exception

    Stack Overflow | 3 years ago | DivinaProportio
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Unable to use multiple datasources in 3.0.1

    GitHub | 2 years ago | kschmit90
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  6. 0

    SQL queries in R with RJDBC crash if column or table doesn't exist

    Stack Overflow | 8 months ago | dc1232123
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

  1. bpbhat77 1 times, last 5 months ago
8 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.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
    8. oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:942)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
    11. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1690)
    12. oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:446)
    12 frames
  3. com.hyperroll.hfm2ess
    BridgeOperationManager.getHFMMetadata
    1. com.hyperroll.hfm2ess.metadata.HFMExtractor.extractTextDims(Unknown Source)
    2. com.hyperroll.hfm2ess.metadata.HFMExtractor.extract(Unknown Source)
    3. com.hyperroll.hfm2ess.bridge.HFMProcess.exportDataFromHfm(Unknown Source)
    4. com.hyperroll.hfm2ess.bridge.HFMProcess.extractTablesFromHFM(Unknown Source)
    5. com.hyperroll.hfm2ess.bridge.ws.BridgeOperationManagerImpl.getHFMMetadata(Unknown Source)
    6. com.hyperroll.hfm2ess.bridge.ws.BridgeOperationManager.getHFMMetadata(Unknown Source)
    6 frames
  4. 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:597)
    4 frames
  5. weblogic.wsee.jaxws
    WLSInstanceResolver$WLSInvoker.invoke
    1. weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
    2. weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
    2 frames
  6. JAX-WS RI Runtime Bundle
    ServletAdapter.handle
    1. com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:151)
    2. com.sun.xml.ws.server.sei.EndpointMethodHandlerImpl.invoke(EndpointMethodHandlerImpl.java:268)
    3. com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:100)
    4. com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:866)
    5. com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:815)
    6. com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:778)
    7. com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:680)
    8. com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:403)
    9. com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:539)
    10. com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:253)
    11. com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:140)
    11 frames
  7. weblogic.wsee.jaxws
    HttpServletAdapter$AuthorizedInvoke.run
    1. weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:171)
    2. weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
    2 frames
  8. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
    1 frame
  9. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
    1 frame
  10. weblogic.wsee.util
    ServerSecurityHelper.authenticatedInvoke
    1. weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
    1 frame
  11. weblogic.wsee.jaxws
    JAXWSServlet.doRequest
    1. weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
    2. weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
    3. weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)
    3 frames
  12. Atmosphere weblogic
    AbstractAsyncServlet.service
    1. weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
    1 frame
  13. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    1 frame
  14. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
    4. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
    5. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3732)
    6. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
    6 frames
  15. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  16. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  17. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
    3 frames
  18. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames