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

Last updated on FEBRUARY 21, 2023

Applies to:

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:

[XFM] [ERROR:1] [EPMHFM-07392] [XFM] [ecid: ] [File: XfmODBC.cpp] [Line: 203] [userId: ] [Msg arguments: ] [appName:<APPNAME>] [pid: 7012] [tid: 6348] Please note

...

[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: <ecid>] [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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.