Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Message Tracking - Message ID

    Posted 11/06/22 02:32 AM

    Hi all,

    Does anyone know how 'Message ID' field on 'Message Tracking' application auto-generates the numbers?
    MAXINTMSGTRK.MEAMSGID attribute do not have a sequence associated with it.


    Regards,
    KK

    ------------------------------
    KKunnuthara
    ------------------------------



    #AssetandFacilitiesManagement
    #Maximo
    #MaximoIntegrationandScripting


  • 2.  RE: Message Tracking - Message ID

    Posted 11/07/22 11:57 AM
    The table has a trigger on it for before insert:  MAXINTMSGTRK_T

    CREATE OR REPLACE TRIGGER MAXIMO.MAXINTMSGTRK_T
    NO CASCADE BEFORE INSERT
    ON MAXIMO.MAXINTMSGTRK
    REFERENCING
    NEW AS N
    FOR EACH ROW
    SET N.ROWSTAMP = NEXTVAL FOR MAXSEQ;

    ------------------------------
    Brandie White
    ------------------------------



  • 3.  RE: Message Tracking - Message ID

    Posted 11/07/22 11:57 AM
    The Sequence I have is: 

    CREATE OR REPLACE SEQUENCE MAXIMO.MAXINTMSGTRKSEQ
    AS BIGINT
    NO CACHE
    ORDER;





    ------------------------------
    Brandie White
    ------------------------------



  • 4.  RE: Message Tracking - Message ID

    Posted 11/13/22 06:48 PM
    Edited by System Admin 08/22/23 04:32 PM


    Thanks @Brandie White

    MAXINTMSGTRKSEQ is linked to MAXINTMSGTRKID attribute.
    What I am looking for is the sequence that is being used for MEAMSGID attribute.

    ​
    The issue that I am having is that for some instances, the MEAMSGID is not matching the messageID in the XML.
    See the screenshot below.









    @Steven Shull  @Jason Uppenborn  @Alex Walter any thoughts?



    Regards,


    ​

    ------------------------------
    KKunnuthara
    ------------------------------

    Original Message


  • 5.  RE: Message Tracking - Message ID

    Posted 01/16/23 09:38 PM
    Bumping it up. 
    We are also looking for ways to capture unique transaction ids for each message across source/middleware/target and wanted to use the out of the box field for the same. Has anyone done this. 



    ------------------------------
    RJ
    ------------------------------

    Original Message


  • 6.  RE: Message Tracking - Message ID

    Posted 01/17/23 08:39 AM
    The message ID we store comes from the JMS provider which gives us the unique identifier it's using to track it. If you want your own identifier you can extract something from the XML using XPath (https://www.ibm.com/support/pages/xpath-syntax-message-tracking). On a lot of tables that are commonly integrated we have a SENDERSYSID & EXTERNALREFID attribute for customers to track these references as well. 

    ------------------------------
    Steven Shull
    ------------------------------

    Original Message


  • 7.  RE: Message Tracking - Message ID

    Posted 02/17/23 12:56 PM

    Hi Steven,

    has the above setting provided for JSON messages too going through a publish channel ? I know it was working for the xml message, however seems its not working for JSON messages. 

    Is there any other path we have to provide in the message tracking setting in PC?



    ------------------------------
    Subhransu Sekhar Sahoo
    ------------------------------

    Original Message