Delete entries from Extraction queue

[Former Member]

Hello

I am trying to change the extract structure of an application component ( SD....MC11VA0HDR) through LBWE.

but it gives an error...." Entries for Application 11 still exist in the extraction queue".

I've made the datasource "inactive" but....

Kindly assist..

Full points waiting...!

[Former Member · Accepted solution]

Hi,

First delete the data in which exists in the Extract Structre i.e using tcode 'LBWG' and give the application component no. and delete the extract structre data.

and then try to add the new fields to the extract structer.

Hope it helps.

Thanks

[Former Member]

Thankyou

[Former Member]

HI Reddy,

First Run all the V3 jobs. .....and then run the delta infopackage twice..In the second run you will get 0 from 0 records. and then delete Source system Initailization option in Init Infopackage. ...Then automatically your Delta queue in RSA7 will get delete.....

Regards,

Srikanth

Edited by: srikanth on Feb 12, 2009 9:01 AM

[Former Member]

Hi.......

Remember.......before Datasource Enhancement of a datasource............u hav to make sure that there are no entries in the Delta queue.......

U can delete Delta Queue in RSA7........Also delete Extraction Queue(LBWQ) and in SMQ1..........drill in to the queue and delete the respective queue.........

Regards,

Debjani........

[Former Member]

Hi ,

This has been discussed many a times...

One of the thresd

https://www.sdn.sap.com/irj/scn/forums

Regards,

Mann

[Former Member]

hi ajeet

Could you please give me the steps to delete the RSA7 entries?

I've run the collective run from LBWE by activating the datasource and chosing "immediate" from Job control.

My Datasource is 2LIS_11_VAHDR.

checked the LBWQ....one queue MCEX02 has vanished after the collective run.

Now, is MCEX02 the exact queue i need to delete from LBWQ? there is one more queue MCEX11?

I'm confused.It didnt change after the collective run.

Now i deleted the setup tables for app comp 11.

Please let me know how should i delete the entries from RSA7?

Do i have to search randomly in BW for source system ( T90...) and look for datasource 2LIS_VA_HDR and find infopackages( Init) associated with it?

Pls help

Edited by: reddy reddy on Feb 11, 2009 1:12 PM

[Former Member]

hello,

RSA7 will contain entry only if there is an init done...if not then no entry for this data source in RSA7 in delta queue.

You have to just select the entry for that data source and chose the option delete on the top in the RSA7.

Also you need to delete the entroes from MCEX11 queue in LBWQ and SMQ1 if possible.

This will get created if you do a new init and schedule the delta again...

Or if possible try to change data source and see if it still gives the error...

Thanks

Ajeet

[Former Member]

Hello Reddy

Before doing any data source enhancement, you ahve to make sure that they are no entries in the RSA7.

If you are doing in development ,it is ok if you delete the entries in RSA7.

but in production you should nt delete any entries like that.

for that try loading the data in the BW untill u get the 0 records in your delta.

For that you can collective V3 run and check if any records in your datasource and again load the data in BW till you get 0 records .

Then delete the setup tables

After this only try to modify the datasource,

Regards

[Former Member]

Hi Ajeet

Are the names of the queues fixed for each application? or are they dependent on the configuration?

for example: Is MCEX11 the precise name of the SD component extraction/Delta queue in SAP?

Please clarify...

cheers!

Edited by: reddy reddy on Feb 12, 2009 6:44 AM

[Former Member]

Hi......

Extraction Queue name is MCEXnn, where nn is the application number from the LO Cockpit......

So.for each application area name is fixed.......

Regards,

Debjani......

[former_member181964]

Hi,

Goto SMQ1 in ECC and execute...

MCEX02

MCEX03

MCEX04

MCEX05

Like this you take last two letters and compare with LEWE datasource application names.

Thanks

Reddy

Edited by: Surendra Reddy on Feb 12, 2009 8:12 AM

[Former Member]

Hi

If you make the Ds inactive also the Delta Queue is not get empty by itself, you need to delte the delta queue from RSA7 -- then try LBWG -- Delete the entries from LBWQ for this data source-- Try to stop the V3 Collective run through LBWE Job control

Hope it helps and clear

[Former Member]

Hi

Check the thread, you will gat all the steps

Shilpa

[Former Member]

Hello,

there could be couple of reasons.

delta queue should be empty...so delete the delta queue from RSA7.

Delete the set up table for the application 11.

Delete the entries from LBWQ for this data source.

Also stop the collective job through job control for this data source.

check this note for more on how to enhance the LO data source.

328181

Thanks

Ajeet