Skip to Content
avatar image
Former Member

Process LUW (Records) in SMQ1

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Feb 16, 2009 at 09:21 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Feb 16, 2009 at 09:22 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 09:22 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 09:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded