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
November 7, 2012 by Leave a Comment
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
June 28, 2012 by 1 Comment
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
April 12, 2012 by Leave a Comment
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.
Maximo SQL Injection
May 31, 2011 by Leave a Comment
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 [...]
Create MAXDEMO database for Maximo 7
November 1, 2009 by Leave a Comment
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 [...]
Best practices for Maximo performance
August 9, 2009 by 1 Comment
Here are some links to help with tuning your Maximo application. These range from database configuration to websphere.
Optimize SQL Server 2005 with Maximo 6.1 or above
July 30, 2009 by Leave a Comment
To help improve performance on SQL Server 2005 with Maximo 6.1 or above use this settings in the maximo.properties file.
Improve Maximo performance with SQL Server and Page Locking
July 8, 2009 by Leave a Comment
Turning off Page Locking in SQL Server will improve performance and prevent slow transactions or hanging. This applies to Maximo 6 and 7. Since Page Locking is already turned on unless it has been modified by the Configure utility. Therefore it is suggested that you turn it off. Open SQL Server Query Analyzer and run [...]
How to fix “Assert statement failed” error in Actuate reports for Maximo 6
March 8, 2009 by 12 Comments
If you have developed or deployed Actuate 8 reports for Maximo 6, you have undoubtedly encountered this error many times. The problem is usually due to the fact that there is a connection problem to the database and it is the user account name that is causing this error. So when you try to run [...]
