Unnecessary entries in Alert Table SALRT and SALRTRECPT

[Former Member]

Hi Friends,

Unnecessary entries are getting created in SALRT and SALRTRECPT table which is consuming a huge amount of memory on the server.(These tables Belong to Alert)

I had run report RSALERTPROC. But it didn't work.

Any workaround.

Thanks

Sunil Singh

[Former Member · Accepted solution]

Hi,

Refer - Delete Alert Rules in XI

http://help.sap.com/saphelp_nw04s/helpdata/en/56/d5b54020c6792ae10000000a155106/frameset.htm

Thanks

Swarup

[sunil_singh13 · Accepted solution]

@Swarup : Entries are so large ( 9800000 ) that it does not allows me to open Alert inbox. so Deleting through RWB is not possible.

@KK that parameter was unchecked.

Thanks

Sunil Singh

[sunil_singh13]

I have deleted those entries by running a report

[JoelTrinidade]

Which report did you run.

[kkram]

Sunil

These tables are used by alert framework and gets an entry whenever an alert is created. I am assuming you are facing this situation in XI and there are no custom programs that trigger alerts in your system. With this assumption, I suggest you to check the alert rules maintained in the runtime workbench. Look for alerts that are configured with "Suppress multiple Alerts" unchecked. These are the once that might be filling up your alert table.

KK

[sunil_singh13]

Thanks for reply.

But my problem is how do i delete these entries, I have diabled everything that can play part in creating the alert.

I can,t directly delete these entries.

Are there any standard reports available to achieve the same.

Thanks

Sunil Singh

[kkram]

Hello

I see, you tried to run RSALERTPROC already to delete old entries. Did you choose to delete only 'Confirmed' alerts. If you did so, then only alerts that have been confirmed by the user will be deleted. If you are sure to delete the alert entries irrespective of having been confirmed by the users, remove the 'Confirmed Alerts' option.

Thanks

KK