Maximo

Maximo

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

 View Only
  • 1.  Monitoring Maximo integrations for issues

    Posted Sun December 06, 2020 11:51 AM
    Edited by System Admin Wed March 22, 2023 11:54 AM

    Does anyone have any tips/tricks, monitoring service recommendations, etc. when it comes to monitoring inbound and outbound integrations to Maximo?

    Related info here: What are the ways a cron-to-web service integration can fail?


    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Monitoring Maximo integrations for issues

    Posted Sun December 06, 2020 11:51 AM


    For example, I could monitor the record count in an external table vs. the record count in a Maximo table. If there is a difference in the counts, then there is a problem.


    I could set up a scheduled job (via Oracle Scheduler) to run a query and send an email notification if FLAG = ERROR.

    select
        external_tbl_count,
        maximo_tbl_count,
        case when external_tbl_count <> maximo_tbl_count then 'ERROR' end as flag
    from
        (
        select 
            (select
                count(*)
            from
                gis.workorder
            ) as external_tbl_count,
            (select
                count(*)
            from
                maximo.workorder@my_dblink
            ) as maximo_tbl_count
        from dual
        )

    EXTERNAL_TBL_COUNT MAXIMO_TBL_COUNT FLAG
    ------------------ ---------------- -----
    8279 8439 ERROR


    In general, I don't think I'd want to trust Maximo to tell me when it is broken. I think it would be safer to use an external tool that would query Maximo for issues.




  • 3.  RE: Monitoring Maximo integrations for issues

    Posted Sun December 06, 2020 06:10 PM
    Hi,

    Does your scepticism about relying on Maximo come solely from concerns about starting the check?
    If so then you may want to look at using other ways to trigger the check e.g. an MMI call.
    External monitoring systems can often execute MMI type calls.

    An MMI call would call Maximo code.
    Using Maximo's code means that the code can rely on the Maximo framework when it is doing its work e.g. Mbosets and communications templates.

    If your organisation does not have a monitoring system then it may be worth holding off selecting one. There have been suggestions that the MAS solution will provide functionality in this area.


    ------------------------------
    Mark Robbins
    Support Lead/Technical Design Authority / IBM Champion 2017 & 2018 & 2019 & 2020
    Vetasi Limited
    Bristol
    https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/
    ------------------------------