on 03-16-2011 5:10 AM
Hi,
I am facing wierd issue while accessing tcode SXMB_MONI in my PI system.
When I try to search any message without giving any filter criteria, it take lot of time to process the request and in the end I get timeout error as shown below
"The program "CL_XMS_PERSIST_ADM============CP" has exceeded the maximum
permitted uninterrrupted runtime and has therefore been terminated."
However when I give any filtering criteria, then SXMB_MONI shows the appropriate results.
When I perform same action while accessing message monitoring (Integration engine) from RWB I get 500 Connection Timed out error.
My PI system is SAP EHP 1 for SAP NetWeaver 7.1.
Regards,
Deepak.
Hello Deepak
What DB are you using? If Oracle, you will probably need to update the DB statistics as per instructions in the note #1020260 Delivering Oracle statistics. This note has solved many similar errors.
Regards
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You need to rebuild the indexes of tables related to SXMB_Moni
SXMSPMAST - master table
SXMSPEMAS
SXMSCLUR
and SXMSCLUP
This has solved my problem.
Please check and do the following:
.For rebuilding Please go to DB02 go to detailed analysis fill the Object Name & execute it,now click on Table Index,Select the Appropriate index,then go to detailed analysis,Now check the storage Quality of Index.Ideally it should be more than 75%.If the storage quality is quite less then go to index menu & rebuild Index.next day you will not get any warning related to this Index
- Sandy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak,
Check the SAP Notes: 1124574, 1362116
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.