Foundation Services Database Configuration Causes Errors Against Microsoft SQL*Server 2008 SP2 (Doc ID 2021249.1)

Last updated on OCTOBER 06, 2016

Applies to:

Hyperion BI+ - Version 11.1.2.3.000 and later
Microsoft SQLServer - Version 2008 R2 to 2008 R2
Information in this document applies to any platform.

Symptoms

Configuration of Foundation Services database displays completed and the task bar says 100 % but it never finishes.

The configtool.log contains the following errors:

...

[SRC_CLASS: com.hyperion.config.wizard.impl.RegistryWizardState] Error: [[
com.hyperion.hit.registry.exceptions.RegistryException: Failed to update DB values in the Registry:
    at com.hyperion.config.wizard.impl.RegistryWizardState.updateRegistryDbComponent(RegistryWizardState.java:729)
    at com.hyperion.config.wizard.impl.RegistryWizardState.access$900(RegistryWizardState.java:74)
    at com.hyperion.config.wizard.impl.RegistryWizardState$1$1.commit(RegistryWizardState.java:367)
    at com.hyperion.hit.wizard.Wizard$NextClass.run(Wizard.java:566)
    at java.lang.Thread.run(Thread.java:662)
Caused by: com.hyperion.hit.registry.exceptions.RegistryException: FOUNDATION_SERVICES_PRODUCT doesn't have children DATABASE_CONN
    at com.hyperion.config.wizard.impl.RegistryWizardState.updateRegistryDbComponent(RegistryWizardState.java:722)

...

Failed to populate Foundation Services trusted key in the registry. Component SYSTEM9/FOUNDATION_SERVICES_PRODUCT/SHARED_SERVICES_PRODUCT is null in EPM System Registry. Verify EPM System Registry configuration.
    at com.hyperion.css.registry.RegistryManager.initRegistry(RegistryManager.java:146)
    at com.hyperion.css.registry.RegistryManager.<init>(RegistryManager.java:122)
    at com.hyperion.css.registry.RegistryManager.populateCSSTrustedServicesKey(RegistryManager.java:273)
    at com.hyperion.foundation.config.FoundationDbConfigurator.populateCssTrustedKey(FoundationDbConfigurator.java:185)
    at com.hyperion.foundation.config.FoundationDbConfigurator.configure(FoundationDbConfigurator.java:119)
    at com.hyperion.config.wizard.impl.RunAllTasks.executeDbConfigTask(RunAllTasks.java:650)
    at com.hyperion.config.wizard.impl.RunAllTasks.execute(RunAllTasks.java:296)
    at com.hyperion.config.wizard.impl.RunnAllTasksState.run(RunnAllTasksState.java:92)
    at java.lang.Thread.run(Thread.java:662)

...

[SRC_CLASS: com.hyperion.cis.utils.PortManager] Bad Registry: unable to get SYSTEM9 component.
[ERROR] [EPMERR-00000] [oracle.EPMCFG] [tid: 19] [ecid: 0000Krd72FX5MeK5qVs1yY1LUm^l000006,0] [SRC_CLASS: com.hyperion.config.wizard.impl.AppServerConfigurationForm] [[
java.util.MissingResourceException: Can't find resource for bundle java.util.PropertyResourceBundle, key EPMCMN-01001
    at java.util.ResourceBundle.getObject(ResourceBundle.java:374)
    at java.util.ResourceBundle.getString(ResourceBundle.java:334)
    at com.oracle.hit.logging.EPMLogger.error(EPMLogger.java:365)
    at com.hyperion.config.wizard.impl.AppServerConfigurationForm.updateFields(AppServerConfigurationForm.java:429)
    at com.hyperion.config.wizard.impl.AppServerConfigurationState.getForm(AppServerConfigurationState.java:49)
    at com.hyperion.hit.wizard.Wizard.changeState(Wizard.java:447)
    at com.hyperion.hit.wizard.Wizard.access$1500(Wizard.java:47)
    at com.hyperion.hit.wizard.Wizard$NextClass.run(Wizard.java:574)
    at java.lang.Thread.run(Thread.java:662)

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms