Skip to Content
avatar image
Former Member

/SAPAPO/AM_ALERT table has over 2 million entries

Hi

We are currently scheduling a deletion program SAPAPO/AMON_REORG on a regular basis included in our process chain ABAP process type for database alert deletion. The next step after this is execution of Macros. The Variant for this program has type SD (APO Demand and Supply) and the Day interval is empty.

Currently our process chain has failed with a short dump, which relates to "No Space to increase Internal table" , BASIS intervened and they say that the Memory parameters are fine and set up according to Standards.

However when I saw the SAPAPO/AM_ALERT database table it has over 2million entries.

Question 1: I would like to find if the database alerts are actually getting deleted ? is there a way to confirm this

Question 2 : How do I avoid this Memory relevant short dump, are there any settings needed for config or Indexing on the relevant Tables ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 22, 2011 at 03:23 AM

    AAL,

    If you have 2M records, something is probably not right. You are either generating a huge number of alerts every day, or your reorg job is not agressive enough. Or, as you suspect, the reorg step is not completing.

    Question 1: I would like to find if the database alerts are actually getting deleted ? is there a way to confirm this?

    Sure. SE16 > /SAPAPO/AM_ALERT > click Number of Entries. Execute. Write down the results. Run the PC. Repeat the SE16 task. Compare the results.

    For an immediate solution, I would manually start deleting the oldest records. The interactive transaction code is the same as the program: /SAPAPO/AMON_REORG. You can either run your variant (this will show you the effectivity of your variant as well) or just manually start selecting all records before a certain date.

    Best Regards,

    DB49

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 23, 2011 at 06:45 AM

    Hi

    Thanks for the response. There is an Option of Simulate Check Box , Is it required to be checked or unchecked.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      AAl,

      . Is it good option to delete with /SAPAPO/AMODAL_DELETE ?

      I don't know. The version I am currently working on is SCM 5.0. . /SAPAPO/AMODAL_DELETE did not appear until 7.0.

      I would try it in a test environment. If .you run /SAPAPO/AMODAL_DELETE and you still get a dump, make sure you have reviewed the contents of https://service.sap.com/sap/support/notes/1400234 before giving up.

      Best Regards,

      DB49