Quick & Dirty reference doc on what’s DIFFERENT in HFM 11.1.2.4

Link to reference document:

Oracle Doc ID 2015669.1

CONTENT in above referenced and linked article:

1. New Features in HFM 11.1.2.4
2. Architectural Changes
New Platform Support
Configuration Changes
Differences in Architecture between 11.1.2.1 and 11.1.2.4
3. Utilities/Tools/Logs That Are No Longer Used in 11.1.2.4 – Things an HFM Admin Should be Aware of
4. References

UPDATE:
****HFM copy app utility is now “kinda” available with HFM 11.1.2.4.101 patch 21749351; it is a Copy app utility type functionality using the the BRC (Backup & Recovery utility) that LCM also uses.

DSF initialization error ORA-00904: “PROCESSNAME”: invalid identifier – UPGRADE issue from 11.1.2.1.600 still exists even with 11.1.2.4

Issue:

If the Shared Services database schema is not upgraded completely, and you have a DSF initialization error ORA-00904: “PROCESSNAME”: invalid identifier in the Shared Services log file, this indicates that the Foundation Service upgrade scripts failed to execute, and the Shared Services schema was not upgraded to Release 11.1.2.4.

Cause: Foundation Service upgrade scripts failed to execute which results in Shared Services schema not upgrading to Release 11.1.2.3/11.1.2.4.

Resolution:

  1. Restore the Shared Services database to the Release 11.1.2.1.600 database backup taken before attempting to upgrade.
  2. Execute the following SQL scripts based on the database type configured from the SQL client connecting to the restored Shared Services database:

For an Oracle database: m DROP INDEX CSS_DELTA_TRANSACTION_IDX; m DROP SEQUENCE CSS_DELTA_TRANSACTION_ID_SEQ; m DROP TABLE CSS_GROUP_CACHE_DELTA CASCADE CONSTRAINTS; m CREATE TABLE CSS_GROUP_CACHE_DELTA (GROUP_IDENTITY VARCHAR2(200 BYTE) NOT NULL, ACTION_TYPE NUMBER(1, 0), VALUE1 VARCHAR2(256 BYTE), VALUE2 VARCHAR2(1000 BYTE), UPDATEDTIMESTAMP TIMESTAMP(9) WITH TIME ZONE DEFAULT (SYSTIMESTAMP) NOT NULL); l

For an MS-SQL Server database: m DROP INDEX CSS_DELTA_TRANSACTION_IDX ON CSS_GROUP_CACHE_DELTA; m DROP TABLE CSS_GROUP_CACHE_DELTA; m CREATE TABLE CSS_GROUP_CACHE_DELTA (GROUP_IDENTITY NVARCHAR(200) NOT NULL, ACTION_TYPE NUMERIC(1, 0), VALUE1 NVARCHAR(256), VALUE2 NVARCHAR(1000), UPDATEDTIMESTAMP DATETIME NOT NULL); l

For an IBM DB2 database: m DROP INDEX CSS_DELTA_TRANSACTION_IDX; m DROP TABLE CSS_GROUP_CACHE_DELTA; m CREATE TABLE CSS_GROUP_CACHE_DELTA (GROUP_IDENTITY VARCHAR(200) NOT NULL, ACTION_TYPE NUMERIC(1, 0), VALUE1 VARCHAR(256), VALUE2 VARCHAR(1000), UPDATEDTIMESTAMP TIMESTAMP NOT NULL );

  1. Commit the transaction.
  2. Reuse the database to upgrade Release 11.1.2.1.600 to Release 11.1.2.3/11.1.2.4.

Source

Successfully re-run the OBIEE 11.1.1.9 instance configuration after a failure #EPM #OBIEE #Oracle

So you were installing OBIEE, and the configuration failed halfway through? Don’t panic we have you covered.

ISSUE: unable to re-run OBIEE configuration after failure

CAUSE: OBIEE failed instance must first be cleanly removed

Resolution: You’ll need to remove the instance the initial configuration created. You can quickly remove the instance by launching a command line, browsing to <MIDDLEWAREHOME>\Oracle_BI1\oui\bin and running “setup.exe –deinstall”. (Note: Your WebLogic Admin Server will need to be running, so start it up if you haven’t already)

Next you’ll want to select “Deinstall ASInstances…”

OBIEE1

Then populate your server details and select the instance in question, as such…

OBIEE2

Next select the Oracle instance(s) you would like to deinstall

OBIEE3

Click De-install to remove the instance

OBIEE5

Select “Deinstall” and let it run its course.

At this point, you should be able to run the configuration utility again (<MiddlewareHome>\Oracle_BI\bin\config.bat) to restart the configuration piece of your OBIEE installation.

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.