Financial Management (HFM) Performance Problems When Using SQL Server Database

  • Date: October 10, 2016
  • Article by: Elysha Daly

Is your Hyperion Financial Management System running “slow?”  That’s good, because now you have a chance to “catch it” and maybe speed it up!!  If you have more than one HFM application server running against a Microsoft SQL Server backend for your database, then please follow these steps to either fix the issue or confirm that this is not causing the issue.
The standard procedure when using Microsoft SQL Server database as a repository for any Oracle Hyperion product is to run the following SQL query for all databases prior to configuring your software:

Set READ_COMMITTED_SNAPSHOT = ON
Set ALLOW_SNAPSHOT_ISOLATION = ON

This pre-requisite requirement can be found in the Oracle Enterprise Performance Management System Installation and Configuration Guide.
However, it has been recently discovered, that this database setting has potential negative performance impact on certain HFM Application tasks, such as consolidations.
Run the following SQL query against all existing HFM databases within your environment(s) to confirm the state of the current database setting.  If your results display a “1” or “on” then please proceed to our offered solution below.

select name, is_read_committed_snapshot_on, snapshot_isolation_state_desc from sys.databases

 
epm_hfm_pics
Solution:
First, confirm that all Oracle EPM Service Software has been stopped.
Second, if possible, perform a restart of the Microsoft SQL Server Windows service to clear any orphaned processes.
Third, perform a cold back up of your HFM database.  ***This is a critical step***
Last, you will run the following SQL query against the HFM database.

alter database <HFM_DB>
set allow_snapshot_isolation off;
alter database <HFM_DB>
set read_committed_snapshot off;

 
In our example we changed the <HFM_DB> within the SQL query to EPM_FM, the name of our Financial Management database.
pic03
Now you can go back and run this query again to confirm the change has taken hold:

select name, is_read_committed_snapshot_on, snapshot_isolation_state_desc from sys.databases

 
Please note the change in the EPM_FM state to “0” and “off.”
pic04
 
When this process is complete, please go ahead and restart your Oracle EPM Service Software.  We always suggest you perform your standard validation to confirm that your environment is still functioning properly.  While there is no guarantee of the amount of performance improvement, through our own testing, we were able to see a client’s Financial Management consolidation process reduced from over 2 hours to approximately 15 minutes.
We at iArch Solutions hope you found this blog helpful. Is there a question you want answered in a blog?  Send us your questions, comments and feedback.
APPLICABLE VERSIONS: 11.1.2.4

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

A simple problem that is hard to describe, but easy to fix.

  • Date: February 15, 2016
  • Article by: Elysha Daly

Problem:
My Internet Explorer navigation windows open on top of each other!
The links don’t cascade correctly!
Why do my options open over each other?
I don’t know how to describe this problem!!
When logged into your workspace using Internet Explorer 9 or later, I sometimes encounter a problem where my second window link opens directly over my first. The hardest part of this problem is trying to find the correct term to use to describe this problem and search for a solution.  I did manage to find an answer though.
An example is shown here where my first link is selected by clicking on the File option.
Pic1
This second screen shows that by moving down to the presented options the next set of choices opens directly above the first.
Pic2
 
Solution:
Select the “Tools” option in Internet Explorer.
Then select “Internet Options.”
Pic3
 
 
Under the Security tab select “Custom Level…”
Pic4
Scroll down until you find “Allow Script-initiated windows without size or position constraint”
Pic5
 
Then change it to “Enable” and click “OK.”
Pic6
Click “Yes.”
Pic7
It will be necessary to restart your browser session for the changes to take effect. Once reset your windows will open as below.
Pic9
 
We hope you found this tip helpful.  Here at iArch Solutions, we strive to enable our customers with the knowledge and confidence for a smooth running system.  Should you have any questions, please do not hesitate to give us a call.
APPLICABLE VERSIONS: 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, 11.1.2.4

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Windows Data Execution Prevention

  • Date: October 20, 2013
  • Article by: Joe Malewicki

ISSUE: Data Execution Prevention (DEP) is not currently enabled for essential Windows programs and services on all servers
RISK: The primary benefit of DEP is that it helps prevent code execution from data pages, such as the default heap pages, various stack pages, and memory pool pages. Typically, code is not executed from the default heap and the stack. Hardware-enforced DEP detects code that is running from these locations and raises an exception when execution occurs. If the exception is unhandled, the process will be stopped. Execution of code from protected memory in kernel mode causes a Stop error.
SOLUTION: Correct the DEP Settings per standard Windows operating tuning.
APPLICABLE VERSIONS: 9.3.x, 11.1.1.x, 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, 11.1.2.4

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More