Data not coming from smq1 into rsa7

[Former Member]

Hi,

We use 2 standard extractors 2LIS_18_I0NOTIF and 2LIS_18_I0TASK in our system to pull data into BW. I am trying to change the delta mode from current Direct Delta to Queued delta mode (in Quality environment). After changing it, I am not getting any data into RSA7 even though I can see some data in SMQ1 and I have run V3 job as well.

Can someone suggest as to where I am going wrong.

[Former Member · Accepted solution]

Hi,

Please check the question discussed here :

-Vikram

[Former Member · Accepted solution]

I went through it but don't think its answering my problem.

The initialization was not done in BW system for any particular Sales Organisation.

Also, it was working fine till the time it was working as Direct Delta. It was only after I changed it to Queued delta that the data is not coming into RSA7.

The Job log is as below.

Job started

Step 001 started (program RMBWV318, variant , user name RKR05)

Queue processing started (MCEX18, 1,000, , 0)

Extraction queue processing started MCEX18 with 1 LUWs

Processing of extraction queue MCEX18 successfully ended

Queue processing started (MCEX18_1, 1,000, , 0)

Extraction queue processing started MCEX18_1 with 0 LUWs

Processing of extraction queue MCEX18_1 successfully ended

Job finished

[former_member181964 · Accepted solution]

Hi,

You change the Update Mode to Delta in LBWE and activate the DS and then, fill the setup tables and load INit and then Run V3 job and then load Delta else see in RSA7

See the Articles.

Checking the Data using Extractor Checker (RSA3) in ECC Delta Repeat Delta etc...

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/80f4c455-1dc2-2c10-f187-d264838f21b5&override...;

Data Flow from LBWQ/SMQ1 to RSA7 in ECC and Delta Extraction in BI

http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/business-intelligen...

https://wiki.sdn.sap.com/wiki/display/profile/Surendra%20Reddy

Thanks

Reddy

[Former Member · Accepted solution]

Hi Surendra,

This extractor has been active since a long time. In the existing mode, it was loading data using Direct delta mode.

I have not made any changes to the extractor and am only changing mode from Direct to Queued. Do I still need to perform the mentioned steps.

[Former Member · Accepted solution]

Hi,

Please follow the steps below:

-->Lock the users

-->Empty the delta queue

-->Delete Set Up tables

-->Deactivate the data source

-->Change the Update Mode

-->Save the setting

-->Replicate the data source

-->Start the Statistical Set up - Ensure you have a plan to split the data say based on PO or Document date. So you will run the Statistical set up in a split way.

-->Start BW Init

-->Realign the delta for old timings

-->Unlock the users

-Vikram

[Former Member]

Hi,

We are facing the same issue for 2LIS_04_P_MATNR, there are over 600 records in SMQ1; but in RSA7 it shows 0 records. We also ran the V3 job. Our delta mode is already set to Queued delta. So I don't understand why it is not getting populated in RSA7. Do i need to change it to Unserialized V3 Update?

Any help would be greatly appreciated.

Thanks