Hyperion / Oracle EPM 11.2.6.0 is out on Oracle eDelivery today (original date of this post: July 20, 2021... because The Internet Is Forever).
As with all EPM 11.2.x releases, it is very important to carefully crawl through the README before installing it. Especially if you've never installed an EPM 11.2.x release before. 11.2.x is not your granddaddy's Hyperion!
If you're new to my blog, here are a few high-level points to be aware of:
Oracle has provided guidance within their latest EPM 11.2.x README's that, generally speaking, updates will be provided as new .dot releases rather than as PSUs for individual modules. The exceptions to this rule are the Essbase 11.1.2.4 Suite that's used under the covers and also Oracle DRM.
RCU is not your friend. Search the "RCU" tag on my blog. RCU is not optional in 11.2.x and you will suffer if you overlook this crucial step.
Likewise search my blog for the "OHS" tag. You don't get a Windows service for Oracle HTTP Server ("OHS") in 11.2.
There are a few one-off PSEs coming out, but first check the quarterly Critical Patch Update announcements, such as the one that came out today. There are some very severe vulnerability scores addressed in the July 2021 update:
July 2021 Oracle Critical Patch Update
Other one-off patches may come out at Oracle's discretion, so check Oracle's on-premises EPM blog every month to stay aware of what's new:
Back to the topic at hand....
I tend to go through 2-3 iterations when new 11.2 dot releases come out:
- Fresh install on a fresh Windows VM.
- Attempt an in-place upgrade on an older Windows VM.
- Fresh install on a fresh Red Hat Linux VM.
Hi Dave.. I have been reading your blogs regularly.. Thanks for that.
ReplyDeleteI need 1 help if you can advise..
We are in a process to install 11.2.6 EMP system.. currently using 11.1.2.4 version. Our current user's are very frequently using Generic jobs in Workspace using URL in task list.
Now in 11.2.6, Generic jobs are removed , so can you please suggest any alternative how user's can trigger batch scripts now? We also explored Windows Task scheduler but did not find helpful.
Thanks
Vishal
Hello Vishal, thanks for your comment. An interesting question.
DeleteIf you have Calculation Manager and Essbase, one way you could do this is you could create a CalcManager script (it needs to be in script mode, not graphical mode). You create a little script like this:
RUNJAVA com.hyperion.calcmgr.common.cdf.MaxLScriptFunction
"SHELL D:\Scripts\YourScript.bat"
"exit"
;
In the above example, D:\Scripts\YourScript.bat (the name I picked was arbitrary... it can be anything on any drive) exists on your Essbase server. If if the script you truly want to run resides on a non-Essbase server, and if you're running a Windows environment, YourScript.bat would use the built-in WMIC (do a web search for the syntax) to invoke the script you want to run on the foreign server.
wmic syntax example:
wmic /node:FOREIGNHOSTNAME process call create "echo hello > d:\scripts\hello.log"
Good luck!
Dave
HI Dave.. Thanks for your response.. I tried multiple ways to run batch script in and outside Essbase server however not able to achieve this. Not sure if anything is missing in server to execute this from CalcMgr. My job is not getting triggered .
ReplyDeleteHi Vishal,
DeleteThere are multiple ways to get one EPM server to invoke a job that runs on another EPM server. Without providing free consulting on all the various options work specifically, I will give these tips:
No matter which option you try, you will have a hard time if all of your services (I'm assuming you're running on Windows) are running as "Local System" rather than as a named AD service account. While this is my personal opinion, multiple back-to-back on-premises upgrade projects have proven me right each time.
Powershell, built-in "wmic", and 3rd party "psexec" are just 3 options to look into outside of CalcMgr->Essbase RUNJAVA. Server-to-server integrations can get messy.
Again, good luck :)