This discussion is archived
7 Replies Latest reply: Dec 6, 2012 8:14 AM by 866532 RSS

"Configure Database" fails for the HFM

866532 Newbie
Currently Being Moderated
Can some help me with this issue. I recently applied the 11.1.2.1 Maintenance Release on 11.1.2.0 Env. "Configure Database" fails for the HFM, I havent made any changes to TNSnames.ora file, not sure what Entry it is looking for ?
I deleted all the FM entries using epmsys_registry, but still it fails.


[2012-10-12T16:59:54.083-04:00] [EPMCFG] [NOTIFICATION] [EPMCFG-02080] [oracle.EPMCFG] [tid: 19] [ecid: 0000JdMladfEkJ8zngvH831GU8IL000004,0] [SRC_CLASS: com.hyperion.hfm.config.hfmregistry.HFMRegistry] TNS parsing: Entry: ORCL[[
     Address: Protocol:(TCP) Host:(HyPServer) Port:(1521)
     SID:(orcl)
]]
[2012-10-12T16:59:54.083-04:00] [EPMCFG] [WARNING] [EPMCFG-02084] [oracle.EPMCFG] [tid: 19] [ecid: 0000JdMladfEkJ8zngvH831GU8IL000004,0] [SRC_CLASS: com.hyperion.hfm.config.hfmregistry.HFMRegistry] Error while configuring HFM Database: {0}[[
com.hyperion.hfm.config.hfmregistry.TNSEntryException: Entry does not exist for these parameters in tnsnames.ora file.
     at com.hyperion.hfm.config.hfmregistry.HFMRegistry.configureHFMDataBase(HFMRegistry.java:1034)
     at com.hyperion.hfm.config.HfmDbConfigurator.configure(HfmDbConfigurator.java:141)
     at com.hyperion.config.wizard.impl.RunAllTasks.executeDbConfigTask(RunAllTasks.java:863)
     at com.hyperion.config.wizard.impl.RunAllTasks.execute(RunAllTasks.java:489)
     at com.hyperion.config.wizard.impl.RunnAllTasksState.run(RunnAllTasksState.java:90)
     at java.lang.Thread.run(Thread.java:619)

]]
[2012-10-12T16:59:54.083-04:00] [EPMCFG] [ERROR] [EPMCFG-05020] [oracle.EPMCFG] [tid: 19] [ecid: 0000JdMladfEkJ8zngvH831GU8IL000004,0] [SRC_CLASS: com.hyperion.hfm.config.HfmDbConfigurator] Error: Error while configuring HFM DatabaseEntry does not exist for these parameters in tnsnames.ora file.
[2012-10-12T16:59:54.083-04:00] [EPMCFG] [ERROR] [EPMCFG-01020] [oracle.EPMCFG] [tid: 19] [ecid: 0000JdMladfEkJ8zngvH831GU8IL000004,0] [SRC_CLASS: com.hyperion.config.wizard.impl.RunAllTasks] Error: [[
com.hyperion.cis.config.ProcessingException
     at com.hyperion.hfm.config.HfmDbConfigurator.configure(HfmDbConfigurator.java:155)
     at com.hyperion.config.wizard.impl.RunAllTasks.executeDbConfigTask(RunAllTasks.java:863)
     at com.hyperion.config.wizard.impl.RunAllTasks.execute(RunAllTasks.java:489)
     at com.hyperion.config.wizard.impl.RunnAllTasksState.run(RunnAllTasksState.java:90)
     at java.lang.Thread.run(Thread.java:619)

]]
  • 1. Re: "Configure Database" fails for the HFM
    hyperionEPM Journeyer
    Currently Being Moderated
    Hello,

    Following is what I found under EPM_Tips_Issues Guide

    This error symptom indicates that EPM System Configurator has issues finding the tnsnames entry in tnsnames.ora needed for proper Financial Management configuration.

    Two separate issues have been reported, and both relate to the Oracle 11.2 database client
    installation:

    *1. Path reference to the bin folder*

    The logic that checks the tnsnames.ora location is case-sensitive and tries to parse the “bin” (in lowercase) folder in this path: D:\Oracle\app\product\11.2.0\client_1\BIN\OraOLEDB11.dll. However, the actual path contains “BIN” in uppercase and hence the configuration fails.

    As a workaround, rename “BIN” to “bin”:

    D:\Oracle\app\product\11.2.0\client_1\BIN to: D:\Oracle\app\product\11.2.0\client_1\bin

    Then reconfigure the Financial Management database again.

    *2. Registry key*

    Change the HKEY_CLASSES_ROOT\CLSID\{3F63C36E-51A3-11D2-BB7D-00C04FA30080}\InprocServer32 value data to use lowercase “bin” folder in the
    path; e.g., D:\Oracle\app\product\11.2.0\client_1\bin\OraOLEDB11.dll.

    Make the changes as mentioned and then try to configure the Database for HFM and let us know the updates.

    Thanks,
    HyperEPM
  • 2. Re: "Configure Database" fails for the HFM
    866532 Newbie
    Currently Being Moderated
    HyperEPM thank you, I tried your suggestion...it didn't work for me. Is there something else I can try.
  • 3. Re: "Configure Database" fails for the HFM
    hyperionEPM Journeyer
    Currently Being Moderated
    Hello,

    It is worth having a look at the following document on Oracle support -

    *Financial Management Database Configuration Fails [ID 1296214.1]*

    Thanks,
    HyperEPM.

    Please mark the answers helpful or correct for the other people for easy access_
  • 4. Re: "Configure Database" fails for the HFM
    Nicholas King Journeyer
    Currently Being Moderated
    I would first make sure you can successfully tnsping the sid of your db instances from the hfm server via a cmd prompt. That would allow you to narrow down if it's a db client config issue or a hyperion issue.

    Nick
  • 5. Re: "Configure Database" fails for the HFM
    866532 Newbie
    Currently Being Moderated
    I am able to TNSPing the SID from the command prompt.

    I also tried KM ID # 1296214.1

    Still getting the same error in the config.log

    [2012-12-04T09:37:22.318-05:00] [EPMCFG] [TRACE] [EPMCFG-06062] [oracle.EPMCFG] [tid: 19] [ecid: 0000JhaLsX3EkJ8zngvH831GjW_z000004,0] [SRC_CLASS: com.hyperion.hfm.config.hfmregistry.HFMRegistry] Oracle DB CLSID default value: {3F63C36E-51A3-11D2-BB7D-00C04FA30080}
    [2012-12-04T09:37:22.318-05:00] [EPMCFG] [TRACE] [EPMCFG-06063] [oracle.EPMCFG] [tid: 19] [ecid: 0000JhaLsX3EkJ8zngvH831GjW_z000004,0] [SRC_CLASS: com.hyperion.hfm.config.hfmregistry.HFMRegistry] Oracle DB file path to OraOLEDB10.dll: D:\ORCL\Database\client\bin\OraOLEDB11.DLL
    [2012-12-04T09:37:22.318-05:00] [EPMCFG] [TRACE] [EPMCFG-06038] [oracle.EPMCFG] [tid: 19] [ecid: 0000JhaLsX3EkJ8zngvH831GjW_z000004,0] [SRC_CLASS: com.hyperion.hfm.config.hfmregistry.HFMRegistry] File path to tnsnames.ora file: D:\ORCL\Database\client\network\admin\tnsnames.ora
    [2012-12-04T09:37:22.318-05:00] [EPMCFG] [NOTIFICATION] [EPMCFG-02080] [oracle.EPMCFG] [tid: 19] [ecid: 0000JhaLsX3EkJ8zngvH831GjW_z000004,0] [SRC_CLASS: com.hyperion.hfm.config.hfmregistry.HFMRegistry] TNS parsing: Entry: ORCL[[
         Address: Protocol:(TCP) Host:(demodrive) Port:(1521)
         SID:(orcl)


    ]]
    [2012-12-04T09:37:22.318-05:00] [EPMCFG] [WARNING] [EPMCFG-02084] [oracle.EPMCFG] [tid: 19] [ecid: 0000JhaLsX3EkJ8zngvH831GjW_z000004,0] [SRC_CLASS: com.hyperion.hfm.config.hfmregistry.HFMRegistry] Error while configuring HFM Database: {0}[[
    com.hyperion.hfm.config.hfmregistry.TNSEntryException: Entry does not exist for these parameters in tnsnames.ora file.
         at com.hyperion.hfm.config.hfmregistry.HFMRegistry.configureHFMDataBase(HFMRegistry.java:1034)
         at com.hyperion.hfm.config.HfmDbConfigurator.configure(HfmDbConfigurator.java:141)
         at com.hyperion.config.wizard.impl.RunAllTasks.executeDbConfigTask(RunAllTasks.java:863)
         at com.hyperion.config.wizard.impl.RunAllTasks.execute(RunAllTasks.java:489)
         at com.hyperion.config.wizard.impl.RunnAllTasksState.run(RunnAllTasksState.java:90)
         at java.lang.Thread.run(Thread.java:619)

    ]]
    [2012-12-04T09:37:22.318-05:00] [EPMCFG] [ERROR] [EPMCFG-05020] [oracle.EPMCFG] [tid: 19] [ecid: 0000JhaLsX3EkJ8zngvH831GjW_z000004,0] [SRC_CLASS: com.hyperion.hfm.config.HfmDbConfigurator] Error: Error while configuring HFM DatabaseEntry does not exist for these parameters in tnsnames.ora file.
    [2012-12-04T09:37:22.318-05:00] [EPMCFG] [ERROR] [EPMCFG-01020] [oracle.EPMCFG] [tid: 19] [ecid: 0000JhaLsX3EkJ8zngvH831GjW_z000004,0] [SRC_CLASS: com.hyperion.config.wizard.impl.RunAllTasks] Error: [[
    com.hyperion.cis.config.ProcessingException
         at com.hyperion.hfm.config.HfmDbConfigurator.configure(HfmDbConfigurator.java:155)
         at com.hyperion.config.wizard.impl.RunAllTasks.executeDbConfigTask(RunAllTasks.java:863)
         at com.hyperion.config.wizard.impl.RunAllTasks.execute(RunAllTasks.java:489)
         at com.hyperion.config.wizard.impl.RunnAllTasksState.run(RunnAllTasksState.java:90)
         at java.lang.Thread.run(Thread.java:619)

    ]]
  • 6. Re: "Configure Database" fails for the HFM
    hyperionEPM Journeyer
    Currently Being Moderated
    Can you paste the contents of tnsnames.ora and listener.ora here.
  • 7. Re: "Configure Database" fails for the HFM
    866532 Newbie
    Currently Being Moderated
    TNSNames.ora
    # tnsnames.ora Network Configuration File: D:\ORCL\Database\db\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = demodrive)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
    )
    )

    Listener.ora
    # listener.ora Network Configuration File: D:\ORCL\Database\db\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = demodrive)(PORT = 1521))
    )
    )

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points