Oracle HFM System Logs

When supporting the application, you need to know where you can find the messages that tell you how your application is performing. The error messages appear in a couple of places. The main places are

The HsvEventLog.Log file under the HFM application server’s \Hyperion\logs\hfm folder

The HFM_ErrorLog table within the relational store (Oracle HFM schema)

Windows application events

Audit and task logs

User interface

If you aren’t familiar with HFM, it can be difficult to understand what these messages are trying to tell you about your application. Unfortunately, there isn’t a list of the errors that you can refer to and see what is wrong. More importantly, there isn’t a list of errors that tells you what the resolution is for each error. In this section, you will see most of the messages you could get, and what the resolution most likely is. I will try to emphasize the term “messages” rather than “errors.” Some of the messages are errors, but the logs contain a lot of information about how the system is performing. They also capture quite a few transactions, such as failed logins or the execution of Calculate and Consolidate. You should refer to the l....