Starting EPM 11.2.8 services on distributed Linux environment

 After installing services on distributed environment, the Java Web Services on distributed servers do NOT start.

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

Solution: Copy the /domain/EPMSystem/bin/setstartupEnv.sh script from the Foundation server to the distributed servers

Start the services. 

OR 

1. Add the below variables to the setStartupEnv.sh file

export

JAVA_OPTIONS="-Dhyperion.home=/u01/Oracle/Middleware/EPMSystem11R1 -DHYPERION_HOME=/u01/Oracle/Middleware/EPMSystem11R1 -DEPM_ORACLE_HOME=/u01/Oracle/Middleware/EPMSystem11R1 -DEPM_ORACLE_INSTANCE=/u01/Oracle/Middleware/user_projects/epmsystem1 -Dlogging.folder=/u01/Oracle/Middleware/user_projects/domains/EPMSystem/servers/EssbaseAdminServices0/logs/ -Dserver.name=EssbaseAdminServices0 -Dsun.net.inetaddr.ttl=0 -Djava.io.tmpdir=/u01/Oracle/Middleware/user_projects/epmsystem1/tmp -Doracle.jdbc.useFetchSizeWithLongColumn=true -Doracle.security.jps.config=/u01/Oracle/Middleware/user_projects/domains/EPMSystem\config\fmwconfig\jps-config.xml -Dcommon.components.home=/u01/Oracle/Middleware\oracle_common -Dweblogic.alternateTypesDirectory=/u01/Oracle/Middleware\Oracle_common\modules -Djrf.version=12.2.1.3.0 -Doracle.domain.config.dir=/u01/Oracle/Middleware/user_projects/domains/EPMSystem\config\fmwconfig -Djava.system.class.loader=com.oracle.classloader.weblogic.LaunchClassLoader -d64 -Djava.security.egd=file:/dev/../dev/urandom -DcomponentId=a30d97cf1ea22fc0S1d5b5b21180fbe47665S7a55 -Djava.library.path=/u01/Oracle/Middleware/EPMSystem11R1/lib:/u01/Oracle/Middleware/EPMSystem11R1/products/Essbase/eas/server/bin:/u01/Oracle/Middleware/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin: -DPATH=/u01/Oracle/Middleware/EPMSystem11R1/lib:/u01/Oracle/Middleware/EPMSystem11R1/products/Essbase/eas/server/bin:/u01/Oracle/Middleware/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin: -DEAS_HOME=/u01/Oracle/Middleware/EPMSystem11R1/products/Essbase/eas -DESS_ES_HOME=/u01/Oracle/Middleware/EPMSystem11R1/products/Essbase/eas/server  ${JAVA_OPTIONS}"

export

LD_LIBRARY_PATH="/u01/Oracle/Middleware/EPMSystem11R1/lib:/u01/Oracle/Middleware/EPMSystem11R1/products/Essbase/eas/server/bin:/u01/Oracle/Middleware/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin::${LD_LIBRARY_PATH}"

export

PATH=/u01/Oracle/Middleware/EPMSystem11R1/lib:/u01/Oracle/Middleware/EPMSystem11R1/products/Essbase/eas/server/bin:/u01/Oracle/Middleware/EPMSystem11R1/common/EssbaseRTC64/11.1.2.0/bin:$PATH

ESSBASEPATH="/u01/Oracle/Middleware/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0"

export ESSBASEPATH

ARBORPATH="/u01/Oracle/Middleware/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0"

export ARBORPATH

Then start the managed service like EAS , APS on other node. 

Read More

EPRCS Series: Tips & Tricks: Does your doclet generate overlapped preview?

 Working on Narrative Reporting Tool with word format can be tricky. Does your preview overlap and look like this?

It is merging two doclets due to incorrect formatting. Let us fix this:

1. Open the doclet > Check Out

2. Simple trick is to insert a textbox to easily move the content around the doclet.

3. Format the textbox as shown below to make it invisible and appear as a part of the doclet

4. Layout for the textbox:

 

5. Embed the content/table/referenced ranges inside the textbox

6. Check-in

7. Preview the report again:

Read More

EPRCS Series : Uploading Additional Fonts

 Oracle recommends uploading any custom fonts or additional fonts to the EPRCS cloud instance to generate a pixel-perfect 'preview'. 

On the reference doclet click on "Valdiate Fonts" and view the warning.

Only .ttf are supported. You can upload as follows

1. Go to Library > Fonts

2. You can create a separate folder to organize it

3. Select the TTF file or zip file and upload.

If there are any duplicates it will warn and import the rest of the fonts. 

Read More

What's new with EPM 11.2.6 ?

As promised Oracle has released a new version of EPM this July and here is a quick summary of the fixes.

New Release:

• MS SQL Server 2019 supported
• Essbase Studio removed from EPM Installer 
• Automation of the process of uninstalling or updating Fusion Middleware patches as needed during Apply Update.
• Premier Support is provided through at least 2030
• Updated Oracle HTTP Server
• Support for any identity management product that supports header-based authentication
• Certification of Oracle Hyperion Planning Release 11.2.x with OGNL 3.2.18.
• Install and configure all the WebLogic instances on the same OS except for Essbase which can be on a different OS
• Documentation of database password change procedure in the Oracle Enterprise Performance Management System Deployment Options Guide .

 

Install and configure all the WebLogic instances on the same OS except for Essbase which can be on a different OS. 

 

Supported Upgrade Paths:

 

 EPM 11.1.2.4 to EPM 11.2.X

 

 

 What's in store for EPM 11.2.7?

·       Support for Visual Basic will be removed for all FDMEE customers in Release 11.2.7. Customers should migrate to Jython as the scripting language

·       FDMEE-SAP adapter, SAP adapter will be certified

 

 

 

Read More

Starting OHS with stored nodemanager password EPM 11.2.5

 

The password can be saved in a key file to avoid the password prompt each time on starting the OHS. 

                  

                           startComponent.cmd OHS_component StoreUserConfig

Java Version

 D:\Oracle\Middleware\jdk\bin>java -version

java version "1.8.0_251"

Java(TM) SE Runtime Environment (build 1.8.0_251-b08)

Java HotSpot(TM) 64-Bit Server VM (build 25.251-b08, mixed mode)

Read More