This discussion is archived
0 Replies Latest reply: Nov 12, 2012 8:42 AM by RMarques RSS

Error importing staging tables

RMarques Newbie
Currently Being Moderated
Hi...

I'm getting an odd error while importing stage for Assgn Rules.

[2012-11-12T14:14:34.873-03:00] [Profitability0] [TRACE] [] [oracle.EPMPCM.essbase.calcscript] [tid: 18] [userId: <anonymous>] [ecid: 0000JfpaszfDwW45zVS4yW1GcIpX00000L,1:32370] [SRC_CLASS: com.hyperion.profitability.business.service.AssignmentRule] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: validateSameAsSourceRuleSelection] AssignmentRule::validateSameAsSourceRuleSelection(): same as source dimension Recurso specified for destination Dimension Recurso
[2012-11-12T14:14:34.874-03:00] [Profitability0] [TRACE] [] [oracle.EPMPCM.essbase.calcscript] [tid: 18] [userId: <anonymous>] [ecid: 0000JfpaszfDwW45zVS4yW1GcIpX00000L,1:32370] [SRC_CLASS: com.hyperion.profitability.business.service.AssignmentRule] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: validateSameAsSourceRuleSelection] AssignmentRule::validateSameAsSourceRuleSelection(): same as source dimension is same as destination stage dimension and the dimension exists in the source stage
[2012-11-12T14:14:34.874-03:00] [Profitability0] [TRACE] [] [oracle.EPMPCM.essbase.calcscript] [tid: 18] [userId: <anonymous>] [ecid: 0000JfpaszfDwW45zVS4yW1GcIpX00000L,1:32370] [SRC_CLASS: com.hyperion.profitability.business.service.AssignmentRule] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: validateSameAsSourceRuleSelection] AssignmentRule::validateSameAsSourceRuleSelection(): same as source dimension Atividade specified for destination Dimension Atividade
[2012-11-12T14:14:34.875-03:00] [Profitability0] [TRACE] [] [oracle.EPMPCM.essbase.calcscript] [tid: 18] [userId: <anonymous>] [ecid: 0000JfpaszfDwW45zVS4yW1GcIpX00000L,1:32370] [SRC_CLASS: com.hyperion.profitability.business.service.AssignmentRule] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: validateSameAsSourceRuleSelection] AssignmentRule::validateSameAsSourceRuleSelection(): same as source dimension is same as destination stage dimension and the dimension exists in the source stage
[2012-11-12T14:14:34.876-03:00] [Profitability0] [TRACE] [] [oracle.EPMPCM.essbase.calcscript] [tid: 18] [userId: <anonymous>] [ecid: 0000JfpaszfDwW45zVS4yW1GcIpX00000L,1:32370] [SRC_CLASS: com.hyperion.profitability.business.service.AssignmentRule] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: validateSameAsSourceRuleSelection] AssignmentRule::validateSameAsSourceRuleSelection(): same as source dimension not specified for destination Dimension Objeto
[2012-11-12T14:14:34.876-03:00] [Profitability0] [TRACE] [] [oracle.EPMPCM.essbase.calcscript] [tid: 18] [userId: <anonymous>] [ecid: 0000JfpaszfDwW45zVS4yW1GcIpX00000L,1:32370] [SRC_CLASS: com.hyperion.profitability.business.service.AssignmentRule] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: validateSameAsSourceRuleSelection] Leaving AssignmentRule::validateSameAsSourceRuleSelection() for appId 35482001
[2012-11-12T14:14:34.961-03:00] [Profitability0] [ERROR] [] [oracle.EPMPCM.import] [tid: 18] [userId: <anonymous>] [ecid: 0000JfpaszfDwW45zVS4yW1GcIpX00000L,1:32370] [SRC_CLASS: com.hyperion.profitability.business.integration.data.imp.StgAssignmentRules] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: save] [[
java.lang.NullPointerException
     at com.hyperion.profitability.business.integration.data.imp.model.ModelDataImportSaverImpl.getDimensionMemberIds(ModelDataImportSaverImpl.java:60)
     at com.hyperion.profitability.business.integration.data.imp.StgAssignmentRules.save(StgAssignmentRules.java:108)
     at com.hyperion.profitability.business.integration.data.imp.StagingDataImportImpl.processConfigEntries(StagingDataImportImpl.java:87)
     at com.hyperion.profitability.business.integration.data.imp.StagingDataImportImpl.importData(StagingDataImportImpl.java:54)
     at com.hyperion.profitability.business.integration.data.Import.runStagingImport(Import.java:104)
     at com.hyperion.profitability.business.facade.ServiceFacadeImpl.runStagingImport(ServiceFacadeImpl.java:1824)
     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.common.support.aop.TraceInterceptor.invoke(TraceInterceptor.java:161)
     at com.hyperion.profitability.common.support.aop.InterceptingInvocation.proceed(InterceptingInvocation.java:37)
     at com.hyperion.profitability.common.support.aop.PerformanceMonitorInterceptor.invoke(PerformanceMonitorInterceptor.java:22)
     at com.hyperion.profitability.common.support.aop.InterceptingInvocation.proceed(InterceptingInvocation.java:37)
     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 $Proxy117.runStagingImport(Unknown Source)
     at com.hyperion.profitability.business.integration.ces.jobs.ImportStagingJob.start(ImportStagingJob.java:34)
     at com.hyperion.profitability.business.integration.ces.TaskHandler$AgentThread.run(TaskHandler.java:154)

]]
[2012-11-12T14:14:34.963-03:00] [Profitability0] [ERROR] [EPMPCM-09085] [oracle.EPMPCM.import] [tid: 18] [userId: <anonymous>] [ecid: 0000JfpaszfDwW45zVS4yW1GcIpX00000L,1:32370] [SRC_CLASS: com.hyperion.profitability.business.integration.data.imp.StagingDataImportImpl] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: importData] Falha na preparação da importação de dados.[[
java.lang.NullPointerException
     at com.hyperion.profitability.business.integration.data.imp.model.ModelDataImportSaverImpl.getExceptionString(ModelDataImportSaverImpl.java:140)
     at com.hyperion.profitability.business.integration.data.imp.StgAssignmentRules.save(StgAssignmentRules.java:180)
     at com.hyperion.profitability.business.integration.data.imp.StagingDataImportImpl.processConfigEntries(StagingDataImportImpl.java:87)
     at com.hyperion.profitability.business.integration.data.imp.StagingDataImportImpl.importData(StagingDataImportImpl.java:54)
     at com.hyperion.profitability.business.integration.data.Import.runStagingImport(Import.java:104)
     at com.hyperion.profitability.business.facade.ServiceFacadeImpl.runStagingImport(ServiceFacadeImpl.java:1824)
     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.common.support.aop.TraceInterceptor.invoke(TraceInterceptor.java:161)
     at com.hyperion.profitability.common.support.aop.InterceptingInvocation.proceed(InterceptingInvocation.java:37)
     at com.hyperion.profitability.common.support.aop.PerformanceMonitorInterceptor.invoke(PerformanceMonitorInterceptor.java:22)
     at com.hyperion.profitability.common.support.aop.InterceptingInvocation.proceed(InterceptingInvocation.java:37)
     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 $Proxy117.runStagingImport(Unknown Source)
     at com.hyperion.profitability.business.integration.ces.jobs.ImportStagingJob.start(ImportStagingJob.java:34)
     at com.hyperion.profitability.business.integration.ces.TaskHandler$AgentThread.run(TaskHandler.java:154)

]]
[2012-11-12T14:14:34.963-03:00] [Profitability0] [NOTIFICATION:16] [] [org.eclipse.persistence.session.zip:E:/Oracle/Middleware/user_projects/domains/EPMSystem/servers/Profitability0/tmp/servers/Profitability0/tmp/_WL_user/PROFITABILITY_11.1.2.0/mig5y6/war/WEB-INF/lib/_wl_cls_gen.jar!/_staging.connection] [tid: 18] [userId: <anonymous>] [ecid: 0000JfpaszfDwW45zVS4yW1GcIpX00000L,1:32370] [APP: PROFITABILITY#11.1.2.0] disconnect
[2012-11-12T14:14:34.965-03:00] [Profitability0] [NOTIFICATION] [] [org.eclipse.persistence.session.zip:E:/Oracle/Middleware/user_projects/domains/EPMSystem/servers/Profitability0/tmp/servers/Profitability0/tmp/_WL_user/PROFITABILITY_11.1.2.0/mig5y6/war/WEB-INF/lib/_wl_cls_gen.jar!/_staging] [tid: 18] [userId: <anonymous>] [ecid: 0000JfpaszfDwW45zVS4yW1GcIpX00000L,1:32370] [APP: PROFITABILITY#11.1.2.0] zip:E:/Oracle/Middleware/user_projects/domains/EPMSystem/servers/Profitability0/tmp/servers/Profitability0/tmp/_WL_user/PROFITABILITY_11.1.2.0/mig5y6/war/WEB-INF/lib/_wl_cls_gen.jar!/_staging logout successful
[2012-11-12T14:14:34.965-03:00] [Profitability0] [NOTIFICATION:16] [] [org.eclipse.persistence.session.zip:E:/Oracle/Middleware/user_projects/domains/EPMSystem/servers/Profitability0/tmp/servers/Profitability0/tmp/_WL_user/PROFITABILITY_11.1.2.0/mig5y6/war/WEB-INF/lib/_wl_cls_gen.jar!/_staging.connection] [tid: 18] [userId: <anonymous>] [ecid: 0000JfpaszfDwW45zVS4yW1GcIpX00000L,1:32370] [APP: PROFITABILITY#11.1.2.0] disconnect
[2012-11-12T14:14:34.965-03:00] [Profitability0] [TRACE:16] [] [oracle.EPMPCM.common] [tid: 18] [userId: <anonymous>] [ecid: 0000JfpaszfDwW45zVS4yW1GcIpX00000L,1:32370] [SRC_CLASS: com.hyperion.profitability.common.support.aop.TraceInterceptor] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: invoke] com.hyperion.profitability.business.facade.ServiceFacadeImpl.runStagingImport(5109961)


I have duplicated my app.
Deploy is OK.
Import POV is OK.
Import Stages is OK.

Is there any way to clear the HPCM tables for Assignment Rules?

Thanks


-Cheers,
Rafael

Legend

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