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

Oracle Community | 785434 | 5 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Error Installing CS delivery - Table or view does not exist?

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

    Error executing a Oracle query when connection is fetched from Datasource

    Oracle Community | 4 years ago | 992632
    java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
  3. 0

    Cant provision user using AD connector (9.1.1.7.2) in OIM (11.1.1.5.0)

    Oracle Community | 5 years ago | user10233157
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    OIM 11.1.2.3 Create Organization recon event

    Oracle Community | 8 months ago | 1035694
    java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification
  6. 0

    Error executing a Oracle specific query when connection is fetched from Datasource

    Coderanch | 4 years ago | Rob Eddy
    java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
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:445)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
    8. oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
    11. oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4692)
    12. oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4825)
    13. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1913)
    14. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
    15. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
    15 frames
  3. weblogic.jdbc.wrapper
    Statement.execute
    1. weblogic.jdbc.wrapper.Statement.execute(Statement.java:485)
    1 frame
  4. COM.FutureTense.Servlet
    JDBCConn.ExecuteQuery
    1. COM.FutureTense.Servlet.JDBCConn.ExecuteQuery_trans(JDBCConn.java:983)
    2. COM.FutureTense.Servlet.JDBCConn.ExecuteQuery(JDBCConn.java:611)
    2 frames
  5. COM.FutureTense.Common
    ftDBTable.doSQL
    1. COM.FutureTense.Common.ftDBTable.doSQL(ftDBTable.java:2189)
    1 frame
  6. COM.FutureTense.CatalogManager
    CatalogEngine$8.execute
    1. COM.FutureTense.CatalogManager.CatalogEngine.runSQL(CatalogEngine.java:2730)
    2. COM.FutureTense.CatalogManager.CatalogEngine._queryAndCache(CatalogEngine.java:4939)
    3. COM.FutureTense.CatalogManager.CatalogEngine.access$800(CatalogEngine.java:43)
    4. COM.FutureTense.CatalogManager.CatalogEngine$8.execute(CatalogEngine.java:4920)
    4 frames
  7. com.fatwire.cs
    NestedTransactionBlock.execute
    1. com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:180)
    1 frame
  8. COM.FutureTense.CatalogManager
    CatalogEngine.processSQL
    1. COM.FutureTense.CatalogManager.CatalogEngine._queryAndCacheTrans(CatalogEngine.java:4926)
    2. COM.FutureTense.CatalogManager.CatalogEngine.processSQL(CatalogEngine.java:4879)
    2 frames
  9. COM.FutureTense.Common
    CS.SQL
    1. COM.FutureTense.Common.CS.SQL(CS.java:1104)
    2. COM.FutureTense.Common.CS.SQL(CS.java:1052)
    2 frames
  10. com.openmarket.visitor
    VisitorDataManager.worker
    1. com.openmarket.visitor.data.AbstractPersistentObject.executeSQL(AbstractPersistentObject.java:1453)
    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:263)
    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:3186)
    2. COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2447)
    3. COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1895)
    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:3186)
    2. COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2447)
    3. COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1895)
    4. COM.FutureTense.Common.CS.CallElement(CS.java:1599)
    4 frames
  16. COM.FutureTense.Apps
    InstallServer.evalPage
    1. COM.FutureTense.Apps.Install.command.ReadURL.exec(ReadURL.java:169)
    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:453)
    1 frame
  18. COM.FutureTense.Servlet
    FTServlet.doGet
    1. COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129)
    2. COM.FutureTense.Servlet.FTServlet.doGet(FTServlet.java:53)
    2 frames
  19. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  20. Atmosphere weblogic
    FilterChainImpl.doFilter
    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.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  21. com.fatwire.wem
    SSOFilter.doFilter
    1. com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:557)
    2. com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
    2 frames
  22. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
    3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
    3 frames
  23. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  24. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  25. 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
  26. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames