Skip to Content
avatar image
Former Member

too long to open message in sxi_monitor

Hi Experts,

when I try to open the message in sxmb_moni or sxi_monitor,  it is taking too long to open the message.  most of the time it is getting timed out.  then I try to open again and after so much time it is opening.

sxmspmast table contains 4.799.197 entries. 

what can be the cause for this and how can I resolve it ?

Thanks for your help in advance.

Regards,

Santhi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 28, 2015 at 06:54 AM

    Hi Santhi,

    Which version of PI are you on ? Also please post the error message you are getting .

    Thanks,

    Harish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Iñaki Vila

      HI Inaki,

      No, they don't restart system every day.  it is a production system and I am in support team as well.

      So whenever message fails at night time,  it is taking 15 to 20 min time to open the message after I switch on the system.  even in the day time,  when I open 1st message in the morning it takes that long and later it will be ok.

      Regards,

      Santhi

  • Oct 28, 2015 at 07:00 AM

    Hi Santhi,

    The issue seems to be that you have not set the archive/deletion process and when the DB is more full more time takes the transaction. Also, the problem could be that your PI have not enough memory. Also you can check these threads:

    SXI_MONITOR is slow | SCN

    Regards

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Inaki,

      Thanks for the reply.  I have checked with basis they said DB memory is ok.  and the deletion job is running.  the retention period is 14 days.  so according to that the deletion job is running.

      Regards,

      Santhi

  • Oct 28, 2015 at 07:00 AM

    Hi Santhi,

    There is a workaround for this. In sxi_monitor, double-click the message. It will then ask you to display the payload (select no). Then go to the payload section, right-click on it and select download. That way, it will not open inside sxi_monitor.

    Regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mark,

      I understand what you said.  but it is taking too long to open the xml message not the payload.

      once the xml message opened,  every thing I can access easily.

      Regards,

      Santhi

  • Oct 28, 2015 at 07:17 AM

    Hello Santhi,

    As Inaki suggested its memory issue.do an archiving.

    Add comment
    10|10000 characters needed characters exceeded