Sunday, February 20, 2022

EPM 11.2.x and Quarterly Java Update - Be Careful!

So far I've discovered 2 issues with respect to the Quarterly Oracle "Critical Patch Update" (abbreviated "CPU" henceforth) and Hyperion / Oracle EPM 11.2.x.

The problem seems to have been introduced with the October 2021 CPU and continues to be present in the January 2022 CPU.

So far, I've observed 2 symptoms:

  1. The legacy frconfig utility fails to launch.  No error message is provided.  The javaw process appears briefly in your process list and then closes.
  2. The EAS Console screen that is supposed to display a graphical chart when viewing ASO Essbase aggregate information is blank.
Here's how you can definitively know if you have the issue, and what you can do about it.

With respect to item #1 above, Oracle does have a Knowledge Base article about it.  It takes a bit of digging to find.  Essentially, Oracle acknowledges that the Quarterly CPU delivers an incomplete Java 8.

So let's say you blow away \Oracle\Middleware\jdk's content and replace it with the latest Java CPU.  After all, that's what we've been doing for years, so why change our techniques?

Don't do that anymore!

Whether you are in Linux or Windows, you need to count the number of files in the jdk folder before and after you apply the CPU.  In Windows you can right-click the folder and hit Properties.  Look at the file count.  If the number of files is below 900 after applying the CPU (typically I've seen it is in the mid-300's), you got hit with the problem.

The better way forward is to follow this procedure:
  1. Back up your Middleware\jdk folder.
  2. Download the Java 8 quarterly CPU.  Don't run the installer.  In the case of Windows, use 7-zip to unzip the included .gz file and then again use 7-zip to unpack the .tar file included therein.  Linux nerds like me know what to do on the Linux side of the fence.
  3. MERGE the files extracted from the tar into your Middleware\jdk.  This will replace your JDK binaries that WebLogic cares about, while also preserving the JRE files that include JavaFX (EAS Console wants these) and the stuff frconfig needs.
I am hoping this condition is temporary.  Oracle knows about it because they published the KB article about it, although the workaround they suggest is something I don't agree with.

The last KB article I read said to uninstall Java 8 (how? Java 8 is bundled with EPM and there's no uninstaller in the Windows Control Panel for it - I'm speaking Windows here as that is what the bulk of my customers use nowadays), reinstall the base Java 8 release, and then install the CPU on top of it as an "in-place upgrade".  How?  Old EPM Infrastructure dinosaurs like me can figure it out, but there are many folks new to EPM 11.2.x and trying to unpack all of this knowledge is a daunting task.

The above is my own opinion, so your mileage may vary.




3 comments:

  1. Hi Dave, We are currently on 11.2.5 and 11.2.4 trying to apply OHS patches collocated of Jan 2022 as we installed HTTP server via Configtool while installing Hyperion products. Any idea what exactly going wrong here ? Patch: 33619347

    [Mar 4, 2022 7:25:19 PM] [INFO] Files conflict detected, CBCC cannot resolve.
    [Mar 4, 2022 7:25:19 PM] [INFO] Common File: D:\Oracle\Middleware\oracle_common\modules\com.bea.core.apache.log4j.jar, in patch (33791665) and (32300397)
    [Mar 4, 2022 7:25:19 PM] [INFO] Not all patches are cbcc enabled
    [Mar 4, 2022 7:25:19 PM] [INFO] Files conflict detected, CBCC cannot resolve.
    [Mar 4, 2022 7:25:22 PM] [INFO] Checking if Oracle Home has components required by patches...
    [Mar 4, 2022 7:25:25 PM] [INFO] Skip patch 33619405 from list of patches to apply: This patch is not needed.
    [Mar 4, 2022 7:25:25 PM] [INFO] CheckMissingComps: Cached file does not exist or is invalid, re-build prereq result.
    [Mar 4, 2022 7:25:25 PM] [WARNING] OUI-67124:
    After skipping patches with missing components, there are no patches to apply.
    [Mar 4, 2022 7:25:25 PM] [INFO] UtilSession: N-Apply done.
    [Mar 4, 2022 7:25:25 PM] [INFO] --------------------------------------------------------------------------------
    [Mar 4, 2022 7:25:25 PM] [INFO] The following warnings have occurred during OPatch execution:
    [Mar 4, 2022 7:25:25 PM] [INFO] 1) OUI-67124:
    After skipping patches with missing components, there are no patches to apply.
    [Mar 4, 2022 7:25:25 PM] [INFO] --------------------------------------------------------------------------------
    [Mar 4, 2022 7:25:25 PM] [SEVERE] OUI-67008:OPatch Session completed with warnings.

    ReplyDelete
  2. Oracle Engineer OHS team unable to confirm is it collocated OHS or standalone OHS, as they asked me to run viewinventory.cmd where its displaying only OHS product details not other products installed on platform.
    Oracle Home: D:\Oracle\Middleware
    Distribution: Oracle Data Integrator 12.2.1.4.0
    FeatureSet: cieCfg_wls_shared_external 12.2.1.4.0
    Component: oracle.fmwconfig.wls.shared 12.2.1.4.0
    Component: oracle.fmwconfig.common.wls.shared.external 12.2.1.4.0
    FeatureSet: cieCfg_wls_external 12.2.1.4.0
    Component: oracle.fmwconfig.common.wls.external 12.2.1.4.0
    FeatureSet: db_nlsoramapping 19.3.0.0.0
    Component: oracle.nlsoramapping.jrf 19.3.0.0.0
    FeatureSet: db_nlsrtl 19.3.0.0.0
    Component: oracle.nlsrtl.jrf 19.3.0.0.0
    FeatureSet: db_xdkNoJaxp 12.2.1.4.0
    Component: oracle.xdk.jrf.jaxp 12.2.1.4.0
    Patch: ID: 26626168 UID: 23644760
    FeatureSet: db_xdb 19.3.0.0.0
    Component: oracle.rdbms.jrf 19.3.0.0.0
    FeatureSet: glcm_common_logging 13.9.4.0.0
    Component: oracle.glcm.logging 1.6.4.0.0
    FeatureSet: glcm_common 13.9.4.0.0
    Component: oracle.glcm.comdev 7.8.4.0.0
    Component: oracle.glcm.dependency 1.8.4.0.0
    Component: oracle.glcm.xmldh 3.4.4.0.0
    Component: oracle.glcm.wizard 7.8.4.0.0
    FeatureSet: jrf_dmsJse 12.2.1.4.0
    Component: oracle.jse.dms 12.2.1.4.0
    FeatureSet: jrf_dmsCommon 12.2.1.4.0

    ReplyDelete
    Replies
    1. OHS in EPM 11.2.x has its own opatch subfolder. If you are still having issues, try running lsinventory from there. If this in the 2nd paste:

      Oracle Home: D:\Oracle\Middleware

      This suggests to me you ran it from Middleware rather than OHS. OHS has its own patch inventory.

      Delete

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!