Lifecycle management fails to migrate data completely

By -
Lifecycle Management is the widely used option to export application artifacts for migration and backup. Starting 11.1.2 LCM also offers the ability to export data and can be selected while defining the migration definition.  
I wanted to setup a backup process to export application artifacts and used LCM. All seemed OK until I encountered an issue with LCM and wanted to share via this article. Lets reiterate the steps I followed and identify the error ourselves.
I selected all artifacts including data.

 

I defined the migration to export all the artifacts to file system and scheduled it to run as a job to export all the artifacts on Essbase server.
Just to brief  you on how to do achieve this is to write a batch script which calls the LCM command line utility with migration definition xml and path to export all the artifacts to desired location. On testing it, everything executed well as scheduled.

It was after few days when my scheduled job failed to run because there was not enough memory on C:\ drive of the machine. On drilling into each folder based on its size, I reached to a directory Users\<username>\Appdata\Local\Temp and found it had grown a lot in size. There I found bunch of temp files each of almost same size and created at the same time when my backup process was scheduled to run.


 

I could not open the big file in text editor due to its size, but going through the other files (audit and cssxml) seemed something related to Essbase. Just to test a vague thing, I exported the whole data from my Essbase application to be surprised to find out that the export created two files and one of them was of the same size as the temp file left behind under Temp directory.

 

To test it, I opened the Temp directory and started the LCM utility to export all the artifacts. When LCM utility is running export and reaches step to export data, it first exports all data under the Temp directory and then moves it to export location.

 

 

This is where Oracle did not code the LCM utility intelligently to pick both files. LCM moves the first file to the export location and renames it Data and the second file with same name but a '_1' suffixed is left behind under the Temp directory. Thus we have all the artifacts but incomplete data exported using LCM.
Hope it helps !!!

Comments

  1. kwNovember 2, 2012 at 9:46 PM

    Did you let Oracle know so they can patch it?

    ReplyDelete
  2. kwNovember 2, 2012 at 9:53 PM

    Do you get to choose level 0 data or all data? Or does it default to all data?

    ReplyDelete
  3. Navan MehraNovember 2, 2012 at 10:29 PM

    I raised a ticket with Oracle. As usual they take their own time to respond. I was trying to export level zero data from an ASO cube. But it doesn't matter whether its level zero data or all data. It is the issue that LCM does not pick up the multiple files which if the data export extends more than one file

    ReplyDelete
  4. AnonymousFebruary 21, 2014 at 5:48 AM

    Navan,

    Any solution yet to this problem?

    ReplyDelete
    Replies
    1. Navan MehraFebruary 21, 2014 at 9:51 AM

      The update which I received was that this issue existed in 11.1.2.1 only and has been resolved in 11.1.2.2+ Though I did not get a chance to test the same in latest release. Oracle identified it as Bug 16165824 - ASO LCM MIGRATION DOESN'T MIGRATE THE COMPLETE DATA (> 2 GB) and informed to release a solution in 11.1.2.1 PSU.
      The work around would be to skip exporting data in LCM and setup a MAXL job to export data

      Delete

Post a Comment

Popular posts from this blog

Power BI + Oracle PBCS - Part 1: REST API Structure

By -
Image
“Visualization gives you answers to questions you didn’t know you had.” – Ben Schneiderman . Undoubtedly, visualization is playing a vital role in today’s corporate world. The data is no longer confined to tables or worksheets, be it a CXO or analyst, its far easy to consume information and report via pretty visuals knit together into colourful dashboards. This has lead to an upward trend of visualization tools like Oracle Analytics Cloud (OACS), Microsoft Power BI, Qlik Sense, Tableau, etc. With each product bringing its own benefits to the table, it is important for the firms to invest in the best and harness each product’s capability. PBCS might be a leading planning and budgeting SaaS application but doesn’t offer all dashboarding capabilities or the varied charts available with Power BI. Similarly, Power BI or OACS are best for dashboards not for planning and budgeting. Not all firms invest in OACS with PBCS and tend to have a heterogeneous architecture of BI products. Thu...
Read more

Unexpected Essbase error 1007083

By -
I came across this issue and thought of sharing one of the possible solutions for it. The solution of mine may not apply in all situations but you never know it may help. Before going ahead, I would just like to give a small background of the situation. I have an ASO application with 10 dimensions in Essbase version 11.1.2.0. I had a task to clean up some metadata to get rid of unwanted members and thus developed few load rules. All load rules ran well except for one which gave this error Object [outline name] is locked by user [user name] Dimension build failed. Error code [1090040]. Check the server log file and the dimension build error file for possible additional info. Unexpected Essbase error 1007083 Object [outline name] unlocked by user [user name] The log files do not provide any information about the error. Initial search on web, oracle forums, support says a lot many things. From all those sources I could get information that this error may occur due to any one ...
Read more

Groovy Series 4: Playing with cell level formatting

By -
Image
When it comes to highlighting certain data cells or making them read only, we all must have got our hands dirty with validation rules and valid intersections. Undoubtedly, they make things quite descriptive and help to control data entry when required. But at the same time, the trouble to maintain all these objects is equally troublesome. Lets consider three random scenarios which client must have proposed to highlight certain cells on a data form or make certain cells read-only If the entity is E105 and COA member is among ‘A66001’ or ‘A82580’, colour it red If the entity is E100 and COA member is A65001 , colour it green If COA member is A84001 , make the first open period of scenario as read only Considering the above requirements, if we intend to implement them, we would have to create validation rules to highlight the cells and create valid intersections to make specific cell read-only. W hat if, we have multiple calculating scenarios which run in isolation, say Plan scenario wher...
Read more