Skip to Content
author's profile photo Former Member
Former Member

LO extraction fails and enabling the delta queue back to capture the delta

Hi All,

We have the BI system and the LO extractions have been done 6 months back and all the data is in BI now for 2lis_02_itm (Purchase order line items). Right now, we have a requirement for few enhancement fields in the 2lis_02_itm and hence after the enhancement we need to perform the LO extraction again.

As the LO extraction must be done in a down time and as it takes a longer hours, in a worst case scenario if the set up table is not filled by the stated down time, we might need to stop it and make sure there is no impact to the existing data in BI.

In case if the set up table extraction is partial, and if we delete the setup table and do a INIT without data transfer, will the changes to PO after the init will be captured and go in to BI system without any problems. In this case we will not able to get our new enhancements but just make sure we do not cause any impact to the existing system which is up and running. As the existing data will still remain in BW side and we can get the changed data in the delta queue after the down time...?

Kindly help to answer this as this blocks my mind!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2011 at 11:18 AM

    Are you able to check with LO-Functional colleagues to see how you can reduce the subset of data for downtime i.e. records which can be changed? If so consider these as part of the downtime and subset again since each subset will use one background process

    Therefore:

    1. Set of data which can be changed Set A for example within doc/posting date range eg. current posting period/month - 2

    2. Break Set A if possible into subsets for example Sets B - D

    3. All non changing data sets subset these for example Sets E - K

    When Sets A - D are complete you can open the system

    Ideally carry out the init w/o data once sets A - D complete to avoid any missing docs if a collection run takes place

    You can bring all sets as Full repair loads

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.