Essbase Studio was removed in Hyperion / Oracle EPM 11.2.6.0. You need to figure out a different way to build your Essbase cubes. As the point of this blog post is not to give free application consulting, I'm going to pass over this particular topic and instead help those who are still using Essbase Studio 11.1.2.3 through 11.2.5.0 on Linux.
There's a little bug with how Essbase Studio Server was packaged for Linux, and I first detected it when doing an 11.1.2.3 upgrade back in the day. The problem persists in 11.1.2.4, and I suspect the 11.2.0.0 through 11.2.5.0 releases have the exact same issue.
And here is the root cause and solution!
The symptom: You run the pre-built start script for Essbase Studio Server on Linux, in your user_projects/epmsystem1/bin/ folder. The script doesn't complain, but you never see the Java process for Essbase Studio Server start up. What's going on here?
The root cause: installtool.sh doesn't set the UNIX filesystem permissions correctly for the back-end Essbase Studio Server scripts.
The fix:
cd to your EPMSystem11R1 folder
Type (you will have to tweak this depending upon the variation of UNIX you are running)
find . -name *.sh -exec chmod ug+x {} \;
Done. You've nuked it from orbit and changed all shell scripts to be executable by the owner and the group.
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!