Skip to Content
author's profile photo Former Member
Former Member

Repeat Delta

Posted on Jul 14, 2006 at 12:34 PM 159 Views

Hi all,

I've been loading delta's for the past few days and today my delta failed because of some data problem in R3 side.And I rectified the Erroneous data.

Now I want to do the delta,Is it possible for me?

Somewhere I read about Repeat delta, is it soves my problem..Please guide me How do I will get my delta..

Regards,

Preetham

BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 14, 2006 at 12:38 PM

    check this :

    repeat-delta

    • assign points if useful ***

    Thanks,

    Raj

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Bhanu Gupta
      Jul 18, 2006 at 01:14 AM

      May I ask for your thoughts on the following situation:

      2lis_03_bf data was collected on r3 extracted into BW at 2am successfully then again at 6am and then at 10am just the collect occurred. Then the BW database had to be brought down and when it was brought back up it had found a data inconsistency at 7pm from the night before. We began to roll forward but was only successful in getting it rolled forward until 2:18am. So now BW only has the request for 2am. In R3 when I view a delta repetition it shows me 3527 records and I assume this is from the 6 am run. In R3 when I view the delta records it shows me 2382 records and I assume this is from the 10 am collect.

      I need to get the 3527 records from 6am and the 2382 recs from 10am into BW. Can anyone assist me please?

  • author's profile photo Bhanu Gupta
    Bhanu Gupta
    Posted on Jul 14, 2006 at 12:36 PM

    Hi Preetham,

    Yes, it is possible to 'repeat' the delta in certain cases when it fails. You can try executing the delta InfoPackage to do this. It will work so long as you did not force the errored load to Green status.

    Hope this helps...

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 14, 2006 at 12:37 PM

    Hi Preetham,

    You can do repeate delta.

    1. First make the status(total and quality) of the request RED. and delete it from Monitor.

    2. go to infopackage and schedule the infopackage, system will ask for repetition, say ok and continue.

    Hope it Helps

    Srini

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 06:09 AM

    Hi !

    Eventhough one delta Request is successful, it will be maintained in Delta Que Unitl the successfull delta Request from BW.

    When the next DeltaRequest comes from BW,the system Checks the previous request QM Status, if its green the data belonging to that request will be deleted in Delta Que.

    If it is red, Repeat Delta in Que pulls previous delta records as well as the current detlas One.

    So If the request has failed , make the QM status red inorder to pull the previous delta Records

    Hope this helps

    Regards

    Durai

    Add comment
    10|10000 characters needed characters exceeded