Data Recovery in delta loading

[Former Member]

Hi Everybody,

We pull GL Item data from R/3 to BW on a nightly basis using the 0FI_GL_4 extractor using delta updates with a process chain.

The process normally starts around 01:00 CST. At around 01:37, there was a problem with the database for R/3 and our extraction job was cancelled. No data was transferred to BW. No PSA entries were created in BW.

Later on, we executed the same process chain again. This time, the process chain completed successfully. However, the system said there were no new delta records. Since it is in the middle of the week and

there are only a few days until month end financial close, we should have many GL records.

We need to find out if we lost any GL data, and if so, how is the best way to recover.

Thanks in advance

For another BW guy.

[Former Member]

Maran,

This becomes very critical in production system. You need to be very careful regarding the following now:

1) you should never delete the failed delta request from CUBE, rather restart the failed delta again. If you have deleted that failed request in CUBE, then cube will have say 20 records load out of 500. So first thing you need to reverse those 20 records from cube before you do the following. (Reversing can be done by loading one flat file of those 20 records to cube with inverse key figure value).

Then Simulate the Initialization for Delta on R/3 in TR SBIW giving your time (as you said 1.00 CST)

If this helps, please credit the points. If need further help, let me know.

Regards

Pankaj

[Former Member]

Hi Gurus

Just going thro this note but it seems that nobody has given proper solution so would anybody pl suggest some good way to reload the delta?

Thanks

[Former Member]

Take a look in transaction sm58 (in source system) maybe the delta RFC transaction is there, if yes execute luw for it.

[former_member184494]

Maran,

you coudl try a pseudo Delta with specific date limits and get the number of records.

Try giving a delta date which is before the date the data load failed and then execute your delta and check.

This can be done is date is a selection field in either your info source or the RSA3.

Arun

[Former Member]

hey AruN,

how r u ?

how to do that ya can u give me in detail.

Best Regards....

Sankar Kumar

[Former Member]

Hi,

did you deleted that failed request from the datatarget ?

/manfred