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

Oracle Community | 785434 | 4 years ago
  1. 0

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

    Oracle Community | 4 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 | 5 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

    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: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