IBM TRIRIGA Application Platform, Version 3.5.3.2

Readme file for 3.5.3.2 IBM TRIRIGA Application Platform

This fix pack updates the IBM® TRIRIGA® Application Platform product.

Copyright© International Business Machines Corporation 2018. All rights reserved. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

Prerequisites and supported products

To install this fix pack, you must have TRIRIGA Application Platform 3.5.3 installed.

Information resources

IBM Knowledge Center

http://www.ibm.com/support/knowledgecenter/SSHEB3_3.5.3/com.ibm.tap.doc/product_landing.html

Access the Knowledge Center to view the product documentation. Topics include product overviews; installation and configuration tasks; instructions for using, administering, and troubleshooting the product; and security information.

Real Estate and Facilities Management community on Service Management Connect

https://www.ibm.com/developerworks/servicemanagement/rfm/

Use Service Management Connect to access blogs, wikis, forums, and communities. In Service Management Connect you can review information such as best practices, performance and tuning, and product integrations. You can also collaborate with IBM experts and the broader user community.

IBM TRIRIGA Application Platform support resources portal

http://www.ibm.com/support/entry/portal/overview/software/tivoli/ibm_tririga_application_platform

The IBM support resources portal provides access to tools and resources to keep your systems, software, and applications running smoothly. From the support resources portal you can find fixes, service requests, useful links and an enhanced search to help you find information quickly.

Installing the IBM TRIRIGA Application Platform 3.5.3.2 fix pack

To install the TRIRIGA Application Platform 3.5.3.2 fix pack, refer to the following instructions.

Before you begin

Before you extract and run the fix pack file, back up the existing TRIRIGA files and make a backup copy of the database. You can extract the fix pack file into any directory.

About this task

Note: In the patch folder for the 3.5.3.2 fix pack, when the fix pack installer backs up the ibm-tririga.war file, the back-up .war file appears as the ibs-tririga.war.bak file.

Procedure

  1. Ensure that no database configuration changes are pending.
  2. Shut down all of the application and process servers.
  3. Take a back-up of the database of the TRIRIGA install directory.
  4. For IBM WebSphere® Application Server, shutdown the WebSphere enterprise application that runs TRIRIGA and leave the WebSphere Application Server up. After the backup completes, restart WebSphere Application Server.
  5. For Oracle WebLogic Server installations, start and run the Oracle WebLogic Server while you apply the fix pack.
  6. Download the 3.5.3-TIV-TAP-FP002 file.
  7. Extract the file and run one of following patch executable files: fixpack_tririga_v3.5.3.2_Windows.exe, fixpack_tririga_v3.5.3.2_Linux.bin, or fixpack_tririga_v3.5.3.2_AIX.bin.
  8. In the Introduction pane, select Next.
  9. In the license agreement, accept the terms and select Next.
  10. Choose the directory where IBM TRIRIGA is installed. For example, the following directories: c:\ibm\tririga\ or /opt/ibm/tririga/.
  11. Review the information and select Next.
  12. The fix pack process patches the WAR file, runs any platform database fix pack scripts, and redeploys the WAR file in Liberty.
  13. For Oracle WebLogic Server, delete all of the cache, tmp, and .wlnotdelete directories that might contain files that are left over from the previous application/ear installation. For example:

    C:\oracle\weblogic10\user_projects\domains\tririga10domain\servers\tririgaServer\tmp

    C:\oracle\weblogic10\user_projects\domains\tririga10domain\servers\tririgaServer\cache

    or

    /opt/oracle/weblogic10/user_projects/domains/tririga10domain/servers/tririgaServer/cache

    /opt/oracle/weblogic10/user_projects/domains/tririga10domain/servers/tririgaServer/tmp

  14. For Oracle WebLogic Server, the fix pack process attempts to redeploy the WAR file into the managed server. However, because of conditions in the server environment outside of IBM TRIRIGA's control, you might need to manually redeploy the WAR file. Restart the application server when the fix pack completes, and check the build number in the IBM TRIRIGA Administrator Console. If the old .war file still shows, redeploy the .war file. Refer to Oracle's instructions for deploying a .war application into the managed server.
  15. For WebSphere Application Server Liberty Core profile, the WAR file deploys and the cache directories are automatically removed. This is required to restart Liberty.
  16. For WebSphere Application Server, the WAR file redeploys and starts automatically. If it fails, you can try to manually redeploy. The WAR file is located in one of the following root TRIRIGA install directories: c:\ibm\tririga\ibm-tririga.war or /opt/ibm/tririga/ibm-tririga.war
  17. For Oracle WebLogic Server, the fix pack process attempts to restart the managed server. You might need to manually restart the application server.

Resolved issues

The following issues were resolved in the TRIRIGA Application Platform 3.5.3.2 fix pack.

General issues

The following issues were resolved in 3.5.3.2.

APAR Number Description
IV97981 System actions and custom actions are now enabled on system reports with group-by fields. (Tri-5823)
IV98101 The way Document Manager handles the paths of documents that are uploaded to records was changed. Previously any document uploaded to a record would be assigned a path of: Object Attachments/<user name>/<bo name>/<doc_name>.<extension>

When a given user owned two leases and uploaded two unique documents that had the same name to each lease (one document to each lease), the first uploaded document would be overwritten because both document records shared the exact same path.

The way paths are represented for documents that are uploaded to a record was changed

from:
    Object Attachments/<User name>/<bo name>/<doc_name>.<extension>
to:
    Object Attachments/<User name>/<bo name> - <spec_id>/<doc_name>.<extension>
Now, each record has a unique path for its child documents that does not conflict with other records of the same type owned by the same user. (Tri-5825)
IJ00798 A JAWS user can now navigate on related reports lists. (Tri-5827)
IJ00704 The filter and group-by classification records of a metric report now render completely and match all the records found in the report. (Tri-5960)
IJ00756 The current user's time zone is now displayed in a metric query chart with Group By Day and Group By Hour charts for DateAndTime field groupings. (Tri-5961)
IJ01609 Running a report with a defined Group By no longer causes a platform error. (Tri-5962)
IJ00580 When a summary report is displayed in a portal section, there is no decimal precision for the count values, and only a decimal precision of 2 for any number values. In addition, date, date time, and time values also display as they would if the report had been run from the Report Manager. (Tri-5963)
IJ00364 You can add the new AGENT_STALE_TIME_IN_SECONDS property to the TRIRIGAWEB.properties file. The property controls workflow agents. The default and minimum value is 60 seconds. The AGENT_STALE_TIME_IN_SECONDS property determines when an agent is stale or unresponsive and adds extra logging. You can use this property in environments where you notice that a running agent seems down when it is actually very busy and unresponsive. (Tri-5964)
IJ01094 You can add the new BIRT_ALLOW_XLSX property to the TRIRIGAWEB.properties file. When set to false, BIRT reports cannot be exported with the .xlsx file extension. When set to true, BIRT reports can be exported as .xlsx files. Only use the .xlsx file extension on BIRT reports that have a direct connection to the database. Export all as-delivered BIRT reports with the .xls file extension. It is a known limitation that some as-delivered BIRT reports do not export to the .xlsx file extension correctly. This is a known third-party limitation. If you experience this issue, export using the .xls file extension. (Tri-5968)
IJ01974 You can add the new GEO_ORG_SECURITY_CONTRIBUTE_BEHAVIOR property to the TRIRIGAWEB.properties file. The property controls the SQL generated that contributes geography and organization security to queries. Values are the default COALESCE, PATH, or the older OR. OR has degraded performance in Oracle but OK performance in DB2 and Microsoft SQL Server. (Tri-29678)

When the GEO_ORG_SECURITY_CONTRIBUTE_BEHAVIOR=PATH is in the TRIRIGAWEB.properties file see IJ03324 for more information.
IV99291 In the Gantt, Calculated Start/End date now properly calculates in scenarios where the project time zone is ahead of the server time zone. (Tri-49495)
IJ00839 You can add the new EXPORT_EXCEL_BATCH_PROCESS_SIZE property to the TRIRIGAWEB.properties file. This property enables you to tune your system to balance memory consumption by controlling the size of the batch of records returned when exporting to Excel. The default is 128000. (Tri-50201)
IJ00683 When a project is imported into the Gantt, if the TRIRIGA project has no Planned Start date (or Planned End date based on the Calculate direction), the imported tasks are no longer planned against today's date or 1969 depending upon whether a calendar is used or not. Either the earliest Planned Start date or the latest Planned End date is now used to schedule the imported project. (Tri-50211)
IJ03324 The following provides an alternative way to handle org/geo security on a query. The generated SQL is less expensive and may perform better depending on your org/geo hierarchy structure. To use this method, you must comply with the following limitations.

. The triPathSY field must be part of the organization and of all geography business objects.

. The values of triPathSY fields on organizations and all geography records must be consistent with the hierarchy structure.

. The organization and geography used within any security group must contain fewer characters than the size of triPathSY on the organization and geography business objects.

By default this functionality is not turned on. It can be enabled by setting the following property in the TRIRIGAWEB.properties file. The values of triPathSY must be in sync before using this in any production system.
    GEO_ORG_SECURITY_CONTRIBUTE_BEHAVIOR=PATH
For 3.5.3.2, this is only supported on DB2 and Oracle. (Tri-51099)

When the GEO_ORG_SECURITY_CONTRIBUTE_BEHAVIOR=PATH is in the TRIRIGAWEB.properties file for DB2 and Oracle environments, you can determine if your organization and geography hierarchies are in sync before using the PATH setting in production. In the Administrator Console, Database Manager, Database Admin Tasks, select "Check Organization Hierarchy" or "Check Geography Hierarchy". Read the popup and click OK to confirm. This tool may take a long time to run depending on the size of your organization or geography hierarchy. Monitor the server.log for feedback regarding out of sync entries and completion. This feature is not available for Microsoft SQL Server databases. (Tri-51374)
IJ03340 When a user connects to a UX application by using an SSO URL, the application now loads without waiting for a browser refresh. (Tri-51100)
IJ03143 Record lookup no longer returns an empty screen when ENFORCE_GUI_LEVEL_QUERY_SECURITY is set to true. (Tri-51101)
IJ02731 Extra icons and characters are no longer displayed next to editable fields in editable queries. (Tri-51115)
IJ02907 Fields that could not be edited in editable queries can now be edited. (Tri-51127)
IJ01870 After a user accepts a lease contract action item in the Action Items portal, the accept task is processed correctly. (Tri-51227)
IJ03000 In Portfolio > Locations > Property, when a non-US English-language user filters a query and exports the filtered data, the exported Excel file contains the appropriate data. The exported Excel file also contains the appropriate data when a non-US English- language user does not filter the query before exporting. (Tri-51373)

Notices

This information was developed for products and services offered in the US. This material might be available from IBM in other languages. However, you may be required to own a copy of the product or product version in that language in order to access it.

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, MD-NC119
Armonk, NY 10504-1785
US

For license inquiries regarding double-byte character set (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to:

Intellectual Property Licensing
Legal and Intellectual Property Law
IBM Japan Ltd.
19-21, Nihonbashi-Hakozakicho, Chuo-ku
Tokyo 103-8510, Japan

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 jurisdictions 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 websites are provided for convenience only and do not in any manner serve as an endorsement of those websites. The materials at those websites are not part of the materials for this IBM product and use of those websites is at your own risk.

IBM may use or distribute any of the information you provide 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 Director of Licensing
IBM Corporation
North Castle Drive, MD-NC119
Armonk, NY 10504-1785
US

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.

The performance data discussed herein is presented as derived under specific operating conditions. Actual results may vary.

The client examples cited are presented for illustrative purposes only. Actual performance results may vary depending on specific configurations and operating conditions.

The performance data and client examples cited are presented for illustrative purposes only. Actual performance results may vary depending on specific configurations and operating conditions.

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.

Statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.

All IBM prices shown are IBM's suggested retail prices, are current and are subject to change without notice. Dealer prices may vary.

This information is for planning purposes only. The information herein is subject to change before the products described become available.

This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to actual people or business enterprises is entirely coincidental.

COPYRIGHT LICENSE:

This information contains sample application programs in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. The sample programs are provided "AS IS", without warranty of any kind. IBM shall not be liable for any damages arising out of your use of the sample programs.

Each copy or any portion of these sample programs or any derivative work must include a copyright notice as follows:
© (your company name) (year).
Portions of this code are derived from IBM Corp. Sample Programs.
© Copyright IBM Corp. _enter the year or years_.

Trademarks

IBM, the IBM logo, and ibm.com are trademarks or registered trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Terms and conditions for product documentation

Permissions for the use of these publications are granted subject to the following terms and conditions.

Applicability

These terms and conditions are in addition to any terms of use for the IBM website.

Personal use

You may reproduce these publications for your personal, noncommercial use provided that all proprietary notices are preserved. You may not distribute, display or make derivative work of these publications, or any portion thereof, without the express consent of IBM.

Commercial use

You may reproduce, distribute and display these publications solely within your enterprise provided that all proprietary notices are preserved. You may not make derivative works of these publications, or reproduce, distribute or display these publications or any portion thereof outside your enterprise, without the express consent of IBM.

Rights

Except as expressly granted in this permission, no other permissions, licenses or rights are granted, either express or implied, to the publications or any information, data, software or other intellectual property contained therein.

IBM reserves the right to withdraw the permissions granted herein whenever, in its discretion, the use of the publications is detrimental to its interest or, as determined by IBM, the above instructions are not being properly followed.

You may not download, export or re-export this information except in full compliance with all applicable laws and regulations, including all United States export laws and regulations.

IBM MAKES NO GUARANTEE ABOUT THE CONTENT OF THESE PUBLICATIONS. THE PUBLICATIONS ARE PROVIDED "AS-IS" AND WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANTABILITY, NON-INFRINGEMENT, AND FITNESS FOR A PARTICULAR PURPOSE.