Monday, May 14, 2012

Multiple Sets Of ODI Scenarios Are Triggered When Running ERPI Data Load Rule From FDM 11.1.2



Multiple Sets Of ODI Scenarios Are Triggered When Running ERPI Data Load Rule From FDM 11.1.2 [ID 1275584.1]

 Modified 03-JAN-2011     Type HOWTO     Status PUBLISHED 

In this Document
  Goal
  Solution
  References

Applies to:

Hyperion Financial Data Quality Management - Version: 11.1.2.0.00 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Goal

Multiple sets of ODI scenarios are launched for an ERPi data load rule that is executed from an FDM import.  The scenarios are launched at 5 minute intervals as seen in the ODI operator.

This only seems to occur when running the ERPi Data load rule from FDM using the source adapter import.

When the same data load rule is run from the ERPI web interface this issue does not occur.

What causes this issue and how can the timeout be increased?

Solution

When using Oracle HTTP Server (OHS) as the web server the default timeout is set at 5 minutes. In order to increase the timeout the following must be performed.

In the C:\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component directory you will find a mod_wl_ohs.conf file. In this file you will find:

WLForwardUriUnparsed ON
KeepAliveEnabled ON
KeepAliveSecs 20
DynamicServerList OFF


Add the following two lines just after the KeepAliveSecs 20 line

WLIOTimeoutSecs 1800
HungServerRecoverSecs 1800

Restart the OHS Service and ERPi Web Service.

No comments:

Post a Comment