Skip to Content
0
Jan 11, 2010 at 03:42 PM

Clean up table ARFCRSTATE - lots of "CONFIRMD" entries

3186 Views

Hi all,

Our database size is growing significantly even though we have setup archiving/deletion. I found that our biggest table (from ST04) is table ARFCRSTATE, which contains qRFC entries, all of them with status "CONFIRMD". After browsing through this forum and notes it seems the entries should be deleted automatically from this table (profile parameter abap/arfcrstate_col_delete = X), but they are not. Currently we have over 60 000 000 entries in this table and growing all the time.

I have tried running report RSTRFCEU, but this triggers a dump saying: TSV_TNEW_BLOCKS_NO_ROLL_MEMORY, indicating that there is not enough memory for the program to read all entries in this table before it deletes them. From looking at the program code there seems to be no commit work executed until the entire loop is finished.

Do you have any suggestion how to reduce the size of this table consistently?

Our system is PI 7.0 patch SP14, MSSQL.

If this is the wrong forum for this, please direct me to where I should post this...

Thanks a lot!

Br,

Kenneth