cancel
Showing results for 
Search instead for 
Did you mean: 

delete messages in the Messages/Alert Overview takes time

Former Member
0 Kudos

Hi,

We would like to inquire why for some users when they try to delete one messages in the Messages/Alert Overview takes them 5 minutes before it finsh. Also the workstation hang during this activity. These scenario are experienced by users who have inbox messages of more than 500. But for users who have less inbox messages can excute the deletion of message faster.We even tried to do this in the server for the same user but it takes 4 minutes to delete one message in their inbox.

How we could resolve the slowness in deleting inbox messages in SAP for those users?

Thanks,

Janice

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Janice,

You may run this query first:

SELECT UserSign, count(UserSign) 'Count' from oalr

GROUP BY UserSign

Order by count(UserSign) DESC

What is the highest count?

Thanks,

Gordon

Former Member
0 Kudos

Hi Gordon,

The highest count is 32931.

Let us know what should be done next.

Thanks,

Janice

Former Member
0 Kudos

That is way too high to get deleting process normal. You may try to use non business hour to delete message with the high count first to trim the database. If it is not feasible, you may check SAP support to find the solution.

Former Member
0 Kudos

Hi Gordon,

As per confirmation from our customer, they even tried it when no users are connected to SAP except but still it takes time to delete one message. They are asking if it is ok to delete this messages via sql command.

Thanks,

Janice

Former Member
0 Kudos

In this case, it has to log a message to SAP support.

They can try through test environment only.

Former Member
0 Kudos

Hi Gordon,

Just want to clarify if they delete the messages via sql faster using their test database, can we execute this also on the live database. Is there would be no problem or other tables that may be affected when we delete the messages via SQL command.

Thanks,

Janice

Former Member
0 Kudos

No.

When you delete any data via SQL command, the database consistency may be broken. Only SAP support may do so.

Former Member
0 Kudos

Hi Janice,

If these are through alerts, you may also un-tick save history so that these messages do not accumulate in your inbox.

Thanks,

Joseph

Answers (0)