EPMHFM-65559: Invalid property dbPort for HIT Registry component customURL:HYP_FM


When try create a new HFM application on “Consolidation Administration” receive the error:

EPMHFM-65559: Invalid property dbPort for HIT Registry component customURL:HYP_FM


Execute the command:

Will generate the registry.html

Find the name of conection, in my case is HYP_FM

Execute the command:

epmsys_registry addproperties “#<Object ID>/@dbPort” 1521

Eg: epmsys_registry addproperties “#11d1def534ea1be0S1220cf11154a1c57cd8S7c64/@dbPort” 1521

Restart the EPM Services



Posted in Oracle Hyperion Financial Management, Uncategorized | Tagged | Leave a comment

java.lang.UnsatisfiedLinkError: no environmentjni in java.library.path



After apply the patch receive the service dont start and receive the error message

<Servlet: “AppManServlet” failed to preload on startup in Web application: “eas”.
java.lang.UnsatisfiedLinkError: no environmentjni in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1738)
at java.lang.Runtime.loadLibrary0(Runtime.java:823)
at java.lang.System.loadLibrary(System.java:1029)
at com.essbase.eas.utils.Environment.(Unknown Source)
at com.essbase.eas.server.AppManServlet.setEssbasePath(Unknown Source)
Truncated. see log file for complete stacktrace >



Check if download the correct platform. (32 or 64bits)


Posted in Oracle EPM, Oracle Hyperion Essbase Administration Service | Leave a comment

Installing the pre requirements – Oracle 12c in linux 7


# su
# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol7.repo
Posted in Oracle Database, Uncategorized | Leave a comment

Attribute calculations dimension is absent


When try refresh de application in Planning receive the error

Attribute calculations dimension is absent


Check all members with attribute, Some member in diferent level have the atribute.

Posted in Oracle Hyperion Planning, Uncategorized | Leave a comment


I will create a script to export a data from Sample.Basic and import in Sample.BasicT (is the same outline)


Create LoadData.msh

Name: LoadData.msh
Purpose: Load Data
Created: Jul-09-2014
Author: Celvin Kattookaran
Usage: Maxl script launched from Essbase
Run-time prompts: 7
1 User
2 Password
3 Server
4 Application
5 Database
6 Data file
7 Rule file
Substitution variables: none

Modification History:
MMM-DD-YYYY - Name - description of modification */

/* Spool the results of Load Data process to a log file */

spool on to 'C:\HyperionScripts\Logs\MaxL\Load_Data.log';
set timestamp on;
iferror 'Finish';

/* login with username and password */

login $key $1 $key $2 on $3;
iferror 'Finish';

/* Load Data */
import database $4.$5 data from data_file $6 using server rules_file $7 on error write to 'E:\HyperionScripts\Logs\MaxL\DataLoad.err';

iferror 'Finish';

define label 'Finish';
spool off;

Create the public and private key

Run in Essbase Server

essmsh -gk

Will generate two keys

Public Key for Encryption: 27641,2008785764
Private Key for Decryption: 1519112201,2008785764

Then encrypt the username and password with the comand
esmsh -ep admin 27641,2008785764

Will generate the key: 81656511607325267361473989641049921896510514271342

esmsh -ep password 27641,2008785764

Will generate the key: 8448562280971503442048624798809918246475

Then create a calc to export and import data

DataExportLevel "LEVEL0";
DataExportRelationalFile ON;
DataExportOverwriteFile ON;

FIX ("100-10","New York","Actual","Sales");

DATAEXPORT "File" "," "E:\HyperionScripts\Data\NewYork.txt";

@CalcMgrExecuteEncryptMaxLFile("1519112201,2008785764","C:\HyperionScripts\MaxL\LoadData.msh",@List("81656511607325267361473989641049921896510514271342","8448562280971503442048624798809918246475", "Servidor1", "Sample","BasicT","'C:\HyperionScripts\Data\Export.txt'","Ld_Bas"),






Posted in Oracle Essbase | Leave a comment

After few Minutes the OHS stop (more or less 2 min)


After few minutes the Oracle HTTP (OHS) stop.


Init: Session Cache is not configured [hint: SSLSessionCache]
Oracle-Application-Server-11g/ Oracle-HTTP-Server (Win64) mod_plsql/ mod_ssl/2.2.22 OtherSSL/0.0.0 configured -- resuming normal operations
Server built: , Server Label: unknown
Parent: Created child process 7416
Init: Session Cache is not configured [hint: SSLSessionCache]
Child process is running
WebLogic Server Plugin version 1.1 
Acquired the start mutex.
Starting 512 worker threads.
Starting thread to listen on port 9999.
Starting thread to listen on port 9999.
Starting thread to listen on port 19000.
Starting thread to listen on port 19000.
Parent: Received shutdown signal -- Shutting down the server.
Exit event signaled. Child process is ending.
Released the start mutex
All worker threads have exited.
Child process is exiting
Parent: Child process exited successfully.


[ons-internal] ONS server initiated
[pm-internal] PM state directory exists: \httpConfig\ohs\config\OPMN\opmn\states
[pm-internal] OPMN server ready. Request handling enabled
[pm-requests] Request 2 Started. Command: /start
[pm-process] Starting Process: ohs_component~OHS~OHS~1 (1969095797:0)
[pm-requests] Request 2 Completed. Command: /start
[pm-requests] Request 4 Started. Command: /start
[pm-requests] Request 4 Completed. Command: /start
[pm-process] Stopping Process: ohs_component~OHS~OHS~1 (1969095797:7064)
[pm-process] Process Stopped: ohs_component~OHS~OHS~1 (1969095797:7064)
[pm-requests] Request e Started. Command: /stop
[pm-requests] Request e Completed. Command: /stop
[pm-internal] OPMN server stopped. Request handling disabled


Check the host file. (C:\Windows\System32\drivers\etc\hosts.)

If have myhost.com myhost localhost.localdomain localhost

chage to localhost.localdomain localhost
Posted in Oracle Hyperion Foundation Services | Tagged , , , | Leave a comment

Error 1270076 loading application


When try start application receive the error:

Error : Error 1270076 loading application:

Failed to open file [C:\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\hybrid\\APP\metadata\ess00001.dat]: a system file error occurred. Please see application log for details


  • Stop Essbase
  • Delete/rename de folder  C:\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\hybrid\APP
  • Restart Essbase
Posted in Uncategorized | Leave a comment