1st step in case of Delta Failure!!

[Former Member]

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.

[Former Member]

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

[Former Member]

Hello Swapna,

Thanks for your concern.

Extremely sorry for not acknowledging your replies. I was not in the city for 1 week and was held up with some personal work.

Reg. Q1 in your reply, the better option to check if the delta carries 0 Records is to check the Delta Queue in RSA7 is it??

AND Could u plz give me brief steps along with Tcodes to delete certain entries like using the option "Init options..." in the IP schedular menu, then delete our delta queue data in RSA 7 etc..

In Q2, What is that u r trying to say through the following sentence..

"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""

Plz elaborate??

and also in ur previous reply u wrote: the reasons for the following error would be..

"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."

Here,

1a. is the target system here is DSO?? and are we trying to retrieve data from DSO till Infocube and the delta fails becos the previously loaded delta request in the Infocude has been deleted.... is that soo??

2a. If the tartget system is DSO.. how can a request be compressed in the Infocube before the request could be reached from DSO?? (I hope I am not confusing you)

Plz clarify!!

And thanks again for ur time!! and sorry for the delay!

Regards,

Sapster!!

[Former Member]

Hello Swapna ji,

If you have free time. plz try to clarify!!

Regards.

Sapster.

[Former Member]

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

[Former Member]

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

[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.

[Former Member]

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

[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.

[former_member441329]

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

[former_member228339]

Hi..

Double click in the IP

Scheduler menu

Click in Initialization options for source system

[former_member188975]

Checking the Init settings and trying to Reinit is not the first step to deal with failed delta loads!

[Former Member]

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..