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
- 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.