"ODI-1217: Session CALL_CALCMGR fails with return code 7000" Error received when Launching Hyperion Planning Calculation Manager Rules via OdiOSCommand (Doc ID 2495640.1)

Last updated on OCTOBER 17, 2019

Applies to:

Symptoms

In Oracle Data Integrator (ODI) 11g, the following error is received when attempting to set the parameters for the OdiOSCommand tool:

oracle.odi.oditools.OdiToolInvalidParameterException: Error while setting parameters on tool

When attempting to run an OdiOSCommand tool which calls CalcMgrCmdLineLauncher.sh to capture success/error information for the Calculation Manager rules, the following error is received:

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-30044: Invalid parameter

Syntax for the OdiOSCommand tool is as follows:

OdiOSCommand "-OUT_FILE=D:\Odi11\Odi_demo\CalcManager\Alloc_out.txt" "-ERR_FILE=D:\Odi11\Odi_demo\CalcManager\Alloc_err.txt" "-FILE_APPEND=NO" "-WORKING_DIR=d:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1" "-SYNCHRONOUS=YES" "-COMMAND=d:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1\CalcMgrCmdLineLauncher.cmd -f:password.txt /A:nbkr /U:admin /D:bdr /R:Alloc"

The full error stack received is as follows:

ODI-1217: Session CALL_CALCMGR (2776501) fails with return code 7000.
ODI-1226: Step CALL_CALCMGR fails after 1 attempt(s).
ODI-1232: Procedure CALL_CALCMGR execution fails.
Caused By: oracle.odi.oditools.OdiToolInvalidParameterException: Error while setting parameters on tool
at com.sunopsis.dwg.function.SnpsFunctionBase.getCoreOdiTool(SnpsFunctionBase.java:618)
at com.sunopsis.dwg.function.SnpsFunctionBase.getSunopsisApi(SnpsFunctionBase.java:494)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1431)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-30044: Invalid parameter
at com.sunopsis.dwg.function.SnpsFunctionBase.getCoreOdiTool(SnpsFunctionBase.java:610)
... 18 more

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.