Place Planning under Maintenance Mode from Command Line


This was one of the requirements that came up in one of my friends and with his inspiration (Prajeev’s) I thought of creating a batch file for placing Planning under Maintenance Mode.

All you have to do is download the file and extract it to a folder.

Prerequisites

  • Essbase client needs to be installed on the server where you are running this script
  • SQLPlus needs to be installed on the server where you are running this script

Edit the following scripts
  • Maintenance_Mode.bat
    • BASE_DIR – Change to the directory where you extract the zip file
    • PATH – Add the path to SQLPLUS
    • PLN_APP – Change to your application
    • Change the path to Broadcastmessage.cmd, Username, Appname
    • Change the path to the encrypted password file 
  • Under sql directory change
    • UserId, Password and SID files
    • Set the login_level in PLN_MAINT_SQL.txt
      • LOGIN_LEVEL=’0′ – For all Users
      • LOGIN_LEVEL=’2′ – For Administrators
      • LOGIN_LEVEL=’3′ – For Planning Owner
  • sendmail.vbs
    • Update the SMTP server details
    • User ID, if your SMTP server needs authentication then uncomment the lines starting with ‘***_*** under section “Configuration”
  • Under Maxl directory
    • Change User name, password and Essbase Server details
Restart Planning and you are done. This will broadcast a message to all the Users who are logged in Planning and they will get a mail also which will inform that Planning Maintenance will begin after 5 mins.

Hope this helps.

Update

For those who are on 11.1.2.1 version there is a patch available which comes with a utility

Read more about it here.
Advertisements

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.


Leave a Reply

0 thoughts on “Place Planning under Maintenance Mode from Command Line