Process LUW (Records) in SMQ1

[Former Member]

Dear Experts,

How do I process LUW (or block of records) shown in SMQ1?

For ex: 2LIS_02_HDR has 71 entries against it in SMQ1, But RSA7 has 0 entries.

If I execute delta infopackage in BI, no records are transferred i.e. 0 as reflected in RSA7.

Since I am recreating the setup tables, I intend to start fresh. Hence my ques:

1. SHould I process these records and if so how?

2. If not should I delete this entry in SMQ1/

Thanks & BR,

Jain

[Former Member]

Thanks to all, but the issue has not resolved.

While checking the datasource in SMQ1, the status for LUW is "NOSEND".

I than ran the job control for queried delta.

The log for this job is:

"

Queue processing started (MCEX02, 100, , 0) MCEX 153

Extraction queue processing started MCEX02 with 0 LUWs MCEX 154

Processing of extraction queue MCEX02 successfully ended MCEX 155

Job finished 00 517

"

Now when I check in RSA7, the 2LIS_02_HDR has 0 records and the entry in SMQ1 for this datasource remains same i.e. 71 entries

Jain

[Former Member]

status of LUW s should be NO SEND,then

only they will be updated to Delta Queue

So Go to SM13 and check the status of

any pending trfc queues.There go to

your DataSource and check the status

and manually change the status to

NOSEND.

[Former Member]

Hi ,

see the data is there in extraction queue now so you have to scedule V3 jobs from LBWE .. to get the data in delat queue .. then only data will be fetched in BW .

http://help.sap.com/saphelp_nw70/helpdata/en/ad/7b623c6374a865e10000000a11402f/content.htm

regards,

shikha

[Former Member]

Hi Rajesh,

First run the LBWE job...records would be available in RSA7

Then run the delta infopackage from BW side ...

hope it helps

Mann

[Former Member]

Rajesh,

Run V3 job to push data from SMQ1 to Delta queue. and run infopackage to pull data into BI.

Since I am recreating the setup tables, I intend to start fresh. Hence my ques: 

1. SHould I process these records and if so how?

--> If this data required, run v3 job and infopackge to pull data into BW.

2. If not should I delete this entry in SMQ1/

--> As you are loading entire data again, you can delete this data. No need to process.

Srini

[Former Member]

Thanks Srini, but the issue has not resolved.

While checking the datasource in SMQ1, the status for LUW is "NOSEND".

I than ran the job control for queried delta.

The log for this job is:

"

Queue processing started (MCEX02, 100, , 0) MCEX 153

Extraction queue processing started MCEX02 with 0 LUWs MCEX 154

Processing of extraction queue MCEX02 successfully ended MCEX 155

Job finished 00 517

"

Now when I check in RSA7, the 2LIS_02_HDR has 0 records and the entry in SMQ1 for this datasource remains same i.e. 71 entries

Jain

[Former Member]

Rajesh,

Check V3 job log(SM37). Job successfully executed or not...? After successfull completion of V3 job only data moves from update queue(SMQ1) to Delta Queue(RSA7).

Srini