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]

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