4 Replies Latest reply: Nov 15, 2012 7:57 AM by 923301 RSS

    Planning application issue

    923301
      Hello All,
      Of the several applications, I have, I canot open one of them. I can log into the workspace, and when I open some of them they work fine, however, when I try to open one of them, it gives me an error message.
      Moreover, I can log in to EAS and get in to the cube that is associated with it.
      What could be the problem?
      The error messages tells me to look for some kind of log files, but I am not too good with reading those log files.
      Can you suggest anything please.
      Thanks
        • 1. Re: Planning application issue
          JohnGoodwin
          You should check the log for more information, you don't mention planning version or OS you are running.
          If on windows and 11.1.2.x then check <MIDDLEWARE_HOME>\user_projects\<instancename>\diagnostics\logs\services
          If on windows and 11.1.1.x then check <HYPERION_HOME>\logs\services\

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: Planning application issue
            923301
            John,
            Thank you very much for the path. I am in Windows OS and 11.1.2.
            When I checked the logs, this is what I found. The application as working fine. Suddenly it has stopped. I am not sure if I had done something by mistake.
            Any input would be helpful.
            Thanks

            Query Failed: SQL_GET_SYSTEMCFG: null
            java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
                 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
                 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
                 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
                 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
                 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
                 at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:924)
                 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
                 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
                 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
                 at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3806)
                 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1667)
                 at com.hyperion.planning.sql.HspSQLImpl.executeQuery(Unknown Source)
                 at com.hyperion.planning.sql.HspSQLImpl.executeQuery(Unknown Source)
                 at com.hyperion.planning.sql.JDBCCacheLoader.loadObjects(Unknown Source)
                 at com.hyperion.planning.sql.JDBCCacheLoader.loadObjects(Unknown Source)
                 at com.hyperion.planning.sql.GenericCache.loadCache(Unknown Source)
                 at com.hyperion.planning.sql.GenericCache.getCache(Unknown Source)
                 at com.hyperion.planning.sql.GenericCache.getUnfilteredCache(Unknown Source)
                 at com.hyperion.planning.HspJSImpl.loadSystemCfg(Unknown Source)
                 at com.hyperion.planning.HspJSImpl.<init>(Unknown Source)
                 at com.hyperion.planning.HspJSHomeImpl.createHspJS(Unknown Source)
                 at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(Unknown Source)
                 at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(Unknown Source)
                 at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                 at HspLogOn.Handle(Unknown Source)
                 at HspLogOn.doPost(Unknown Source)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
                 at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
                 at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
                 at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
                 at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at HspValidationFilter.doFilter(Unknown Source)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
                 at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
                 at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
                 at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
                 at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
                 at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
                 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                 at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                 at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
                 at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
                 at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
                 at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
                 at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
            java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
                 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
                 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
                 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
                 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
                 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
                 at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:924)
                 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
                 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
                 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
                 at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3806)
                 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1667)
                 at com.hyperion.planning.sql.HspSQLImpl.executeQuery(Unknown Source)
                 at com.hyperion.planning.sql.HspSQLImpl.executeQuery(Unknown Source)
                 at com.hyperion.planning.sql.JDBCCacheLoader.loadObjects(Unknown Source)
                 at com.hyperion.planning.sql.JDBCCacheLoader.loadObjects(Unknown Source)
                 at com.hyperion.planning.sql.GenericCache.loadCache(Unknown Source)
                 at com.hyperion.planning.sql.GenericCache.getCache(Unknown Source)
                 at com.hyperion.planning.sql.GenericCache.getUnfilteredCache(Unknown Source)
                 at com.hyperion.planning.HspJSImpl.loadSystemCfg(Unknown Source)
                 at com.hyperion.planning.HspJSImpl.<init>(Unknown Source)
                 at com.hyperion.planning.HspJSHomeImpl.createHspJS(Unknown Source)
                 at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(Unknown Source)
                 at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(Unknown Source)
                 at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                 at HspLogOn.Handle(Unknown Source)
                 at HspLogOn.doPost(Unknown Source)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
                 at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
                 at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
                 at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
                 at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at HspValidationFilter.doFilter(Unknown Source)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
                 at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
                 at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
                 at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
                 at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
                 at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
                 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                 at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                 at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
                 at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
                 at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
                 at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
                 at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
            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(Unknown Source)
                 at com.hyperion.planning.sql.GenericCache.getCache(Unknown Source)
                 at com.hyperion.planning.sql.GenericCache.getUnfilteredCache(Unknown Source)
                 at com.hyperion.planning.HspJSImpl.loadSystemCfg(Unknown Source)
                 at com.hyperion.planning.HspJSImpl.<init>(Unknown Source)
                 at com.hyperion.planning.HspJSHomeImpl.createHspJS(Unknown Source)
                 at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(Unknown Source)
                 at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(Unknown Source)
                 at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                 at HspLogOn.Handle(Unknown Source)
                 at HspLogOn.doPost(Unknown Source)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
                 at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
                 at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
                 at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
                 at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
                 at HspValidationFilter.doFilter(Unknown Source)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
                 at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
                 at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
                 at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
                 at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
                 at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
                 at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
                 at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
                 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                 at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                 at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
                 at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
                 at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
                 at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
                 at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
            java.lang.NullPointerException
                 at com.hyperion.planning.HspJSImpl.loadSystemCfg(Unknown Source)
                 at com.hyperion.planning.HspJSImpl.<init>(Unknown Source)
                 at com.hyperion.planning.HspJSHomeImpl.createHspJS(Unknown Source)
                 at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(Unknown Source)
                 at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(Unknown Source)
                 at com.hyperion.planning.HyperionPlanningBean.Login(Unknown Source)
                 at HspLogOn.Handle(Unknown Source)
                 at HspLogOn.doPost(Unknown Source)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
                 at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
                 at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
                 at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
                 at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at HspValidationFilter.doFilter(Unknown Source)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
                 at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
                 at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
                 at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
                 at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
                 at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
                 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                 at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                 at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
                 at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
                 at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
                 at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
                 at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
            java.lang.NullPointerException
                 at com.hyperion.planning.HyperionPlanningBean.getPreferences(Unknown Source)
                 at HspLogOff.savePersistancePrefs(Unknown Source)
                 at HspLogOff.Handle(Unknown Source)
                 at HspLogOff.doGet(Unknown Source)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
                 at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
                 at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
                 at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
                 at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at HspValidationFilter.doFilter(Unknown Source)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
                 at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
                 at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
                 at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
                 at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
                 at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
                 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                 at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                 at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
                 at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
                 at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
                 at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
                 at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
            • 3. Re: Planning application issue
              JohnGoodwin
              Have a read of the following doc in Oracle Support - Error Logging Into Planning "An Error Occurred While Processing This Page. Check The Log For Details. Please Close The Current Tab and Open Application Again..." [ID 1315954.1]

              Cheers

              John
              http://john-goodwin.blogspot.com/
              • 4. Re: Planning application issue
                923301
                I definitely will John, Thanks