Saturday, March 3, 2012

Issue: MaxL and Esscmd not opening from windows command line

Hi,

I am currently busy installing Oracle Hyperion EPM product suite v11.1.2.1 on VMware machines and the issues which I face while installation, I just thought of sharing here on this blog.

After installation of Essbase Server on one of the VMware machine, I found that I cant open MaxL or esscmd command from windows command line. I found that ARBORPATH and ESSBASEPATH environment variable were not set. I set it for the seesion and it worked. It can be set in the Environment Variable and then MaxL and Esscmd can be executed from windows command line.



Hope this helps you all

Keep Sharing

OraHyperion

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