Blog
Remove legacy (Actuate) reports from Maximo
If you are upgrading from Maximo 5 or 6, to Maximo 7.1 or 7.5, you may want to remove legacy (Actuate) Maximo 5 or 6 reports. The following SQL script deletes those obsolete report entries from the database. delete from reportlookupwhere reportlookup.reportnum in(select reportnum from reportwhere runtype in ('ESPREADSHEET', 'QUERY', 'REPORT'))or reportlookup.reportnum is nullor reportlookup.reportname is null;delete from reportlabelwhere reportname like '%.rox'or reportname like '%.dox'or reportname like '%.vts'or reportname like '%.vtf';delete from reportwhere reportname like '%.rox'or reportname like '%.dox'or reportname like '%.vts'or reportname like '%.vtf'; Reference: Maximo Wiki - Deleting reports
September 7, 2014
MxLoader 4.1 has been released !
Hi all, I have just released MxLoader version 4.1 on developerWorks. These are the new features: Rewritten XML/TABLE conversion algorithm to support unlimited levels of nested objects Many MxSheet templates added with object’s primary key fields underlined in header row Object count limit now works also for sync action For sync operation it is possible to specify the action (Add, Delete, Update, Change, Replace, AddChange) New button to quickly create custom MxLoader Object Structures MxLoader.xlsm file size reduced from 4 MB to 0.5 MB Comments support in MxSheet templates Removed text formatting for text fields because it was messing Excel formula automatic calculation Performance optimization in attribute lookup algorithm (GetAttrType) Feel free to download it and it everyday. For questions and support please use this forum.
September 4, 2014
Invoke an Action when a button is pressed
In this article I explain how to attach/associate an action to a push button in an application. Create the Action you have to call if not already done (Go To - System Configuration - Platform Configuration - Actions). Open your application with the Application Designer and create a Signature Option with the same name of the Action you want to call (Actions - Add/Modify Signature Options - New Row). Expand the ‘Advanced Signature Options’ section and set ‘This is an action that must be invoked by user in the UI’.
June 20, 2014
Attachments (DOCLINKS) Configuration
This procedure describes how to set up attached documents in Maximo 7.1 and above with IBM WebSphere Application Server. In this procedure I will use [IHSDIR] and [DOCLINKSDIR] tags to identify IBM HTTP Server and attachments home directory respectively. Replace those tags according to your environment. Here are the default values. Windows [IHSDIR] - C:\Program Files\IBM\HTTPServer [DOCLINKSDIR] - C:\doclinks UNIX [IHSDIR] - /home/IBMHTTPD [DOCLINKSDIR] - /home/doclinks Attachment repository First of all you have to create the create the [DOCLINKSDIR] directory to store your attachments. For example: C:\doclinks for Windows or /home/doclinks for UNIX.
June 10, 2014
Maximo applets and Java security
Java 6 and 7 have introduced new security features that may create some problems in Maximo/SCCD/TPAE applications that make use of Java applets. Some examples of such applications are Configuration Items, Workflow Designer and Scheduler. First of all Start Menu > Java> Configure Java > Security > Add the server host to the trusted sites This should be enough to fix Java related issues. Maximo Scheduler may require an additional configuration to solve the ilogViewerApplet.initProjectDataModel error.
June 9, 2014
Automatically rotate and clean HTTP Server log files
By default IBM HTTP Server log files always grow. This may be a problem especially on production servers where there is a large amount of HTTP requests that can quickly generate a very big access.log file. This file cannot be deleted without stopping the HTTP Server and can be practically impossible to open with a text editor. A quick solution for this is to use the rotatelogs utility located in [HTTPHOME]/bin directory.
May 31, 2014
Mount shared DOCLINKS folder on Windows
A typical configuration step when building a Maximo cluster on Windows systems is to mount a shared filesystem on all the physical systems that belongs to the cluster. This allows to store attachments in a single place in order to be able to access them from all the servers that builds up the cluster. It is also important to adopt an approach that automatically remounts the network share in case of system restarts.
May 23, 2014
Securing Maximo with SSL/HTTPS
Maximo installation configures by default HTTP unencrypted communication. This basic configuration may represent a security exposure especially when the server is reachable from the public internet. This article describes all the steps needed to enable HTTPS (SSL) communications for Maximo. It comprises the following main steps. Creation of a self-signed certificate IBM HTTP Server configuration WebSphere configuration Adjust DocLinks settings Create a self-signed certificate Run IBM Key Management utility - Start > Programs > IBM HTTP Server > Start Key Management Utility. Click Create a new key database file button.
May 22, 2014
MxLoader has been released!
I am proud to announce the release of MxLoader on developerWorks. This is a great tool I have developed to help me in my day-to-day job as a Maximo specialist. MxLoader is a Microsoft Excel spreadsheet that allows to quickly and easily query and load data into IBM Maximo, IBM SmartCloud Control Desk (SCCD) and other TPAE based applications. It brings together the power of the Maximo Integration Framework and the flexibility of Excel allowing to quickly manipulate and import data into any Maximo database.
May 16, 2014
Educational videos
Yes these are very busy days for me and probably for you all. But don’t worry I will start publishing new articles soon. In the meanwhile you can enjoy watching those two videos from my fellow colleague Andreas. Jobplan demo (3:03 min) Offerings/pricebook demo (2:32 min)
May 15, 2014