SXMB_MONI time out - dump

[Former Member]

Hi friends,

My transaction SXMB_MONI is getting timed out. till few days back it is working fine, but suddenly now it is getting timed out and the dump is occuring. Please provide me the solution for the same.

Thanks

Prem

[Former Member]

answered

[Former Member]

Hi,

Could you tell me ...how u got it resolved...what was the problem?

[Former Member]

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

Edited by: sandy11er on Aug 3, 2011 1:37 PM

[Former Member]

Prem,

This might help you

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e01e9400-9e81-2910-20a5-a862945a...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6a90d6aa-0b01-0010-8a83-cf0e6c70...

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

Regards,

[dharamveer_gaur2]

Hi

Look Last Reply of this thread, might help u

[SudhirT]

HI PREM,

there might be two reasons.

1. check in SXMB_ADMIN-Persistance layer,what is your current container?1 or 2.also check if meanwhile the content of table one is copied to container2.

2. check in tcode SM50, if some background job is running on table SXMSPMAST.

Thanks.