1 2 Previous Next 23 Replies Latest reply: Sep 25, 2014 3:20 AM by RMarques RSS

    Cannot load metadata from EBS

    RMarques

      Hi guys!

       

      Im using 11.1.2.3.500 and trying to pull metadata from EBS 12.

      Everything is well configured (so far).

      I am trying to load 3 (Account, Entity and Product in this order) dimensions form EBS and I got a green OK on Entity dim and a yellow triangle for the others (Account and Entity).

      It seems he is loosing connection between Planning. But how it happens if its OK for Entity dim?

       

      [Wed Jul 02 19:46:05 EST 2014]Performing cube refresh...

      [Wed Jul 02 19:46:05 EST 2014]An error occurred during the cube refresh operation: com.hyperion.planning.HspRuntimeException: Unable to connect to Hyperion Essbase.

      Verify that Hyperion Essbase is running and check your network connections.

       

       

      Thanks

       

      RMarques

       

       

      Whole log:

       

       

      ACCOUNT

       

       

      2014-07-02 19:45:20,399 INFO  [AIF]: FDMEE Process Start, Process ID: 30

      2014-07-02 19:45:20,399 INFO  [AIF]: FDMEE Logging Level: 4

      2014-07-02 19:45:20,399 INFO  [AIF]: FDMEE Log File: /u01/app/oracle/product/epm/EPMSystem11R1/HPL/EPRI/outbox/logs/HPL_DEV_30.log

      2014-07-02 19:45:20,400 INFO  [AIF]: User:admin

      2014-07-02 19:45:20,400 INFO  [AIF]: Location:EBS_ACT_DL_AUD (Partitionkey:2)

      2014-07-02 19:45:20,400 INFO  [AIF]: Period Name:NA (Period Key:null)

      2014-07-02 19:45:20,400 INFO  [AIF]: Category Name:NA (Category key:null)

      2014-07-02 19:45:20,400 INFO  [AIF]: Rule Name:1 (Rule ID:1)

      2014-07-02 19:45:23,681 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

      [Oracle JRockit(R) (Oracle Corporation)]

      2014-07-02 19:45:23,682 INFO  [AIF]: Java Platform: java1.6.0_37

      2014-07-02 19:45:33,283 INFO  [AIF]: COMM Dimension Pre-Processing - Multi Process Validation - START

      2014-07-02 19:45:33,293 INFO  [AIF]: COMM Dimension Pre-Processing - Multi Process Validation - END

      2014-07-02 19:45:33,378 INFO  [AIF]: LKM EBS/FS Extract Members Table VS - Process Value Sets - START

      2014-07-02 19:45:33,396 INFO  [AIF]: LKM EBS/FS Extract Members Table VS - Process Value Sets - END

      2014-07-02 19:45:33,681 INFO  [AIF]: EBS Extract Members Ind VS - Populate Dim Members Stage - START

      2014-07-02 19:45:33,745 INFO  [AIF]: EBS Extract Members Ind VS - Populate Dim Members Stage - END

      2014-07-02 19:45:34,079 INFO  [AIF]: EBS Extract Members Ind VS - Populate Dim Members Stage - START

      2014-07-02 19:45:34,186 INFO  [AIF]: EBS Extract Members Ind VS - Populate Dim Members Stage - END

      2014-07-02 19:45:34,470 INFO  [AIF]: EBS Extract Members Ind VS - Populate Dim Members Stage - START

      2014-07-02 19:45:34,532 INFO  [AIF]: EBS Extract Members Ind VS - Populate Dim Members Stage - END

      2014-07-02 19:45:36,383 INFO  [AIF]: EBS/FS Load Concat Dim Members - Load Concat Dim Members - START

      2014-07-02 19:45:36,386 INFO  [AIF]: EBS/FS Load Concat Dim Members - Load Concat Dim Members - END

      2014-07-02 19:45:41,815 INFO  [AIF]: EBS Hierarchy Processing Ind VS - Insert into Process Details Ind VS - START

      2014-07-02 19:45:41,824 INFO  [AIF]: EBS Hierarchy Processing Ind VS - Insert into Process Details Ind VS - END

      2014-07-02 19:45:42,270 INFO  [AIF]: EBS Extract Hierarchies Ind VS - Populate Dim Hierarchy Stage - START

      2014-07-02 19:45:42,331 INFO  [AIF]: EBS Extract Hierarchies Ind VS - Populate Dim Hierarchy Stage - END

      2014-07-02 19:45:42,897 INFO  [AIF]: EBS Extract Hierarchies Ind VS - Populate Dim Hierarchy Stage - START

      2014-07-02 19:45:43,044 INFO  [AIF]: EBS Extract Hierarchies Ind VS - Populate Dim Hierarchy Stage - END

      2014-07-02 19:45:43,531 INFO  [AIF]: EBS Extract Hierarchies Ind VS - Populate Dim Hierarchy Stage - START

      2014-07-02 19:45:43,657 INFO  [AIF]: EBS Extract Hierarchies Ind VS - Populate Dim Hierarchy Stage - END

      2014-07-02 19:45:43,803 INFO  [AIF]: EBS Extract Hierarchies Table VS - Populate Dim Hierarchy Stage - START

      2014-07-02 19:45:43,805 INFO  [AIF]: EBS Extract Hierarchies Table VS - Populate Dim Hierarchy Stage - END

      2014-07-02 19:45:43,891 INFO  [AIF]: COMM Load Single Dim Hierarchies - Load Single Dim Hierarchies - START

      2014-07-02 19:45:45,883 INFO  [AIF]: COMM Load Single Dim Hierarchies - Load Single Dim Hierarchies - END

      2014-07-02 19:45:45,989 INFO  [AIF]: COMM Load Concat Dim Hierarchies - Load Concat Dim Hierarchies - START

      2014-07-02 19:45:45,993 INFO  [AIF]: COMM Load Concat Dim Hierarchies - Load Concat Dim Hierarchies - END

      2014-07-02 19:45:48,177 INFO  [AIF]: COMM Dimension Member Attributes - ICP Attribute Processing - START

      2014-07-02 19:45:48,179 INFO  [AIF]: COMM Dimension Member Attributes - ICP Attribute Processing - END

      2014-07-02 19:45:56,815 INFO  [AIF]: HPL Metadata Load - Application: HPL_DEV

      2014-07-02 19:45:56,818 INFO  [AIF]: Number of dimensions to load into HPL_DEV: 3

      2014-07-02 19:45:56,818 INFO  [AIF]: Building SQL query for dimension Account...

      2014-07-02 19:45:56,819 INFO  [AIF]: Number of alias tables in HPL_DEV: 1

      2014-07-02 19:45:56,825 INFO  [AIF]: Loading members for dimension: Account

      2014-07-02 19:45:56,825 INFO  [AIF]: [HPLService] Info: The name of the OLU log file is: /u01/app/oracle/product/epm/user_projects/epmdevexa1/tmp/aif_30_Account.log

      2014-07-02 19:46:00,571 INFO  [AIF]: Property file arguments: /-C /RIC:*** /D:Account /RIU:*** /RIR:*** /RID:*** /RIP:*** /RIQ:*** /IR

      No arguments were derived from the command line.Submitted (merged) command line:

      /-C /RIC:*** /D:Account /RIU:*** /RIR:*** /RID:*** /RIP:*** /RIQ:*** /IR

      [Wed Jul 02 19:45:56 EST 2014]The input query specified with the /RIQ switch did not match a key in the Command Properties file "null" so it will be executed as a sql query directly: "

      SELECT m.NAME "Account"

      ,m.PARENT "Parent"

      ,m.DataStorage "Data Storage"

      ,m.VALUE1 "Alias: Default"

      ,m.MemberValidForPlan1 "Plan Type (FinPlan)"

      ,m.MemberValidForPlan2 "Plan Type (RevPlan)"

      ,m.MemberValidForPlan3 "Plan Type (CapProj)"

      ,m.AccountType "Account Type"

      ,m.TimeBalance "Time Balance"

      ,m.VarianceReporting "Variance Reporting"

      ,m.SourcePlanType "Source Plan Type"

      FROM (

      SELECT mem.NAME

      ,CASE hier.PARENT WHEN '#root' THEN NULL ELSE hier.PARENT END PARENT

      ,hier.CHILD_DEPTH_NUM

      ,CASE mem.AccountType WHEN 'SavedAssumption' THEN 'Saved Assumption' ELSE mem.AccountType END AccountType

      ,mem.TimeBalance

      ,CASE mem.VarianceReporting WHEN 'NonExpense' THEN 'Non-Expense' ELSE mem.VarianceReporting END VarianceReporting

      ,hier.MemberValidForPlan1

      ,hier.MemberValidForPlan2

      ,hier.MemberValidForPlan3

      ,hier.MemberValidForCapex

      ,hier.MemberValidForWorkforce

      ,hier.SourcePlanType

      ,CASE hier.DataStorage

         WHEN 'NeverShare' THEN 'Never Share'

         WHEN 'StoreData' THEN 'Store'

         WHEN 'ShareData' THEN 'Shared'

         ELSE hier.DataStorage

      END DataStorage

      ,hier.HIERARCHY_ID

      ,mh.BASE_HIERARCHY_FLAG

      ,(SELECT prop.VALUE

         FROM AIF_HS_DIM_PROPERTYARRAY prop

         WHERE prop.LOADID = mem.LOADID

         AND prop.DIMENSION = mem.DIMENSION

         AND prop.PROPERTY = 'Alias'

         AND prop.NAME = mem.NAME

         AND prop.KEY = 'Default'

      ) VALUE1

         FROM AIF_HS_DIM_MEMBER mem

         INNER JOIN AIF_HS_DIM_HIERARCHY hier

           ON hier.LOADID = mem.LOADID

           AND hier.DIMENSION = mem.DIMENSION

           AND hier.CHILD = mem.NAME

         LEFT OUTER JOIN AIF_MAP_HIERARCHIES mh

           ON mh.HIERARCHY_ID = hier.HIERARCHY_ID

         WHERE mem.LOADID = 30

         AND mem.DIMENSION = 'ACCOUNT1'

      ) m

      ORDER BY m.BASE_HIERARCHY_FLAG desc

      ,m.HIERARCHY_ID

      ,m.CHILD_DEPTH_NUM

      ,m.PARENT

      ,m.NAME".

      [Wed Jul 02 19:45:56 EST 2014]Attempting to make input rdb connection.

      Source RDB "EPM_REPO" on jdbc:oracle:thin:@server:1521/instace connected to successfully.

      [Wed Jul 02 19:45:56 EST 2014]Connection to input RDB made successfully.

      [Wed Jul 02 19:45:56 EST 2014]Header record fields: Account, Parent, Data Storage, Alias: Default, Plan Type (FinPlan), Plan Type (RevPlan), Plan Type (CapProj), Account Type, Time Balance, Variance Reporting, Source Plan Type

      [Wed Jul 02 19:45:56 EST 2014]Located and using "Account" dimension for loading data in "HPL_DEV" application.

      [Wed Jul 02 19:45:56 EST 2014]HspOutlineLoad::dateFormatSpecified is false, SessionHalDateFormat stored on session: null, sessionId: 886045942

      [Wed Jul 02 19:45:59 EST 2014]com.hyperion.planning.HspRuntimeException: Exchange Rate must be None if Data Type is Non-Currency, Percentage, Smart List, Date, or Text.  Member: ATRDAY

      [Wed Jul 02 19:45:59 EST 2014]com.hyperion.planning.HspRuntimeException: Exchange Rate must be None if Data Type is Non-Currency, Percentage, Smart List, Date, or Text.  Member: ATRDAY

      [Wed Jul 02 19:46:00 EST 2014]com.hyperion.planning.HspRuntimeException: An alias with the name Membership Trading Account already exists.

      [Wed Jul 02 19:46:00 EST 2014]com.hyperion.planning.HspRuntimeException: An alias with the name Membership Trading Account already exists.

      [Wed Jul 02 19:46:00 EST 2014]Load dimension "Account" has been unlocked successfully.

      [Wed Jul 02 19:46:00 EST 2014]A cube refresh operation will not be performed.

      [Wed Jul 02 19:46:00 EST 2014]Create security filters operation will not be performed.

      Planning Outline data store load process finished. 1099 data records were read, 1099 data records were processed, 1085 were accepted for loading (verify actual load with Essbase log files), 14 were rejected.

      [Wed Jul 02 19:46:00 EST 2014]Planning Outline data store load process finished. 1099 data records were read, 1099 data records were processed, 1085 were accepted for loading (verify actual load with Essbase log files), 14 were rejected.

       

       

      2014-07-02 19:46:00,571 INFO  [AIF]: Account dimension load completed - Records Read: 1,099, Records Rejected: 14, Records Processed: 1,099.

       

       

       

       

      ENTITY

       

       

      2014-07-02 19:46:00,574 INFO  [AIF]: Building SQL query for dimension Entity...

      2014-07-02 19:46:00,579 INFO  [AIF]: Loading members for dimension: Entity

      2014-07-02 19:46:00,579 INFO  [AIF]: [HPLService] Info: The name of the OLU log file is: /u01/app/oracle/product/epm/user_projects/epmdevexa1/tmp/aif_30_Entity.log

      2014-07-02 19:46:04,247 INFO  [AIF]: Property file arguments: /-C /RIC:*** /D:Entity /RIU:*** /RIR:*** /RID:*** /RIP:*** /RIQ:*** /IR

      No arguments were derived from the command line.Submitted (merged) command line:

      /-C /RIC:*** /D:Entity /RIU:*** /RIR:*** /RID:*** /RIP:*** /RIQ:*** /IR

      [Wed Jul 02 19:46:00 EST 2014]The input query specified with the /RIQ switch did not match a key in the Command Properties file "null" so it will be executed as a sql query directly: "

      SELECT m.NAME "Entity"

      ,m.PARENT "Parent"

      ,m.DataStorage "Data Storage"

      ,m.VALUE1 "Alias: Default"

      ,m.MemberValidForPlan1 "Plan Type (FinPlan)"

      ,m.MemberValidForPlan2 "Plan Type (RevPlan)"

      ,m.MemberValidForPlan3 "Plan Type (CapProj)"

      FROM (

      SELECT mem.NAME

      ,CASE hier.PARENT WHEN '#root' THEN NULL ELSE hier.PARENT END PARENT

      ,hier.CHILD_DEPTH_NUM

      ,CASE mem.AccountType WHEN 'SavedAssumption' THEN 'Saved Assumption' ELSE mem.AccountType END AccountType

      ,mem.TimeBalance

      ,CASE mem.VarianceReporting WHEN 'NonExpense' THEN 'Non-Expense' ELSE mem.VarianceReporting END VarianceReporting

      ,hier.MemberValidForPlan1

      ,hier.MemberValidForPlan2

      ,hier.MemberValidForPlan3

      ,hier.MemberValidForCapex

      ,hier.MemberValidForWorkforce

      ,hier.SourcePlanType

      ,CASE hier.DataStorage

         WHEN 'NeverShare' THEN 'Never Share'

         WHEN 'StoreData' THEN 'Store'

         WHEN 'ShareData' THEN 'Shared'

         ELSE hier.DataStorage

      END DataStorage

      ,hier.HIERARCHY_ID

      ,mh.BASE_HIERARCHY_FLAG

      ,(SELECT prop.VALUE

         FROM AIF_HS_DIM_PROPERTYARRAY prop

         WHERE prop.LOADID = mem.LOADID

         AND prop.DIMENSION = mem.DIMENSION

         AND prop.PROPERTY = 'Alias'

         AND prop.NAME = mem.NAME

         AND prop.KEY = 'Default'

      ) VALUE1

         FROM AIF_HS_DIM_MEMBER mem

         INNER JOIN AIF_HS_DIM_HIERARCHY hier

           ON hier.LOADID = mem.LOADID

           AND hier.DIMENSION = mem.DIMENSION

           AND hier.CHILD = mem.NAME

         LEFT OUTER JOIN AIF_MAP_HIERARCHIES mh

           ON mh.HIERARCHY_ID = hier.HIERARCHY_ID

         WHERE mem.LOADID = 30

         AND mem.DIMENSION = 'ENTITY1'

      ) m

      ORDER BY m.BASE_HIERARCHY_FLAG desc

      ,m.HIERARCHY_ID

      ,m.CHILD_DEPTH_NUM

      ,m.PARENT

      ,m.NAME".

      [Wed Jul 02 19:46:00 EST 2014]Attempting to make input rdb connection.

      Source RDB "EPM_REPO" on jdbc:oracle:thin:@server:1521/instace connected to successfully.

      [Wed Jul 02 19:46:00 EST 2014]Connection to input RDB made successfully.

      [Wed Jul 02 19:46:00 EST 2014]Header record fields: Entity, Parent, Data Storage, Alias: Default, Plan Type (FinPlan), Plan Type (RevPlan), Plan Type (CapProj)

      [Wed Jul 02 19:46:00 EST 2014]Located and using "Entity" dimension for loading data in "HPL_DEV" application.

      [Wed Jul 02 19:46:00 EST 2014]HspOutlineLoad::dateFormatSpecified is false, SessionHalDateFormat stored on session: null, sessionId: 872481248

      [Wed Jul 02 19:46:04 EST 2014]Load dimension "Entity" has been unlocked successfully.

      [Wed Jul 02 19:46:04 EST 2014]A cube refresh operation will not be performed.

      [Wed Jul 02 19:46:04 EST 2014]Create security filters operation will not be performed.

      Planning Outline data store load process finished. 881 data records were read, 881 data records were processed, 881 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.

      [Wed Jul 02 19:46:04 EST 2014]Planning Outline data store load process finished. 881 data records were read, 881 data records were processed, 881 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.

       

       

      2014-07-02 19:46:04,247 INFO  [AIF]: Entity dimension load completed - Records Read: 881, Records Rejected: 0, Records Processed: 881.

       

       

      PRODUCT

       

       

      2014-07-02 19:46:04,249 INFO  [AIF]: Building SQL query for dimension Product...

      2014-07-02 19:46:04,253 INFO  [AIF]: Loading members for dimension: Product

      2014-07-02 19:46:04,253 INFO  [AIF]: [HPLService] Info: The name of the OLU log file is: /u01/app/oracle/product/epm/user_projects/epmdevexa1/tmp/aif_30_Product.log

      2014-07-02 19:46:05,556 INFO  [AIF]: Property file arguments: /C /RIC:*** /D:Product /RIU:*** /RIR:*** /RID:*** /RIP:*** /RIQ:*** /IR

      No arguments were derived from the command line.Submitted (merged) command line:

      /C /RIC:*** /D:Product /RIU:*** /RIR:*** /RID:*** /RIP:*** /RIQ:*** /IR

      [Wed Jul 02 19:46:04 EST 2014]The input query specified with the /RIQ switch did not match a key in the Command Properties file "null" so it will be executed as a sql query directly: "

      SELECT m.NAME "Product"

      ,m.PARENT "Parent"

      ,m.DataStorage "Data Storage"

      ,m.VALUE1 "Alias: Default"

      FROM (

      SELECT mem.NAME

      ,CASE hier.PARENT WHEN '#root' THEN NULL ELSE hier.PARENT END PARENT

      ,hier.CHILD_DEPTH_NUM

      ,CASE mem.AccountType WHEN 'SavedAssumption' THEN 'Saved Assumption' ELSE mem.AccountType END AccountType

      ,mem.TimeBalance

      ,CASE mem.VarianceReporting WHEN 'NonExpense' THEN 'Non-Expense' ELSE mem.VarianceReporting END VarianceReporting

      ,hier.MemberValidForPlan1

      ,hier.MemberValidForPlan2

      ,hier.MemberValidForPlan3

      ,hier.MemberValidForCapex

      ,hier.MemberValidForWorkforce

      ,hier.SourcePlanType

      ,CASE hier.DataStorage

         WHEN 'NeverShare' THEN 'Never Share'

         WHEN 'StoreData' THEN 'Store'

         WHEN 'ShareData' THEN 'Shared'

         ELSE hier.DataStorage

      END DataStorage

      ,hier.HIERARCHY_ID

      ,mh.BASE_HIERARCHY_FLAG

      ,(SELECT prop.VALUE

         FROM AIF_HS_DIM_PROPERTYARRAY prop

         WHERE prop.LOADID = mem.LOADID

         AND prop.DIMENSION = mem.DIMENSION

         AND prop.PROPERTY = 'Alias'

         AND prop.NAME = mem.NAME

         AND prop.KEY = 'Default'

      ) VALUE1

         FROM AIF_HS_DIM_MEMBER mem

         INNER JOIN AIF_HS_DIM_HIERARCHY hier

           ON hier.LOADID = mem.LOADID

           AND hier.DIMENSION = mem.DIMENSION

           AND hier.CHILD = mem.NAME

         LEFT OUTER JOIN AIF_MAP_HIERARCHIES mh

           ON mh.HIERARCHY_ID = hier.HIERARCHY_ID

         WHERE mem.LOADID = 30

         AND mem.DIMENSION = 'DIM1'

      ) m

      ORDER BY m.BASE_HIERARCHY_FLAG desc

      ,m.HIERARCHY_ID

      ,m.CHILD_DEPTH_NUM

      ,m.PARENT

      ,m.NAME".

      [Wed Jul 02 19:46:04 EST 2014]Attempting to make input rdb connection.

      Source RDB "EPM_REPO" on jdbc:oracle:thin:@server:1521/instace connected to successfully.

      [Wed Jul 02 19:46:04 EST 2014]Connection to input RDB made successfully.

      [Wed Jul 02 19:46:04 EST 2014]Header record fields: Product, Parent, Data Storage, Alias: Default

      [Wed Jul 02 19:46:04 EST 2014]Located and using "Product" dimension for loading data in "HPL_DEV" application.

      [Wed Jul 02 19:46:04 EST 2014]HspOutlineLoad::dateFormatSpecified is false, SessionHalDateFormat stored on session: null, sessionId: 677666057

      [Wed Jul 02 19:46:04 EST 2014]java.lang.RuntimeException: com.hyperion.planning.DuplicateObjectException: An object with the name WULC1 already exists.

      [Wed Jul 02 19:46:04 EST 2014]java.lang.RuntimeException: com.hyperion.planning.DuplicateObjectException: An object with the name WULC1 already exists.

      [Wed Jul 02 19:46:05 EST 2014]com.hyperion.planning.InvalidDimensionMemberNameException: Dimension Member name "ORDER" is a Report Script command.

      [Wed Jul 02 19:46:05 EST 2014]com.hyperion.planning.InvalidDimensionMemberNameException: Dimension Member name "ORDER" is a Report Script command.

      [Wed Jul 02 19:46:05 EST 2014]Load dimension "Product" has been unlocked successfully.

      [Wed Jul 02 19:46:05 EST 2014]Performing cube refresh...

      [Wed Jul 02 19:46:05 EST 2014]An error occurred during the cube refresh operation: com.hyperion.planning.HspRuntimeException: Unable to connect to Hyperion Essbase.

      Verify that Hyperion Essbase is running and check your network connections.

      [Wed Jul 02 19:46:05 EST 2014]An error occurred during the cube refresh operation: com.hyperion.planning.HspRuntimeException: Unable to connect to Hyperion Essbase.

      Verify that Hyperion Essbase is running and check your network connections.

      [Wed Jul 02 19:46:05 EST 2014]Unable to obtain dimension information and/or perform a data load: An error occurred during the cube refresh operation: com.hyperion.planning.HspRuntimeException: Unable to connect to Hyperion Essbase.

      Verify that Hyperion Essbase is running and check your network connections.

      [Wed Jul 02 19:46:05 EST 2014]Unable to obtain dimension information and/or perform a data load: An error occurred during the cube refresh operation: com.hyperion.planning.HspRuntimeException: Unable to connect to Hyperion Essbase.

      Verify that Hyperion Essbase is running and check your network connections.

      [Wed Jul 02 19:46:05 EST 2014]Trace information: com.hyperion.planning.utils.HspOutlineLoad::parseAndLoadInputFile:1912, com.hyperion.planning.utils.HspOutlineLoad::halAdapterInfoAndLoad:304, com.hyperion.planning.utils.HspOutlineLoad::loadAndPrintStatus:4667, com.hyperion.planning.utils.HspOutlineLoad::outlineLoadAsyncImpl:3752, com.hyperion.planning.utils.HspOutlineLoad::outlineLoad:3692, com.hyperion.planning.utils.HspOutlineLoad::outlineLoad:3810, com.hyperion.aif.webservices.HPLService::loadMetadata:500, sun.reflect.NativeMethodAccessorImpl::invoke0:-2, sun.reflect.NativeMethodAccessorImpl::invoke:39, sun.reflect.DelegatingMethodAccessorImpl::invoke:25, java.lang.reflect.Method::invoke:597, com.hyperion.aif.servlet.ODIServlet::doPost:97, javax.servlet.http.HttpServlet::service:727, javax.servlet.http.HttpServlet::service:820, weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction::run:227, weblogic.servlet.internal.StubSecurityHelper::invokeServlet:125, weblogic.servlet.internal.ServletStubImpl::execute:301, weblogic.servlet.internal.TailFilter::doFilter:26, weblogic.servlet.internal.FilterChainImpl::doFilter:56, oracle.security.jps.ee.http.JpsAbsFilter$1::run:119, oracle.security.jps.util.JpsSubject::doAsPrivileged:324, oracle.security.jps.ee.util.JpsPlatformUtil::runJaasMode:460, oracle.security.jps.ee.http.JpsAbsFilter::runJaasMode:103, oracle.security.jps.ee.http.JpsAbsFilter::doFilter:171, oracle.security.jps.ee.http.JpsFilter::doFilter:71, weblogic.servlet.internal.FilterChainImpl::doFilter:56, oracle.dms.servlet.DMSServletFilter::doFilter:163, weblogic.servlet.internal.FilterChainImpl::doFilter:56, weblogic.servlet.internal.RequestEventsFilter::doFilter:27, weblogic.servlet.internal.FilterChainImpl::doFilter:56, weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction::wrapRun:3730, weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction::run:3696, weblogic.security.acl.internal.AuthenticatedSubject::doAs:321, weblogic.security.service.SecurityManager::runAs:120, weblogic.servlet.internal.WebAppServletContext::securedExecute:2273, weblogic.servlet.internal.WebAppServletContext::execute:2179, weblogic.servlet.internal.ServletRequestImpl::run:1490, weblogic.work.ExecuteThread::execute:256, weblogic.work.ExecuteThread::run:221

      [Wed Jul 02 19:46:05 EST 2014]Trace information: com.hyperion.planning.utils.HspOutlineLoad::parseAndLoadInputFile:1912, com.hyperion.planning.utils.HspOutlineLoad::halAdapterInfoAndLoad:304, com.hyperion.planning.utils.HspOutlineLoad::loadAndPrintStatus:4667, com.hyperion.planning.utils.HspOutlineLoad::outlineLoadAsyncImpl:3752, com.hyperion.planning.utils.HspOutlineLoad::outlineLoad:3692, com.hyperion.planning.utils.HspOutlineLoad::outlineLoad:3810, com.hyperion.aif.webservices.HPLService::loadMetadata:500, sun.reflect.NativeMethodAccessorImpl::invoke0:-2, sun.reflect.NativeMethodAccessorImpl::invoke:39, sun.reflect.DelegatingMethodAccessorImpl::invoke:25, java.lang.reflect.Method::invoke:597, com.hyperion.aif.servlet.ODIServlet::doPost:97, javax.servlet.http.HttpServlet::service:727, javax.servlet.http.HttpServlet::service:820, weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction::run:227, weblogic.servlet.internal.StubSecurityHelper::invokeServlet:125, weblogic.servlet.internal.ServletStubImpl::execute:301, weblogic.servlet.internal.TailFilter::doFilter:26, weblogic.servlet.internal.FilterChainImpl::doFilter:56, oracle.security.jps.ee.http.JpsAbsFilter$1::run:119, oracle.security.jps.util.JpsSubject::doAsPrivileged:324, oracle.security.jps.ee.util.JpsPlatformUtil::runJaasMode:460, oracle.security.jps.ee.http.JpsAbsFilter::runJaasMode:103, oracle.security.jps.ee.http.JpsAbsFilter::doFilter:171, oracle.security.jps.ee.http.JpsFilter::doFilter:71, weblogic.servlet.internal.FilterChainImpl::doFilter:56, oracle.dms.servlet.DMSServletFilter::doFilter:163, weblogic.servlet.internal.FilterChainImpl::doFilter:56, weblogic.servlet.internal.RequestEventsFilter::doFilter:27, weblogic.servlet.internal.FilterChainImpl::doFilter:56, weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction::wrapRun:3730, weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction::run:3696, weblogic.security.acl.internal.AuthenticatedSubject::doAs:321, weblogic.security.service.SecurityManager::runAs:120, weblogic.servlet.internal.WebAppServletContext::securedExecute:2273, weblogic.servlet.internal.WebAppServletContext::execute:2179, weblogic.servlet.internal.ServletRequestImpl::run:1490, weblogic.work.ExecuteThread::execute:256, weblogic.work.ExecuteThread::run:221

      Planning Outline data store load process finished. 707 data records were read, 707 data records were processed, 674 were accepted for loading (verify actual load with Essbase log files), 33 were rejected.

      [Wed Jul 02 19:46:05 EST 2014]Planning Outline data store load process finished. 707 data records were read, 707 data records were processed, 674 were accepted for loading (verify actual load with Essbase log files), 33 were rejected.

       

       

      2014-07-02 19:46:05,556 INFO  [AIF]: Product dimension load completed - Records Read: 707, Records Rejected: 33, Records Processed: 707.

      2014-07-02 19:46:05,558 INFO  [AIF]: HPL Metadata Load completed with return status: true

      2014-07-02 19:46:05,653 INFO  [AIF]: FDMEE Process End, Process ID: 30

        • 1. Re: Cannot load metadata from EBS
          KKT

          Check if during metadata load any Backend sessions are running in the same application.

           

          Also check the logs of Essbase.

           

          Thanks,

          ~KKT~

          • 2. Re: Cannot load metadata from EBS
            Chuggans-Oracle

            It looks to me like the loads to Planning worked but the refresh of the Essbase cube has failed when it's being run on the Planning side. I'd say to check if you can do a refresh of the Essbase outline from within Planning itself with the same user that you're using for FDMEE.

             

            You do have some rejections in the logs as well that you'll need to have a look at.

            • 3. Re: Cannot load metadata from EBS
              RMarques

              Hi Chuggans-Oracle

               

              I can refresh the cube from Planning and I am using admin user.

              In which specific log file I should take a look?

               

              Thanks

              • 4. Re: Cannot load metadata from EBS
                Chuggans-Oracle

                Hi RMarques,

                 

                The log that you attached to the forum entry shows the rejected members in the lines below. You also need to bear in mind that if the rejected member is a parent member then the children of that parent will also get rejected (because the parent member will not exist).

                 

                Account

                 

                [Wed Jul 02 19:45:59 EST 2014]com.hyperion.planning.HspRuntimeException: Exchange Rate must be None if Data Type is Non-Currency, Percentage, Smart List, Date, or Text.  Member: ATRDAY

                [Wed Jul 02 19:45:59 EST 2014]com.hyperion.planning.HspRuntimeException: Exchange Rate must be None if Data Type is Non-Currency, Percentage, Smart List, Date, or Text.  Member: ATRDAY

                [Wed Jul 02 19:46:00 EST 2014]com.hyperion.planning.HspRuntimeException: An alias with the name Membership Trading Account already exists.

                [Wed Jul 02 19:46:00 EST 2014]com.hyperion.planning.HspRuntimeException: An alias with the name Membership Trading Account already exists.

                 

                Product


                [Wed Jul 02 19:46:04 EST 2014]java.lang.RuntimeException: com.hyperion.planning.DuplicateObjectException: An object with the name WULC1 already exists.

                [Wed Jul 02 19:46:04 EST 2014]java.lang.RuntimeException: com.hyperion.planning.DuplicateObjectException: An object with the name WULC1 already exists.

                [Wed Jul 02 19:46:05 EST 2014]com.hyperion.planning.InvalidDimensionMemberNameException: Dimension Member name "ORDER" is a Report Script command.

                [Wed Jul 02 19:46:05 EST 2014]com.hyperion.planning.InvalidDimensionMemberNameException: Dimension Member name "ORDER" is a Report Script command.

                 

                If the refresh of the Essbase cube works with the same user from Planning web then is there any chance that there was a temporary 'blip' with Essbase when the metadata load was being done or is this happening consistently when the metadata loads are run from FDMEE?

                 

                Regards

                 

                Craig

                • 5. Re: Cannot load metadata from EBS
                  RMarques

                  Wired thing.

                  I've made my metadata load with just Entities.

                  In ODI session I can see 3 green lights:

                  • Session EBS_GL_LOAD_HIERARCHIES (59501)
                  • Session EBS_GL_LOAD_DIMENSION_MEMBERS (58501)
                  • Session COMM_LOAD_DIMENSIONS (57501)

                  But in the ERPi - Process Details I've got almost green tickers and a yellow triangle saying: "Exporting member to Planning application for dimension Entity"

                  Maybe im getting duplicated alias?

                  • 6. Re: Cannot load metadata from EBS
                    RMarques

                    Yes. It has duplicated things. How can I put the "_"+ Name in the Alias for these cases?

                    • 7. Re: Cannot load metadata from EBS
                      Chuggans-Oracle

                      There's a 'Concat Name to Alias' option in the metadata load rule mapping that you can use to ensure uniqueness of the alias on the EPM end, that should hopefully do the trick I think

                       

                      Regards

                       

                      Craig

                      • 8. Re: Cannot load metadata from EBS
                        RMarques

                        Hi Craig,

                         

                        Yes, I found that. In the 11.1.2.2 we dont have this.

                        But weird thing is, in the current env 11.1.2.2 I can see Name - Alias_Name (ex: Member1, Alias: XXXYYY_Member1) in these cases that the alias should be duplicated. It that possible?

                        I tried "Concat", no duplicated members errors, but, still cannot connect to Essbase

                        An error occurred during the cube refresh operation: com.hyperion.planning.HspRuntimeException: Unable to connect to Hyperion Essbase.

                         

                        Regards,
                        Rafael

                        • 9. Re: Cannot load metadata from EBS
                          RMarques

                          Hi JohnGoodwin!

                           

                          Can you gimme a hand?

                           

                          Thanks

                          • 10. Re: Cannot load metadata from EBS
                            Chuggans-Oracle

                            Hi Rafael,

                             

                            I'm not 100% on how the Essbase cube refresh is triggered from FDMEE but I know that FDMEE connects directly to Essbase when running data loads in order to create data load rules files. Could it be possible here that the port that Essbase is bound to (default 1423) is not accessible from the FDMEE box maybe?

                             

                            If the refresh /*can*/ be done from Planning it sounds like Essbase is up and running and can be accessed from the Planning machine. So that leaves me wondering if it's an issue with FDMEE not being able to connect to Essbase. If Essbase and FDMEE are on separate boxes can you use telnet (telnet Essbaseservername 1423) or netcat (nc -v Essbaseservername 1423) to check if the port is accessible from the FDMEE box.

                             

                            Regards

                             

                            Craig

                            • 11. Re: Cannot load metadata from EBS
                              RMarques

                              Hi Craig,

                               

                              They are in the same box.

                              I found this:

                              Patch 18614001: MERGE PATCH. FIXES BUG 18536469

                              Maybe?

                              I'm trying to apply this patch to check.

                               

                              Regards,
                              Rafael

                              • 12. Re: Cannot load metadata from EBS
                                RMarques

                                I've applied the patch and still have the same.

                                Maybe SR.

                                Any clues?

                                • 13. Re: Cannot load metadata from EBS
                                  Chuggans-Oracle

                                  Hi Rafael,

                                   

                                  Yeah I think that you may be best with an SR at this stage as something isn't quite right here. That patch was for an issue with Planning not binding to the RMI port but it sounds like in your case it's an issue connecting to Essbase.

                                   

                                  To try and speed things along I think that I'd say to run the metadata load once more and note the time in the SR, then run the following and provide the results when logging the SR (see note 1303200.1) so that we can give it a good once over:

                                   

                                  1. the ziplogs.sh or ziplogs.bat utility to get the full set of logs

                                   

                                  2. the validate.sh or validate.bat utility to get an overview of the system health

                                   

                                  3. the epmsys_registry.sh or epmsys_registry.sh tool to show the registry and

                                   

                                  4. epmsys_registry.sh report deployment or epmsys_registry.sh report deployment to give an overview of the deployment


                                  Regards


                                  Craig

                                  • 14. Re: Cannot load metadata from EBS
                                    RMarques

                                    Great. I'll get those file and SR then.

                                    I'll let you know.

                                     

                                    Thanks Craig

                                    1 2 Previous Next