IBM Maximo consultant, geek, agile evangelist
Before Maximo 6 it was a common practice to implement customizations using database triggers. Although Conditional Expressions, SigOptions, Java coding and scripting are now available in Maximo 7, I still see many Maximo environments with a lot of database triggers.In a recent project I have found a Maximo system with more than 30 triggers and […]
Few times I have found a small but annoying issue on Maximo when attaching Office 2007 files. Do you know those Excel, Word, PowerPoint files with xlsx, docx, pptx extensions? Yes, those! If you are using Microsoft Internet Explorer it may happen that these files can be uploaded successfully into your DOCLINKS folder but when you try […]
Today a customer asked me to extract the full listing of failure codes, problems, causes and remedies. He wants to be able to create an Excel spreadsheet to analyze the failure codes tree in order to improve and reorganize such structure.Here is the SQL query that can extract this information from Maximo database. select f.failurecode […]
This entry is part of the Maximo Java Development series. In this post I have explained how to query and fetch MBOs from the database. In this small article I will show how to get and set the attributes of an Mbo. How to read attributes To read the attributes of an Mbo you can […]
This entry is part of the Maximo Java Development series. To query a Maximo table using Java you need to perform the following steps: Get a reference to the MboSet. Specify a where clause. Loop through the MboSet and fetch Mbos. The following example shows how to retrieve all the assets located in BEDFORD site. […]
Today I want to share with you all a very efficient technique that I use to test email notifications and communication templates in workflows. The technique is based on a very lightweight dummy SMTP server called smtp4dev that can run on any Windows system. This small application sits in the system tray and does not […]
This entry is part of the Maximo Java Development series. When you are in an Mbo class or you already have a reference to an Mbo object is it possible to retrieve the related records using Maximo object relationships as defined in the Database Configuration application.For example the ASSET object has a relationship called ACTIVEASSETMETER to the […]
This entry is part of the Maximo Java Development series. One of the biggest issues when implementing Java customizations in the Maximo Business Objects layer is to know what is the best method to override to achieve a specific goal.Here I have listed the most common usages of the the main methods in Mbo, MboSet and […]
This entry is part of the Maximo Java Development series. Debugging is a great aid in developing Maximo/TPAE customizations in Java. This powerful technique, albeit simple, is too often ignored or neglected by less experienced developers. In this tutorial I will show how to connect Eclipse to a remote Maximo server in debug mode.Here we go. Enable debug […]
This entry is part of the Java MBO performance optimization golden rules series. A not well tuned SQL query is often the biggest contributor to elapsed time taken by Maximo Business Objects (MBO) logic. A general example of this is the use of IN or NOT IN in SQL where clauses. Avoid IN or NOT IN […]