Skip to Content

Applies to:

SAP BW 3.x & SAP BI Net Weaver 2004s.

Author Bio

Gopinath Ramalingam is working as SAP Consultant with Cognizant technology solutions

He has got experience and worked on various BW/BI/BO Implementation/Support Projects.

Scenario

When we are applying patches or in case of SAP server migration, Basis team will bring both ECC and BW System in down state. At that point of time, all the delta record will be moved to BW system ,then the BASIS team can apply the patches/migrating the server activity.

Before clearing the queue, user must locked in the SAP ECC & BW system and also suspend the jobs done by basis team .Also we need to stop the posting from the client, otherwise continuously delta update in the system

Steps to clear Outbound Queue

1. Check the LBWQ t.code and clear the outbound queue using the LBWE.

     /wp-content/uploads/2013/07/1_243311.jpg

2. Go to LBWE transaction code and click the Job Control.          

    /wp-content/uploads/2013/07/2a_243366.jpg

Then click Start date.

    /wp-content/uploads/2013/07/3_243320.jpg

Set the Print param

      /wp-content/uploads/2013/07/4_243322.jpg

         /wp-content/uploads/2013/07/5_243326.jpg

Select ‘Immediate’.

        /wp-content/uploads/2013/07/6_243327.jpg

Click Schedule job

        /wp-content/uploads/2013/07/7_243328.jpg

Click Job overview

          /wp-content/uploads/2013/07/8_243329.jpg

Then check the LBWQ

            /wp-content/uploads/2013/07/9_243330.jpg

Now, the queue MCEX03 has been cleared. Likewise move the queue MCEX11, MCEX12 and MCEX13 from LBWQ to RSA7.

Once all the queues clearing activity is completed, we can check on t-code LBWQ having no entries.

             /wp-content/uploads/2013/07/10_243331.jpg

Steps to clear Delta Queue:

Check the RSA7 and move the data into BW System using Info Package.

               /wp-content/uploads/2013/07/11_243341.jpg

Go to Info package and trigger the delta.

              /wp-content/uploads/2013/07/12_243342.jpg

Now, the 2LIS_02_SCL becomes zero by default.

               /wp-content/uploads/2013/07/13_243343.jpg

Likewise proceed with all the extractor. Now, all the extractor must be zero (0).

          

                /wp-content/uploads/2013/07/14_243353.jpg

To confirm the delta queue,

Check the SMQ1 transaction code if any Queue Name start with MCEX** or Destination BWCLNT*** (i.e. your BW System name).

                    /wp-content/uploads/2013/07/15_243354.jpg

If any entries are available then trigger the equivalent Info package in the BW System.

Finally, our SMQ1 should not have any entries like MCEX** and BWCLNT** queue. (See below screen shot)

The below two entries are invalid posting or error record in the system and can be ignored. 

          /wp-content/uploads/2013/07/16_243355.jpg                              

Select the queue and display the detail of the record.

             /wp-content/uploads/2013/07/17_243359.jpg

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Ashok Babu Kumili

    Hello Gopinath Ramalingam,

    Thank you so much for this blog. This is very cool. I specifically love that it is SOLUTION oriented.  This is so organised and well described.

     

    Regards

    Ashok

    (0) 
  2. Carlos Eduardo EspaƱa Orellana

    Absolutely very good post, thank you very much. We are in the middle of a system conversion from ECC to Business Suite prior to S4. And we will use this functionality to accelerate the upgrade prerequisites on the ERP side. Thanks!

    (0) 

Leave a Reply