delta load fail

[Former Member]

hi everybody & kalpana,

my question is wen delta load fail we go for repeat delta okkk.

i need the navigation steps how do we use it.

is there any option like repeat in cube-manage .

i need navigation steps.

[Former Member]

thank a lot kalpana & vijay. I think tis wil help me a lot.

[Former Member]

Hi

You need to make the request status to Red in monitor screen and then delete it from ODS/Cube. Then when you open infopackage again, system will prompt you for repeat delta.

also.....

Goto RSA7->F2->Update Mode--->Delta Repetation

<b>Delta repeation is done based on type of upload you are carrying on.</b>

1. if you are loading masterdata then most of the time you will change the QM status to red and then repeat the delta for the repeat of delta. the delta is allowed only if you make the changes.

and some times you need to do the RnD if the repeat of delta is not allowed even after the qm status id made to red. here you have to change the QM status to red.

If this is not the case, the source system and therefore also the extractor, have not yet received any information regarding the last delta and you must set the request to GREEN in the monitor using a QM action.

The system then requests a delta again since the last delta request has not yet occurred for the extractor.

Afterwards, you must reset the old request that you previously set to GREEN to RED since it was incorrect and it would otherwise be requested as a data target by an ODS.

Caution: If the termianted request was a REPEAT request itself, always set this to RED so that the system tries to carry out a repeat again.

To determine whether a delta or a repeat are to be requested, the system ONLY uses the status of the monitor.

It is irrelevant whether the request is updated in a data target somewhere.

When activating requests in an ODS, the system checks delta repeat requests for completeness and the correct sequence.

Each green delta/repeat request in the monitor that came from the same DataSource/source system combination must be updated in the ODS before activation, which means that in this case, you must set them back to RED in the monitor using a QM action when using the solution described above.

If the source of the data is a DataMart, it is not just the DELTARNR field that is relevant (in the roosprmsc table in the system in which the source DataMart is, which is usually your BW system since it is a Myself extraction in this case), rather the status of the request tabstrip control is relevant as well.

Therefore, after the last delta request has terminated, go to the administration of your data source and check whether the DataMart indicator is set for the request that you wanted to update last.

If this is NOT the case, you must NOT request a repeat since the system would also retransfer the data of the last delta but one.

This means, you must NOT start a delta InfoPackage which then would request a repeat because the monitor is still RED. For information about how to correct this problem, refer to the following section.

For more information about this, see also Note 873401.

[Former Member]

Hi Venu,

If the Delta Load Fails.

Delete the failed Request from Datatarget(s).

Go to the Delta Infopackage -> Click on Schedule , It will prompt you Repeat the Request Again or Schedule the Next Delta,Click on Repeat the Request Again.

to Repeat Delta.

Hope it helps,

Thanks,

-Vijay