IBM TRIRIGA Application Platform, Version 3.5.3.4

Readme file for 3.5.3.4 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/community/groups/service/html/communityview?communityUuid=9e3a5b9d-6a06-4796-a6c1-5137b626e39c

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/docview.wss?uid=swg21611356

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.4 fix pack

To install the TRIRIGA Application Platform 3.5.3.4 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.4 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

Ensure that no database configuration changes are pending.
Shut down all of the application and process servers.
Take a back-up of both the database and of the existing TRIRIGA install directory for each server. If necessary, you can use the back-ups to revert the system to the current state.

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.
For Oracle WebLogic Server installations, start and run the Oracle WebLogic Server while you apply the fix pack.
Download the 3.5.3-TIV-TAP-FP004 file.
Extract the file and run one of following patch executable files: fixpack_tririga_v3.5.3.4_Windows.exe, fixpack_tririga_v3.5.3.4_Linux.bin, or fixpack_tririga_v3.5.3.4_AIX.bin.
In the Introduction pane, select Next.
In the license agreement, accept the terms and select Next.
Choose the directory where IBM TRIRIGA is installed. For example, the following directories: c:\ibm\tririga\ or /opt/ibm/tririga/.
Review the information and select Next.
The fix pack process patches the WAR file, runs any platform database fix pack scripts, and redeploys the WAR file in Liberty.
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
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.
For WebSphere Application Server Liberty Core profile, the WAR file deploys and the cache directories are automatically removed. This is required to restart Liberty.
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
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.4 fix pack.

APAR Number	Description
IJ00305 and IJ01316	Query sections no longer render under-width or not at all when forms are displayed in a portal section. (Tri-52075, Tri-51917)
IJ00974	When a user enters an invalid value for an 'In' query filter or a 'Not In' query filter, the user now sees a message describing the correct input format instead of a MID error. (Tri-51916)
IJ02239	Query sections no longer render under-width. (Tri-52076)
IJ03350	An unsafe character ":" (colon) that was passed on the URL when you switched between form tabs that contained queries with runtime filters was replaced with an "_" (underscore). (Tri-51685)
IJ03596	The sum row in a form query section now displays without a vertical scroll bar when the section contains a small number of query results. (Tri-52120)
IJ04278	Apply Record or Apply Template no longer has an issue if the project's time zone makes the stored date fall on the previous or next day. The issue occurred when the tasks start dates were calculated when the record or template was applied. (Tri-51684)
IJ05343	The check for valid licenses was refactored to avoid causing a race condition where integrations received an "Insufficient License" message when the server had valid licenses. (Tri-52074)
IJ05074	When you use an incoming mail agent, email message bodies generated by certain mail clients are no longer added to the email record as an attachment. Also, the notes field in the email message now displays the message in HTML if it is available; otherwise, it displays the plain text version. (Tri-51915)
	You can now configure TRIRIGA to use the geography and organization from the user's profile in addition to the user's geography and organization from the user's security groups to determine the user's geography and organization access. After connecting to the database as the TRIRIGA user, run and commit the following SQL statement to enable this functionality in the TRIRIGA Application Platform: insert into ENVIRONMENT_PROPERTIES (ENVIRONMENT, PROPERTY, VALUE) VALUES('Security','GEO_ORG_SECURITY_MODEL','1') (Tri-52077)
	Column headers now display when a query is rendered in a portal section. (Tri-52207)

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.

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.