Recently have was tasked to troubleshoot a custom BIRT report performance issue for a client for Maximo 7.1 The problem was that the report, which normally ran fine, was now taking over 30 minutes to run and eventually never ran at all, which then in turn resulted in other reports not being able to run. [...]
Installation guide for Maximo 7.5 with WebSphere and Active Directory
These are shortened guides that is more focused on installing Maximo 7.5 with Active Directory. Installation MAM, WebSphere, SQL, Microsoft Active Directory [PDF] Installation MAM, WebSphere, DB2, Tivoli Directory Server [PDF] Installation MAM, WebSphere, Oracle, Microsoft Active Directory [PDF] Installation MAM, WebSphere, Oracle, Tivoli Directory Server [PDF] Provided by IBM Support
Advanced Date SQL Queries in Maximo
Date queries in general can be difficult to handle in SQL. Not only do you have to think about the syntax for both SQL Server and Oracle but to do “simple” queries like “get all approved work orders this week” isn’t that easy. Hopefully these will help you in creating advanced date queries to full [...]
Delete a custom Maximo application
This tip on how to delete a Maximo application from Bruno is a a lifesaver and perfect timing because I was wondering how to this exact thing the other day.
Understanding and creating KPI’s for your Start Center
This entry is part 5 of 5 in the series Maximo Start CentersThe ultimate goal of using start centers is to utilize the power of KPI’s and result sets for quick access to some important information. This information can be useful to your users for quick access to things but it can also affect performance [...]
Change or modify the Go To menu application positions
We can already add custom modules to main Go To dropdown menu, but here are two tutorials from IBM on how to re-position the menu items with detailed instructions on updating the backend database to achieve what you want. Changing Application Listings within the Go To Changing the Sub Menu Positions With the Go To According to [...]
Maximo SQL Injection
This is an interesting property that applies to Maximo 7.1 This is when users manipulate data entry fields to execute malicious SQL statements. Maximo dynamically prepares SQL statements so in almost every attribute this is not an issue. There are a few exceptions so there is a property mxe.db.sqlinjection can be enabled to further limit [...]
Maximo PM error message: “BMXAA3206E” while generating work orders
Here are two resolutions for error message “BMXAA3206E” and when PM wogen fails with refetch errors.
Create MAXDEMO database for Maximo 7
Here are the steps to create a MAXDEMO database: The automated installation selected from the Launchpad defaults to creating an ‘empty’ maximo database. There are 2 ways to create a maxdemo database during the installation of Maximo 7. 1. Launch the installation executable passing parameters. a. From a command prompt and change to the location [...]







