4 Replies Latest reply: Dec 10, 2012 8:45 AM by user5434116 RSS

    Receive error when re-instaling/reconfiguring/reregistering Essbase 11.1.2

    792319
      Hello All,
      Is it possible to uninstall/reinstall Essbase studio in Hyperion 11.1.2 after it has already been registered with Shared Services? I uninstalled/re-installed Essbase Studio and received an error when I treid to re-configure it. the error states "EPMCFG-10372:The database does not contain Shared Services information. Verify the database connection information". I have verified and I am properly connecting to the HSS database. I went and looked at the confi log and this is what I am seeing. Thank you in advance for any help that you can provide.


      [2010-08-18T22:58:10.136-07:00] [EPMCFG] [ERROR] [EPMCFG-01001] [oracle.EPMCFG] [tid: 14] [ecid: 0000Ie8vGbOD0jWjLxiOOA1CRCV8000005,0] [SRC_CLASS: com.hyperion.config.document.Storage] trace: {0}[[
      com.hyperion.hit.registry.exceptions.RegistryException: com.hyperion.hit.registry.exceptions.RegistryException: No database properties could be read
           at com.hyperion.hit.registry.Registry.releaseInstance(Registry.java:2039)
           at com.hyperion.config.document.Storage.resetRegistryItems(Storage.java:811)
           at com.hyperion.config.document.Storage.resetRegistry(Storage.java:798)
           at com.hyperion.config.wizard.impl.RegistryWizardState$1.validate(RegistryWizardState.java:348)
           at com.hyperion.hit.wizard.Wizard$NextClass.run(Wizard.java:504)
           at java.lang.Thread.run(Thread.java:619)
      Caused by: com.hyperion.hit.registry.exceptions.RegistryException: No database properties could be read
           at com.hyperion.hit.registry.datasource.SharedServicesDataSourceFactory.getDataSource(SharedServicesDataSourceFactory.java:29)
           at com.hyperion.hit.registry.datasource.SharedServicesDatabaseConnectionBuilder.getConnection(SharedServicesDatabaseConnectionBuilder.java:26)
           at com.hyperion.hit.registry.RegistryUtils.createNewConnection(RegistryUtils.java:183)
           at com.hyperion.hit.registry.RegistryConnection.getInstance(RegistryConnection.java:149)
           at com.hyperion.hit.registry.Registry.releaseInstance(Registry.java:2030)
           ... 5 more

      ]]
      [2010-08-18T22:58:10.933-07:00] [EPMCFG] [TRACE] [EPMCFG-01758] [oracle.EPMCFG] [tid: 14] [ecid: 0000Ie8vGbOD0jWjLxiOOA1CRCV8000005,0] [SRC_CLASS: com.hyperion.config.wizard.impl.DBConnectionForm] DB type is MSSQLServer
      [2010-08-18T22:58:10.949-07:00] [EPMCFG] [TRACE] [EPMCFG-05922] [oracle.EPMCFG] [tid: 14] [ecid: 0000Ie8vGbOD0jWjLxiOOA1CRCV8000005,0] [SRC_CLASS: com.hyperion.install.sw.SoftwareRegistry] Adding Hyperion Home entry...
      [2010-08-18T22:58:10.949-07:00] [EPMCFG] [TRACE] [EPMCFG-01114] [oracle.EPMCFG] [tid: 14] [ecid: 0000Ie8vGbOD0jWjLxiOOA1CRCV8000005,0] [SRC_CLASS: com.hyperion.cis.config.AbstractProductDBConfigurator] JDBC driver class is weblogic.jdbc.sqlserver.SQLServerDriver
      [2010-08-18T22:58:10.949-07:00] [EPMCFG] [TRACE] [EPMCFG-01115] [oracle.EPMCFG] [tid: 14] [ecid: 0000Ie8vGbOD0jWjLxiOOA1CRCV8000005,0] [SRC_CLASS: com.hyperion.cis.config.AbstractProductDBConfigurator] Connection URL: jdbc:weblogic:sqlserver://ethype-sql.sierra.local:1433;databaseName=hss;loadLibraryPath=E:\Oracle\Middleware\wlserver_10.3\server\lib
        • 1. Re: Receive error when re-instaling/reconfiguring/reregistering Essbase 11.1.2
          792319
          Hello All,
          I did not find a way to recover from this. I dropped the HSS DB, renamed the <Oracle/Hyperion Home>\Oracle\Middleware\user_projects\epmsystem1 directory, and reconfigured everything, please note that the first time around I reused all the D'sB. Everything was working fine with the exception of the Framework Agent service. It would initially startup fine but then hung in a "stopping" state. The error logs produced the below. Lessons learned. #1. If you are going to uninstall anything from Hyperion 11.1.2, I discovered that if you first shut all services down, then also take the HSS DB offline, and then uninstall, you will not have to reconfigure everything. You will however need to go into HSS web console and delete whichever component you uninstalled or else you will have two of the same things within Shared Services. #2. If you have to reconfigure everything, it is not okay to reuse the FR DB.


          [2010-08-19T09:26:12.859-07:00] [EPMRAF] [WARNING] [] [oracle.EPMRAF.stdout] [tid: 15] [ecid: 0000IeBB0VSD0jWjLxrI8A1CRLgR000007,0] Agent RM2 registered.
          [2010-08-19T09:26:13.264-07:00] [EPMRAF] [WARNING] [] [oracle.EPMRAF.stdout] [tid: 10] [ecid: 0000IeBAyp2D0jWjLxrI8A1CRLgR000003,0] SB2 UNAVAILABLE, to fetch the configuration data
          [2010-08-19T09:26:13.264-07:00] [EPMRAF] [WARNING] [] [oracle.EPMRAF.stdout] [tid: 10] [ecid: 0000IeBAyp2D0jWjLxrI8A1CRLgR000003,0] java.lang.IndexOutOfBoundsException: Index: 0, Size: 0[[
               at java.util.ArrayList.RangeCheck(ArrayList.java:547)
               at java.util.ArrayList.get(ArrayList.java:322)
               at com.brio.one.config.utils.RegistryUtil.getWorkspaceServiceProperties(Unknown Source)
               at com.brio.one.config.utils.RegistryUtil.getWorkspaceServiceProperty(Unknown Source)
               at com.sqribe.transformer.SAConfig.populateMaxConnections(Unknown Source)
               at com.sqribe.transformer.SAConfig.populate(Unknown Source)
               at com.sqribe.transformer.DBConfig.populate(Unknown Source)
               at com.sqribe.transformer.MultiTypeServerConfig.populate(Unknown Source)
               at com.sqribe.transformer.ServiceBrokerConfig.createAgent(Unknown Source)
               at com.sqribe.transformer.ServiceBrokerConfig.populate(Unknown Source)
               at com.sqribe.transformer.AgentConfigurationData.createAgent(Unknown Source)
               at com.sqribe.transformer.AgentConfigurationData.get(Unknown Source)
               at com.sqribe.transformer.BootStrapUtils.getSAConfigurationData(Unknown Source)
               at com.sqribe.transformer.ServiceBrokerImpl.init(Unknown Source)
               at com.sqribe.transformer.ServiceThread.init(Unknown Source)
               at com.brio.one.system.Server.initializeService(Unknown Source)
               at com.brio.one.system.Server.initialize(Unknown Source)
               at com.brio.one.system.Server.initialize(Unknown Source)
               at com.brio.one.system.Server.main(Unknown Source)
               at com.sqribe.transformer.SuperServerImpl.main(Unknown Source)

          ]]

          more junk here in between

          0000012a8b2bd306-0009-c12c-c0a823e2.00000114d0804fa9-0002-0607-c0a8ad15.11-1-2-0-0-515::::SK_0000012a8b2bd306-0009-c12c-c0a823e2_ethypeweb.sierra.local
          [2010-08-19T09:26:18.609-07:00] [EPMRAF] [WARNING] [] [oracle.EPMRAF.stdout] [tid: 10] [ecid: 0000IeBAyp2D0jWjLxrI8A1CRLgR000003,0] activated 0000012a8b2bd306-0009-c12c-c0a823e2.00000114d0804fa9-0002-0607-c0a8ad15.11-1-2-0-0-515::::SK_0000012a8b2bd306-0009-c12c-c0a823e2_ethypeweb.sierra.local
          [2010-08-19T09:26:18.609-07:00] [EPMRAF] [WARNING] [] [oracle.EPMRAF.stdout] [tid: 10] [ecid: 0000IeBAyp2D0jWjLxrI8A1CRLgR000003,0] Checking if all services have initialized
          [2010-08-19T09:26:18.609-07:00] [EPMRAF] [WARNING] [] [oracle.EPMRAF.stdout] [tid: 10] [ecid: 0000IeBAyp2D0jWjLxrI8A1CRLgR000003,0] 15 out of 16 services have initialized
          [2010-08-19T09:26:18.609-07:00] [EPMRAF] [WARNING] [] [oracle.EPMRAF.stdout] [tid: 10] [ecid: 0000IeBAyp2D0jWjLxrI8A1CRLgR000003,0] Waiting for remaining services to initialize...
          [2010-08-19T09:26:31.387-07:00] [EPMRAF] [WARNING] [] [oracle.EPMRAF.stdout] [tid: 10] [ecid: 0000IeBAyp2D0jWjLxrI8A1CRLgR000003,0] Waiting for remaining services to initialize...
          • 2. Re: Receive error when re-instaling/reconfiguring/reregistering Essbase 11.1.2
            742807
            Hi,
            I am facing same issue:

            While running the configuration utility on Windows Server we are getting the following Error
            "EPMCFG-10372: The database does not contain Shared Services information. Verify the database connection information"

            My environement was:
            SUN SOLARIS 64bit, Oralce 10g
            Windows 64bit

            I installed Foundation services, Essbase and Planning in sun solaris environment and configured well.
            I have instllaed on EPMA,web analysis and FR on windows box. When I am tring to configure EPMA,web analysis and FR to the foundation services(Here fundation services installed on SUN SOLARIS BOX) it throughed above error.

            Please give me inputs indetails steps.

            Thanks & Regards,
            Babu
            • 3. Re: Receive error when re-instaling/reconfiguring/reregistering Essbase 11.1.2
              838345
              Hallo guys,

              Please be sure that all common components were installed correctly.

              I you do not need to install Foundation Services, for example because you are installing just Essbase in standalone mode, then try this one:

              Start configuration process with option –forceRegistry (see this thread [https://kr.forums.oracle.com/forums/thread.jspa?threadID=1070820] )

              To do this, follow the following steps:

              1. Open cmd console as administrator
              2. Navigate to HYPERION_HOME\EPMSystem11R1\common\config\11.1.2.0
              3. Execute startconfigtool.bat –forceRegistry

              It worked for me

              Regards,

              Mojito

              Edited by: Mojito on 13.11.2011 13:40
              • 4. Re: Receive error when re-instaling/reconfiguring/reregistering Essbase 11.1.2
                user5434116
                Hey Mojito...Nice...it worked for me..