Skip to Content
avatar image
Former Member

Unnecessary entries in Alert Table SALRT and SALRTRECPT

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 03:17 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      @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

  • Sep 01, 2008 at 08:35 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Mar 19, 2009 at 04:00 AM

    I have deleted those entries by running a report

    Add comment
    10|10000 characters needed characters exceeded