Home > Default > Metadata load during 24 hours and still has not finished

Metadata load during 24 hours and still has not finished

November 30Hits:0
Advertisement
Hi all,
I have a problem with the metadata load on HFM 9.3.1.3
It seems it is running from about 24 hours.
it happened some time that the log has not been produced from the HFM client, but I always have found in the log that the metadata load had finsihed succesfully.
This time I have no clue that the dataload has completed.
I have performed some times ago the delete invalid record task, that completed succesfully.
Can some one tell me wich are the drivers that make the data load process last so long?
Regards, Andrea Zannetti.

Answers

Changes to the Entity or Currency dimensions can take far longer than changes to the Account, Custom, or Scenario dimensions. The reason for this lies primarily with the calc status tables, since changes to Entity or Currency require HFM to make changes including inserts to all of the CSE/CSN tables. Changes made to the Accounts or Customs do not require updates to the CSE/CSN tables.
Another common place for very long metadata loads lies with journals. The "Check integrity" box for metadata loads tells HFM to read through each and every journal and journal template in the entire application, checking to see whether even a single journal or template could become invalid if it allowed the metadata to be loaded. NEVER uncheck this, since once metadata has invalidated even one journal, you can never load metadata with the check in place afterward.
Another possibility is that metadata loads have to wait for all currently running data loads and consolidations to complete before the metadata load can start. Once it starts, subsequent data loads and consolidations have to wait for the metadata load to complete before they can start. This is to preserve data integrity.
One last place to look for long metadata load times comes with an application whose database is performing poorly, possible because of missing/broken/out of date indexes.
--Chris                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   

Read other 2 answers

Tags:

Related Articles

  • Metadata load during 24 hours and still has not finishedNovember 30

    Hi all, I have a problem with the metadata load on HFM 9.3.1.3 It seems it is running from about 24 hours. it happened some time that the log has not been produced from the HFM client, but I always have found in the log that the metadata load had fin

  • Metadata Loads (.app) - What is best practice?October 11

    Dear All, Our metadata scan and load duration is approximately 20 mins (full load using replace option). Business hfmadmin has suggested the option of partial dimension loads in an effort to speed up the loading process. HFM System Admins prefer Meta

  • Automated MetaData LoadOctober 11

    Greetings, I'm curious to know how some of the users in this forum perform automated metadata load against dimensions in the Shared Library (and subsequently against any EPMA Planning apps). We have several apps whose dimensions are shared amongst va

  • HFM Metadata Loading On-going ProblemOctober 11

    Hi There, We just migrated to HFM 11.1.1.3 from HFM 4. We used to have an issue in HFM 4 where almost everytime we loaded metadata, the system would hang and become unresponsive. The load screen would just sit there without ever completing the load.

  • "MDL1223: Metadata Loader cannot be executed ..." error?October 11

    Hi folks, Am getting this strange error from OMBPlus (11Gr2): MDL1223: Metadata Loader cannot be executed while other user(s) are accessing the workspace. when trying to import an MDL file, when using this statement: catch {OMBIMPORT MDL_FILE '$projn

  • Metadata load using ERPiNovember 30

    Hi All, I am new to ERPi, Our client is willing to implement ERPi Metadata load. The source is People soft 9.1 and the target Hyperion EPMA planning 11.1.2.2.300.20. My source COA tree structure is different with my target Hyperion COA structure, can

  • Metadata load problemNovember 30

    Hi, Iam a newbie to Hyperion. Iam trying to load metadata into the classic application for a particular dimension. I get the error as "unrecognized column header value "". I removed all spaces in the csv file but still the error is the same

  • Automate Metadata loads into EPMANovember 30

    Hi, My company has 2 systems HCM and EPMA. We are tying to get the data in sync between these 2 systems. I am new to EPMA and was wondering if there is a way to automate the Metadata loads into EPMA? We recently installed ODI but not sure if this can

  • Automate DRM Metadata load into HFMNovember 30

    Is there a way to automate a DRM metadata load into HFM? In both instances, we are using the latest Fusion versions and I wanted to know if there is a way to automate loading the flat file produced by DRM into HFM. How would this be done? Does EPMA v

  • How to choose member position during ERPi metadata load ?November 30

    Dear All , We are using ERPi to load data and metadata from EBS to our target Hyperion Planning Application . during metadata load , members set to be at the root of the dimension . My question , How to choose where the extracted members to be placed

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.478 s.