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

Problem

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

Solution

Execute the command:
epmsys_registry

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

 

 

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

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

 

Problem

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 >

 

Solution

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

Type

# 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

Problem

When try refresh de application in Planning receive the error

Attribute calculations dimension is absent

Solution

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

Posted in Oracle Hyperion Planning, Uncategorized | Leave a comment

@CalcMgrExecuteEncryptMaxLFile

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;
logout;
exit;


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


SET DATAEXPORTOPTIONS
{
DataExportLevel "LEVEL0";
DataExportRelationalFile ON;
DataExportOverwriteFile ON;
};


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


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


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


ENDFIX

 

 

 

 

Posted in Oracle Essbase | Leave a comment

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

Problem

After few minutes the Oracle HTTP (OHS) stop.

OHS Log

Init: Session Cache is not configured [hint: SSLSessionCache]
Oracle-Application-Server-11g/11.1.1.7.0 Oracle-HTTP-Server (Win64) mod_plsql/11.1.1.0.0 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.

OPMN Log

[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

Solution

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

If have

127.0.0.1 myhost.com myhost localhost.localdomain localhost

chage to

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

Error 1270076 loading application

Problem

When try start application receive the error:

Error : Error 1270076 loading application:
[Local/APP///1285256/Error(1270076)

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

Solution

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