Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invoking PushData.sh from Calc Mgr via RUNJAVA - UnsatisfiedLinkError: no HspEssbaseEnv in java.li

Tinotarantino-OracleJun 6 2017 — edited Jun 7 2017

In using 11.1.2.4.9 of calc manager (on-prem).   Single Linux box.   I'm able to successfully run the following MAXL  script from the command line as follows:

essmsh -D /home/oracle/scripts/hp_push.mxls 102265831,3994942673 "Vol1 Program and EC Data Map"

 

File: hp_push.mxls

set message level all;

set ScriptFolder="/home/oracle/scripts";

set LogFolder="$ScriptFolder/logs";

set MapReportApplication="$1";

spool on to "$LogFolder/hp_push.log";

login $key 4460069531625546562382005929635163689811 $key 3420814602475698156005037370310629761660 on localhost;

shell "/home/oracle/scripts/hp_push.sh '$MapReportApplication'";

All this script does is call the shell script: hp_push.sh.   This script is just a wrapper around the planning utility:   PushData.sh.

So for so good !!!!

Next,  I try to run the same script from Calc Manager using RUNJAVA.   See script below. Note:  the script is encrypted and "102265831,3994942673" is the private key;  "Vol1 Program and EC Data Map" is the name of my map reporting application.

RUNJAVA com.hyperion.calcmgr.common.cdf.MaxLFunctions

"-D"

"/home/oracle/scripts/hp_push.mxls"

"102265831,3994942673"

"Vol1 Program and EC Data Map";

Here's the ISSUE.  I get the following stack trace in PushData.log

[Tue Jun 06 07:31:40 EST 2017]: no HspEssbaseEnv in java.library.path

  1. java.lang.UnsatisfiedLinkError: no HspEssbaseEnv 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:1028)

        at com.hyperion.planning.olap.HspEssbaseEnv.<clinit>(HspEssbaseEnv.java:34)

        at com.hyperion.planning.olap.HspEssbaseJniOlap.<clinit>(HspEssbaseJniOlap.java:127)

        at com.hyperion.planning.HspJSImpl.createOLAP(HspJSImpl.java:509)

        at com.hyperion.planning.HspJSImpl.<init>(HspJSImpl.java:177)

        at com.hyperion.planning.HspJSHomeImpl.createHspJS(HspJSHomeImpl.java:662)

        at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(HspJSHomeImpl.java:425)

        at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(HspJSHomeImpl.java:399)

        at com.hyperion.planning.HyperionPlanningBean.login(HyperionPlanningBean.java:746)

        at com.hyperion.planning.HyperionPlanningBean.Login(HyperionPlanningBean.java:628)

        at com.hyperion.planning.HyperionPlanningBean.Login(HyperionPlanningBean.java:758)

        at com.hyperion.planning.utils.HspPushDataUtil.doProcess(HspPushDataUtil.java:189)

        at com.hyperion.planning.utils.HspPushDataUtil.main(HspPushDataUtil.java:57)

Clearly, this is a CLASSPATH, LD_LIBRARY_PATH issue.  However, same MAXL worked fine

executing from the command line.    

This post has been answered by Tinotarantino-Oracle on Jun 6 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2017
Added on Jun 6 2017
7 comments
487 views