problem with 0FI_GL_4 Delta extractor

[Former Member]

hi everyone,

I have encountered a problem when using 0FI_GL_4 delta extractor.

As I had changed the settings in table BWOM_SETTINGS according to note 485958, the datasource should be able to extract FI lines up to the day I run the extractor.

Here is the problem:

At 1st March, 01:18 am, I ran the extractor and get some records.

I found that FI lines with createdon date later than 29th Feb 16:00 were not extracted to BW. According to that note, shouldn't I get all FI lines created on 29th Feb?

After 30 minutes, I ran the extractor again. These records came to BW this time. That's strange.

My settings in table BWOM_SETTINGS:

EXTLOG

ORGSYSONLY

NOTSSELECT

OBJSELSIZE X

FLAG_AL

OBJCURTYPE 10

BWFILOWLIM 19910101

BWFISAFETY 1

BUFFERREF

OBJSELSICO X

BWFITIMBOR 020000

BWFIOVERLA X

DELTIMEST 60

PRICECOMP X

Thanks for your help!

[Former Member]

Hi,

I agree with Murali as your are extracting data before 02.00 AM the data till yesterday will be extracted.

Check the below link for more information,

[http://help.sap.com/saphelp_bw33/helpdata/en/af/16533bbb15b762e10000000a114084/content.htm]

but as per your another post the second extraction happened before 0200, just cross check one thing that the time noted was not from local machine but was from app server.

Rgards,

Durgesh.

[Former Member]

Thanks for your reply, Murali.

What you said is completely coincident with note 485958. According to your reply in the linked page, when BWFIOVERLA=X and I extract before 2:00am, I should get all data up to yesterday. But part of the "29th Feb created" data was not fetched when I ran the extractor at 1:18am 1st March. The fact comflicts with theory.

Ferther more, my second run is at 1:48am, still earlier than 2:00am. It fetched all data.

Thanks again Murali.

[Former Member]

Hi,

If you implement note 485958, you would get the most recent data only when the loads are run after 2 AM (BWFITIMBOR parameter would be set to 2 in the table). The same happened in your case. When you ran the loads after 2 AM, you got all the data for 29th.

If you want to load multiple times in a day and want to get the most recent data, you would need to implement 'Minute-based extraction'. Please check note 991429 for the procedure. Also see my earlier post.

Best Regards,

Murali.