cancel
Showing results for 
Search instead for 
Did you mean: 

2LIS_03_BF lost some of the documents

Former Member
0 Kudos

Greetings to all!

Extractor 2LIS_03_BF a result of unforeseen shut down the server lost about 1000 documents, they do not got to the BW, noticed after the delta has worked many days later. Is there an opportunity to push the missing documents via this extractor?

What happens if sbiw repeat Inventory Management - Perform Setup this help?

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

As you have mentioned these are only 1000 odd documents and you know which are the ones, perform below steps.

1. Empty the setup table for Inventory.

2. For the documents missed, load the setup table again. If you have document numbers specifically, you would have to do this load in batches. If you give all the 1000 documents and execute it, it would go to dump. So, do the load by giving about 50 documents at a time.

If its the date range that you know, then go for date range.

3. Carry out Repair full load. You would find this option in the menu bar of infopackage. This data comes from setup table. As all the data in setup table is needed, dont give any selection conditions.

Note: There is one point to be noted with date range as an option for filling setup table. There may be certain documents for this date range which would have already got loaded in BI. So If you carry out repair full dataload to DSO, no issues. But if the flow involves Infocube, then this may result in duplicating of data and doubling of values in infocube for those documents which were already loaded.

Former Member
0 Kudos

The deletion of the last query in BW doesn't helps - delta loads only new data from last load and doesn't understand that data dropped in BW

How could i say to extractor 2LIS_03_BF take the delta from yesterday or from few days ago?

Edited by: Ilya Mukovoz on Dec 23, 2010 1:34 PM

Former Member
0 Kudos

Hi,

Please note that deltas would only come from RSA7 for LO datasources. These delta records are captured in RSA7/ SMQ1(depending on delta mode) as and when there are any transactional changes in R/3 system, therefore you cannot control them to get any past dated records. Let them continue to come as they are.

How could i say to extractor 2LIS_03_BF take the delta from yesterday or from few days ago?

You cannot do this for the reason mentioned above.

To load the past data missed, as I have mentioned in my last post, you need to carry out Repair full load. Repair full is not delta load, therefore comes from setup table. So, whatever is in setup table would come in BI when you carry out Repair full load.

Just load the setup table with missed documents and carry out Repair full load.

Former Member
0 Kudos

You can make that failed data red and do repeat delta so that it will bring last successful delta along with missed delta.

But you have to check in update rule that all the key figures are in overwrite mode.

Former Member
0 Kudos

You can made that failed data red and do repeat delta so that it will bring last successful delta along with missed delta.

But you have to check in update rule that all the key figures are in overwrite mode.

Former Member
0 Kudos

it's not possible - the end of the year!

Former Member
0 Kudos

Hi,

You can get the lost data using repair full request but make sure on which date your server was down during the delta load.

create infopackage specify the selection conditions and execute it.

Hope this helps.

Prasad

Former Member
0 Kudos

Thank you.

It's an idea!

Former Member
0 Kudos

Points please

Thanks

Prasad