This discussion is archived
0 Replies Latest reply: May 16, 2013 11:45 PM by 1005144 RSS

Essbasse error

1005144 Newbie
Currently Being Moderated
Hello,

I got a problem regarding HPCM calculation. When I calculate I got an error . Logs are :




[2013-05-16T23:26:21.677-07:00] [EPMServer0] [NOTIFICATION] [EPMPCM-10510] [oracle.EPMPCM.ces] [tid: 78] [userId: <anonymous>] [ecid: 0000JulAj5gFo2WFLzbQ8A1H_STn0000Ki,1:21730] [SRC_CLASS: com.hyperion.profitability.business.integration.ces.TaskHandler$AgentThread] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: run] Starting task 'CalcScript' for the application 'CBAR' in the taskflow 'CBAR_CalcScripts_D20130516T232620_a90'
[2013-05-16T23:26:25.412-07:00] [EPMServer0] [NOTIFICATION] [EPMPCM-10502] [oracle.EPMPCM.ces] [tid: 78] [userId: <anonymous>] [ecid: 0000JulAj5gFo2WFLzbQ8A1H_STn0000Ki,1:21730] [SRC_CLASS: com.hyperion.profitability.business.integration.ces.TaskHandler$AgentThread] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: run] Task 'CalcScript' for 'CBAR_CalcScripts_D20130516T232620_a90' finished. Duration (ms): 3,735
[2013-05-16T23:26:25.566-07:00] [EPMServer0] [NOTIFICATION] [EPMPCM-10510] [oracle.EPMPCM.ces] [tid: 81] [userId: <anonymous>] [ecid: 0000JulAk2TFo2WFLzbQ8A1H_STn0000Kk,1:21732] [SRC_CLASS: com.hyperion.profitability.business.integration.ces.TaskHandler$AgentThread] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: run] Starting task 'CalcScript' for the application 'CBAR' in the taskflow 'CBAR_CalcScripts_D20130516T232620_a90'
[2013-05-16T23:26:25.977-07:00] [EPMServer0] [NOTIFICATION] [EPMPCM-10502] [oracle.EPMPCM.ces] [tid: 81] [userId: <anonymous>] [ecid: 0000JulAk2TFo2WFLzbQ8A1H_STn0000Kk,1:21732] [SRC_CLASS: com.hyperion.profitability.business.integration.ces.TaskHandler$AgentThread] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: run] Task 'CalcScript' for 'CBAR_CalcScripts_D20130516T232620_a90' finished. Duration (ms): 411
[2013-05-16T23:26:26.120-07:00] [EPMServer0] [NOTIFICATION] [EPMPCM-10510] [oracle.EPMPCM.ces] [tid: 84] [userId: <anonymous>] [ecid: 0000JulAkB7Fo2WFLzbQ8A1H_STn0000Km,1:21734] [SRC_CLASS: com.hyperion.profitability.business.integration.ces.TaskHandler$AgentThread] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: run] Starting task 'CalcScript' for the application 'CBAR' in the taskflow 'CBAR_CalcScripts_D20130516T232620_a90'
[2013-05-16T23:26:26.235-07:00] [EPMServer0] [ERROR] [EPMPCM-09203] [oracle.EPMPCM.ces] [tid: 84] [userId: <anonymous>] [ecid: 0000JulAkB7Fo2WFLzbQ8A1H_STn0000Km,1:21734] [SRC_CLASS: com.hyperion.profitability.business.integration.ces.jobs.ProcessCalcscriptsJob] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: start] 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.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     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 $Proxy160.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 'i3101_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:216)
     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)
     ... 14 more
Caused by: com.essbase.api.base.EssException: Cannot calculate file. Essbase Error(1012043): Calculation is not allowed for virtual member [CostReceived] in the Calc script.
     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:216)
     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)
     ... 14 more

]]
[2013-05-16T23:26:26.238-07:00] [EPMServer0] [NOTIFICATION] [EPMPCM-10502] [oracle.EPMPCM.ces] [tid: 84] [userId: <anonymous>] [ecid: 0000JulAkB7Fo2WFLzbQ8A1H_STn0000Km,1:21734] [SRC_CLASS: com.hyperion.profitability.business.integration.ces.TaskHandler$AgentThread] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: run] Task 'CalcScript' for 'CBAR_CalcScripts_D20130516T232620_a90' finished. Duration (ms): 118

Please, help,
Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points