Skip to Content
author's profile photo
Former Member

1st step in case of Delta Failure!!

Hello BW Experts,

What is the very first step that we should do in case of a delta failure?? That could in the process chain or a normal manuall;y sheduled delta load!!

When do we decide to go for a Re-Initialization of delta??

Plz provide the basic step-by-step procedure to handle thses situations!!

Thanks & regards,

Sapster.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • Posted on Sep 06, 2007 at 01:52 PM

    Hi..

    Double click in the IP

    Scheduler menu

    Click in Initialization options for source system

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 06, 2007 at 12:55 PM

    Hi,

    In case of delta failure from source system , go to monitor screen - set the total status to 'red' , eventhough it is red ..

    delete the bad request from data target and then load the infopackage , while scheduling the infopackage it will ask for to do repeat , say yes to continue.. normally these steps should be done by manual only..

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 06, 2007 at 04:52 PM

    If delta fails ,then check first why it has failed there may be erroneous record ,or no data coming from source system..many possibilities are there

    Now If its in the process chains

    follow the following steps:

    1.Right click on the process step infopackage loading in the process chain concerned >Select Process Monitor >Now make the status of the load as incorrect(Red).

    2.Now check the loading whether its loading to a target or till PSA only..if its loading to a target like DSO etc then go in the target from the Process Monitor(at the top there is a button for Target arrow).

    In the target also make the status as Red.and delete the request .

    3.Now go in the PSA (RSA1) (by double click on datasource concerned and at top menu bar you will find button for PSA.).

    Delete the erroneous reequest.

    <b>Important: If you don't change the status of request as red and make it green etc ,it will cause error and you will loose those delta records,so very carefully do this before you actually delete the request from target and PSA</b>

    4.Even if you are manually loading ,you can go to process monitor and follow the above steps.

    Though SAP system is itself very good and it will ask you to delete the failed request from the target before you reload the data..

    please ask if any thing not clear to u!!!

    REMOVED

    regards,

    rocks

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 10, 2007 at 08:57 PM

    Hi,

    I guess now you are clear with the actions that needs to be performed if there is a delta failure after checking previous updates.

    Now let me give some idea about reinitialization:

    Reinitialization means uploading all the data once again from the scratch

    Here are the few senario's when reinitialization is required:

    1.If a delta infopackage fails with any of the below error:

    a.Error: Update Mode 'R' not supported.

    b.Delta update for ( some data target) is invalidated

    2.delta mechanism got currupted because the same Delta IP(infopackage ) is used to run full load.(this will damages delta mechanism)

    3.Your datasource is already picking up deltas successfully every day.

    after some time,your business scenario has been changed.so that you have add some extra fields into your data source as per business requirement(also called enhancement of datasource).

    4.we use reinitilallization when all the data were not retrived in the previous initialization.

    supose user enter data in application table when setup table is filled then that data may not be extracted in the bw.

    I hope you have got some idea by now!!!!!!!!!!

    please check SDN /OSS notes /SAP library for further information

    Assign points if you find it helpful!

    Regards,

    Swapna.G

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Swapna,

      Thanks for being my mentor so far. I have been knowing many things with ur answers!!

      What could be the possible reasons for the following reasons u mentioned..?

      *Error: Update Mode 'R' not supported.

      *Delta update for ( some data target) is invalidated

      AND

      2.delta mechanism got corrupted because the same Delta IP(infopackage ) is used to run full load.(this will damages delta mechanism)

      What is it exactly meant in the above point?? yeah! I know that we could negotiate in converting Full to Delta and Delta to Full loads using an option called "Repair Full Request" option in the Schedular menu of the InfoPackage. Is it the latter one (negotiating Full after Delta load) which we are pointing in the above point??

      Plz clarify!!

      (no need to mention to assign points, I will and urs a worth)

      Thanks & Regards,

      Sapster.

  • author's profile photo
    Former Member
    Posted on Sep 11, 2007 at 06:48 PM

    Hi Sapster,

    Glad to know that !

    well, the Error: "Update Mode 'R' not supported "occurs when we were unable to do repeat delta i.e requesting the same delta load again .

    check the below one:-

    we have different Update mode types

    R : Repetition of the transfer of a data packet

    F:Transfer of all requested data

    D:Transfer of the deltas since the last request

    C:Initialization of the delta transfer

    I:Transfer of an opening balance for non-cumulative values

    Moving on..., to analyse the cause for "Delta update for ( some data target) is invalidated"

    the reason would be

    1. A request, which was already retrieved from the target system, was

    deleted from the InfoCube.

    2. A request, which was not yet retrieved from the target system, was

    compressed in the InfoCube."

    Point 2 "delta mechanism got corrupted because the same Delta IP(infopackage ) is used to run full load.(this will damages delta mechanism)"

    implies that" Full load destroys a prior initilaztion"

    Repair Full Request" possible only with ODS.The advantage is ,if we run full repair load it won't effect the existing delta mechanism

    But this is not the case with infocube.

    If a delta IP is used for loading to an infocube and if the same IP is used for full load,it will corrupts the existing delta mechanism.

    Hope now ypu got clear Idea!

    Regards,

    Swapna.G

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Swapna,

      Thanks again for ur time in answering my questions in detail.

      So, How can we rectify the error "Update Mode 'R' not supported "?? are there any measures to be taken to load the repeat delta??

      According to a Note I know that, if the DELTARNR field in the table ROOSPRMSC is empty, its understood that Source system has not yet received any data which has to be transferred to BW through Delta Queue... so as the Delta Queue will not have this data, it cannot perform the Repeat delta even though the QM status is RED in the monitor.

      So, in this case we can change the QM status to green and proceed with the next delta, as the prvious request (for which we changed the the QM to green) did not load anything at all right from the source system. And once the next delta is over, we have to change it Back to Red as the ODS requires correct statuses while activating its data.

      OR is there any other way to rectify this error?

      ALSO Could u plz eloberate ur sentences below plz?

      "Delta update for (some data target) is invalidated"

      the reason would be

      1. A request, which was already retrieved from the target system, was

      deleted from the InfoCube.

      2. A request, which was not yet retrieved from the target system, was

      compressed in the InfoCube."

      What is "retrieving data from the target system" ??

      Plz clarify!!

      Thanks in Advance!!

      Regards,

      Sapster.

  • author's profile photo
    Former Member
    Posted on Sep 12, 2007 at 06:07 PM

    Hi,

    Q1:

    The best and effective way of rectifying the error Update Mode 'R' not supported is to do "reinitialization" to recover the complete data including the last failed delta load.

    If we are sure that the last failed delta carries zero records,then we can go for INIT without data transfer to set the init flag,followed by running delta to pick any new delta if exists.

    Q2:

    You have mentined ,one way to check whether delta exists or not.However the best way to check whether any delta load exists in the source system or not is to go T- code RSA7 check the LUW's (if it is zero,no delta)for the corresponding datasource

    if there is no new data ,the delta picks zero records and will be successfull.

    And if you check the message in the monitor it says "no new delta found"

    Q:3

    "Retrieving data from the target system" means the request is datamarted i.e the request is further loaded to other targets.

    Hope you are clear now!

    Regards,

    Swapna.G

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 17, 2007 at 10:41 AM

    Hi sapster,

    Just would like to confirm have you got clear with the explanation i have provided for your Q.

    pls let me know if u need more clarification

    Regards,

    Swapna.G

    Add comment
    10|10000 characters needed characters exceeded