7 Replies Latest reply on Aug 8, 2011 9:42 PM by Jasmine Pauline-Oracle

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

    878661
      Imported Hyperion Planning App into EPM 11.1.2.1 successfully. But it is throwing error while opening Planning Application.
      The errror Message as.

      An Error Occurred while processing this page.Check Log for details. Please Close the current tab and open application again

      Log Details: PlanningAppUpgradeLog_HypPlanapp:

      [26 Jul, 2011 4:45:58 PM]: 11.1.2.0 to 11.1.2.1
      [26 Jul, 2011 4:45:58 PM]: *******************************
      [26 Jul, 2011 4:45:58 PM]: Execute SQLs-E:\Oracle\Middleware\EPMSystem11R1\products\Planning\config\sql\11_1_2_1Migration_Oracle.sql
      [26 Jul, 2011 4:45:58 PM]: *******************************
      [26 Jul, 2011 4:45:58 PM]: Ignored Error -ORA-00942: table or view does not exist
      Executed line number1
      [26 Jul, 2011 4:45:58 PM]: Ignored Error -ORA-00942: table or view does not exist
      Executed line number2
      [26 Jul, 2011 4:45:59 PM]: Executed line number3
      [26 Jul, 2011 4:45:59 PM]: Executed line number4
      [26 Jul, 2011 4:45:59 PM]: Executed line number5
      [26 Jul, 2011 4:45:59 PM]: Executed line number6
      [26 Jul, 2011 4:45:59 PM]: Executed line number7
      [26 Jul, 2011 4:45:59 PM]: Executed line number8
      [26 Jul, 2011 4:45:59 PM]: Executed line number9
      [26 Jul, 2011 4:45:59 PM]: Executed line number10
      [26 Jul, 2011 4:45:59 PM]: Executed line number11
      [26 Jul, 2011 4:45:59 PM]: Executed line number12
      [26 Jul, 2011 4:45:59 PM]: Executed line number13
      [26 Jul, 2011 4:45:59 PM]: Executed line number14
      [26 Jul, 2011 4:45:59 PM]: Executed line number15
      [26 Jul, 2011 4:45:59 PM]: Executed line number16
      [26 Jul, 2011 4:45:59 PM]: Executed line number17
      [26 Jul, 2011 4:45:59 PM]: Executed line number18
      [26 Jul, 2011 4:45:59 PM]: Executed line number19
      [26 Jul, 2011 4:45:59 PM]: Executed line number20
      [26 Jul, 2011 4:45:59 PM]: Executed line number21
      [26 Jul, 2011 4:45:59 PM]: Executed line number22
      [26 Jul, 2011 4:45:59 PM]: Executed line number23
      [26 Jul, 2011 4:45:59 PM]: Executed line number24
      [26 Jul, 2011 4:45:59 PM]: Executed line number25
      [26 Jul, 2011 4:45:59 PM]: Executed line number26
      [26 Jul, 2011 4:45:59 PM]: Executed line number27
      [26 Jul, 2011 4:45:59 PM]: Executed line number28
      [26 Jul, 2011 4:45:59 PM]: Executed line number29
      [26 Jul, 2011 4:45:59 PM]: Executed line number30
      [26 Jul, 2011 4:45:59 PM]: Executed line number31
      [26 Jul, 2011 4:45:59 PM]: Executed line number32
      [26 Jul, 2011 4:45:59 PM]: Executed line number33
      [26 Jul, 2011 4:45:59 PM]: Executed line number34
      [26 Jul, 2011 4:45:59 PM]: Executed line number35
      [26 Jul, 2011 4:45:59 PM]: Updated Version and Release.
      [26 Jul, 2011 4:45:59 PM]: Your application has been successfully upgraded to the new release of Oracle® Hyperion Planning, Fusion Edition. Reopen the application.
      [26 Jul, 2011 4:46:00 PM]: Registering the migrated application hypplanapp with Shared Services...
      [26 Jul, 2011 4:46:00 PM]: Setting following properties:
      [26 Jul, 2011 4:46:00 PM]: User: admin AppName: Hypplanapp OlapServerName: Servername PlanTypes: [Plan1, Ops, Plan2, Wrkforce, Capex] BaseURL: http://ServerName:19000/HyperionPlanning/
      [26 Jul, 2011 4:46:00 PM]: Successfully registered the migrated application with Shared Services.
      [26 Jul, 2011 4:46:00 PM]: Updating CSS URL in HSP_SYSTEMCFG table...
      [26 Jul, 2011 4:46:00 PM]: CSS URL : http://servername:19000/interop
      [26 Jul, 2011 4:46:00 PM]: Updated CSS URL (EIE_SERVER) successfully in HSP_SYSTEMCFG table.
      [26 Jul, 2011 4:46:00 PM]: Migrating all user identities...
      [26 Jul, 2011 4:46:01 PM]: Getting updated user/group identities from CSS:
      [26 Jul, 2011 4:46:01 PM]: Total Identities sent to update: 11
      [26 Jul, 2011 4:46:01 PM]: Ambiguous entries Count:0
      [26 Jul, 2011 4:46:01 PM]: Ignored entries Count:0
      [26 Jul, 2011 4:46:01 PM]: Identical entries Count:0
      [26 Jul, 2011 4:46:01 PM]: Updated entries Count:0
      [26 Jul, 2011 4:46:01 PM]: Deleted entries Found. Count = 11. Either the users/groups were deprovisioned or the security provider is not configured/reachable. The identities for these will not be updated.
      [26 Jul, 2011 4:46:01 PM]: Successfully migrated all user identities.
      [26 Jul, 2011 4:46:01 PM]: Successfully migrated the application hypplanapp to current version.

      Please help me out to solve this issue.

      Edited by: 875658 on Jul 28, 2011 12:52 AM

      Edited by: 875658 on Jul 28, 2011 10:04 PM
        • 1. Re: Hyperion Planning Error, while opening App
          JohnGoodwin
          That is the upgrade log you have posted, if you are on windows the have a look at the two planning logs in the diagnostics\logs\services folder

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: Hyperion Planning Error, while opening App
            878661
            John Thanks for quick reply. Pls cjheck my Log files, shown below

            LOGNAME: HyS9Planning-syserr

            Creating rebind thread to RMI
            Query Failed: SQL_GET_DIMENSIONS: 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.db.HspDEDBImpl.resetCacheRoots(Unknown Source)
                 at com.hyperion.planning.db.HspDEDBImpl.initCache(Unknown Source)
                 at com.hyperion.planning.db.HspDEDBImpl.initializeDB(Unknown Source)
                 at com.hyperion.planning.HspJSImpl.createDBs(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

            Edited by: 875658 on Jul 28, 2011 9:58 PM
            • 3. Re: Hyperion Planning Error, while opening App
              878661
              LOG NAME: HyS9Planning-sysout

              <26 Jul, 2011 8:13:52 PM IST> <Info> <Security> <BEA-090905> <Disabling CryptoJ JCE Provider self-integrity check for better startup performance. To enable this check, specify -Dweblogic.security.allowCryptoJDefaultJCEVerification=true>
              <26 Jul, 2011 8:13:52 PM IST> <Info> <Security> <BEA-090906> <Changing the default Random Number Generator in RSA CryptoJ from ECDRBG to FIPS186PRNG. To disable this change, specify -Dweblogic.security.allowCryptoJDefaultPRNG=true>
              <26 Jul, 2011 8:13:53 PM IST> <Info> <WebLogicServer> <BEA-000377> <Starting WebLogic Server with Oracle JRockit(R) Version R28.0.2-11-135406-1.6.0_20-20100624-2119-windows-x86_64 from Oracle Corporation>
              <26 Jul, 2011 8:14:00 PM IST> <Info> <Management> <BEA-141107> <Version: WebLogic Server 10.3.4.0 Fri Dec 17 20:47:33 PST 2010 1384255 >
              <26 Jul, 2011 8:14:05 PM IST> <Emergency> <Management> <BEA-141151> <The admin server could not be reached at http://localhost:7001.>
              <26 Jul, 2011 8:14:05 PM IST> <Info> <Configuration Management> <BEA-150018> <This server is being started in managed server independence mode in the absence of the admin server.>
              <26 Jul, 2011 8:14:05 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING>
              <26 Jul, 2011 8:14:05 PM IST> <Info> <WorkManager> <BEA-002900> <Initializing self-tuning thread pool>
              <26 Jul, 2011 8:14:06 PM IST> <Notice> <LoggingService> <BEA-320400> <The log file E:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\Planning0\logs\Planning0.log will be rotated. Reopen the log file if tailing has stopped. This can happen on some platforms like Windows.>
              <26 Jul, 2011 8:14:06 PM IST> <Notice> <LoggingService> <BEA-320401> <The log file has been rotated to E:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\Planning0\logs\Planning0.log00043. Log messages will continue to be logged in E:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\Planning0\logs\Planning0.log.>
              <26 Jul, 2011 8:14:06 PM IST> <Notice> <Log Management> <BEA-170019> <The server log file E:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\Planning0\logs\Planning0.log is opened. All server side log events will be written to this file.>
              <26 Jul, 2011 8:14:25 PM IST> <Notice> <Security> <BEA-090082> <Security initializing using security realm myrealm.>
              <26 Jul, 2011 8:14:32 PM IST> <Warning> <JTA> <BEA-110503> <The migrator(the AdminServer for manual JTA migration policy, or the Singleton Master for automatic JTA migration policy) is not available. Will skip JTA TRS failback because isStrictOwnershipCheck is [false]. This may lead to potencial TLOG corruption if TRS of Planning0 has been migrated to backup server and the backup server is accessing the TLOG of Planning0. More safety can be achieved by setting isStrictOwnershipCheck to [true].>
              <26 Jul, 2011 8:15:01 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STANDBY>
              <26 Jul, 2011 8:15:01 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING>
              Calling getConnection()
              return weblogic.management.jmx.mbeanserver.WLSMBeanServer@a003a3
              Calling getDomainConfiguration()
              Calling getConnection()
              return weblogic.management.jmx.mbeanserver.WLSMBeanServer@a003a3
              Calling getRuntimeService()
              Calling getConnection()
              return weblogic.management.jmx.mbeanserver.WLSMBeanServer@a003a3
              return com.bea:Name=RuntimeService,Type=weblogic.management.mbeanservers.runtime.RuntimeServiceMBean
              return com.bea:Name=EPMSystem,Type=Domain
              Calling getConnection()
              return weblogic.management.jmx.mbeanserver.WLSMBeanServer@a003a3
              Domain location is 'E:\Oracle\Middleware\user_projects\domains\EPMSystem'
              Calling getRuntimeService()
              return com.bea:Name=RuntimeService,Type=weblogic.management.mbeanservers.runtime.RuntimeServiceMBean
              Calling getConnection()
              return weblogic.management.jmx.mbeanserver.WLSMBeanServer@a003a3
              Calling getConnection()
              return weblogic.management.jmx.mbeanserver.WLSMBeanServer@a003a3
              Calling getConnection()
              return weblogic.management.jmx.mbeanserver.WLSMBeanServer@a003a3
              Calling getConnection()
              return weblogic.management.jmx.mbeanserver.WLSMBeanServer@a003a3
              Checking E:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\Planning0\registry_update.xml file
              EPM_ORACLE_HOME: E:\Oracle\Middleware\EPMSystem11R1
              Template for PLANNING#11.1.2.0: E:\Oracle\Middleware\EPMSystem11R1\common\templates\applications\epm_planning_11.1.2.1.jar
              Dependencies for E:\Oracle\Middleware\EPMSystem11R1\common\templates\applications\epm_planning_11.1.2.1.jar: []
              BPMUI shared webapp not referenced from PLANNING#11.1.2.0
              Application name: PLANNING#11.1.2.0
              Application source: HyperionPlanning.ear
              Server name: Planning0
              Server port: 8300
              Server SSL port: 8343
              Application context: HyperionPlanning
              Registry product type: PLANNING_PRODUCT
              Registry physical web application type: PLANNING_WEBAPP
              weblogic.Name property is 'Planning0', seems to be WebLogic mode
              registry.isRegistryDatabaseCreated()true
              Registry was initialized sucessfully
              Executing pre custom update for PLANNING#11.1.2.0
              EPM_ORACLE_INSTANCE: E:\Oracle\Middleware\user_projects\epmsystem1
              Physical Web App found
              Web app already linked to some application server: false
              The registry was not modifyed because it already containse all sturctures
              Web app is already linked to the logical web app
              No needs to run custom updater for PLANNING#11.1.2.0
              loggingUpdatePLANNING.block file exist or the system is running in the Fusion mode, skipping logging.xml configuration
              Planning locale: en_IN
              <26 Jul, 2011 8:15:45 PM IST> <Notice> <Cluster> <BEA-000197> <Listening for announcements from cluster using unicast cluster messaging>
              <26 Jul, 2011 8:15:45 PM IST> <Notice> <Cluster> <BEA-000133> <Waiting to synchronize with other running members of Planning.>
              <26 Jul, 2011 8:15:50 PM IST> <Warning> <Log Management> <BEA-170011> <The LogBroadcaster on this server failed to broadcast log messages to the admin server. The Admin server may not be running. Message broadcasts to the admin server will be disabled.>
              <26 Jul, 2011 8:16:15 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to ADMIN>
              <26 Jul, 2011 8:16:16 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RESUMING>
              <26 Jul, 2011 8:16:24 PM IST> <Notice> <Cluster> <BEA-000162> <Starting "async" replication service with remote cluster address "null">
              <26 Jul, 2011 8:16:24 PM IST> <Notice> <Security> <BEA-090171> <Loading the identity certificate and private key stored under the alias DemoIdentity from the jks keystore file E:\Oracle\MIDDLE~1\WLSERV~1.3\server\lib\DemoIdentity.jks.>
              • 4. Re: Hyperion Planning Error, while opening App
                Jasmine Pauline-Oracle
                Are the tables present in the Planning application repository?
                What is the permission in the DB for the Planning database user in the upgraded version?

                HTH-
                Jasmine.
                • 5. Re: Hyperion Planning Error, while opening App
                  JohnGoodwin
                  When you upgraded the application the table HSP_JOB_STATUS was missing, check this table exists, if it doesn't exist can you explain what upgrade you have done because 11.1.2 would have the table before upgrading.

                  Cheers

                  John
                  http://john-goodwin.blogspot.com/
                  • 6. Re: Hyperion Planning Error, while opening App
                    878661
                    Once again i tried to import the planning app file and checked log file. pls find below and provide solution

                    IMP-00058: ORACLE error 1017 encountered
                    ORA-01017: invalid username/password; logon deniedUsername:
                    IMP-00058: ORACLE error 1017 encountered
                    ORA-01017: invalid username/password; logon deniedUsername:
                    Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
                    With the Partitioning, OLAP, Data Mining and Real Application Testing options

                    Export file created by EXPORT:V11.01.00 via conventional path
                    import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
                    About to enable constraints...
                    Import terminated successfully with warnings.
                    • 7. Re: Hyperion Planning Error, while opening App
                      Jasmine Pauline-Oracle
                      There is some issue with the database. Check if the password you are using is right.

                      HTH-
                      Jasmine.