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

ECC system has to be locked?

Dear BW Extraction gurus,

I heard that ECC system has to be locked during certain extractions? Can you please mention in which scenarios we have to lock ECC system and why?

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    Posted on Apr 21, 2012 at 05:01 AM

    Hi,

    When we are loading full or init load we lock the ecc users.

    Usually the initialization job is extremly time consuming, and has to be performed when the ECC system is locked to the users. Therefore it is often performed at night-time. To minimize system downtime, the loading process on the BI system should be started immediately after the setup job has finished.

    Regards,

    Aravind.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2012 at 07:22 PM

    bump

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 21, 2012 at 08:00 AM

    Hi,

    Locking the R3 system is to avoid postings.It is basis job.

    Locking means, the r3 system is not available for users to post new documents/transactions.

    While full, init and repair full request we need to lock the users.Once the full upload is done then basis people will remove the lock and next transaction on wards data will come under delta load.

    As aravind said these things should be done at night to minimize system down time(System not available to users)

    Regards,

    Anand.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2012 at 09:53 AM

    Hi,

    We have to lock system / Users ( using transactions ) for logistic modules data loading in BW. There are 017 PM, 03 Invetory , 02 Purchase, 013 SD etc logistic modules , whenever first time we load data in BW , we have fill setup tables & initilize delta . While filling of setup table we must lock tables used by these setup table.

    Regards,

    Anand Mehrotra.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 21, 2012 at 09:18 AM

    Hi Saurav,

    In addition to points mentioned by our friends, I would like to one more scenari when ECC will be locked.

    ECC will be locked before applying any Support packs / enhancements. We lock ECC to stop postings done by the user. When applying support packs or doing enhancements in ECC side, the delta queues has to be cleared by pulling data to BW. Once the delta queues are cleared, the system will be put to maintenance mode and the changes are applied.As soon as the changes are changed, system will be open and further postings will be saved.

    Hope this helps you

    Regards

    Chandu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2012 at 02:43 PM

    Hi,

    Taking down the ECC system - is this a best practice or is it a "must"?

    I know of a company that is extracting data from Z-tables.

    The company drops the data from the infoproviders, and does a full load from the Z-tables of ECC. They do not take the ECC system down for this full load. The data volume is very low.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2012 at 03:51 PM

    There has been a lot of different replies.

    Please allow me to summarize my understanding in a comprehensive way:

    There are 3 types of extraction process: Standard, Logistics, and Custom.

    Standard: We do not lock the user even if it is a full or init load.

    Custom: We do not lock the user even if it is full load.

    Logistics: We lock the users ONLY when we are performing a historical/full load to fill the set up tables.

    Can you please confirm if this understanding is correct?

    Thanks.

    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.