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

sap.com | 4 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Using mitreid-connect with a backend Oracle DB

    GitHub | 2 years ago | kochsen
    java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected ```
  2. 0

    JavaRoots: Configure Oracle DataSource Using Commons DBCP

    javaroots.com | 1 year ago
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  3. 0

    GitHub comment 506#282962127

    GitHub | 2 months ago | TimMoore
    java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Sqoop to HDFS error Cannot initialize cluster

    sqoop-user | 3 years ago | Brenden Cobb
    tool.ImportTool: Encountered IOException running import job: java.io.IOException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  6. 0

    Re: Sqoop to HDFS error Cannot initialize cluster

    sqoop-user | 3 years ago | Brenden Cobb
    tool.ImportTool: Encountered IOException running import job: java.io.IOException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

  1. osvzs 27 times, last 1 month ago
  2. tomthomas 20 times, last 1 month ago
  3. rp 1 times, last 4 months ago
  4. jpvee 2 times, last 4 months ago
  5. Nikolay Rybak 2 times, last 4 months ago
5 more registered users
30 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
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
    8. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
    9. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
    10. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
    11. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
    13. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
    14. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
    14 frames
  3. com.sap.engine
    PreparedStatementWrapper.executeQuery
    1. com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:375)
    1 frame
  4. com.sap.idm
    SAP_ITSAM_IDM_ServiceWrapper.invoke
    1. com.sap.idm.jmx.ic.IDStoreUtil.getIDStoreProperties(IDStoreUtil.java:133)
    2. com.sap.idm.jmx.ic.EntryUtil.getMskeyForCurrentUser(EntryUtil.java:1092)
    3. com.sap.idm.jmx.impl.SAP_ITSAM_IDM_Service_Impl_Impl.retrieveTabs(SAP_ITSAM_IDM_Service_Impl_Impl.java:1858)
    4. com.sap.idm.jmx.SAP_ITSAM_IDM_ServiceWrapper.invoke(SAP_ITSAM_IDM_ServiceWrapper.java:1277)
    4 frames
  5. Java RT
    JmxMBeanServer.invoke
    1. com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:835)
    2. com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:771)
    2 frames
  6. com.sap.pj
    MBeanServerWrapperInterceptor.invoke
    1. com.sap.pj.jmx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:468)
    2. com.sap.pj.jmx.server.interceptor.MBeanServerWrapperInterceptor.invoke(MBeanServerWrapperInterceptor.java:288)
    2 frames
  7. com.sap.engine
    CompletionInterceptor.invoke
    1. com.sap.engine.services.jmx.CompletionInterceptor.invoke(CompletionInterceptor.java:612)
    1 frame
  8. com.sap.pj
    BasicMBeanServerInterceptor.invoke
    1. com.sap.pj.jmx.server.interceptor.BasicMBeanServerInterceptor.invoke(BasicMBeanServerInterceptor.java:277)
    1 frame
  9. com.sap.jmx
    ProviderInterceptor.invoke
    1. com.sap.jmx.provider.ProviderInterceptor.invoke(ProviderInterceptor.java:365)
    1 frame
  10. com.sap.engine
    RedirectInterceptor.invoke
    1. com.sap.engine.services.jmx.RedirectInterceptor.invoke(RedirectInterceptor.java:340)
    1 frame
  11. com.sap.pj
    MBeanServerInterceptorChain.invoke
    1. com.sap.pj.jmx.server.interceptor.MBeanServerInterceptorChain.invoke(MBeanServerInterceptorChain.java:367)
    1 frame
  12. com.sap.engine
    ClusterInterceptor.invoke
    1. com.sap.engine.services.jmx.MBeanServerSecurityWrapper.invoke(MBeanServerSecurityWrapper.java:289)
    2. com.sap.engine.services.jmx.ClusterInterceptor.invoke(ClusterInterceptor.java:813)
    2 frames
  13. com.sap.pj
    MBeanServerInterceptorChain.invoke
    1. com.sap.pj.jmx.server.interceptor.MBeanServerInterceptorChain.invoke(MBeanServerInterceptorChain.java:367)
    1 frame
  14. com.sap.idm
    InternalModelWrapperInterface.wdInvokeMethod
    1. com.sap.idm.wd.jmx.SAP_ITSAM_IDM_Service$Impl.retrieveTabs(SAP_ITSAM_IDM_Service.java:1121)
    2. com.sap.idm.wd.modelwrapper.ModelWrapperInterface.getTabVisibility(ModelWrapperInterface.java:528)
    3. com.sap.idm.wd.modelwrapper.wdp.InternalModelWrapperInterface.wdInvokeMethod(InternalModelWrapperInterface.java:803)
    3 frames
  15. com.sap.tc
    ExternalControllerPI$ExternalInterfaceInvocationHandler.invoke
    1. com.sap.tc.webdynpro.progmodel.generation.ExternalControllerPI$ExternalInterfaceInvocationHandler.invoke(ExternalControllerPI.java:339)
    1 frame
  16. com.sun.proxy
    $Proxy624.getTabVisibility
    1. com.sun.proxy.$Proxy624.getTabVisibility(Unknown Source)
    1 frame
  17. com.sap.idm
    InternalTopTabView.wdDoInit
    1. com.sap.idm.wd.wf.toptab.TopTab.InitializeContext(TopTab.java:231)
    2. com.sap.idm.wd.wf.toptab.wdp.InternalTopTab.InitializeContext(InternalTopTab.java:206)
    3. com.sap.idm.wd.wf.toptab.TopTabView.wdDoInit(TopTabView.java:119)
    4. com.sap.idm.wd.wf.toptab.wdp.InternalTopTabView.wdDoInit(InternalTopTabView.java:186)
    4 frames
  18. com.sap.tc
    AbstractDispatcherServlet.doGet
    1. com.sap.tc.webdynpro.progmodel.generation.DelegatingView.doInit(DelegatingView.java:59)
    2. com.sap.tc.webdynpro.progmodel.controller.Controller.initController(Controller.java:227)
    3. com.sap.tc.webdynpro.progmodel.view.View.initController(View.java:731)
    4. com.sap.tc.webdynpro.progmodel.controller.Controller.init(Controller.java:206)
    5. com.sap.tc.webdynpro.progmodel.window.ViewManager.getView(ViewManager.java:668)
    6. com.sap.tc.webdynpro.progmodel.window.ViewManager.bindRoot(ViewManager.java:563)
    7. com.sap.tc.webdynpro.progmodel.window.ViewManager.init(ViewManager.java:183)
    8. com.sap.tc.webdynpro.progmodel.window.InterfaceView.manageEmbeddedViewManager(InterfaceView.java:141)
    9. com.sap.tc.webdynpro.progmodel.window.InterfaceView.initController(InterfaceView.java:55)
    10. com.sap.tc.webdynpro.progmodel.controller.Controller.init(Controller.java:206)
    11. com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.doOpen(WebDynproWindow.java:386)
    12. com.sap.tc.webdynpro.clientserver.window.ApplicationWindow.show(ApplicationWindow.java:180)
    13. com.sap.tc.webdynpro.clientserver.window.ApplicationWindow.open(ApplicationWindow.java:174)
    14. com.sap.tc.webdynpro.clientserver.cal.ClientApplication.init(ClientApplication.java:592)
    15. com.sap.tc.webdynpro.clientserver.cal.ClientApplication.doPreprocessing(ClientApplication.java:1457)
    16. com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doPreprocessing(ApplicationSession.java:660)
    17. com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:349)
    18. com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:326)
    19. com.sap.tc.webdynpro.serverimpl.core.AbstractDispatcherServlet.doContent(AbstractDispatcherServlet.java:87)
    20. com.sap.tc.webdynpro.serverimpl.wdc.DispatcherServlet.doContent(DispatcherServlet.java:101)
    21. com.sap.tc.webdynpro.serverimpl.core.AbstractDispatcherServlet.doGet(AbstractDispatcherServlet.java:55)
    21 frames
  19. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:734)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
    2 frames
  20. com.sap.engine
    RequestDispatcherImpl.forward
    1. com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:152)
    2. com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.doWork(RequestDispatcherImpl.java:373)
    3. com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:499)
    3 frames
  21. com.sap.tc
    ForwardServlet.doGet
    1. com.sap.tc.webdynpro.serverimpl.wdc.ForwardServlet.doPost(ForwardServlet.java:77)
    2. com.sap.tc.webdynpro.serverimpl.wdc.ForwardServlet.doGet(ForwardServlet.java:34)
    2 frames
  22. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:734)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
    2 frames
  23. com.sap.engine
    CentralExecutor$SingleThread.run
    1. com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:152)
    2. com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:38)
    3. com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:466)
    4. com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:210)
    5. com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:441)
    6. com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:430)
    7. com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:38)
    8. com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
    9. com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:81)
    10. com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
    11. com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:278)
    12. com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
    13. com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:81)
    14. com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)
    15. com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
    16. com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)
    17. com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)
    18. com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
    19. com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)
    20. com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
    21. com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
    22. com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)
    23. com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
    24. com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
    25. com.sap.engine.services.httpserver.filters.SessionSizeFilter.process(SessionSizeFilter.java:26)
    26. com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
    27. com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
    28. com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:57)
    29. com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
    30. com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
    31. com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:43)
    32. com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
    33. com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
    34. com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:475)
    35. com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:269)
    36. com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:56)
    37. com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)
    38. com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)
    39. com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:328)
    39 frames