Leverage Automation Script to Log a Temporary Audit Trail in Maximo

Phil Runion, Projetech
October 24, 2023

Challenges with Record Updates and User Errors

A mature Maximo system tends to have layers of configuration, customizations, integrations and moving parts. Often a single record can have multiple processes interacting with it. Recently I worked in an environment where work orders were created by an integration; once the work order hit the new work queues schedulers started updating the record. While updates were being performed, outbound integrations were triggered which led to another inbound integration updating the records. There were also escalations performing updates on some work orders. All to say users and automated tasks were getting “BMXAA4200E - Record has been updated by another user” errors regularly causing some user frustration.

Addressing 'Record Updated by Another User' Errors

When it comes to ‘record updated by another user’ errors there are as many ways to troubleshoot them as there are reasons they occur. The articles linked below describe two approaches that can be very useful. These approaches give visibility into the error at the time it occurs and these approaches should be in your toolbelt.



The Power of Automation Scripts for Audit Trails

What most approaches lack is the ability to track the whole lifecycle of a record. Traditionally to achieve a record’s lifecycle, audit tables are used to record every change. Configuring audit tables serves a purpose but it can have some significant overhead and they can be tricky to back out once they are no longer needed. In my example scenario I was looking at specific records in the first few days after they were created. I was not concerned in keeping audit data long term and I wanted something that was easily enabled and disabled.

Leveraging an automation script, I was able to meet all my goals. I was able to add it to the system without an outage and disable it easily once I was complete. Since implementing this I have returned back to the script and enabled it to help troubleshoot on multiple occasions. With a launch point on WORKORDER and WOACTIVITY save I was able to log basic information every time a save was performed.

# Setup a logger

from psdi.util.logging import MXLoggerFactory


# Pull any data that I want to log

mboParent = mbo.getOwner()

strParentName = ""

if mboParent and mboParent.getName():

   strParentName = mboParent.getName()


# Write a log entry

projetechLogger.info("Auto Script " + scriptName + " detected a WO save. Site ID:"+mbo.getString("SITEID")+" WONUM:"+mbo.getString("WONUM")+" Change By:"+mbo.getString("CHANGEBY")+" This Mbo:"+mbo.getName()+" Parent MBO:"+strParentName+" Interactive:" + str(interactive))

With the additional logging I was able to capture the data I needed. Using the data logged in conjunction with correlation IDs in the log message I was able to assemble a full picture of a work order creation life cycle quickly. Utilizing the log data, I was able to identify some process improvements that eliminated much of the user frustration. We were also able to identify an unnecessary legacy process.

How can you utilize this? This approach isn’t limited to just work orders. It could be applied to any scenario where an automation script launch point can be fired, and additional logging is required. When utilizing this approach or any approach that adds additional logging it is important to consider the performance impact. Every log entry and automation script launch point that is utilized has a resource and performance cost.

Keep your environment snappy, enable logging while troubleshooting and disable it as soon as possible.

Share this post
Phil Runion, Projetech
October 24, 2023
IBM Maximo Tips & Tricks

More Blogs

Diving into the World of Maximo Solutions: A Recap of Our Inaugural User Group

Diving into the World of Maximo Solutions: A Recap of Our Inaugural User Group

The inaugural Maximo Solutions User Group, hosted by Projetech in partnership with the MORE Community, successfully gathered over 550 participants from various industries worldwide. This event showcased diverse Maximo solutions, including mobility, cloud integration, IoT, and AI, through educational presentations. Attendees gained valuable insights into Maximo's capabilities, fostering a collaborative environment for idea exchange and community growth in enterprise asset management.
Read post
Using Maximo Work Order Hierarchies to Manage Projects

Using Maximo Work Order Hierarchies to Manage Projects

This blog delves into using Maximo for managing uncommon processes through work order hierarchies. It covers basics, such as the creation and structure of these hierarchies, and practical applications in managing projects and outages. The focus is on planning, scheduling, cost management, and the benefits of hierarchical organization, including labor and cost accumulation and enhanced reporting capabilities.
Read post
Demystifying the Differences: Understanding 'Manage with Health', 'Health and Predict – Utilities', and 'Health, Safety and Environment'

Demystifying the Differences: Understanding 'Manage with Health', 'Health and Predict – Utilities', and 'Health, Safety and Environment'

This blog clarifies the differences between three Maximo Application Suite (MAS) solutions: 'Manage with Health', 'Health and Predict – Utilities', and 'Health, Safety and Environment'. It explains that 'Manage with Health' integrates asset health tracking within the Manage application, while 'Health and Predict – Utilities', designed for energy and utilities, will be restructured in MAS v8.11. Lastly, 'Health, Safety and Environment' is an add-on focusing on safety, compliance, and environmental control within the operational environment.
Read post

Become a part of our thriving community with over 3,300 Maximo users.

MORE offers users a platform to discover valuable resources and engage in insightful discussions surrounding the intricacies of Maximo software. Connect with peers and experts to explore the depths of possibilities and enhance your expertise.