Monday, March 30, 2020

Planning RMI 11.2: "Could not find the service start class" SOLUTION

I spent more time troubleshooting this than I care to admit.  Rather than walking you through the things I tried, let's cut to the chase!

Symptom Observed:
You start the "Oracle Hyperion RMI Registry" service in the Control Panel or via a script.  The service shows it is running and no logfiles reveal an up/down status for it.

Meanwhile, your classic Planning batch scripts don't work like they used to...


Digging deeper with traditional port checking tools, we see the RMI port 11333 is not listening.

Finally, we check the Windows Event Viewer.


Oh boy, this is going to be a long day...

Quick Tip:
Search engines and the Oracle Knowledge Base don't have current information on this "could not find the service start class" error yet, at least not where Oracle EPM 11.2 is concerned.  There's some older articles out there about ports, service names, etc. that don't lead you to a solution.  Hopefully this blog entry will help!

Solution:
First, export this portion of your Windows Registry in case you want to roll back to the original configuration:

Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\HyS9RMIRegistry_epmsystem1\Parameters

And here it is!

Planning RMI is still using the old Java 6.

I haven't dug enough to find the exact culprit, but there's likely a mix of Java class files in RMI where some were compiled with Java 6, and others with Java 8.  Java 6 can't run Java 8 classes, but Java 8 can often run both Java 6 and Java 8 classes.

So the trick is to locate a "jvm.dll" file that is Java 8 and 32-bit. I tried using a 64-bit one and it immediately complained I was mixing 32-bit and 64-bit.

In a vanilla EPM 11.2 system, you will have a 32-bit Java 8 if you allowed it to install the 32-bit Oracle Database Client.  The file is:

\Oracle\Middleware\dbclient32\jdk\jre\bin\client\jvm.dll

Replace the "JVMLibrary" Data value in my screenshot above so your system looks like this:


Bounce RMI, and suddenly port 11333 is working and you may continue with your day.

Here's hoping a more official fix will be forthcoming!
 
Aug 22, 2020 Update: This is also an issue in the Windows version of EPM 11.2.2.0.

Sunday, March 29, 2020

Q&A From March 12 2020 Webinar

We ran out of time in our ODTUG EPM 11.2 Webinar to get to everyone's questions, so we had to rush through it.  Without further ado, here's the questions submitted in writing by attendees.  I'll discuss them in no particular order and exactly as they were submitted.

Q: Does 11.2 still have rapid deployment option?
A: Yes.

Q: So no more CopyApp Utilities to migrate HFM Apps between environments?
A: No, the venerable HFMCopyApplication utility was deprecated in 11.1.2.4.  In theory, the latest patch of the utility from 11.2.3.7xx could work, followed by running the HFMUpgradeApplication utility.  In practice, I believe Oracle Support would advise migrating via the HFM LCM Snapshot instead (if, and only if, you are on 11.1.2.4).  Or, use the Import Application link in Navigate->Administer->Consolidation Applications.

Q: Is RCU schema/database needed per application server or per environment?
A: One per application server.  A pure Essbase server with no WebLogic web apps wouldn't need it.

Q: Is Windows Server 2019 only supported or okay to install Windows Server 2012 or 2016?
A: In theory, yes you can put 11.2 on either Server 2012 R2 or 2016.  I've done it myself.  In practice, I'd advise against it using 2012 and 2016.  You want to use server operating systems specifically vetted and certified by Oracle Corporation.  Oracle has only certified Server 2019 at this time for 11.2.

Q: Any word on Oracle 18c or 19c support?
A: Terrific question and I'm getting asked this more and more.  I'm told by DBAs that 19c is essentially 12c technology with bugfixes sitting on top of it.  I know of at least one customer who is using 19c successfully for their EPM 11.1.2.4 system.  I would love to see certification from Oracle on 19c.

Q: Understand Financial Reports with Essbase connection cannot be migrated from 11.1.2.4 to 11.2? Is that right?
A: The Essbase connection type is visible as a drop-down in Database Connection Manager. I'll need one of my report developers to kick the tires to see if it works.  Sorry I don't have a definitive answer yet!

Q: Hello, how can I  save the nodemanager password so when I start OHS I don't have to type the password in windows?
A: Yes!  The syntax is all on one line:
\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\bin\startComponent.cmd ohs_component storeUserConfig
You only need to do this one time per OHS server.  Be mindful that if a different userID needs to perform restart maintenance, that person either needs to be trained on this process, or you put it in a script from them to double-click.  You will be prompted to type in epm_admin's password, and then you won't be asked again.

Q: will you be supported by oracle if you install 11.2 on ANYTHING other than Windows 2019 server.
A: I can't answer for Oracle on this point.  Depending upon who is assigned to work on your SR, someone might kick it back at you.  My personal recommendation is to use certified operating systems only - especially where Production is concerned.

Q: Any word on when Rhel7 server version for EPM 11.2 will come out?  Other then soon?
A: "Soon".  :)  I have not received any specific guidance beyond what is available for public consumption.

Q: Users will probably miss the Home page in 11.2.  Any workaround, or plan for bringng that back?
A: As a workaround, users can set their preferences so a specific app launches upon login.  The loss of the Home page is a byproduct of the architectural change that removed Reporting & Analysis Framework.

Q: what is the replacement for the HFR studio thick client?
A: The Reporting Web Studio is available within EPM Workspace and was first introduced by Financial Reporting patch set update 11.1.2.4.700.  In 11.1.2.4.7xx there's a manual OHS configuration step before it appears to users.  It works out-of-the-box in 11.2 without needing to manually update OHS.  Several PSUs were issued since then which improved parity with the thick client.  Customers who are on 11.1.2.4.700 or higher are urged to become familiar with the web studio before making the jump to 11.2.  Alternatives would be saved SmartView templates or other technology.


Thursday, March 26, 2020

March 12 2020 webinar - because you REALLY want to hear my voice?

EPM 11.2 Upgrade - Lessons Learned

I have a face for radio, but not the voice!  If you can withstand my voice, click the link above and listen to findings about the Oracle EPM 11.2 upgrade.

A big THANK YOU to the nice people at ODTUG for hosting this session and allowing me to present!

Wednesday, March 4, 2020

Upcoming EPM 11.2 Webinar March 12 2020


Thursday, March 12, 2020 12:00 PM - 1:00 PM EDT
EPM 11.2: Lessons Learned and 2021 Preparedness
Dave Shay, Datavail

Webinar abstract:


As we all know, Oracle EPM 11.2 is here! But…it was released too late in 2019 for most organizations to budget an on-premises EPM upgrade for fiscal 2020. However, the end of support for 11.1.2.4 is also looming in 2021. If you’re staying on premises, an upgrade to 11.2 should go live no later than December 2021 (earlier if subject to SOX controls).

Rather than waiting for the next budget cycle to roll around, this webinar will show attendees how to prepare for an upgrade this year without spending significant time and capital. We’ll also share what we’ve learned while upgrading to 11.2 and what you can expect post install.


Visit this link to reserve your free spot!

Avid readers of this blog will be familiar with a good chunk of the content I'll present.  In this session I'll do my best to condense observations collected since the Dec 18 2019 Oracle EPM 11.2 Release Date into a 1-hour session.

The session will include Q&A at the end.

Thanks to ODTUG for sponsoring this session!