Delta Queue in Source System

[tom_darsy]

Hello

Please can you give me some links which describes the behaviour of delta queue in source system.

I am trying to analyze whether a delta queue should be cleared before a system is restarted or not and need some links to read more about the delta queue.

Also can someone tell me the database tables for delta queue?

thanks

[former_member21257]

Hi Tom,

Delta Queue is a central temporary repository for delta records (new and changed records) in the SAP source system.

The 3 tables that make up a Delta Queue are:

TRFCQOUT (Client Dependent pointer table per queue name and destination.

ARFCSSTATE: Link between TRFCQOUT and ARFCSDATA

ARFCSDATA: Compressed data for tRFC/qRFC

See info on this link for further information:

http://help.sap.com/saphelp_nw04/helpdata/en/6f/66bca6ae43744283d74f1e456ff6c0/content.htm

Rgds,

Colum

[tom_darsy]

So if it is temporary repository for delta records then is it necessary that we need to clear the delta queues if a source system is restarted. If we do not delete the delta queues what can be the effect?

Thanks

[Former Member]

Is the question

If I bounce BW do I need to clear the delta queues (for example for a summer time change in the next 2 weeks)?

Answer is no

If I bounce R3 do I need to clear the delta queues?

Answer is no

If I patch R3 do I need to clear the delta queues?

yes

If I patch BW do I need to clear the delta queues?

depends - but I would to mitigate the risk

[former_member181964]

Hi,

So if it is temporary repository for delta records then is it necessary that we need to clear the delta queues if a source system is restarted. If we do not delete the delta queues what can be the effect?

source system is restarted: generally production systems are not restart.

If you loose any data then you need to reint again if LO you need to fill setup tables and do it for others you need to run Init Infopackages directly in BW and then deltas will go to RSA7.

See about Delta Queue.

Data Flow from LBWQ/SMQ1 to RSA7 in ECC and Delta Extraction in BI

http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/business-intelligen...

Checking the Data using Extractor Checker (RSA3) in ECC Delta Repeat Delta etc...

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/80f4c455-1dc2-2c10-f187-d264838f21b5&override...;

https://wiki.sdn.sap.com/wiki/display/profile/Surendra+Reddy

Thanks

Reddy

[Former Member]

Hello Simon,

I just found your reply related to what to do with the delta queues...

What about an Oracle database maintenance on SAP BW?

Do I need to clear delta queues as well?

Thank you in advance,

BR David

[former_member209700]

Hi David,

Its not require to do delta clean up if data base maintenance .

I have found good document on  delta queue .Hope it will help you understand delta queue functionality.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40427814-376a-2c10-5589-bc1aaa669...

Thanks,

Venkat.