Skip to main content

Data & Intelligence

A Solution to Essbase Security File Backups

shutterstock_164194724_300Essbase does its best to be friendly to us system admin types, but sometimes I just want to scratch my head in bewilderment.

Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

In 11.1.2.3 and later, Essbase performs a backup of the Essbase.sec file every 300 seconds and retains a default of two backups. This means that at any given time, you have two backups of the Essbase security file that are at most 10 minutes old.

In my experience, corruption to the Essbase security file is not identified within a 10-minute period, so as a matter of habit, I set the follow in the Essbase configuration file (essbase.cfg):

NUMBEROFSECFILEBACKUPS 10
SECFILEBACKUPINTERVAL 8640

The interval is in seconds. This ensures that at any given time, I have 10 backups spanning across a 24-hour period. I will determine the Essbase security file is corrupted easily within a few hours of symptoms occurring and can roll it back several hours if necessary.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Cris Dunn

Cris Dunn is the manager of Perficient's EPM SupportNet practice which provides direct support for applications and infrastructure surrounding many organizations' EPM software implementations. He is also an Oracle University certified instructor and teaches everything around Essbase as well as the EPM installation and configuration classes. When he is not working, you will find Cris engaged in His church serving as the treasurer, musician, nursery worker, and, when necessary, toilet scrubber.

More from this Author

Follow Us
TwitterLinkedinFacebookYoutubeInstagram