java.lang.RuntimeException: Error loading objects from data source: 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.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 | 3 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 | 5 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 | 4 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