The Installer is Unable to Instantiate the File key_xe.reg file

ISSUE:

• When I attempt to install the Oracle Database XE 11g. 
• “The installer is unable to instantiate the file C:\Users\ … … \KEY_XE.reg. This file does not appear to exist.”  

SOLUTION:

Steps

• With the error message box still open, click the Windows start button and type “regedit” in the search box. Press enter. The registry editor will open.
• On the left column, expand the folders as follows: 
• HKEY_CLASSES_ROOT -> Installer -> Products -> 266B7A….. -> SourceList-> Media
• Look for ’1′ under Name on the right column. Under ‘Data’ on the same row, the value should be ‘DISK 1′ or something similar. Right click on that row and click on ‘Modify’.
• A window named ‘Edit String’ will open and type in the address indicated in the error window you had from the Oracle installer, ending just before ‘KEY_XE.reg’. It should end with a row of numbers/letters then ‘}\”.
• Click OK and close the Registry Editor.
• Return to the Oracle Installer and click OK on the error message box.
• It will take a while, but eventually, the installer will indicate that installation is complete.
• To check if everything’s good, click on the windows start button -> All programs -> Oracle Database 11g Express Edition -> Get started.
• A web browser will appear and the Oracle Database Get Started page will load.

Unable to Open Workspace

Symptoms:

• When trying to access Hyperion Workspace using the following URL:
• http://<servername>:19000/workspace/index.jsp

The following error occurs:

• Internet Explorer cannot display the webpage

Most likely causes:

• You are not connected to the Internet.
• The website is encountering problems.
• There might be a typing error in the address.

Cause:

• The Apache server was not running.

Solution:

• Steps to check if the Apache service is running:
• Start the windows services and see if the Hyperion apache service is running
• If it is running then check that it is listening on port 19000 by doing the following

        On windows Platform:

• Start a command prompt window
• telnet ApacheServerName 19000 press enter and see if it is listening on that port
• If not listening then try stopping the service and reconfigure the workspace webserver

Unable to Connect Database When Creating FDM Application

Symptoms:

• When attempting to create FDM application it will throw the following error

• Unable to connect to target database, please check the database details or contact Administrator.

Cause: 

• The ORACLE_HOME was set to the 64-bit Oracle Home.

Solution: 

• Remove the ORACLE_HOME setting, it was trying to force the 32-bit Oracle ODBC Driver to use the 64-bit Oracle client and bequeath adapter.
• Remove it (ORACLE_HOME) then will allow to use the 32-bit Oracle client.

Issues in Essbase Excel Add-Ins

Issues:

• While I opening the Microsoft Excel, I get the following Error,

• "The file you are trying to open 'essexcln.xll' is in a different format than specified by the file extension.Verify that the file is not corrupted and is from a trusted source before opening the file.Do you want to open the file now?"

Solution:

• Remove the Excel Add-Ins
  
  • Start --> Control Panel --> Add/Remove Programs.
  • Click Microsoft Office in the list of installed programs, and then click the Change button.
• Re-Install and Re-Configure the SpreadSheet Add-Ins

Reset the Hyperion Component Schema's Password

Issue:

• When attempting to login to workspace and EAS console, it will throw the following error

• Workspace:  EPMCSS-00301: Failed to authenticate user. Invalid credentials. Enter valid credentials. EAS console:  Could not connect to admin server.

Symptoms:

• The following services will get down

• The foundation services
• EPMA server
• Reporting Analysis and framework [web]

Cause:

• The database password which we had used for configuring Hyperion got expired.

Solution:

• Reset the password by using the following command
• Alter user username identified by password;
• Check the default password lifetime by issuing the following command
• select * from dba_profiles;
• The PASSWORD_LIFE_TIME field is responsible for expiring of password after 180 days.
• Execute following command to disable this feature:
• ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
• Now Reconfigure the Hyperion using the reset password.

Recreate Essbase.sec File

Issue:

When attempting to connect EAS console it will throw the error as follows:

• Network Error [10061]: Unable To Connect To [<hostname>:10302].  The client timed out waiting to connect to the Essbase Server using TCP/IP.  Check the network connections. Also make sure that Server and Port values are correct.

Symptoms:

Essbase server will not start.

Cause:

Essbase.sec file gets corrupted.

Solution:

• Stop the Essbase.
• Navigate to C:\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\bin
• Rename the ESSBASE.BAK_postUPM to ESSBASE.sec
• Start the EssbaseThis will create the Essbase.sec file in the bin folder.

Database Configuration For Reporting & Analysis Gets Fail

Step: 1

• Stop all the services of EPM system.

Step: 2

• Download and apply a service fix numbered: 13807599
• The downloaded file extracted in the following location,

• C:\Oracle\Middleware\EPMSystem11R1\OPatch

• Extracted file name: 13807599

Step: 3

To apply the patch, enter the following command on (Start-->Run-->Cmd): 

Windows:

• opatch.bat apply C:\Oracle\Middleware\EPMSystem11R1\OPatch\13807599 -oh C:\Oracle\Middleware\EPMSystem11R1 –jre C:\Oracle\Middleware \jdk160_21

Step: 4
Download cleanup-ra-components-rule.xml and located in the following location,

• C:\Oracle\Middleware\EPMSystem11R1\OPatch

Step: 5

• Delete Existing R&A components using registry-cleanup.bat file located in following location,
• C:\Oracle\Middleware\EPMSystem11R1\OPatch\13807599\files\common\config\11.1.2.0
• Navigate to the above location in cmd prompt and then execute the following command,
• Registry-cleanup.bat -eoi C:\ORACLE\MIDDLEWARE\user_projects\epmsystem1 -rules     C:\Oracle\Middleware\EPMSystem11R1\OPatch\cleanup-ra-components-rule.xml
• Restart the machine.

Step: 6

• Run configtool, select all the R&A tasks and perform new configuration.

Reference:
(Ref: Web Analysis - Reporting And Analysis Configuration with New Database Fails (Doc ID 1482499.1))    

EPM Architecture

Customizing Logo in Hyperion

For HSS:

Navigate to below given directories and change logon_panel.gif

• \bpmstatic\themes\theme_tadpole\images_global
• \bpmui_WAR\bpmstatic\themes\theme_fusionfx\images_global
• \bpmstatic\themes\theme_tadpole_hc\images_global

For Workspace:

Navigate to below given directories and change

• <HYPERION_HOME>\common\epmstatic\bpmui\themes\theme_fusionfx\images_global
• <HYPERION_HOME>\common\epmstatic\bpmui\themes\theme_tadpole_hc\images_global
• <HYPERION_HOME>\common\epmstatic\bpmui\themes\theme_tadpole\images_global

For Planning:

Navigate to below given directories and change logon_panel.gif

• \ui_themes\tadpole\images_global
• \ui_themes\tadpole_hc\images_global

HSS Splash image:

Navigate to the below given directory and change Shared Services_Splash.gif

• \cas\Shared Services_Splash.gi

Workspace Splash image:

Navigate to the below given directory and change SplashScreenSystem9BIPlus.gif.

• <HYPERION_HOME>\common\epmstatic\wspace\images\SplashScreenSystem9BIPlus.gif

Reference: 

http://www.orahyplabs.com/2012/01/customizing-epm-workspace-1112.html#.UD2n-KMg7cc

Configure Application Cluster Failed

Symptoms:

While configuring Hyperion Financial Management , the configure application cluster will get fail.

Solution:

• Create a UDL file in any location and confirm that is able to connect to your database.
• For that we need to download oracle OLEDB provider from oracle.com. Follow the below link to download the file.
•  http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html
• Extract the file in a different location.
• Open the command prompt then navigate to extracted downloaded file location and use the following command to install the OLEDB.
•  >D:\HFM_STORAGE_FOLDER\New_Folder >install.bat oledb oracle_home myhome true
• Create a file called RegistryBypass.reg in any location and paste the following into the file.

• Make sure to modify the SystemDataLinkFile to point to the location of your UDL file.
• Save the file, then you can double click on it to insert it into the registry on your HFM Application Servers.
• Once this is done, you should be able to re-run the EPM configurator and complete your HFM configuration.

Reference:

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=44729982498947&id=1271183.1&_afrWindowMode=0&_adf.ctrl-state=pjarak1pt_4

DOCID:  1271183.1