Category: Essbase 11.1.2

EPM installTool and configTool – Record Response File for Silent Installation

I use the following to record an installation response file details to use as a future silent install and config task. This will create a unique file name each time, to avoid overwriting the previous: ./installTool.sh -record EPM_11_1_2_4_Install_$(hostname -s)_$(echo $RANDOM)_RunAs_$(whoami).rsp The...

EPM Financial Reporting – Batch Export Folder Locations

EPM Financial Reporting – Batch Export Folder Locations Note: If you have never launched the FRConfig utility or get an error message, do the following step first. Set EPM_ORACLE_INSTANCE path Edit E:\Oracle\Middleware\EPMSystem11R1\products\financialreporting\bin\setInstance.cmd in notepad. Add your EPM_ORACLE_INSTANCE path after the equal...

EPM APS Timeouts – Increase

If users experience this error, the timeout for APS via OHS might be the cause: Smart View Error “Cannot connect to the provider. Make sure it is running in the specified host/port. Error (503) Adjust the APS timeouts for Smartview within...

APS 11.1.2.x Out of Memory Errors

APS occasionally crashes in our Production environment. Our AnalyticProviderServices0.log reveals many “out of memory” errors within all of the java mess in that log file: AnalyticProviderServices0.log: ####<Sep 3, 2014 10:03:12 AM EDT> <Error> <Kernel> <EPMPRWSA> <AnalyticProviderServices0> <[STANDBY] ExecuteThread: '37' for queue:...

Migrating Essbase to New Location

How to migrate Essbase index files and page files for one location to another using Essbase, not symlinks. Log into EAS, and expand the application that you are wanting to move the data for. Right click on the Database and choose...

EPM Hyperion Workspace Repository Items SQL

[ad#ad-post] I had the need to look up all Financial Reporting documents in workspace. I compiled the following list of SQL commands to run against the Oracle database repository. The last command is the winner. http://hyperion-consulting.blogspot.com/2011/09/in-which-tables-reporting-objects-are.html http://hyperion-consulting.blogspot.com/2011/09/in-which-tables-reporting-objects-are.html (posted by Thigulla Krishna) Financial...

Exporting Security Out of Hyperion Planning Application via Oracle Database Repository

I found the below article after hours of searching for a solution for us. I hope this helps others.   EPM 11.1.2 – Exporting Security out of Hyperion Planning application By Ruben Verghese on Sep 03, 2011 copied from https://blogs.oracle.com/pa/entry/exporting_security_out_of_hyperion You...

Copying all files with a certain extension from all subfolders in a directory

I had to copy all of the files (calc scripts) from my Essbase servers’ application directories, and wanted to preserve the folder layout in the destination. I ran the following against all of my servers to achieve this: cp --parents `find...

EAS trying http instead of https when behind load balancer configured with SSL

I ran into an issue when trying to use the https://myepmsuite/easconsole/easclient.jar URL for the first time since configuring SSL on our load balancer. Java opened and tried to load the EAS client, but it stopped with “Unable to launch the application.”...