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

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

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

Encrypt Essbase UserID and Password in MaxL script

Hi, You all would be using Encryption - Decryption of MaxL script containing userID and password for Essbase server. But I just thought of posting it in my blog so that if some of you want a quick reference without going to Technical Reference guide.

Follow the below easy steps to encrypt and decrypt the MaxL script:

Step 1: Create a simple MaxL script (Loginscript.mxl) to login into Essbase server using MaxL commands login on ; logout; 


Step 2: Run essmsh -gk command to generate Encryption and Decryption code 


         D:\oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin>essmsh -gk 
         Essbase MaxL Shell - Release 11.1.2 (ESB11.1.2.1.0B347) Copyright (c) 2000, 2011, Oracle
         and/or its affiliates. All rights reserved. 
     
        Public Key for Encryption: 13005,692804953 
        Private Key for Decryption: 565324885,692804953 


       MaxL Shell completed 


Step 3: Encrypt Loginscript.mxl by issuing the below command along with Encryption Code generated above. This would create an encrypted MaxL script with extension Loginscript.mxls


      D:\oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin>essmsh -Em D:\ 
      Scripts\Loginscript.mxl 13005,692804953 


         Essbase MaxL Shell - Release 11.1.2 (ESB11.1.2.1.0B347) Copyright (c) 2000, 2011, Oracle 
         and/or its affiliates. All rights reserved. 


Step 4: Open the file Loginscript.mxls to check whether the userID and Password got encrypted or not.  

       login $key 225460064724436062164017310 $key 137249360634406684332940616180146296;  
       logout; 


Step 5: If you want to execute encrypted file, run the below command with decryption code 
        
      D:\oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin>essmsh -D D:\S   
      cripts\Loginscript.msh.txts 565324885,692804953 
    
        Essbase MaxL Shell - Release 11.1.2 (ESB11.1.2.1.0B347) Copyright (c) 2000, 2011, Oracle 
        and/or its affiliates. All rights reserved. 


        MAXL> login $key 225460064724436062164017310 $key 37249360634406684332940616180  
       146296; 
              
               OK/INFO - 1051034 - Logging in user [admin@Native Directory]. 
               OK/INFO - 1241001 - Logged in to Essbase. 


        MAXL> logout; 


               User admin is logged out 
               MaxL Shell completed 

Hope these simple steps would help you all while encryting and executing an encrypted MaxL script 

Keep Sharing

MaxL API Instance Not Active EAS to Essbase connectivity issue

Hi Guys,

Today we faced a very peculiar issue with EAS. Once we restart EAS services on Windows box, the EAS services use to start but when we try to open any Essbase Analytic Server, it use to throw below error message : MaxL API instance not Active. Sometime it use to hang EAS console completely.

We investigated the issue and found that the Environment Variable (ESSLANG and ESSBASEPATH) set on the EAS server was not correct. Value for ESSLANG should be .Latin1@Default and ESSBASEPATH value must point to Essbase Client. This make sense as while connecting Essbase server, EAS looks for Essbase Client to get it connected and hence if the values are not proper, if would not connect with Essbase.

Hope this help when you face a similar problem

Keep Sharing