Blog Details Page

  • Date: June 10, 2020
  • Article by: Joe Malewicki

As a professional Oracle Hyperion EPM infrastructure consultant we have sometimes been stumped by the misbehaving of the Oracle HTP Server (OHS) to WebLogic Managed Servers traffic proxying as deployed within the Oracle Hyperion EPM configuration at clients.  There are occasions in which we just can’t figure out why things aren’t “communicating” like they should.  So, from our little bag of tricks we pull out the old “how to debug the traffic” card and realize that we always forget these simple yet powerful settings.  Hence, the reason I’ve created this blog post!

My memory is going the older I get so after writing and publishing this, I have a place of my own to find these simple steps for those future pesky troubleshooting engagements.

It’s important to note that these procedures will work for Fusion Middleware (FMW) 11g as is embedded and deployed with the oracle Hyperion EPM System 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, and finally 11.1.2.4.  These precures are not applicable for the newly released Oracle Hyperion EPM System 11.2.0 or 11.2.1 as those new versions come with the newer Fusion Middleware (FMW) 12c.  I’ll post another blog with the procedures for that release shortly.

For the context of this blog we are using oracle Hyperion EPM System 11.1.2.4 running on Windows 2012.

Start by creating a target location for the debug logs.  The name is arbitrary just remember wat you called it and where it’s located on the file system as this will be required in the coming steps.

1-Create new directory or folder in Windows

Backup your existing mod_wl_ohs.conf file.  Depending upon which configuration option you selected when deploying the Oracle Hyperion EPM System, this file could be located on the Oracle HTTP Server (OHS) under the config\OHS folder:

C:\Oracle\Middleware\user_projects\<YourInstanceNameHere>\httpConfig\ohs\config\OHS\ohs_component\mod_wl_ohs.conf
2-Standard mod_wl_ohs conf file location
2-Standard mod_wl_ohs conf file location

Or this file could be located under your customized shared EPM folder for the Oracle HTTP Server (OHS) if you chose that option during the Web Server configure task of the config process.  If you’re not sure, take a look at the httpd.conf file for your OHS instance and find the “include section down towards the bottom of the file.  This will give you the currently configured location.  **NOTE** if you have more than one Oracle HTTP Server (OHS) you should confirm on each server this location and ensure they match and point to the same place. If they don’t you need to update each server’s version of the files for context of this blog post.

C:\Oracle\Middleware\user_projects\Foundation1\httpConfig\ohs\config\OHS\ohs_component\httpd.conf
3-Standard OHS httpd conf file location
3-Standard OHS httpd conf file location
include "moduleconf/*.conf"

<VirtualHost *:19000>
    include "//11124-prd/EPMShared/OHS/mod_wl_ohs.conf"
    Include "//11124-prd/EPMShared/OHS/epm_online_help.conf"
    Include "//11124-prd/EPMShared/OHS/epm_rewrite_rules.conf"
    Include "//11124-prd/EPMShared/OHS/epm.conf"
    Include "//11124-prd/EPMShared/OHS/deflate.conf"
</VirtualHost>
4-httpd conf file include section
4-httpd conf file include section

In all of our deployments we use the shared EPM location for the Oracle HTTP Server (OHS) web server configuration task.  This removes the need for us to re-rerun that web server task whenever a change is made to the Oracle Hyperion EPM System software configuration, the OHS files just get updated automatically.

\\<ServerName>\EPMShared\OHS
5-Shared mod_wl_ohs conf file location
5-Shared mod_wl_ohs conf file location

We copied our mod_wl_ohs.conf file to mod_wl_ohs.conf-ORIG:

6-Backup Shared mod_wl_ohs conf file location
6-Backup Shared mod_wl_ohs conf file location

Edit the mod_wl_ohs.conf file to include the OHS logging parameters as required for the WebLogic LocationMatch section of the WebLogic Managed Server you want to debug traffic for.  Note this log will fill up pretty quick so if you are troubleshooting multiple products communication proxy/web traffic, we suggest creating a separate file for each product’s WebLogic LocationMatch for easier analysis.

Add the appropriate Debug and WLLogFile location parameters using the location you created in the first step above.  The file name and extension of the log itself is arbitrary so we just use a snippet of the WebLogic managed Server we are debugging for in the name with a .log extension. The content being recorded is in plain text.

A very informative (and way to wordy) technical reference guide to these parameters can be found on Oracle’s published documentation website:

https://docs.oracle.com/cd/E28280_01/web.1111/e10144/directives.htm#CIHCACHB

Parameters to add/modify:

Debug ON
WLLogFile C:\MyDebugLogs\OHS-CalcMgr.log

Sample section of one Calculation manager product LocationMatch AFTER adding/updating the required Debug and WLLogFile parameters:

<LocationMatch ^/calcmgr>
    SetHandler weblogic-handler
    WeblogicCluster 11124-PRD:8500
    WLIOTimeoutSecs 14400
    Idempotent OFF
    WLSocketTimeoutSecs 600
    Debug ON
    WLLogFile C:\MyDebugLogs\OHS-CalcMgr.log
</LocationMatch>
7-Edit LocationMatch for mod_wl_ohs conf file
7-Edit LocationMatch for mod_wl_ohs conf file

For the updates to take effect you must restart the oracle HTTP Server (OHS) on each server where you are trying to debug traffic from.  Since we are using Windows, we will use the Windows services.msc control panel and perform a restart of the Oracle Process Manager (ohsInstance####) Windows service:

8-Restart Oracle HTTP Server-OHS from Windows Services
8-Restart Oracle HTTP Server-OHS from Windows Services

To test your Debug and WLLogFile settings log into the product you are experiencing issues with and a new Debug log file should be created in the path and with the name you specified in the LocationMatch section for the WLLogFile section.

9-Open Oracle Hyperion EPM Calculation Manager screen
9-Open Oracle Hyperion EPM Calculation Manager screen
10-WLLogFile Debug file output location for Calculation Manager screen
10-WLLogFile Debug file output location for Calculation Manager screen

If you open and take a look at the WLLogFile Debug output, you will now see any info and error messages being sent from the Oracle HTTP Server (OHS) web traffic proxy to the WebLogic Managed Server (in our example Calculation Manager).

11-WLLogFile Debug file output for Calculation Manager screen
11-WLLogFile Debug file output for Calculation Manager screen

Happy debugging!!!

We hope this Oracle Hyperion EPM System technical blog post/article was helpful and as always, we appreciate any and all feedback!  If you need any assistance, please know we are always here 24×7 and would happy to help with your Infrastructure needs!

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: August 14, 2019
  • Article by: Elysha Daly
Microsoft and Oracle have some critical end of life dates quickly approaching.  Any customers running on the platforms listed below should begin to prepare for these upcoming support changes.  Contact us today to discuss how these support policy changes might affect your mission critical Financial Close, Budgeting and Reporting systems.

Microsoft product technology end of life dates:

  • Microsoft Windows 2008 Server – January 2020
  • Microsoft SQL Server 2008 – July 2019
  • Microsoft Office 2010 – October 2020

Read More

Oracle EPM/Hyperion on-premise end of life dates:

  • 11.1.2.3.x – March 2018
  • 11.1.2.4.x – December 2020, extended support can be purchased through December 2021
  • 11.2.x – To be released September 2019,  support end of life date of December 2030 

Read More

Oracle EPM/Hyperion Features Discontinued in 11.1

Hyperion Financial Management

Hyperion Planning

  • Financial Management Analytics
  • Essbase Analytics Link for HFM
  • Quantitative Management and Reporting for Solvency
  • Hyperion Strategic Finance (HSF)
  • Simplified User Interface (SUI)
  • Workforce Planning
  • Capital Expense Planning
  • Project Financial Planning
  • Offline Planning

Hyperion BI +

  • Interactive Reporting (IR)
  • Production Reporting (SQR)
  • Web Analysis (WA)

Additional

  • Disclosure Management
  • EPM Mobile
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: June 19, 2019
  • Article by: Joe Malewicki

Rumors gossip and software envy for al those “new vendors” claiming that on-premise Hyperion is dead!!!… news flash, Oracle isn’t killing off On-Premise Oracle Hyperion Enterprise Performance Management (EPM) System 11.2 folks!

Here’s a glimpse of what’s to come with the newly announced Oracle Hyperion Enterprise Performance Management (EPM) System 11.2 roadmap! They’re shifting Oracle Hyperion Enterprise Performance Management (EPM) System family of tools and applications under the “Oracle Applications Unlimited” structure and have announcement details on release cycles as well as product support roadmap.

Oracle Application Unlimited Announcement for Oracle Hyperion Enterprise Performance Management (EPM) System 11.2:

https://www.oracle.com/a/ocom/docs/support/hyperion-epm-announcement.pdf

Oracle Hyperion Enterprise Performance Management (EPM) System 11.2 “Continuous Innovation” announcement:

http://www.oracle.com/us/products/applications/applications-unlimited-1970561.pdf

If you have questions about the direction of Oracle Hyperion Enterprise Performance Management (EPM) System 11.2 or if you are interested in discussing how this coming update will impact your organization’s “Path To The Cloud” please let us know! I’ll be happy to chat!!

Joe Malewicki

President – Certified Oracle Cloud Architect, Cloud Infrastructure OCI and Platform Specialist at iArch Solutions, LLC

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: January 17, 2017
  • Article by: Joe Malewicki

untitled     iArch Solutions is happy to welcome 2017 with lots of exciting news.  January marks the 20th anniversary of Joe Malewicki working within the Oracle EPM/Hyperion software space.  It is this long-standing knowledge that gives clients the confidence, in both Joe and iArch Solutions, to tend to their Hyperion infrastructure architecture needs.  January also marks the 4th anniversary of  iArch Solutions.  Joe Malewicki, Principal owner, took a leap of faith 4 years ago, and has continued to service clients with the utmost knowledge and attention to their needs.  It is this combination of strengths that keeps clients coming back for our work.  As we continue to add the most experienced technical staff year after year, we strive to consistantly provide the best infrastructure services to our current and future clients.

As we previously mentioned, iArch Solutions is very excited to be hosting a booth at this year’s Kscope 17 conference. Well, we recently found out that our founder, Joe Malewicki will also be a presenter at Kscope 17 in June.  We are now less than 6 months away from Kscope 17, and there is lots to do to get ready for our exhibit… we think it will be the best at the conference!  Thinking about heading to San Antonio for the conference, use our discount code IARCH and receive $100 off your registration.

Looking forward to seeing you in June!

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: November 22, 2016
  • Article by: Joe Malewicki

untitled

iArch Solutions is proud to announce that we will be an exhibitor at Kscope 17 in San Antonio, Texas (June 2017).

Having presented in year’s past, we are excited to share our ideas at one of the top conferences on Oracle products.  Thinking about attending the conference?  Use our special discount code IARCH and save $100 on the registration!!

Come swing by our booth, check us out and enter yourself a chance in winning one of our great giveaways!  Stay tuned for more updates coming soon.  We look forward to seeing you in Texas!

http://www.kscope17.com/vendors

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 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: June 24, 2016
  • Article by: Joe Malewicki

Over the last few weeks Oracle has announced the release of three Patch Set Updates for multiple products.  There was one for Oracle Hyperion Calculation Manager 11.1.2.4.006, one for Hyperion Profitability and Cost Management 11.1.2.4.121 and one for Hyperion Essbase 11.1.2.4.010.

iArch Solutions is offering you a FREE, no obligation (yes we said FREE) Patch Analysis of your mission critical Oracle EPM/Hyperion Financial System of software.

So what are you waiting for?  Let’s jump on a quick web conference and we will perform an analysis of your system.  We will let you know which patches are missing and should be considered for application so that your Oracle EPM system is able to be the most stable, secure and best performing environment possible.  You have nothing to lose, so give us a call (203-880-4268) and schedule your free Patch Analysis today!

Check out the link below to see the prerequisites and additional information about theses PSUs.

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

 

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: June 24, 2016
  • Article by: Joe Malewicki

Over the last few weeks Oracle has announced the release of three Patch Set Updates for multiple products.  There was one for Oracle Hyperion Calculation Manager 11.1.2.4.006, one for Hyperion Profitability and Cost Management 11.1.2.4.121 and one for Hyperion Essbase 11.1.2.4.010.

iArch Solutions is offering you a FREE, no obligation (yes we said FREE) Patch Analysis of your mission critical Oracle EPM/Hyperion Financial System of software.

So what are you waiting for?  Let’s jump on a quick web conference and we will perform an analysis of your system.  We will let you know which patches are missing and should be considered for application so that your Oracle EPM system is able to be the most stable, secure and best performing environment possible.  You have nothing to lose, so give us a call (203-880-4268) and schedule your free Patch Analysis today!

Check out the link below to see the prerequisites and additional information about theses PSUs.

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

 

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 4, 2016
  • Article by: Joe Malewicki

After applying Analytics Provider Services Patch Set Update (PSU) 11.1.2.4.006 we can no longer perform an adhoc analysis to an Essbase application.  The following error is thrown inside of Microsoft Excel with the Smart View add-in:

Error:

—————————

Oracle Smart View for Office

—————————

com/essbase/services/olap/grid/EssGGridOption.setOptionSingleMbrPov(Ljava/lang/Boolean;)V

—————————

OK

—————————

Screen Shot of Error:

Pic1

 

To confirm if there is an issue with the Provider Services (APS) patch you can run a test to confirm the version details for the Provider Services JAPI:

http://:13080/aps/Test

The version of Analytic Provider Services should match the JAPI version.  Our test showed a discrepancy:

Analytic Provider Services – Release 11.1.2.4.006.003 , JAPI 11.1.2.3.4408

Pic2

This issue is being caused by the ess_japi.jar file being a “Read-Only” file. When the new patch was applied it could not update this file.

 

To correct the issue, use the following procedure:

 

Shut down ALL Oracle EPM/Hyperion services or processes.  If you don’t have a system wide stop/start script, check out our earlier post on creating this such item!  How To Create Microsoft Windows EPM/Hyperion Start and Stop Scripts

Once all services are down, locate and change the file system properties at the EssbaseJavaAPI folder level, right-click and deselect “Read-Only.”

Pic3

De-select “Read-only” and click “Apply.”

Pic4

Click “OK”

Pic5

Click “OK”

Pic6

Open an Administrator Windows command prompt (cmd.exe using right-click “Run as Administrator”).

Then you want to rollback the Analytic Provider Services (APS) Patch: 11.1.2.4.006:

For example:

opatch.bat rollback -id 22204266 -oh F:OracleMiddlewareEPMSystem11R1 -jdk F:OracleMiddlewarejdk160_35

Type “y” when prompted and press <enter>.

Pic8

Pic9

This would be an appropriate time to go back and confirm that the ess_japi.jar is no longer set to “Read-Only.”  If it is, re-apply the same steps noted above for changing the parent folder and all sub folders/items to be “non-read only.”

Open an Administrator Windows command prompt (cmd.exe using right-click “Run as Administrator”).

Re-apply the Analytic Provider Services (APS) Patch 11.1.2.4.006:

opatch.bat apply F:OracleMiddlewareEPMSystem11R1OPatch22204266 -oh F:OracleMiddlewareEPMSystem11R1 -jre F:OracleMiddlewarejdk160_35

Pic10

Type “y” and press <enter>.

Pic11

Pic12

Delete all of the contents of the tmp and cache directories for the APS server(s) under the WebLogic Domain.  Do NOT remove the tmp and cache folders themselves, just delete the contents.

Sample locations:

F:OracleMiddlewareuser_projectsdomainsEPMSystemserversAnalyticProviderServices0tmp

F:OracleMiddlewareuser_projectsdomainsEPMSystemserversAnalyticProviderServices0cache

Restart All Oracle EPM/Hyperion System services.

***NOTE***

The above procedures should be performed on ALL servers which are hosting Analytics Provider Services (APS) within the affected Oracle EPM /Hyperion System environment(s).

Test your Analytics Provider Services (APS) URL again:

http://:13080/aps/Test

The version of Analytic Provider Services should now match the JAPI version.

Analytic Provider Services – Release 11.1.2.4.006.003 , JAPI 11.1.2.4.006.003

Pic13

Re-test the Smart View connection and perform an adhoc connection to an Essbase application.  The error should no longer be present and the query should work.

Pic14

 

 

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.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: April 22, 2016
  • Article by: Joe Malewicki

 

Don’t you wish you had a more in-depth understanding of the Oracle EPM/Hyperion System infrastructure?   Have you ever wondered how all of this software actually works under the covers?

Let us guide you in this effort.  iArch Solutions will come to you with our detailed and customized Knowledge Transfer session.  It is our goal to have your IT and Finance Departments on the same page so that your system will continually be a high performing environment.  Some of the topics we will discuss are:

  • Validating your Oracle EPM Hyperion System
  • How to perform baseline tuning
  • Teaching you how to troubleshoot system failures and outages
  • Show you how to safely apply patches to your financial system  environments
  • And much, much more…..

Our experts will empower your team with the confidence and technical knowledge to run your system to it’s fullest ability.

Check out the link below for more information regarding our KT session.  So, what are you waiting for?  Give us a call today for a personalized quote to enhance the knowledge of your staff.

 

Learn more about iArch Solutions Oracle EPM/Hyperion Technical Knowledge Transfer and Infrastructure Training Services

 

iArch Solutions Technical Knowledge Transfer

 

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