Skip to Content
Author's profile photo Former Member

How to clear the outbound queue and delta queue

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

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ashok Babu Kumili
      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

      Author's profile photo Former Member
      Former Member

      Very Nice blog

      Author's profile photo Aparajit Banik
      Aparajit Banik

      Thanks for  sharing  these concepts. Really very educating.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks for your all comments

      Author's profile photo Former Member
      Former Member

      Nice one.

      Author's profile photo Former Member
      Former Member

      Thanks Gopinath..Very Nice Blog..you been a life saver !!

      Author's profile photo Former Member
      Former Member

      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!