====================================================================== Readme file for: IBM® Maximo® for Utilities version 6 Release 3 Fix Pack 2 and IBM Maximo Spatial Asset Management Version 6 Release 3 Fix Pack 2 IBM Corporation 27 June 2008 © Copyright International Business Machines Corporation 2008. All rights reserved. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. ======================================================Contents - About this fix pack - Fixed issues - Installation information - Contacting IBM Support - Notices and trademarks ======================================================About this fix pack IBM Maximo for Utilities 6.3.2 and IBM Maximo Spatial Asset Management 6.3.2 is supported on a Maximo 6.2.2 base platform. IBM Maximo for Utilities 6.3.2 and IBM Maximo Spatial Asset Management 6.3.2 support SQL Server, DB2, and Oracle. NOTE: SQL Server Customers must download the Reports zip file to run reports on SQL Server. ======================================================Fixed issues The following issues are fixed in this fix pack. 08-13003 ASSIGNMENT MGR Too many hours in the Crew List in Assignment Manager T&D if the Assignment option is set to STATIC. 08-15621 ASSIGNMENT MGR Problem occurs when the work is spread out over several days. 08-16224 ASSIGNMENT MGR Date field is not calculated correctly from the calendar. 07-25799 CUE ESTIMATE Perform Acceptance process takes too long. 08-13220 CUE ESTIMATE Work order costs do not roll up appropriately. 08-14651 CUE ESTIMATE Receive error: "The contract must be a valid, open agreement contract with bid units referenced on the contract lines" on new contract. 08-14781 CUE ESTIMATE Parent Work Order from CUE shows up multiple times in Assignment Manager T&D. 08-15087 CUE ESTIMATE During Perform Acceptance process, the wrong error message is displayed when inactive CUs exist on an estimate. 08-16087 CUE ESTIMATE The SITEID is set to the default insert site and not the SITEID of the owning estimate request/version during the Perform Estimation process. 07-29195 CUE LIBRARY Duplicate CU action does not copy service details. 08-12947 CUE LIBRARY Relationship problems in CU Estimate. 08-17402 Install Maximo Utilities (T&D) R6.3.1 installation fails with an ORA-01861 error: literal does not match format string". 08-13837 WORK ORDER TRACKING Scheduled Start and Scheduled Finish dates for a task do not get cleared when Labor is unassigned in Assignment Manager T&D. ======================================================Installation information Overview of update process: To apply the fix pack, complete these tasks: 1 Check that pre-installation requirements are met. 2 Install the fix pack. 3 Run the database scripts. 4 Rebuild the EAR files. 5 Restart the application server and deploy the EAR files. 6 Optional: Install the reports. Note: For SQL Server users, step 6 is required. ------------------------------ Pre-installation requirements Before you install this fix pack, check the following requirements: - You have system administrator rights and privileges. - IBM Maximo Asset Management 6.2.2 is installed - IBM Maximo for Utilities 6.3 or IBM Maximo Spatial Asset Management 6.3 is installed. - ArcGIS Server 9.2 Service Pack 5 is installed if you use GIS-enhanced applications. - ArcSDE 9.2 Service Pack 5 is installed if you use GIS-enhanced applications. - All users are logged off Maximo. - All Maximo application servers and services are stopped. - No other programs are open. - The entire directory where Maximo is installed is backed up. - The Maximo database is backed up. - The Maximo help system is backed up. The help system is located in \\applications\maximohelp\helpweb\webmodule\en. ------------------------ Installing the fix pack To install the fix pack, run the update.exe file from the maximoInstallDir\PowerUpdateClientUtilities63 directory of your administrative workstation, where maximoInstallDir is the directory in which Maximo Asset Management is installed. Follow the steps in the update program to download and install the required files. If you cannot run the update.exe file because of a network or security policy, download and run the update file directly from either the IBM Maximo Industry Solution for Utilities product support page: http://www-306.ibm.com/software/sysmgmt/products/ support/IBMMaximoforUtilities.html or the IBM Maximo spatial Asset Management product support page: http://www-306.ibm.com/software/sysmgmt/products/ support/IBMMaximoSpatialAssetManagement.html ----------------------------- Running the database scripts The database scripts create and update some of the database tables. If you run Maximo on Oracle® Database 10g, you must have the create job privilege before you run the database scripts. To grant the create job privilege, the administrator must log on to SQL *Plus under the system account and run the following command: grant create job to dbUserName; where dbUserName is the user to be granted the privilege. To run the database scripts: 1. Ensure that the database is backed up. 2. Open a command prompt, go to the maximoInstallDir\tools\maximo folder, and run the updatedb.bat command. Merging faces-config.xml files using the XML tool ------------------------------------------------- To use the generated GIS faces-config.xml file in the GIS-enhanced applications, use the xml tool to merge the generated GIS faces-config.xml file with the Maximo default faces-config.xml file. The xml tool updates, adds, and deletes nodes in the Maximo faces-config.xml file based on nodes in the generated GIS faces-config.xml file. To merge the two faces-config.xml files: 1. Before you run the xml tool, back up your Maximo faces-config.xml file. 2. Run the following script: [maximo]\tools\maximo\tnd-facesxmltransform.bat Usage : -s -o where [maximo] is where Maximo is installed on your system. Default Parameter Values: -o : [maximo]\tools\maximo\output-faces-config.xml 3. Replace the Maximo faces-config.xml with the newly generated file in: [maximo]\applications\maximo\maximouiweb\webmodule\WEB-INF Modifying the Maximo properties file --------------------------------- Before you start Utilities or Spatial Asset Management, set GIS properties in the maximo.properties file. To set GIS properties in the maximo.properties file: 1. In Windows Explorer, navigate to: \applications\maximo\properties. 2. Open the maximo.properties file with a text editor. 3. At the end of the maximo.properties file, add the following properties: //----------------------------------------------------------------------------------------- // GIS Related properties // //----------------------------------------------------------------------------------------- //name of your ArcGIS server mxe.spatial.arcgis.server= // name of your ArcGIS domain mxe.spatial.arcgis.domain= //gisserver username mxe.spatial.arcgis.username= // password for gisserver mxe.spatial.arcgis.password= // your Map Service name as set in ArcGIS Server Manager mxe.spatial.arcgis.mapobject= // name of your server where ArcSDE is running mxe.spatial.arcsde.server= // database user account for sde mxe.spatial.arcsde.username= //database password for database user account mxe.spatial.arcsde.password= // the service_name for ArcSDE in windows or port number, port number must be used when ArcSDE is remote to the ArcGIS Server mxe.spatial.arcsde.instance= //name of database, set as default for oracle as it does not apply mxe.spatial.arcsde.database= // sde version to connect mxe.spatial.arcsde.version= 4. Save and close the maximo.properties file. Modifying the web.xml file ------------------------- In order to use the GIS-enhanced applications, add spatial code to the web.xml file. To add code to the web.xml file: 1. Open the web-spatial.xml file located in the MAXIMO\applications\maximo\maximouiweb\webmodule\WEB-INF folder. 2. To copy the spatial code into the web.xml file, place each spatial tag after its corresponding tag in the web.xml file. Spatial xml code is enclosed by the following comments: and Example: Place all Spatial tags after the tags defined in the web.xml file. 3. If there is no corresponding tag in the web.xml file, follow the dtd file structure defined in the beginning of the web.xml file to find the correct place for the spatial tags. Rebuilding the EAR files ------------------------- Ensure that the maximo.properties file is up-to-date, then rebuild the maximo.ear file and the maximohelp.ear file. For more information about building EAR files, see the IBM Maximo Installation Guide. Restarting the application server and deploying the EAR files -------------------------------------------------------------- Restart the Maximo application server and redeploy your EAR files to apply the fix pack changes. For information about deploying EAR files, see the IBM Maximo Installation Guide. Installing reports ----------------------- If you are using SQL Server and want to run reports, you must download and install the reports in this fix pack. To install reports: 1. Download the compressed reports file from the support site. 2. Extract the file contents to a temporary location, such as C:\temp\utilities632reports. 3. Extract the file contents from the compressed file that matches your database type in the temporary location. 4. Take your Actuate encyclopedia offline. 5. Run the following Actuate command on the appropriate folder: acimport -all -force -replace -username -password -input For example, if you use Oracle specify the path C:\temp\utilities632reports\oracle_export\export. 6. If your Maximo and Actuate iServers are running, shut down both of them. 7. Restart the Maximo server. 8. Restart the Actuate iServer. Enabling reports --------------------- To enable reports: 1. Login to Maximo Asset Management as someone with Admin Privileges. 2. Select the Report Administration application. 3. On the List tab, click Recreate all XML. 4. Wait until the message "The request page XML has been generated" displays, then click Close to close the message. Reports can now run properly. ====================================================== Contacting IBM Support IBM Software Support provides assistance with product defects. Before contacting IBM Software Support, your company must have an active IBM software maintenance contract, and you must be authorized to submit problems to IBM. For information about the types of maintenance contracts available, see "Enhanced Support," in the Software Support Handbook at http://techsupport.services.ibm.com/guides/services.html. To contact IBM Software Support with a problem: 1. Define the problem, gather background information, and determine the severity of the problem. For help, see "Contacting IBM" in the Software Support Handbook at http://techsupport.services.ibm.com/guides/beforecontacting.html. 2. Gather diagnostic information. 3. Submit your problem to IBM Software Support in one of the following ways: - Online: Report the problem on the IBM Software Support site: http://www.ibm.com/software/support/probsub.html. - By telephone: For the telephone number to call in your country, go to the Contacts page of the Software Support Handbook: http://techsupport.services.ibm.com/guides/contacts.html. If the problem you submit is for a software defect or for missing or inaccurate documentation, IBM Support creates an Authorized Program Analysis Report (APAR). The APAR describes the problem in detail. Whenever possible, IBM Support provides a workaround that you can implement until the APAR is resolved and a fix is delivered. IBM publishes resolved APARs on the IBM Support web site daily, so that other users who experience the same problem can benefit from the same resolution. ====================================================================== Notices and trademarks Third-Party Technology: Certain IBM Maximo products contain technology provided under license from third parties, as noted below. All Products: - Portions © 1996-2003 Visual Mining, Inc. Visual Mining™ NetCharts Server provided by Visual Mining, Inc. IBM Maximo: - Portions © 1995-2004 Actuate Corporation. - Portions © 2005 BEA Systems, Inc. BEA WebLogic Server® provided by BEA Systems, Inc. - Portions © 1996-2005, i-net software GmbH. J-Integra for COM® v2.4. © 2004 Intrinsyc Software International, Inc. - Sentry Spelling-Checker Engine © 2000 Wintertree Software, Inc. IBM Maximo Discovery: - MSDE Copyright © Microsoft® Corporation. - Portions © 1998-2005 Centennial Software Limited. IBM Maximo Asset Navigator: - Portions © 1993-2002 Snowbound™ Software Corporation. RasterMaster™ Raster imaging technology provided by Snowbound Software Corporation. IBM Maximo Mobile: - Portions © 2005 DataMirror, Inc. - Portions © 2000-2005 Zaval Creative Engineering Group. IBM Maximo Mobile SE: - Portions © 1996-2005 Syclo, LLC. Open Source: IBM Maximo contains computer software obtained from the public domain, known as "Open Source" ownership of which is attributed as follows: Portions © 2002, Steve Souza (admin@jamonapi.com). Portions © 2000-2004, Jason Hunter & Brett McLaughlin. Portions © 2004-2005, The Apache Software Foundation (http://www.apache.org/). This information was developed for products and services offered in the U.S.A. IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service. IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not grant you any license to these patents. You can send license inquiries, in writing, to: IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A. For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to: IBM World Trade Asia Corporation Licensing 2-31 Roppongi 3-chome, Minato-ku Tokyo 106-0032, Japan The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you. This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice. Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk. IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you. Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact: IBM Corporation 2Z4A/101 11400 Burnet Road Austin, TX 78758 U.S.A. Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee. The licensed program described in this document and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement or any equivalent agreement between us. Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products. All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only. IBM and IBM Corporation are registered trademarks of the International Business Machines Corporation in the United States, other countries, or both. Other company, product, and service names may be trademarks or service marks of others.