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

Oracle Community | 923301 | 4 years ago
  1. 0

    Planning application issue

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

    Planning DMP File imported.Then it is showing Error while opening App

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

    Can Not open Planning application

    Oracle Community | 3 years ago | 1012136
    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

    ODI topology import error

    Oracle Community | 5 years ago | 898116
    java.lang.RuntimeException: oracle.odi.oditools.OdiToolException: Error while running ODI Tool OdiImportObject
  6. 0

    Execution of procedure fails with ODI-1226 and 1228 error in 11g

    Oracle Community | 5 years ago | 935161
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
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:457)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:924)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3806)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1667)
    13 frames
  3. com.hyperion.planning
    HyperionPlanningBean.Login
    1. com.hyperion.planning.sql.HspSQLImpl.executeQuery(Unknown Source)
    2. com.hyperion.planning.sql.HspSQLImpl.executeQuery(Unknown Source)
    3. com.hyperion.planning.sql.JDBCCacheLoader.loadObjects(Unknown Source)
    4. com.hyperion.planning.sql.JDBCCacheLoader.loadObjects(Unknown Source)
    5. com.hyperion.planning.sql.GenericCache.loadCache(Unknown Source)
    6. com.hyperion.planning.sql.GenericCache.getCache(Unknown Source)
    7. com.hyperion.planning.sql.GenericCache.getUnfilteredCache(Unknown Source)
    8. com.hyperion.planning.HspJSImpl.loadSystemCfg(Unknown Source)
    9. com.hyperion.planning.HspJSImpl.<init>(Unknown Source)
    10. com.hyperion.planning.HspJSHomeImpl.createHspJS(Unknown Source)
    11. com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(Unknown Source)
    12. com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(Unknown Source)
    13. com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
    13 frames
  4. Unknown
    HspLogOn.doPost
    1. HspLogOn.Handle(Unknown Source)
    2. HspLogOn.doPost(Unknown Source)
    2 frames
  5. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  6. 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:300)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  7. Unknown
    HspValidationFilter.doFilter
    1. HspValidationFilter.doFilter(Unknown Source)
    1 frame
  8. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  9. oracle.security.jps
    JpsFilter.doFilter
    1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
    2. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
    3. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
    4. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
    5. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
    6. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
    6 frames
  10. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  11. oracle.dms.servlet
    DMSServletFilter.doFilter
    1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
    1 frame
  12. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
    3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
    3 frames
  13. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  14. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  15. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
    3 frames
  16. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
    2 frames