LUWs in delta queue not correct for FI data source(Eg. 0FI_GL_12)

[Former Member]

Hi Experts:
we have one problem regarding the LUWs in Delta Queue for some data sources, regularly, delta queue only could retain the LUWs for
last delta and the delta to be loaded, however, we find for some data source in delta queue, the number of LUWs is nearly 1 Million,
Anybody who could help to explain this and also please advise how to clean the old LUWs in delta queue? Thanks in advance!

BR
Terry Zhang

[esjewett]

Since this is a question about a business content extractor, it belongs in the Business Content and Extractors space and not the Data Warehousing space. I've moved the thread, but please use this space for these types of questions in the future.

Regards,

Ethan

(moderator)

[former_member21257]

Hi Terry,

I think that SAP Note 380078, qustions 1-4 will help you here.

There may be an inconsistency in the delta queue which you can check for with the program detailed in SAP Note 583086 - Diagnostic program for BW DeltaQueue

If the LUWs are very old and you are happy that the data is in the BW system then you could do a selective deletion.
Caution: delete only those tRFCs that are older than the second last delta.
For this, please follow these notes.

760113    Delete unprocessed LUWs in the qRFC
779664    Consistency check of qRFC queues with deletion
763255    Deleting a TID or a queue

Rgds

Colum