Skip to Content
author's profile photo
Former Member

0PUR_C01 Delta Queue Issue

Hi Experts,

I had forgotten to schedule the job in the LO Cockpit and as a result i was not getting any delta changes in RSA7 Queue and RSA3.

So i deleted the data from the cube and also the Initializations.

Now in R/3 side i deleted setup tables,again filled up the same and did an Init tranfer w/o data transfer and then a Full Repair Load.

Now in the LO Cockpit i scheduled the job.The job was scheduled the same day on a daily basis. However on the same day as the setup table was filled, the job fetched new data records into the Delta Queue but i am sure no new entries were posted in R/3 at that time. Even in RSA3 i am seeing the same number of records as the Full Load but in RSA7 additional 3000 records are present which was fetched by Delta Package today through Process Chain.

But why are those added records not coming in RSA3. Am i missing something?

Thanks and advance.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 03, 2011 at 09:26 AM

    hi,

    Please find below the comments:

    I had forgotten to schedule the job in the LO Cockpit and as a result i was not getting any delta changes in RSA7 Queue and RSA3.So i deleted the data from the cube and also the Initializations.

    RSA3 is for extraction for FULL and full loads are extracted from setup tables and not delta tables. Also even if you unscheduled the job the delta was getting captured in LBWQ (extraction queue) , you need not have deleted the data and loaded again, only scheduling the delta would have brought the correct records.

    Now in R/3 side i deleted setup tables,again filled up the same and did an Init tranfer w/o data transfer and then a Full Repair Load.

    Now in the LO Cockpit i scheduled the job.The job was scheduled the same day on a daily basis. However on the same day as the setup table was filled, the job fetched new data records into the Delta Queue but i am sure no new entries were posted in R/3 at that time.

    This is not possible as delta will only be generated if the documents are being changed or new documents are being posted.

    Even in RSA3 i am seeing the same number of records as the Full Load but in RSA7 additional 3000 records are present which was fetched by Delta Package today through Process Chain.

    But why are those added records not coming in RSA3. Am i missing something?

    RSA3 will match the full load as both refer to setup tables for data, RSA3 does not fetch delta records, check the update method of your KF in the inbound DSO, if all the KF are in overwrite mode then the data is correct and you need not worry, however if any of the key figure is in addition mode then the data will be corrupt and maybe doubled for some documents and you need to correct it.

    regards,

    Arvind.

    Add comment
    10|10000 characters needed characters exceeded