Foundation Services Database Configuration Causes Errors Against Microsoft SQL*Server 2008 SP2

(Doc ID 2021249.1)

Last updated on MARCH 20, 2018

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:

 

[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: 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)

 

Changes

 

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