java.lang.RuntimeException: Error loading objects from data source: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Oracle Community | 923301 | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Planning application issue

    Oracle Community | 5 years ago | 923301
    java.lang.RuntimeException: Error loading objects from data source: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  2. 0

    Can Not open Planning application

    Oracle Community | 4 years ago | 1012136
    java.lang.RuntimeException: Error loading objects from data source: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  3. 0

    Unable to login in Planning.

    Oracle Community | 6 years ago | Journeyer
    java.lang.RuntimeException: Errors occured during syncrhonization: [com.hyperion.planning.HspRuntimeException: An error accurred while adding user to Essbase. Please check the Essbase log for details.]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Need help in copying Hyperion Planning application from Production to UAT

    Oracle Community | 6 years ago | 886093
    java.lang.RuntimeException: Error loading objects from data source: java.sql.SQLException: [Hyperion][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'HSP_SYSTEMCFG', database 'master', schema 'dbo'.
  6. 0

    Unsuccessful Logon. Check Log for Details error when loggin into Planning

    Oracle Community | 5 years ago | SM1985
    java.lang.RuntimeException: Error loading objects from data source: java.lang.NullPointerException: JDBCCacheLoader.loadObjects(): jdbc connection was null.

    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.lang.RuntimeException

      Error loading objects from data source: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

      at com.hyperion.planning.sql.GenericCache.loadCache()
    2. com.hyperion.planning
      HyperionPlanningBean.Login
      1. com.hyperion.planning.sql.GenericCache.loadCache(Unknown Source)
      2. com.hyperion.planning.sql.GenericCache.getCache(Unknown Source)
      3. com.hyperion.planning.sql.GenericCache.getUnfilteredCache(Unknown Source)
      4. com.hyperion.planning.HspJSImpl.loadSystemCfg(Unknown Source)
      5. com.hyperion.planning.HspJSImpl.<init>(Unknown Source)
      6. com.hyperion.planning.HspJSHomeImpl.createHspJS(Unknown Source)
      7. com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(Unknown Source)
      8. com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(Unknown Source)
      9. com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
      9 frames
    3. Unknown
      HspLogOn.doPost
      1. HspLogOn.Handle(Unknown Source)
      2. HspLogOn.doPost(Unknown Source)
      2 frames
    4. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
      2 frames
    5. 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:27)
      5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
      5 frames
    6. Unknown
      HspValidationFilter.doFilter
      1. HspValidationFilter.doFilter(Unknown Source)
      1 frame
    7. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
      1 frame
    8. 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
    9. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
      1 frame
    10. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
      1 frame
    11. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
      2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
      3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
      3 frames
    12. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    13. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    14. 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
    15. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
      2 frames