Dedicated to Oracle EPM (Hyperion) on-premises infrastructure topics, such as upgrading, patching and troubleshooting.
Tuesday, August 29, 2017
ASO, ESSCMDQ, and Essbase 184.108.40.206.015+
Oracle published a workaround for this a while ago, in the form of the ESSCMDQ utility. Once installed and we automate the suggested ASO restructure script, this was a reliable way to avoid the 255 limitation.... until very recently!
A few patches ago, ESSCMDQ started behaving... erratically. Sometimes the restructure script would complete, and other times ESSCMDQ would crash. The crash message would complain about a DLL within the Microsoft Windows version of the 220.127.116.11 Essbase Client, such as ESSOPGN.dll.
It just so happens that Oracle discovered this and published an update, but you have to dig for it within the Knowledge Base!
The Knowledge Base article # on support.oracle.com is "2273191.1". This article acknowledges the bug and includes a download link to a version of ESSCMDQ.exe recompiled for Essbase 18.104.22.168.015 and higher. Unfortunately, this version isn't included on the main download page for ESSCMDQ.
Oracle is issuing patches for on-premises Essbase 22.214.171.124 at the pace of about once every 2 months. Since 126.96.36.199.0 first came out, as of this writing 19 cumulative patches have been issued for Essbase. This means if you are using ASO and are on 188.8.131.52.015 through 184.108.40.206.019, you will want to hit the "2273191.1" article and grab the newer version of ESSCMDQ.
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!
Understandable, have a nice day. Last time I installed the programs, I faced "dll not found" and I had to deal with vcruntime140.dll missing https://fix4dll.com/vcruntime140_dll after the installation was completed, as required, this file worked correctly, and I was able to complete the installation of the programs properly.ReplyDelete