10 Replies Latest reply on Jun 17, 2013 4:43 PM by samacnt

    failed to navigate from registry

    ak123
      On a distributed install for 11.1.2.2 on win 2008 R2 64 bit, I was able to get Shared Services configured to a new schema. But when trying to configure R&A and Planning on another box I landed on "failed to navigate from registry wizard state error while initializing registry" while trying to perform a connect to shared services DB. I tried and tested the following:

      added entries to the host file, verified db connectivity, telnet to the db host everything is fine. Its an oracle database on a unix box. I have been able to use the same db for performing config on DEV and was successful at that .

      Any thoughts on this ?
        • 1. Re: failed to navigate from registry
          ak123
          [2013-02-20T08:38:41.892-08:00] [EPMINS] [TRACE] [EPMINS-00015] [oracle.EPMINS] [tid: 11] [ecid: 0000JnsRD7C5UcYTTq9xWc1H9FOB000004,0] [SRC_CLASS: com.hyperion.hit.wizard.AbstractWizardAction] Invoked action: navigation.next
          [2013-02-20T08:38:41.907-08:00] [EPMCFG] [WARNING] [EPMCFG-01001] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.config.document.Storage] trace: No database properties could be read
          [2013-02-20T08:38:42.063-08:00] [EPMCFG] [TRACE] [EPMCFG-01758] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.config.wizard.impl.DBConnectionForm] DB type is Oracle
          [2013-02-20T08:38:42.063-08:00] [EPMCFG] [TRACE] [EPMCFG-01114] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.AbstractProductDBConfigurator] JDBC driver class is oracle.jdbc.OracleDriver
          [2013-02-20T08:38:42.063-08:00] [EPMCFG] [TRACE] [EPMCFG-01115] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.AbstractProductDBConfigurator] Connection URL: jdbc:oracle:thin:@ <<<<<ORACLE_DB_HOST>>>>>>:1521:HYPDEV
          [2013-02-20T08:38:42.110-08:00] [EPMCFG] [TRACE] [EPMCFG-01116] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.AbstractProductDBConfigurator] DB Version check
          [2013-02-20T08:38:42.110-08:00] [EPMCFG] [TRACE] [EPMCFG-01020] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.AbstractProductDBConfigurator] Error:
          [2013-02-20T08:38:42.110-08:00] [EPMCFG] [TRACE] [EPMCFG-01020] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.AbstractProductDBConfigurator] Error:
          [2013-02-20T08:38:42.110-08:00] [EPMCFG] [TRACE] [EPMCFG-01020] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.AbstractProductDBConfigurator] Error:
          [2013-02-20T08:38:42.110-08:00] [EPMCFG] [TRACE] [EPMCFG-01117] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.AbstractProductDBConfigurator] majors(11 vs -1), minors(2 vs -1)
          [2013-02-20T08:38:42.110-08:00] [EPMCFG] [NOTIFICATION] [EPMCFG-01001] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.utils.CISUtilityHelper] trace: Database characterset: AL32UTF8
          [2013-02-20T08:38:42.110-08:00] [EPMCFG] [TRACE] [EPMCFG-01861] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.config.wizard.impl.RegistryWizardState] Re-using an existing registry, DBtype is ORACLE
          [2013-02-20T08:38:42.110-08:00] [EPMCFG] [TRACE] [EPMCFG-01858] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.config.wizard.impl.RegistryWizardState] JDBC URL: jdbc:oracle:thin:@ <<<<<ORACLE_DB_HOST>>>>>>:1521:HYPDEV
          [2013-02-20T08:38:42.157-08:00] [EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.config.document.Storage] trace: Found registry DB component
          [2013-02-20T08:38:42.172-08:00] [EPMCFG] [TRACE] [EPMCFG-01320] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.ConfigRegistryUtils] System component already exist in the registry: component type = SYSTEM9
          [2013-02-20T08:38:42.188-08:00] [EPMCFG] [TRACE] [EPMCFG-01322] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.ConfigRegistryUtils] Product component already exists in the registry: component type = FOUNDATION_SERVICES_PRODUCT
          [2013-02-20T08:38:42.188-08:00] [EPMCFG] [TRACE] [EPMCFG-01324] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.ConfigRegistryUtils] Registry database connection component already exists in the registry: component type = DATABASE_CONN
          [2013-02-20T08:38:42.188-08:00] [EPMCFG] [TRACE] [EPMCFG-01321] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.ConfigRegistryUtils] Creating product component: component type = SHARED_SERVICES_PRODUCT
          [2013-02-20T08:38:42.204-08:00] [EPMCFG] [TRACE] [EPMCFG-01322] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.ConfigRegistryUtils] Product component already exists in the registry: component type = SHARED_SERVICES_PRODUCT
          [2013-02-20T08:38:42.204-08:00] [EPMCFG] [TRACE] [EPMCFG-02135] [oracle.EPMCFG] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.cis.config.ConfigRegistryUtils] Setting hss mode to NOFUSIONAPPS
          [2013-02-20T08:38:44.762-08:00] [EPMINS] [ERROR] [EPMINS-00001] [oracle.EPMINS] [tid: 17] [ecid: 0000JnsUANn5UcYTTq9xWc1H9FOB000006,0] [SRC_CLASS: com.hyperion.hit.wizard.Wizard] trace: Error:[[
          com.hyperion.hit.wizard.FailedButRetryPossibleException: Error while initializing registry.
               at com.hyperion.config.wizard.impl.RegistryWizardState$1$1.commit(RegistryWizardState.java:359)
               at com.hyperion.hit.wizard.Wizard$NextClass.run(Wizard.java:544)
               at java.lang.Thread.run(Thread.java:662)
          Caused by: java.lang.NullPointerException
               at com.hyperion.cis.config.persistent.utils.RegistryUtils.populateSharedServicesConfigurationFromRegistry(RegistryUtils.java:192)
               at com.hyperion.cis.ConfigToolDocument.<init>(ConfigToolDocument.java:198)
               at com.hyperion.cis.config.document.PS1CTConfigurationLoader.updateConfigurationByRegistryData(PS1CTConfigurationLoader.java:119)
               at com.hyperion.config.document.DocumentUtills.updateConfigurationsByRegistryData(DocumentUtills.java:58)
               at com.hyperion.config.wizard.impl.RegistryWizardState$1$1.commit(RegistryWizardState.java:267)
          • 2. Re: failed to navigate from registry
            Vivek Chetiaparath
            I would recommend executing registry-cleanup script under user_projects/epmsystem(x)/bin folder and removing any problems existing already with the registry.

            The error says it cannot initialize registry so that means there is some tables not created/update correctly.

            You may also want to check the registry.log file,might have some clues.

            Thx
            • 3. Re: failed to navigate from registry
              hyperionEPM
              Hello,

              Do you have all the required privileges for the database? The following privileges are needed as per the Install Start here guide for 11.1.2.2

              CREATE SESSION
              DROP SESSION
              CREATE VIEW
              DROP VIEW
              CREATE TYPE
              DROP TYPE
              CREATE TABLE
              DROP TABLE
              CREATE CLUSTER
              DROP CLUSTER
              CREATE TRIGGER
              DROP TRIGGER
              CREATE SEQUENCE
              DROP SEQUENCE
              CREATE INDEX
              DROP INDEX
              CREATE INDEXTYPE
              DROP INDEXTYPE
              PREATE PROCEDURE
              DROP PROCEDURE

              Thanks,
              hyperionEPM
              • 4. Re: failed to navigate from registry
                samacnt

                Hello friend

                 

                                    In my case this error arise after the deletion of shared services database i.e. HSS . After the deletion what I did was cleaning of registry. So the error could not be solved by the running of registry cleanup.bat script.

                                         Can you provide some different solution

                Thanks in advance

                • 5. Re: failed to navigate from registry
                  Madhusudhan. M

                  Hi,

                  may be this link will help

                  https://forums.oracle.com/thread/2451861

                   

                  Cheers,

                  mady

                   

                  please mark the replies as helpful or correct

                  • 6. Re: failed to navigate from registry
                    samacnt

                    yes it did solve my problem

                     

                    Thanks for the reply

                    • 7. Re: failed to navigate from registry
                      Madhusudhan. M

                      hi,

                       

                      please close the discussion if your issue resolved.

                       

                      Cheers,

                      mady

                       

                      please mark the replies as helpful or correct to help others

                      • 8. Re: failed to navigate from registry
                        samacnt

                        I did not start this discussion. So probably I can't close this discussion . Tell me if there's any way to do so because I cant find any option as such here

                        • 9. Re: failed to navigate from registry
                          Madhusudhan. M

                          If we post as a question then we can close as answered.

                          If we post as a discussion, we can't close the discussion i think.

                           

                          so, leave it for now. Any way you have resolved the issue. Congrats.

                           

                          Cheers,

                          mady