Essbase developers! Mind your WORKERTHREADS in 11.1.2.4

Hello Devs! With 11.1.2.4 WORKERTHREADS are no longer dynamically assigned when in parallel processing.

Historically, Essbase dynamically created threads for parallel operations such as parallel calculation, parallel data load, and parallel restructure. However, beginning in Release 11.1.2.4.000, the following parallel operations do not dynamically create threads, but instead use a set number of threads from a pre-created pool of threads:

  • Parallel calculation, with CALCPARALLEL or FIXPARALLEL
  • Parallel data load, for aggregate storage and block storage databases
  • Parallel export, for block storage databases
  • Parallel restructuring

Oracle recommends the following settings, depending on your system architecture.

threads

For more information please see the below technical reference.

Technical Reference: Click Here

Hyperion Planning 11.1.2.4 “Error connecting to database connection DRPLAN:Plan1: [0] MSG_ADM_ERR_LOADING_OBJECT…”

During a recent implementation of a highly distributed and highly available 11.1.2.4 Hyperion Planning environment we came across the following error “Error connecting to database connection DRPLAN:Plan1: [0] MSG_ADM_ERR_LOADING_OBJECTcom.hyperion.ap.hsp.thin.HspException”

ISSUE:

In version 11.1.2.4, an intermittent error occurs when setting up a Financial Reporting (FR) data source connection to Hyperion Planning when you have multiple instances of Hyperion Planning running on the same server or multiple servers.

CAUSE:

Bug in Hyperion Planning when it is vertically or horizontally scaled.

RESOLUTION:

We were provided with a PSE. The number is 21650002.

Check to see if it is available on Oracle Support otherwise you will have to request it from them through an SR.

The change is in the HspAdm.jar file that resides under ADM and ADM-64 path, after applying issue was resolved.

Patch Link: Click Here

IIS 8.5 Window Server 2012 R2 – How to install & remove

Are we done with IIS when it comes to Oracle EPM? Not just yet.
The following products require IIS & ASP.NET support enabled before installation of the EPM System product:

Performance Management Architect Service (Dimension Server)
Strategic Finance
Data Relationship Management

To assist with this infrasolved has provided a guide below, enjoy.

IIS Install Steps
Launch the Server Manager to add a role

Select Application and Web Server IIS, next

Next

Select COM+ Network Access & Web Server IIS Support, next

Select IIS 6 Management Compatibility, next

Click Install

Installation Succeeded

IIS Uninstall Steps

Launch the Server Manager to remove a role
Once launched click on Manage and then Remove Roles and Features

Uncheck Application Server and Web Server (IIS) click next

Expand NET Framework 4.5 Features and uncheck “ASP .NET 4.5” & “WCF Services”, select next
** IMPORTANT ** DO NOT UNCHECK “.NET Framework 4.5” by doing so you will be removing the Windows GUI/shell which then has to be restored via command prompt (See below to Recover Server GUI for fix)

Reboot to Complete Uninstall of IIS

Recover Server GUI

Chances are if you’re reading this portion of the post you removed .NET Framework 4.5 and now you’re left with a command prompt when booting.

Remain calm we can resolve this by completing the below step.
Enter the following in a command prompt window and press enter:

dism /online /enable-feature /all /featurename:Server-Gui-Mgmt /featurename:Server-Gui-Shell /featurename:ServerCore-FullServer

Y to reboot

Once Reboot is completed GUI will be restored.