I posted previously about my adventures working with Hyperion / Oracle EPM 11.2.2.0 in a Linux environment. One thing that stood out, which I've reproduced and have also received confirmation about from some of my commenters here, is Analytic Provider Services (APS) produces a WebLogic error message during APS's startup sequence.
The error message is hard to decyper, but it essentially complains that something is misconfigured within the aps.ear file.
This error does not happen in the Windows counterpart of EPM 11.2.2.0.
I discovered the following 2 solutions during my regression testing, and wanted to share. So here goes!
Solution 1
Stand up a little throwaway Windows Server 2016 or 2019 virtual machine. Install Essbase Plus 11.2.2.0. In installtool.bat, just pick Foundation and APS. You don't need to configure/deploy. Just the install is sufficient! Once APS is installed, stop APS on Linux and then copy aps.ear from the Windows VM to your Linux server. Clear AnalyticProviderServices0's \tmp and \cache subfolders. Then restart APS in Linux and you should be good to go.
Or....
Solution 2
APS is actually a patch within the 11.1.2.4 stack. The patch is over one year old (11.1.2.4.033 or 11.1.2.4.031). The Linux version of this specific patch is apparently problematic. In Linux, download and OPatch a higher series of patches for the Essbase stack, such as 11.1.2.4.040 or 11.1.2.4.041 as of this writing. You will need to patch the entire Essbase stack: Essbase Agent, Essbase Runtime, Essbase Client, APS, and EAS Server. The APS patch notes tell you which patches are certified for the specific patch version you decide to grab.
Stop the stack, run OPatch for the patches where needed, clear /tmp and /cache for each web service you patched, and restart. No need to reconfig/redeploy.
My results
I've done both Solution 1 and Solution 2 within different test sandboxes. Both worked for me.
Take care with respect to Solution 2 if you're running Essbase ASO cubes. If you read through the patch notes from 11.1.2.4.033 through 11.1.2.4.041, you'll see lots of issues relating to ASO. I suspect the Essbase developers at Oracle aren't done tweaking ASO yet.
No comments:
Post a Comment
Thank you very much for your interest in this blog! I hope you're finding it helpful.
Please keep comments relevant to the topic in the post, as this blog is not a free-for-all substitute for Oracle Support or traditional consulting. If you have many questions unrelated to the specific topic at hand, consider contacting me on LinkedIn (https://www.linkedin.com/in/daveshay) so we may discuss the possibility of consulting.
Commenting on posts older than 90 days unfortunately goes into moderation, thanks to spammers who've been hitting this blog. Please have patience, and thanks for your understanding!
Comments including URLs linking back to gambling or other things unrelated to Oracle EPM will be deleted on sight. If you're an EPM consultant and are offering me constructive criticism or a tip, go ahead and DO link back to your blog or firm's website if you so desire.
Thanks again for reading!