Wednesday, February 7, 2018

HFM Task Flow and Schedule task not running on time

We upgraded to 11.1.2.4 from 11.1.2.2 and noticed our Task Flow scheduling jobs would not run on the given date/time.  After opening Oracle SR and going thru a bunch of patches, this was discovered:

You need to patch your Planning to 11.1.2.4.007 (And some pre-requisite patches) since there is a component called the "Quartz Scheduler" used by Planning, HFM and Calc Manager.
Oracle Development has determined the issue is caused how Planning interacts with the scheduler. That is why the Patch is coming from the planning.

Issue now resolved.

Thanks,


Thursday, February 1, 2018

Hyperion Patching 11.1.2.4 and Review Patches applied command

Many times we run into situation where we have applied a patch PSE or PSU and we forgot to note it down.   You can run this command on each server and review the patches applied with Patch Details, Date and Time:

Results will be stored in your Hyperion Folder under this path (I have my Oracle software installed under E drive)  E:\Oracle\Middleware\EPMSystem11R1\cfgtoollogs\opatch

Filename will be opatchYYYY-MM-DD_HH-MM-SS(AMorPM)_1.log

Use Notepad++ for the best viewing option
  1. From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch (example C:\Oracle\Middleware\EPMSystem11R1\OPatch)
  2. For Windows run: (make sure to confirm the proper JDK path - refer to the example below)
    opatch.bat lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29 > patchlist_servername.txt