Blog Details Page

  • Date: October 10, 2016
  • Article by: Robert Barrett

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 Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: May 16, 2016
  • Article by: Robert Barrett

When recently trying to deploy Essbase Studio, I ran into an issue where it would not create the Windows service because the password for the Windows Services install account contained one or more unacceptable characters.

Here are the steps I performed to work around this issue.

Start by re-launching the Configuration tool on the Essbase server.  This time be sure to choose “Configure Common Settings.”  Then click “Next.”

Pic1a

Deselect the “Run Windows Services as non-local system account” option. Then click “Next.”

Pic1

Now follow through the rest of the process of configuring Essbase Studio.  As you have already tried to configure Essbase Studio once, you will encounter the option to either “Drop and re-create Tables” or “Reuse existing database.”  I would choose to “Reuse the existing database.”  Click “OK” and then “Next.”

Pic2

Now continue with your configuration.  When you have completed the process, if you look at your deployed services, you will find that Essbase Studio has been deployed.  Please note, that it has configured to run as the “local system” account.

Pic3

It is important to go back to you services screen now and change the Essbase Studio settings manually.  So, right click on Essbase Studio and click on “Properties.”

Pic8

Select the “Log on” tab.  Input the correct windows account information and select “Apply.”  When you go back to your services screen, you will find that the Essbase Studio Service is no longer a local system service.  It will now be the windows service account that you previously input.

Pic6

The next step is to run the configuration tool again, this time, only select “Configure Common Settings.”

Pic4

Select to “Run Windows Services as non-local system account.”  Input the right domainusername and Password.  Then click “Next.”

Pic5

And now finish the rest of the steps in the configuration process.

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.

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: March 28, 2016
  • Article by: Robert Barrett

People to tend to think that creating a master start/stop script, which can span multiple servers, is a difficult task.  Some Hyperion consulting firms out there even like to charge for such a beast.  They also try to convince you that you need to purchase their “specialized custom scripts” or “compiled start/stop programs” to do the job.  This just isn’t so!  Remember – anything they charge you for today, they’ll likely want to charge you to modify “tomorrow.”

There’s no secret sauce here folks.  There is no need to go spending your valuable money when all of the tools you need to create your own script are already in place within your Microsoft Windows infrastructure.  In the article below, we will show you step by step how to create your own custom Oracle EPM/Hyperion start/stop scripts which can be easily modified whenever you might need to do so.

Follow these quick and easy steps to create start and stop scripts for your Oracle EPM/Hyperion System running on a Microsoft Windows Operating system today!

On your Foundation Services Server, open/create a new text document using your favorite text editor.   We’re using the built in Notepad application from Widows (Start -> Run -> Notepad.exe).  I often add a few comment lines to the top of my scripts so it is a little easier to know which script I’m working with and what version of software it is for.

Pic1

Save the document by clicking on File and then Save As…

Pic2

Save the script and place it just under the Oracle location in a folder labeled “scripts.”  You can save it wherever you like, but if you place it here, it is less likely to be mistakenly deleted.  Please note that this is being saved as a .txt file.  This will be changed later, but to be safe, it should be saved in this format for now.

Pic3

The first thing to add to your script is a command to start Microsoft Internet Information Services (IIS).  That is, if you are using it for any of the software within your Oracle EPM/Hyperion System deployment.  If you’re not sure if you require this, you can run a Oracle EPM Topology report and check to see if any of the following products are configured:

  • Financial Management (HFM – prior to release 11.1.2.4)
  • Enterprise Performance Management Architect (EPMA)
  • Strategic Finance
  • Financial Data Quality Management (FDQM – not required for Financial Data Enterprise Edition Manager – FDMEE)

For local IIS instances:

iisreset.exe /start

When you need to start IIS on a remote server:

iisreset.exe remote-server-name /start

Pic4

The first part of your start command will contain two items.  First, the  server where your service resides and second, what to do with that service.  Here you are asking it to start.

sc \<your-server-name> <switch>

In the example below, the”sc” stands for Windows Service Control, “Hyperion1” is our test server name and “start” is the action which you wish to perform using the “sc” command.

sc \Hyperion1 start

Pic5

Now, it is necessary to find the “Service Name” of your Oracle EP/Hyperion services in order to use them in your start commands.  Click on the start menu and in ther query box at the bottom type: services.msc and press enter.

Pic6

This will bring up the all the services that are running on this server.  It will not be limited to Hyperion/EPM products.  You will need to locate your services under either Oracle or Hyperion.  This depends on which version of the EPM/Hyperion system you are currently running.

Start by clicking the “Standard” tab at the bottom of the page and then scroll down until you find your services.  This example shows the many different services in this environment.  I will demonstrate the steps needed to finish your first start command.  The process simply repeats for each of these services.

I usually start with the “Oracle Process Manager” and then “Foundation Services.” Generally, in the more recent versions, aside from these two services, the order of starting is not critical.

Pic7

Right click on Oracle Process Manager and select Properties.

Pic8

The information in the Service Name box is what you need to highlight and copy.

Pic9

This is the next component of your start script.  Be sure to add in the double arrows >> to set up the next part of your script.

"OracleProcessManager_ohsInstance4262192120" >>

Pic10

This next part of your script creates a log that will keep the startup information for each command and time you run the script.

For example:

C:OraclescriptsServices_startup.log

Pic11

In this part of the command line you can control how long to wait before allowing the next command to run.  The “10” in “TIMEOUT /T 10” is equal to 10 seconds.  It also puts this information into that same startup.log file.

TIMEOUT /T 10 >> C:OraclescriptsServices_startup.log

Pic12

This is a sample of the second start command.  It is preferable to start Foundation Services second.  Technically speaking, since the release of 11.1.2.3, there is no longer a need for a specific start sequence.  Our experience has shown that starting these two services first reduces occurrence of errors.

Pic13

After copying the Service name from above, paste it into the next start command, as shown in the screen shot below:

Pic14

Once you have completed all your commands for all of your EPM/Hyperion services,  save your work.  Then right click on the file and select “Rename.”

Pic15

Change the .txt file extension to be “.BAT.”  This will convert your text file into a batch file. Click OK.

Pic16

You will now have the ability to run this script.  Please be sure to right click on this file and select “Run as Administrator.”

Pic17

It is now necessary to create a stop script.  You will follow the same steps as before but take notice of the slight changes in the commands.  Now instead of “start” you will use “stop” and you will replace “startup.log” with “shutdown.log.”

The order of processes to be stopped is best when reversed for the stop script.  The exception to this is the IIS stop command.  This can remain in it’s original position.

Pic18

Remember to initially save the document as a text file.

Pic19

Pic20

Then when it is complete, and in place, change it to a batch file.

Pic21

click Yes.

Pic22

As with the start script, it is necessary to run the stop script as an administrator.  Simply right click on the stop script batch file and select “Run as Administrator.”

Pic23

I hope this was an informative and helpful blog for you.  Here is a sample of the start/stop scripts used in this article:

ECHO.
ECHO ------------------Starting Oracle EPM System 11.1.2.4 Services------------------
ECHO.
iisreset.exe /start
sc \Hyperion1 start "OracleProcessManager_ohsInstance3037049148" >> C:OraclescriptsServices_startup.log
TIMEOUT /T 10 >> C:OraclescriptsServices_startup.log
sc \Hyperion1 start "HyS9FoundationServices_Foundation1" >> C:OraclescriptsServices_startup.log
TIMEOUT /T 30 >> C:OraclescriptsServices_startup.log

 

ECHO.
ECHO ------Stopping Oracle EPM System 11.1.2.4 Services-----------
ECHO.
iisreset.exe /stop
sc \Hyperion1 stop "HyS9FoundationServices_Foundation1" >> C:OraclescriptsServices_shutdown.log
TIMEOUT /T 10 >> C:OraclescriptsServices_shutdown.log
sc \Hyperion1 stop "OracleProcessManager_ohsInstance3037049148" >> C:OraclescriptsServices_shutdown.log
TIMEOUT /T 10 >> C:OraclescriptsServices_shutdown.log


Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: March 7, 2016
  • Article by: Joe Malewicki

 

2016 appears to be the year of the Upgrade!  There has been a common theme to many of the calls coming into iArch Solutions these past several months;

  • How do I upgrade?
  • How soon can you do it?
  • How much will this cost me?

Is your system running on the latest Oracle EPM software release 11.1.2.4?  Corporations no longer need to rely on long term application and/or functional consulting engagements to perform an upgrade of their Hyperion system.  Leveraging a technical services firm for your software upgrade can prove to be a much more efficient option and lead to a huge savings in project costs.

Why do you need an upgrade?

  • Microsoft is ending support for older operating systems and web browsers.
  • Oracle’s lifetime support policy for releases.
  • Hardware warranty expiration.
  • Increase your system’s overall performance and stability.

At iArch Solutions, we are your technical UPGRADE experts, it’s what we do.  So, now that we have your attention, what are you waiting for?  Call our experts to discuss how we can help you upgrade today.

 

Learn more about iArch Solutions Installation and Upgrade Services

iArch Solutions Installation and Upgrades

 

 

 

 

 

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: February 1, 2016
  • Article by: Robert Barrett

Ever get the “request timed out” error message and there is not anyone available to help you fix it?  Read below and find a step by step guide on how you can adjust your settings and not slow down your uptime.

ERROR:

Oracle Smart View for Office

The request timed out. Contact your Smart View client system administrator to extend your windows internet explorer time out settings (ReceiveTimeout, KeepAliveTimeout, and ServerInfoTimeout).

image002

Solution:

In order to for SmartView to connect to Analytic Provider Services(APS) it uses Internet Explorer (IE).  Generally IE can have a low default time setting for obtaining the necessary data. It will display the above error message.

Enter Registry settings and increase the time allotted.

  1. Go to “Start” and Select “Run…”

image004

  1. Type “regedit” and select “OK”

image006

3.Navigate to Computer > HKEY_CURRENT_USER > Software > Microsoft > Windows > Current Version > Internet Settings

image008

  1. Select Edit > New > DWORD (32-bit) Value.

image010

  1. Right click on “New Value #1” and change it to “ReceiveTimeout”

image012

image014

  1. Right click on ReceiveTimeout and select “Modify”

image016

  1. Using the Decimal option, please enter “480000.” This corresponds to 480000 milliseconds which is equal to 8 minutes.

 

Newpic

Newpic2

 

 

image022

  1. Follow the same steps to add the parameters “ServerInfoTimeout” and “KeepAliveTimeout”  as well. For the value of the latter two parameters enter “180000.” This Decimal term is equal to 180000 milliseconds or 3 minutes.

image024

9.Close the registry window and restart services.

We hope this step by step process was helpful to you. Should you have any questions on this, or any of our other blogs, please feel free to give us a call. Check back next week with another helpful tip to keep your system stable and ensure maximum uptime.**Please note you might require local administrative privileges to perform these steps.

 

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 Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: February 11, 2015
  • Article by: Joe Malewicki

Oracle has updated the Enterprise Performance Management (EPM) Documentation Library for 11.1.2.4 to the new standard format used amongst the rest of the Business Intelligence and Fusion Middleware stack.  Check out the updated docs for this new release as well as the new look and feel.

http://docs.oracle.com/cd/E57185_01/index.htm

The majority of the documentation is now available in PDF, mobi and ePub formats for download.

EPM-doc-library

 

 

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: February 9, 2015
  • Article by: Joe Malewicki

OPAS_log   A Big Shout out to Torben Hein at Oracle for posting once again another absolutely essential blog entry on how to survive Oracle EPM/Hyperion troubleshooting dilemma in your Enterprise Performance Management deployments.

Check out Torben’s post on the “New Error Message Guides in EPM 11.1.2.4” at the Business Analytics – Proactive Support page.

https://blogs.oracle.com/proactivesupportEPM/entry/self_service_made_easy_new

Thanks again Torben and team!

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • 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 Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More