Essbase Service not starting

After I figured out the issue with OpenLDAP, I recently saw a similar problem with my Essbase service. However many times I tried to start it, it would just shutdown immediately. This could have been a result of the improper shutdown I mentioned as a reason for the OpenLDAP database to get corrupted.

Fixing essbase is not without losses. I discovered that the security file had been corrupted and hence essbase shutdown soon after I started it.

I went to my application backup folder and copied the essbase.sec file back to the current deployment. The essbase.sec needs to be replaced with a working version. When I started the service again, it was back up and running.

Please note that if you don’t have a current backup, then a lot of the security information that has changed since you’re last backup will need to be done again. I had a very recent backup so I was saved from this hassle.

OpenLDAP and Shared Services not starting

A server hosting Hyperion Planning – System 9 was started up. The OpenLDAP and Shared Services were set to start automatically. They didn’t start automatically. When they were started manually they gave an error and failed to start.

I discovered that the OpenLDAP service was the cause of the problem since it did not start. The server had been improperly shutdown because of a power outage. This sudden shutdown had caused the OpenLDAP database to crash and hence it was unable to restart.

Automate Essbase Data Backup with ESSCMD and BAT

Backup! Backup! Backup!

The three most important aspects of managing an enterprise application as explained to me by one of the key personnel for the current client I’m working for. She hasn’t failed to stress enough, the need to ensure timely and complete backups.

Hyperion Financial Data Quality Management (aka FDQM)

Oracle Hyperion Financial Data Quality Management is a packaged solution for finance users that helps develop standardized financial data management processes with its Web-based guided workflow user interface. Its data preparation server can ease integrating and validating financial data from any of your source systems. And to further reduce your data integration costs as well as data mapping complexities, Oracle Hyperion Financial Data Quality Management includes prepackaged adapters for Oracle Hyperion Financial Management, Oracle Hyperion Planning, Oracle Hyperion Strategic Finance, Oracle’s Hyperion Enterprise, Oracle Essbase, and Oracle E-Business Suite.

Limitations on size of dense dimensions for optimum performance

Designing an Essbase DB comes with a lot of practice and experience. There are however some basic tips & tricks that we should be aware of. One common question I’ve come across in my inbox relates to the ideal block size of an Essbase DB.

Hyperion: Why is there a startup order for the services?

I’ve often been asked this question from people who are new to Hyperion. To best understand the reason behind the specific sequence in which the Hyperion services are started we must understand the architecture of the product suite.

Release: Hyperion Planning – System 9 Installation Guide

Hi All,

This has been a long time coming and I apologise for the delay. This document primarily got delayed because I got really busy with a couple of projects and had absolutely no time available. Well, here is the document and I hope it helps out those who are new to Hyperion Planning – System 9. If some of you have experience with this and feel that I missed out on any key details or if there is any change you would like to see in guide then please do feel free to email me and let me know. The comments section on this post will be closely followed for the same.

Announcement: Update on Hyperion Planning Installation Guide

Hi All,

This is a letter to my regular readers and specially those who are anxiously waiting for the Hyperion Planning Installation Guide. I have been overwhelmingly busy these past 3 weeks and have and from little to no time at all for most days. However, taking out a few mins whenever I could, I have finally completed the Installation Guide.

All that remains is for it to be posted and it will be done by tomorrow hopefully. So those of you who had their fingers crossed can now relieve their fingers!

Regards,

Shehzad

Oracle roadmap after Sun acquisition

Oracle has decided to buy Sun, and pending approval from Sun stockholders. Other than that, the deal seems to be set. How this is going to impact Oracle, Sun customers and the technology market in general needs to be seen. That does not mean that there is no room for speculation.

Oracle set to buy Sun Microsystems

The tech world is abuzz with the announcement that Oracle has made a bid to acquire Sun Microsystems for USD 7.4 billion. This news comes after negotiations broke down between IBM and Sun Microsystems.