Friday, February 24, 2012

Shared Connections Drop-Down List empty in Smart View 11.1.2.1

Hi,

I was working on the installation of Oracle Hyperion EPM v11.1.2.1 on 64 bit VMware Server. I installed and configured all the required products (Foundation Services , Essbase, EAS and Provider Services) in that order. Then installed SmartView v11.1.2.1 on my local machine to check the connectivity with Essbase using workspace install link. It got installed successfully and I was able to connect to the Essbase Server using Private Connection (http://ProviderServer:PORT/aps/APS). However when I connected to Shared Connection, the drop-down of the list was coming as empty and it was not allowing me to enter hps details either.

I googled for the solution and found that I need to reconfigure Foundation Services ->Web Server after the installation of SmartView so that Web Server is configured for all the required products. I did the same and the issue was resolved. After connecting to Shared Connection using the URL http://ProviderServer:PORT/workspace/SmartViewProviders in SmartView Options->Advance-> Shared Connection URL, I could see Oracle Essbase Server in the drop-down list. Then I remembered having read the same in epm_install_11121 pdf file which has always refered to configure Web Server in LAST. I got the point and thought of sharing the same here

Hope this helps you all

Happy Sharing

Thursday, February 23, 2012

EPM Configuration Tool Not Opening : Oracle EPM v11.1.2.1

Hi,

I faced a peculiar problem today while running EPM Configuration Tool on one of a new Hyperion server which I was building for migration. EPM Configuration Tool ran fine when I ran the tool for configuring Essbase Server. However after the Essbase configuration completed, I tried to run Configuration tool again to configure Essbase Studio on the same server and I got an error message:

  
I looked for the solution in the troubleshooting guide for v11.1.2.1 (TrobuleShooting Guide - EPM System Configurator Startup 
but this could not help as I was using the same user name to install and configure the products. 

Then I closely looked that the error message on the console and found that the configurator was not able to read some of the file under C:\Oracle... I navigated to the drive and found that I am not able to edit any of the files under Oracle folder in C: drive. I changed the permission for the user which I was using to install the Hyperion Products on the "Oracle folder" to FULL CONTROL on all the files and folders under C:\Oracle and that worked. This issue I observed on VMware server having Microsoft 2008 server (OS) - 64 bit

Hope this helps you all

Keep sharing