cancel
Showing results for 
Search instead for 
Did you mean: 

SXMB_MONI takes a long time to populate the screen

Former Member
0 Kudos

Hello Experts,

We are experiencing an issue here where SXMB_MONI is taking a long time to populate with, for ex : " Successfully Processed " messages. Even if we choose the execution for only 1 day, it takes more than 12 mins to populate.

What we have observed is that in SM50, the DIA WP is going through a "Sequential Read" of "SXMSPMAST" table.

What we have done so far :

- Updated the DB statistics

- Re-organized the DB

- Applied Notes as per " " and also followed the instructions as suggested.

- Updated the DB parameters ( spfile ) for tuning its performance

- Checked and deleted all msgs in SMQ1 & SMQ2

- Checked for the indices

- Re- created all missing statistics for the DB

My system :

OS : Windows Server 2003 Enterprise Edition, 64 bit

DB : Oracle 10.2.0.4

SAP : PI 7.1

Kernel Release : 710, level 80

Support Packs : SAPKB71004

Could someone assist me with a possible solution as this is very critical for me now ? I am new to XI & PI. Any suggestions with instructions would be of great help.

Thanks in advance.

Edited by: The Fuhrer on Oct 23, 2009 9:24 AM

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

I resolve this issue with table statistics:

brconnect -u / -c -f stats -t SXMSPMAST2 -f collect,allsel,keep,locked

Former Member
0 Kudos

Hi Fuhrer,

Pls check T Code SM50....some archiving or deletion job is running in Background Dialogue processes on table SXMSPMAST and other data tables.....Then check that your table switch procedure is working or not...

Also do a persistence layer analysis (SXMB_MONI --> Persistence Layer).

If the fill level is over approx 200000 messages (in persistence layer analysis) then you can assume that switch/deletion procedures are not working properly. SXMB_MONI will hang if fill level goes beyond 200000..

Also kindly go through Timeouts from page no 36 in the following link:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bd5950ff-0701-0010-a5bc-86d45fd5...

Regds,

Pinangshuk.

Former Member
0 Kudos

Hi Guyz,

My issue was resolved by applying the SAP Note 1020260 .

Thanks for all your assistance.

sunilchandra007
Active Contributor
0 Kudos