Skip to Content
avatar image
Former Member

Could I put entire message into a field

Is it possible to put entire message content into a field?

My purpose is when XI receives lots of message and I want to find a specific message, I cannot search the message content in SXMB_MONI. So, my idea is to create a database table and put message in it.

Current design is create several key fields for key fields of XI message and a content field to put entire message.

Is it a good idea?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 26, 2007 at 12:36 AM

    Dennys,

    You can create a ZSXMB_MONI for this type of requirements. With this you can search your message with any value from the payload. Check this weblog on how to do this:

    /people/alessandro.guarneri/blog/2006/02/14/super-message-monitor-for-sap-xi

    Regards,

    ---Satish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 26, 2007 at 03:20 AM

    In XI, you can search the messages based on the values or data directly. You can do this in Runtime work bench.

    hence i am not sure why you are planning to store the mesages again in a database?

    null

    Add comment
    10|10000 characters needed characters exceeded

    • Dennys,

      In RWB of message monitoring , you can find show additional search criteria, using that u can search.

      One more thing if you want to search based on the payload values and all, then I'll suggest u TREX search engine is the best option. You can find the message based on payload content too.

      Best regards,

      raj.

  • avatar image
    Former Member
    Jun 26, 2007 at 04:03 AM

    Hi Dennys,

    Ask your basis team to install TREX. You dont need to save the contents in that case to database.

    Installation and configuration of TREX takes around half a day. Search in SAP MarketPlace for TREX installation guide.

    Regards,

    Sumit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi dennys,

      <i> asked our basis team, they said we don't use TREX</i>

      Its okay but why cant you ask them to install TREX. I dont think TREX as a software costs money.

      Secondly why do you want to insert the payload in a field and store in db. The payload is already stored in DB , so why replicate.

      You can surely pass the whole XML in a field. XSLT Mapping will help you .

      Regards,

      sumit