Rotate Planning logs in 11.1.2.1


I had to enable once enable DEBUG option in Planning (For monitoring the login time of users : http://www.orahyplabs.com/2012/07/monitor-last-login-time-in.html).

This made the logs grew in size and every re-start of Planning was deleting the logs. I was looking for an option to set a maxlogfilesize and then rotate the logs.

I did google 🙂 and found out more information on log rotation using ODL. (Oracle Diagnostic Logging)


Most EPM System products have adopted Oracle Diagnostic Logging (ODL) as the logging mechanism. The ODL framework provides uniform support for managing log files, including log file rotation, maximum log file size, and the maximum log directory size. For more information, see the “Using EPM System Logs” chapter of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Troubleshooting Guide.

Unfortunately (for me at least) Planning 11.1.2.1 does not use ODL.
From 11.1.2.2 ODL is the standard and you can use ODL for log rotation.

For pre 11.1.2.2 environments you’ll have to look for other options and I created a bat file to handle the rotation. This bat file will move Planning logs to an archive folder if HyS9Planning-sysout.log is larger than 500 KB.

I use this bat file after stopping Planning service to archive the logs and then start Planning services.

You can download the file from here.

HTH
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