HPCM: Mismatch In FIX-ENDFIX Count In Calc Script Generatedafter Running The Generate Calc Task

(Doc ID 1611836.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Profitability - Version 11.1.2.2.000 and later
Information in this document applies to any platform.

Symptoms

When running calculation scripts the following error where generated:

Error processing calculation scripts[[ Unexpected error from Essbase. at com.hyperion.profitability.business.mdb.calculation.execution.RunCalcScripts.calculate(RunCalcScripts.java:264) at com.hyperion.profitability.business.service.CubeCalculate.calculateCube(CubeCalculate.java:114) at com.hyperion.profitability.business.service.CubeCalculate.calculateCube(CubeCalculate.java:69) at com.hyperion.profitability.business.facade.ServiceFacadeImpl.cubeCalculate(ServiceFacadeImpl.java:1057) at sun.reflect.GeneratedMethodAccessor4859.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.hyperion.profitability.common.support.aop.MethodInvocation.proceed(MethodInvocation.java:42) at com.hyperion.profitability.common.support.aop.InterceptingInvocation.proceed(InterceptingInvocation.java:39) at com.hyperion.profitability.business.facade.TransactionInterceptor.invoke(TransactionInterceptor.java:30) at com.hyperion.profitability.common.support.aop.InterceptingInvocation.proceed(InterceptingInvocation.java:37) at com.hyperion.profitability.business.facade.DiagnosticInterceptor.invoke(DiagnosticInterceptor.java:34) at com.hyperion.profitability.common.support.aop.InterceptingInvocation.proceed(InterceptingInvocation.java:37) at com.hyperion.profitability.common.support.aop.InvocationHandlerAdapter.invoke(InvocationHandlerAdapter.java:34) at $Proxy116.cubeCalculate(Unknown Source) at com.hyperion.profitability.business.integration.ces.jobs.ProcessCalcscriptsJob.start(ProcessCalcscriptsJob.java:48) at com.hyperion.profitability.business.integration.ces.TaskHandler$AgentThread.run(TaskHandler.java:195) Caused by: Error running calculation script 'a8961_01' at com.hyperion.profitability.data.mdb.essbase.EssbaseAPI.runCalcScript(EssbaseAPI.java:788) at com.hyperion.profitability.business.mdb.calculation.execution.RunCalcScripts.runScript(RunCalcScripts.java:293) at com.hyperion.profitability.business.mdb.calculation.execution.RunCalcScripts.calculate(RunCalcScripts.java:231) at com.hyperion.profitability.business.service.CubeCalculate.calculateCube(CubeCalculate.java:114) at com.hyperion.profitability.business.service.CubeCalculate.calculateCube(CubeCalculate.java:70) at com.hyperion.profitability.business.facade.ServiceFacadeImpl.cubeCalculate(ServiceFacadeImpl.java:1059) ... 13 more Caused by: com.essbase.api.base.EssException: Cannot calculate file. Essbase Error(1012000): Invalid Syntax - Not a CALC command [EndFix] at com.essbase.server.framework.EssOrbPluginDirect.ex_olap(Unknown Source) at com.essbase.server.framework.EssOrbPluginDirect.essMainCalcFile(Unknown Source) at com.essbase.api.session.EssOrbPlugin._invokeMainMethod(Unknown Source) at com.essbase.api.session.EssOrbPlugin._invokeMethod2(Unknown Source) at com.essbase.api.session.EssOrbPlugin._invokeMethod(Unknown Source) at com.essbase.server.framework.EssOrbPluginDirect._invokeProtected(Unknown Source) at com.essbase.api.session.EssOrbPluginEmbedded.invokeMethod(Unknown Source) at com.essbase.api.session.EssOrbPluginEmbedded.invokeMethod(Unknown Source) at com.essbase.api.session.EssOrbPlugin.essMainCalcFile(Unknown Source) at com.essbase.api.datasource.EssCube.calculate(Unknown Source) at com.hyperion.profitability.data.mdb.essbase.EssbaseAPI.runCalcScript(EssbaseAPI.java:785) at com.hyperion.profitability.business.mdb.calculation.execution.RunCalcScripts.runScript(RunCalcScripts.java:293) at com.hyperion.profitability.business.mdb.calculation.execution.RunCalcScripts.calculate(RunCalcScripts.java:231) at com.hyperion.profitability.business.service.CubeCalculate.calculateCube(CubeCalculate.java:114) at com.hyperion.profitability.business.service.CubeCalculate.calculateCube(CubeCalculate.java:69) at com.hyperion.profitability.business.facade.ServiceFacadeImpl.cubeCalculate(ServiceFacadeImpl.java:1057) ============================================================================================================= essbase log: Thu Jan 02 13:38:14 2014]Local/PCMABMC/PCMABMC/Samrat@Native Directory/8036/Error(1012000) Invalid Syntax - Not a CALC command [EndFix]

Changes

None

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms