on 09-23-2005 11:45 AM
Hi,
Can anybody tell me what $SYNC tcode is used for? I know that it is used for deleting the contents of the buffered tables. But under what circumstances are the contents of buffered tables deleted?
Thanks,
-Ravi
Be carefull running this in your productive BW, especcially when dataload is going on.. Why ? When generating dim's and sid's the NRIV numberranges are buffered before committing to db. So when loading data and executing $sync you take the risk of data inconsistency !
Kind regards, Patrick Rieken
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It is recommend to reset the buffers using Transaction $SYNC. If the extract structure change is not communicated synchronously to the server where delta records are being created, the records are written with the old structure until the new structure has been generated.
Regards-
Siddhu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dmitry, Thanks for the reply. Actually, one of my colleague had applied a note 875825 and since then my colleague is unable to work with Transport Connection tab in RSA1. Upon clicking Transport Connection, the system throws him out of RSA1.
We raised an OSS message for the problem and we were asked to run the TCODE $SYNC. Want to know how safe it is to execute the TCODE and will losing the contents of the buffered tables cause any problem in the future?
Thanks,
-Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You are right, it flushes all caches.
It's often used when you see that something wrong, and think that the reason is data caching.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.