Analytics Software

Guys,

has anyone succeded in calling the CalcMgrCmdLineLauncher utility (11.1.2.3) from a different server other than the Planning one?

I have updated all paths i could see in the setHPenv.bat and CalcMgrCmdLineLauncher.cmd of the planning server from rather than D:\Oracle\Middleware.... to \\PlanningServername\D$\Oracle\Middleware....

but still get java not finding the rights classes when i call upon the utility from my FDM server. this is such a nice functionality to launch business rules rather than calculation scripts after an FDM export to Essbase that i really don't want to miss thisone out.

here are my doing details:

I run this from the FDM server

\\PLANNINGSERVER\E$\CRIS_SHARE\Batches\CalcMgrCmdLineLauncher.cmd -f:\\PLANNINGSERVER\E$\CRIS_SHARE\Batches\CalcMgrCmdLineLauncherpassword.txt /D:BudgetDb /U:admin /A:BudgetApp /R:"Budget - Process All" /F:\\FDMSERVER\C$\Temp\BudgetApp\Process_All_RegionWITHPARAM.xml

I get this back:

SET EPM_PLANNING_INSTANCE=\\PLANNINGSERVER\D$\Oracle\Middleware\user_project
s\epmsystem2/Planning/planning1

C:\TEMP>call "\\PLANNINGSERVERfile://\\PLANNINGSERVER\D$\Oracle\Middleware\user_projects\epmsystem2/Plannin\D$\Oracle\Middleware\user_projects\epmsystem2/Plannin
g/planning1\setHPenv.bat"
Exception in thread "main" java.lang.NoClassDefFoundError: com/hyperion/planning
/calcmgr/cmdlnlauncher/HspCalcMgrCmdLineLauncher
Caused by: java.lang.ClassNotFoundException: com.hyperion.planning.calcmgr.cmdln
launcher.HspCalcMgrCmdLineLauncher
        at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
Could not find the main class: com.hyperion.planning.calcmgr.cmdlnlauncher.HspCa
lcMgrCmdLineLauncher.  Program will exit.

and that's because i have changed the setHPenv.bat on the planning server as such:

@echo off

rem *** Replace D:\Oracle\Middleware\user_projects\epmsystem2/Planning/planning1 with Planning Instance location i.e. %EPM_ORACLE_INSTANCE%/Planning/planning1 ***

set EPM_PLANNING_INSTANCE=\\PLANNINGSERVER\D$\Oracle\Middleware\user_projects\epmsystem2/Planning/planning1

rem *** Replace 11.1.2.0 with current EPM Version i.e. 11.1.2.0 ***

set EPM_VERSION=11.1.2.0

rem *** Replace 64 OS architecture type as 32/64 bit i.e. 32 or 64 ***

set HP_OS_ARC=64

call %EPM_PLANNING_INSTANCE%/../../bin/setEnv.bat

call %EPM_ORACLE_HOME%/common/config/%EPM_VERSION%/setJavaRuntime.bat

rem *** Replace D:\Oracle\Middleware\EPMSystem11R1/bin;D:\Oracle\Middleware\EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin with additional PATH required to access EssbaseRTC client ***

rem *** i.e. %EPM_ORACLE_HOME%/bin;%EPM_ORACLE_HOME%/common/EssbaseRTC/%EPM_VERSION%/bin ***

set PATH=\\PLANNINGSERVER\D$\Oracle\Middleware\EPMSystem11R1/bin;\\PLANNINGSERVER\D$\Oracle\Middleware\EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin;\\PLANNINGSERVER\D$\Oracle \Middleware\EPMSystem11R1\products\Essbase\EssbaseClient\bin;\\PLANNINGSERVER\D$\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0

set EPM_PLANNING_HOME=%EPM_ORACLE_HOME%/products/Planning

set HP_LOG_PATH=%EPM_ORACLE_INSTANCE%/diagnostics/logs/planning

set HP_SHARED_LIB_PATH=%EPM_PLANNING_HOME%/lib

set HP_64_JAVA_OPTIONS=

if "%HP_OS_ARC%" == "64" (

set HP_SHARED_LIB_PATH=%EPM_PLANNING_HOME%/lib64

set HP_64_JAVA_OPTIONS=-Dcom.hyperion.planning.datamodel=64

)

set HP_JAVA_OPTIONS=-DEPM_ORACLE_HOME=%EPM_ORACLE_HOME%

set HP_JAVA_OPTIONS=%HP_JAVA_OPTIONS% -DEPM_ORACLE_INSTANCE=%EPM_ORACLE_INSTANCE%

set HP_JAVA_OPTIONS=%HP_JAVA_OPTIONS% -Dhyperion.home=%EPM_ORACLE_HOME%

set HP_JAVA_OPTIONS=%HP_JAVA_OPTIONS% -Djava.library.path=%HP_SHARED_LIB_PATH%

set HP_JAVA_OPTIONS=%HP_JAVA_OPTIONS% -Djavax.xml.parsers.DocumentBuilderFactory=oracle.xml.jaxp.JXDocumentBuilderFactory

set HP_JAVA_OPTIONS=%HP_JAVA_OPTIONS% -Djavax.xml.transform.TransformerFactory=oracle.xml.jaxp.JXSAXTransformerFactory

set HP_JAVA_OPTIONS=%HP_JAVA_OPTIONS% -Djava.io.tmpdir=%EPM_ORACLE_INSTANCE%/tmp

set HP_JAVA_OPTIONS=%HP_JAVA_OPTIONS% -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration

set HP_JAVA_OPTIONS=%HP_JAVA_OPTIONS% -Doracle.core.ojdl.logging.config.file=%EPM_PLANNING_INSTANCE%/loggingCLU.xml

set HP_JAVA_OPTIONS=%HP_JAVA_OPTIONS% -Dlogging.folder=%HP_LOG_PATH%

set HP_JAVA_OPTIONS=%HP_JAVA_OPTIONS% -Xmx512M

set HP_JAVA_OPTIONS=%HP_JAVA_OPTIONS% %HP_64_JAVA_OPTIONS%

set CLASSPATH=%EPM_PLANNING_HOME%/config

set CLASSPATH=%CLASSPATH%;%EPM_ORACLE_HOME%/common/jlib/%EPM_VERSION%/epm_j2se.jar

set CLASSPATH=%CLASSPATH%;%EPM_ORACLE_HOME%/common/jlib/%EPM_VERSION%/epm_pdf.jar

set CLASSPATH=%CLASSPATH%;%EPM_ORACLE_HOME%/common/jlib/%EPM_VERSION%/epm_calcmgr.jar

set CLASSPATH=%CLASSPATH%;%EPM_ORACLE_HOME%/common/jlib/%EPM_VERSION%/epm_fr_shared.jar

set CLASSPATH=%CLASSPATH%;%EPM_ORACLE_HOME%/common/jlib/%EPM_VERSION%/epm_misc.jar

rem ** epm_j2se.jar already has a reference to epm_lcm.jar but not sure if that will be taken away in future **

set CLASSPATH=%CLASSPATH%;%EPM_ORACLE_HOME%/common/jlib/%EPM_VERSION%/epm_lcm.jar

set CLASSPATH=%CLASSPATH%;%EPM_PLANNING_HOME%/lib/epm_planning_server.jar

set CLASSPATH=%CLASSPATH%;%EPM_PLANNING_HOME%/lib/*

And the calcmgrcmdlinelauncher.cmd as such:

@echo on

SET EPM_PLANNING_INSTANCE=\\PLANNINGSERVER\D$\Oracle\Middleware\user_projects\epmsystem2/Planning/planning1

call "%EPM_PLANNING_INSTANCE%\setHPenv.bat"

"

\\PLANNINGSERVER\D$\Oracle\Middleware\jdk160_35\bin\java

" %HP_JAVA_OPTIONS% %JAVA_OPTIONS% com.hyperion.planning.calcmgr.cmdlnlauncher.HspCalcMgrCmdLineLauncher %* /COMMAND:CalcMgrCmdLineLauncher.cmd

I am not sure what could else to change. Anybody same problem?

Thanks in advance for your thoughts.