0 Replies Latest reply: May 17, 2013 1:45 AM by 1005144 RSS

    Essbasse error

    1005144
      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